Hi, I did lots of searching to download Mysql-max (binary/rpm) as per described in http://www.howtoforge.com/loadbalanced_mysql_cluster_debian but unable to find one . At http://dev.mysql.com/downloads/mysql/5.1.html the Server, client rpms etc. are listed but not MySQL-max. Can anybody please point me to the right direction? thanks
All of the features of MAX are built in to the regular server distro now... http://forums.mysql.com/read.php?117,144056,144167#msg-144167
Hi, Thanks for reply. I also thought so but after installing 'Servre' I didnt found any 'mysqld-max' on my system. though, I didnt started building cluster yet to know whether I need any other package in this regard apart from 'Server' and 'Cluster tools'.
Are you sure you need a MySQL cluster? The big disadvantage is that it holds all data in the RAM, so if there's a power failure, all data is gone. I suggest you try MySQL Master-Master replication: http://www.howtoforge.com/mysql5_master_master_replication_debian_etch
Thanks Falko. I will give it a try. Actually our need is to setup multiple mysql servers to share the load, data replication with a single point of access, something like you described in clustering. As I haven't tried any approach yet, what you suggest to proceed in this situation: Cluster or Master-Master? Regards,
If you have a single point of access, than this one MySQL server will always take the whole load, while the other MySQL servers are doing nothing. If your web application is running on multiple nodes, I'd configure the nodes to connect to different MySQL nodes (the MySQL nodes all have the same data thanks to master-master replication).