Questions tagged [hyperdb]
HyperDB is a drop-in database extension that adds support for multiple databases. It is developed and maintained by Automattic and used on WordPress.com.
15 questions
6
votes
3
answers
2k
views
MySQL Replication Latency Issues in wp-admin pages
I have an environment running WP 3.0.1 with a Master db and two slaves. I am using HyperDB to force all writes to go to the Master, and all reads to read from the two slaves.
I am experiencing a ...
- 801
4
votes
1
answer
308
views
Built to scale, or worry later?
I'm starting a service that offers websites that runs on a giant Wordpress multi-site. I have a cloud based vps with nginx-php5-php-fpm-mysql. Storage with Amazon S3, distribution with MaxCDN. WP ...
- 41
3
votes
2
answers
2k
views
How to use hyperdb to separate and share a user dataset between wordpress installs?
I'm looking for a way to separate my users and usermeta table to be in a different database than my main WP install. The end goal is sharing these table over a number of WP installs.
From what I read,...
- 366
1
vote
1
answer
124
views
Doing a loop with multiple DBs simultaneoulsy
I have a website setup made up of with more than 3-4 WordPress setups as subdirectories of main. For example:
Site
|
---------- Site/Site1
|
---------- Site/Site2
|
---------- Site/Site3
Each have ...
- 1,589
1
vote
1
answer
1k
views
Is it possible to split database tables using HyperDB?
I'm looking for an answer from someone who's implemented HyperDB or has knowledge of it.
I have a database which has just passed the 100mb mark a week or so ago, the problem is my host only allows ...
- 579
1
vote
2
answers
1k
views
Split WP_POST table based on post types
I was wondering if it's possible to get my posts from 2 databases depending on the post type.
I'm using HyperDB but can't seem to get it to specify the database based on post type. I Basically need ...
- 11
1
vote
0
answers
219
views
Can't add post when using HyperDB
I try separate users table from rest of database. So i decide to use HyperDB. On localhost i have config like this:
$wpdb->add_database(array(
'host' => 'localhost', // If port is ...
1
vote
1
answer
99
views
Automatic switch to backup database on fail
We have a setup where the WordPress's MySQL database is replicated to a secondary MySQL server in case the primary fails. Are there any plugins or methods which would automatically switch to the ...
- 93
1
vote
0
answers
531
views
How to use HyperDB plugin in a existing wpmu
I am using wordpress multisite v3.5.1 in a single db called maindb. And i have also 5 blog. They are bazar(main blog), demo1, demo2, demo3 and demo4. In future i want add more blog but i want to ...
- 13
0
votes
1
answer
1k
views
Is HyperDB supposed to be able to handle read-only (only) database instances?
I'm trying to make my WordPress database a bit more resilient, with MySQL master/slave replication. To go along with that, I've installed HyperDB, with the master as a read/write database, and the ...
- 186
0
votes
1
answer
88
views
WordPress Multisites or Multiple WP Single sites?
So I am pondering over a decision to use WordPress Multi-Sites or just use Multiple WP Single sites. The reason is that the company site is broken down into multiple departments.
Maindotcom (WP SITE)
...
- 599
0
votes
2
answers
1k
views
how to install wordpress HyperDB
Can anyone help me installing Wordpress multi-site. I want to Partition my database. Suppose I want to use 1 database for 300 blogs and I am expecting to have 10000 blogs. So I will need 33/34 ...
0
votes
1
answer
190
views
Load-balanced site frequently losing permalink settings
There's an intermittent issue where the permalinks are suddenly lost on the site. Going in to wp-admin and saving Settings->Permalinks (without changing anything) always fixes it, but I can't ...
- 441
0
votes
0
answers
223
views
HyperDB failover Delay
We are testing out hyperDB as a solution for automated DB failover for wordpress.
The environment in question consists of 2 Backend DBs. One is setup to Local Master whilst the other remote master.
...
- 93
-1
votes
1
answer
616
views
HyperDB, Multisite - on new site creation put site's tables to specific database
I was given a task to create a Wordpress Multisite, and to make Wordpress Multisite create tables for each new site inside another database that is made just for that (new) site (let's assume that ...
- 161