The MU forums have moved to

install hyperdb plugin (5 posts)

  1. wesam2008
    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

    * 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

  2. andy
    Posted 16 years ago #

    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 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.

  3. Trent
    Posted 16 years ago #

    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.


    EDIT: Disregard my lack of reading. It is fine now and I am subscribed to the mailing list:

  4. rfrovarp
    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.

  5. lunabyte
    Posted 16 years ago #

    The following plugin works out of the box, and handles everything you've asked about.

About this Topic

  • Started 16 years ago by wesam2008
  • Latest reply from lunabyte