From: Ananda Kumar Date: June 11 2012 2:36pm Subject: Re: i need advice on redundancy of mysql server. List-Archive: http://lists.mysql.com/mysql/227614 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf303f6a46dfdad904c2334554 --20cf303f6a46dfdad904c2334554 Content-Type: text/plain; charset=ISO-8859-1 when u say redudency. Do u just want replication like master-slave, which will be active-passive or Master-master which be active-active. master-slave, will work just a DR, when ur current master fails you can failover the slave, with NO LOAD balancing. Master-master allows load balancing. On Mon, Jun 11, 2012 at 7:56 PM, Joey L wrote: > I am running a site with about 50gig myisam databases which are the > backend to different websites. > I can not afford any downtime and the data is realtime. > > What is the best method for this setup? master-master or master-slave? > > What are the best utilities to create and maintain this setup? as far > as load balancing between the two physical servers that i am running. > I am currently working with percona utilities - is there something better ? > what would you use to load balance mysql ? what would you use to load > balance apache. > > > thanks > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > --20cf303f6a46dfdad904c2334554--