Replicating MySQL tables?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
visionmaster
Forum Contributor
Posts: 139
Joined: Wed Jul 14, 2004 4:06 am

Replicating MySQL tables?

Post 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!
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post 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
ultraslacker
Forum Newbie
Posts: 3
Joined: Tue Jul 20, 2004 2:11 pm

Post by ultraslacker »

Replication may work for you as long as you can confine writes to one server.
Post Reply