wesam2008
Member
Posted 16 years ago #
we are trying to install hyperdb plugin, but we have this question.
can you help us to solve this question.
* Q1. we need db cluster or not, and which type of cluster master-master or
master-slave
* Q2. one database in each server or multi databases, and how we can install
this by hyperdb plugin.
* Q3. how we can manage/split (users blogs) into database servers by hyperdb
plugin.
HyperDB supports master-master as well as master-slave. In your configuration you will specify which servers are writable and which are readable. To mark a server read-only, give it a positive value for Read and zero for Write.
Each database gets its own config line. So it does not matter if one server has many databases. In that case, each database config line will have the host in common with the other databases on that server.
The HyperDB plugin does not include code to distribute blogs among many databases. We altered the code for WordPress.com by adding a function that extracts the blog_id from the table name and returns the dataset and partition. I will update HyperDB with example code today.
Andy have you guys thought about updating the hyperDB SVN? It hasn't been able to run on WPMU 1.5.1 or any TRAC version later due to a few small changes. It worked fine on 1.3.3 for me, but I quit using it when it didn't work on 1.5.1.
Trent
EDIT: Disregard my lack of reading. It is fine now and I am subscribed to the mailing list:
http://comox.textdrive.com/pipermail/hyperdb/2008-June/000103.html
rfrovarp
Member
Posted 16 years ago #
I'm finding the plugin to be a bit confusing to use. The regexps are looking for a different pattern than what is being passed in. What is being passed in is wp_28_posts, and that just falls right through. wp_2_posts works however. I'm thinking of rewriting the rexexps. However, I may be doing something wrong to begin with. I look forward to seeing your example code.
lunabyte
Member
Posted 16 years ago #
The following plugin works out of the box, and handles everything you've asked about.
http://premium.wpmudev.org/project/Multiple-Databases