I have a large Mysql database and about 500,000 users on my site. I have
installed a load balancer and 4 apache servers but only have 1 mysql server.
Recently, my database server crashed and my site was offline because of
this. While it was down less than an hour, I would like to eliminate this
problem in the future. Would replication help? Meaning if my main database
server went down, I could switch my application to use the second database
server until the main one come back online? I have also thought about having
my application write to 2 databases, but there has to be a simpler way.
Any help would be greatly appreciated.
Thanks,
Jim
