471,073 Members | 1,402 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Replication??

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
Jul 20 '05 #1
0 1214

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Cherrish Vaidiyan | last post: by
reply views Thread by Cherrish Vaidiyan | last post: by
3 posts views Thread by steve | last post: by
1 post views Thread by Craig HB | last post: by
3 posts views Thread by dlesandrini | last post: by
9 posts views Thread by David W. Fenton | last post: by
3 posts views Thread by Gert van der Kooij | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.