MVSFORUMS.com

ramkriz · Posted: Sat Feb 03, 2007 2:46 pm Post subject: Mysql clustering

Mysql clustering

Hi,

I am working on a new project with one webserver and two mysql database servers.

Webserver: apache-2.0
DBserver1: Mysql-5.0.27
DBserver2: Mysql-5.0.27

Actually, the webserver was running with a single mysql database server. Since the database is too large, the database queries from the webserver takes very long time. So one more database server has been added.

I have setup the sync between the two mysql database servers using master/slave configuration.

Now I need to set up as the DML/DDL queries has to be sent to the master DB server and other queries has to be sent to the slave DB server.

Note: DML/DDL queries - select, drop, alter, update, delete and insert.

Please advice me to setup this mysql clustering.

Regards,
Ram.

kolusu · Posted: Mon Feb 05, 2007 10:57 pm Post subject:

ramkriz,

Try this

http://www.mysql.com/products/database/cluster/

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu