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.

Filter by
Sorted by
Tagged with
1
vote
0answers
96 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
votes
1answer
275 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 ...
1
vote
1answer
62 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 ...
0
votes
0answers
129 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. ...
0
votes
1answer
685 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
1answer
884 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 ...
0
votes
1answer
629 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 ...
1
vote
0answers
500 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 ...
2
votes
2answers
1k 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,...
1
vote
1answer
108 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 ...
4
votes
1answer
297 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 ...
1
vote
1answer
935 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 ...
5
votes
3answers
1k 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 ...