Hi, AFAIK MySQL cluster requires using the NDB engine which is not 100% compatible with MYISAM, etc. The more recent a version you have the better off you will be but there was one point where autoincrement wasn't even supported. Also from what I know, a NDB cluster needs at least three nodes.
That doesn't mean you can't have an active-active database. If you application is ready for it, you can set up MySQL in a Master Master configuration (aka multimaster). For your application to be compatible you basically need to use only autoincrement primary keys for all your tables but you should read the whole Megilah - here is a good article: http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html Google has also released some code for multimaster configurations and they have some docs also: http://code.google.com/p/mysql-master-master/ Regarding Postgres- I can't recommend anything specific but I am looking into pgpool and pgpool II for a new project. Hope that helps, Yonah On Nov 20, 2007 2:51 AM, Amos Shapira <[EMAIL PROTECTED]> wrote: > Hello, > > We are looking at enhancing one of our servers, which runs CentOS 5 on > amd64, for HA using Linux Virtual Servers (LVS). The server runs a web > site using MySQL 5.0.22 and of course we'll need to replicate that on > the second server as well. > > Is MySQL Cluster the right solution for us? > > At least for now, we think we can do with a master-slave solution > (i.e. only one server serving while the other is in "hot standby"), > but if it's possible to take advantage of both servers at the same > time and double our capacity then it would be very useful too. > > I also have a small web service using PostgresQL (8.1.9, from CentOS > packages) on the same server which will also have to be replicated. > What do people usually use to do this? Is PGCluster a practical > option? > > Thanks, > > --Amos > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] > >
