blogs with a different database for each

Hi,

There is a plugin that could help you with that. Unfortunately it is not a free plugin. I also have not tried it myself (my membership with this company has expired) but it seems to do what you are trying to achieve.

https://premium.wpmudev.org/project/multi-db/

Hello Sandra, if the plugin works well, it will be great. The article says that the standard version of WP MU can handle several hundred blogs in a single database, that sounds well, but clearly it is better to have each own blog in a database. I will have to test the plugin. I wish someone could comment on their experience with this, before.

Thanks, sandra.

but clearly it is better to have each own blog in a database.

It is not clearly better by any means. It’s just a different way.

https://www.ads-software.com/extend/plugins/wp-hive/ can do that and is free. I know someone who used it, but personally I found it more of a hassle and not as flexible as Multisite.

Hello ipstenu. I think it is the best option to have separate databases because it is easier to manage them. Also, if there are many queries at once to a single database of different blogs, could collapse. But I do not know, I speak from intuition.

The plugin WP Hive works as WP Multisite, or it is a diferent thing?

It’s subjective which is easier (one DB is easier for me ?? )

Go read about WP Hive and see what it does and if it meets your needs. However, clearly you aren’t looking for a true Multisite solution as you want separate DBs, which means this is no longer the right sub forum for you ??

Hello Ipstenu, sorry, but i dont know which is the subforum more appropiate for this topic.

what I want is to make a social network in wordpress blogs like this: (it is in spanish language)
https://megustaescribir.com/

This example site, is a wordpress multisite versión with a plugin for separate DBs, or is a one database for all blogs?

Thanks, best regards.

Multiple databases are not easier to manage. If you need an example of a multisite site that scales, take a look at WordPress.com. If you reach the point that a single database is not sufficient, then consider using HyperDB which supports millions of tables across thousands of database servers. It is a plugin written by and supported by Automattic, so I think it would be safe to use.

However, before you become too concerned about scaling your database, if you are going to try to grow a large social network, first focus on performance and caching. W3 Total Cache or Supercache are good plugins to start with. Then beyond that I would consider nginx or Varnish. Managed hosts, such as, WP Engine or ZippyKid take care of those things for you.

Hello graynotgrey, thanks for the info, is very complete, although I have little experience with wordpress, I have more experience with joomla. It seems better idea to start with WP MU in one DB, and then there will be time to expand, true? Now, the question is, how many users blogs can WP MU manage without collapsing into a single database?
best regards

MySQL has no limit on the number of databases or tables. Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. Modern versions of Linux can support terabyte and petabyte file sizes.

Individual sites use a minimum of 9 tables, more with certain plugins added. Bluehost has a limit of 3000 tables per account which is very low, but that gives you about 333 sites. You usually won’t have to worry able scaling your DB until 500 sites. But it really depends on the size of the tables and the number of queries. You’ll experience memory constraints long before you approach the limits of the database. It’s something that is going to vary and needs to be monitored.

Ok graynotgrey. My domain, for user blogs in subdomains, is hosted in hostgator reseller plan. I will follow your advice and I set it up the system on a single database of WordPress MU.

Maybe, another option could be install individual wordpress (no multisite), on each subdomain for users. But if i do this, then the blogs are not connected to each other, and users who want to comment on one or the other, they can not because they do not serve the user and pass data.

Definitely, I think your advice is the best choice, and so prove it.
Thanks!