http://wordpress.org/support/ WordPress › Support Topic: Trying to use HyperDB to replicate database en Tue, 24 Nov 2009 09:47:49 +0000 http://wordpress.org/support/topic/219276#post-958255 Sat, 17 Jan 2009 01:33:27 +0000 figaro 958255@http://wordpress.org/support/ <p>I <strong>believe</strong> 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.</p> <p>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. </p> http://wordpress.org/support/topic/219276#post-958223 Sat, 17 Jan 2009 00:21:53 +0000 d910qf 958223@http://wordpress.org/support/ <p>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.</p> <p>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). </p> <p>Set up the config file with these settings and away you go.... </p> <p>Am testing at the moment, will report back. </p> http://wordpress.org/support/topic/219276#post-904641 Fri, 21 Nov 2008 14:17:08 +0000 nemo-maritime 904641@http://wordpress.org/support/ <p>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<br /> <a href="http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html</a><br /> and <a href="http://www.howtoforge.com/mysql_database_replication" rel="nofollow">http://www.howtoforge.com/mysql_database_replication</a> 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 ( <a href="http://codex.wordpress.org/HyperDB" rel="nofollow">http://codex.wordpress.org/HyperDB</a> ), 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. </p>