Trying to use HyperDB to replicate database

  • nemo-maritime

    (@nemo-maritime)


    16 years ago

    I am trying really REALLY hard to set up a replication of my database on a new server I added. I am almost dying with this, its killing me slowly! Sometimes it sucks being a website owner, anyways, I am trying to make a copy of my database. I have looked around and I have found sites like
    https://dev.mysql.com/doc/refman/5.1/en/replication-howto.html
    and https://www.howtoforge.com/mysql_database_replication and they are kind of easy, but at the same time confusing as I don’t know what to use to imput these codes/requests. So I stumbled across HyperDB ( https://codex.www.ads-software.com/HyperDB ), which looks like its made for WordPress, BUT, the installation guide really sucks; it barely explains anything. So I was wondering if anyone here in this huge world wide web of users has a better guide, or can help explain this, I would really appreciate it, as you will be saving me from going insane.

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi – as far as I can tell you need to set up your mysql databases as normal (master/slave etc) and then list each database server in the settings file along with whether it is read only etc.

    For example you might have one database server that handles writes, and 2 that handle read only (I think they would normally be master and 2 slaves).

    Set up the config file with these settings and away you go….

    Am testing at the moment, will report back.

    I believe hyperDB is intended to allow you to split your database tables into different databases and/or servers. It’s used by a lot of people who run WPMU sites since Mu creates a new set of tables for every blog created. I have one (small) Mu site with over 400 blogs, so that results in a lot of tables in a single database. Therefore I use another multi-db script (based on hyperDB) to split the tables across 16 databases.

    So, I’m not sure hyperDB won’t do what you’re wanting to do, but I think it’s intended to split up a db full of tables among several db’s on the same server or on multiple servers…I’m not sure it’s intended to replicate a db…..but, I could be wrong.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Trying to use HyperDB to replicate database’ is closed to new replies.