I understand ..I am looking for load balancing - something that i do not have to worry about if one server goes down - the other server will be up and running by itself and i can bring back the other server later on when i have time.
On Mon, Jun 11, 2012 at 10:36 AM, Ananda Kumar <anan...@gmail.com> wrote: > 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 <mjh2...@gmail.com> 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 >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql