The plugin you are using hasn’t been updated for two years. It is better not to rely on plugins so old. You should consider writing an sql script, that would create a database, as per the MySQL documentation. And simply run the SQL command through php. You can check how that can be done in … Read more
HyperDB failover Delay
This points to an issue with .htaccess. Going to Settings->Permalinks will recreate .htaccess, and so I think that it could be an issue with file permissions during your load or maybe because it’s a dot file the server could be treating the file differently and somehow deleting it? This maybe useful : I have a … Read more
The theory behind how HyperDB and such plugins work is that they use a simple calculation on the blog number to allocate a DB for it at creation time, and access it later. I am not sure what exactly happens when you need do add a new DB server, you will either need to look … Read more
Rather than post this as a bunch of comments, I’m going to make this an answer. Your requirements/questions: to Have a Super admin that has access across all wp sites. That’s a hallmark of Multisite. to use both, subdomains and subfolders, in the chosen setup (see example above). You can accomplish this with something like … Read more
I just came across a similar issue. The problem was that the theme was updating options on the ‘init’ action hook. function theme_setup() { update_option(‘thumbnail_size_w’, 170); update_option(‘medium_size_w’, 470); update_option(‘large_size_w’, 970); } add_action(‘init’, ‘theme_setup’); That is called on every page load. This is better done using the ‘after_switch_theme’ action hook which only takes place when the … Read more
How to use HyperDB plugin in a existing wpmu
HyperDB is awesome. You shouldn’t worry about its dev date (which by the way, its being done by Automattic – the team behind WordPress). HyperDB has some bigger advantages like spreading read/writes across servers and splitting them and its mostly used for such purposes (bigger scales). In your case, I would go for a VIP … Read more
Can’t add post when using HyperDB
You could filter ‘query’ (you get the complete SQL here) and search for the post type in that. Then switch the database depending on what you found. But I don’t think this would work well: You might end up with the same post ID used multiple times (in each DB) and some strange side effects … Read more