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 > >
