Marc, Simple, create a MySQL cluster using two servers. I would recommend using Linux HA with DRBD for the database. This is simple enough to configure.
Then point all of your servers to that cluster. We have 4 SA daemon servers pointed to one of these clusters. Unless you don't configure the cluster correctly you shouldn't have any real downtime. It takes 15 seconds max to fail over (that's pulling the plug on the main node). Why replicate... WE tried that with limited success. Do it right from the beginning. Gary Wayne Smith -----Original Message----- From: Marc Perkel [mailto:[EMAIL PROTECTED] Sent: Sunday, October 30, 2005 12:32 PM To: [email protected] Subject: MySQL on multiple servers OK - here's what I want to do. I'd like to have more than one server that is all feeding into the same database. And I want the databases set up in a way that if the main server goes dow that the other servers run locally. I don't need every update to have to make it to every database in the event of any downtime. I just need it to work great when everything is up and pretty good when some servers are not running. So - what are the MySQL options that people are using with multiple servers? What I'm thinking I'd like to do is have all the spam filter servers run off of a main server and that server replicate to the satalite servers and that if the main server goes down then the other servers run on their own. I also would accept once a day copying the mysql database from the main server to the other servers at night so if the main server went down the other servers could run off of day old data. How does everyone else deal with this? -- Marc Perkel - [EMAIL PROTECTED] Spam Filter: http://www.junkemailfilter.com My Blog: http://marc.perkel.com
