Page 1 of 1

Replicating MySQL tables?

Posted: Wed Jul 28, 2004 4:04 pm
by visionmaster
Hello,

I want a database, where the tables should be replicated on 3 different servers. Of course the databases must be consistent and always be identical. I read something about MySQL and clustering, see http://www.mysql.com/products/cluster/ for details.

Since I have no experience whatsoever, is clustering the wrong solution or even an overkill?

Any other solutions out there? How, where, etc...?

Thanks for your help!

Posted: Thu Jul 29, 2004 7:11 am
by Weirdan
MySQL cluster is based on in-memory database so it's suitable for very specific purposes only, imo (and it's in beta stage atm).
Check Replication chapter of MySQL manual: http://dev.mysql.com/doc/mysql/en/Replication.html

Posted: Thu Jul 29, 2004 10:56 am
by ultraslacker
Replication may work for you as long as you can confine writes to one server.