Guys - thanks for the replys - do any of you guys are on odesk or elancer.com ?? thanks
On Wed, Jun 13, 2012 at 7:28 PM, Rick James <rja...@yahoo-inc.com> wrote: > I prefer: > * Master-Master ("dual master") but write to only one of them. (Writing to > both can lead to duplicate keys, etc., unless you are very careful in your > code.) > * Have the two Masters geographically separate. (Think tornados, floods, > earthquakes, etc) > * Have Slave(s) hanging of each master -- (1) for read scaling, and (2) to > avoid a major outage when one Master goes down and you need to take the other > one down to clone it. > > Another thing to consider: > Backing up via a "LVM snapshot" requires only a minute or so of downtime, > regardless of dataset size. > Percona's XtraBackup is also very good. > > I also agree that MyISAM in not best. But, caution, InnoDB's disk footprint > is 2x=3x bigger than MyISAM's. > > You can Load Balance reads (among slaves and, optionally, masters); you > cannot do writes. > > Any number of Apache servers can talk to MySQL. But watch out -- MaxClients > should not be so large that it swamps max_connections. > > Load balancing: > DNS is the simple way to load balance Apache. > There are low-impact software solutions. > There are hardware solutions. (This is what I am used to at work; it is > severe overkill for most users.) > > Bottom line: There is no "best" or "perfect" solution. First decide what > 'keeps you up at night'. > >> -----Original Message----- >> From: Joey L [mailto:mjh2...@gmail.com] >> Sent: Monday, June 11, 2012 7:26 AM >> To: mysql@lists.mysql.com >> Subject: i need advice on redundancy of mysql server. >> >> 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