| Posted by bsdvps, 01-22-2011, 10:08 PM | | Anyone have any suggestions for real-time backup of a MySQL database so that on Server A, the databases are backed up and installed on Server B in the event of a failure. Some of the databases are small while very soon, I will have large MySQL databases that I will be using for a forum.
I had a VPS provider have a hardware failure this weekend and this got me thinking that I should have real-time backups of my databases.
Also on the topic of forums, any recommendations for minimum RAM requirements for a busy forum? The server I'm looking at has 8gb of RAM on a quad core Xeon.
Thank you in advance
|
| Posted by asciiDigital, 01-22-2011, 10:51 PM | | Check this out:
http://www.cyberciti.biz/tips/mysql-proxy-howto.html
|
| Posted by bsdvps, 01-22-2011, 10:59 PM | | There's no option within MySQL itself?
|
| Posted by foobic, 01-23-2011, 12:00 AM | | For "real-time backup" you probably want replication. Then for the failover part you might use a proxy (as suggested above), or in a more general sense (complete server failover rather than MySQL specifically) DNS failover or heartbeat IP failover - according to your preference and budget.
|
| Posted by bsdvps, 01-23-2011, 12:19 AM | | I think replication will work for me. Looks like it's going to be another long night
|
| Posted by aeris, 01-23-2011, 05:59 AM | | You might want to look into MySQL Cluster if you need full redundancy, but this is way more complex than just putting up a stand-alone MySQL database, even with replication.
|
| Posted by bsdvps, 01-24-2011, 12:10 AM | | Do you know of a provider that does this automatically? For my client, money isn't that much of an issue.
|
| Posted by DJMizt73, 01-24-2011, 02:12 AM | | if money is not a big concern, i'd recommend getting consulting work from the experts at Percona.
www.percona.com
These guys knows mysql inside and out (these are the guys that wrote 'High Performance Mysql' book). Their consulting fee is actually very reasonable.
|
| Posted by bsdvps, 01-24-2011, 10:56 AM | | Nobody knows of a service provider who does this automatically?
|
| Posted by eth00, 01-24-2011, 11:22 AM | | You can do this with DRBD and heartbeat/pacemaker. We have deployed this for quiet a few clients and it works great if you want true real time replication. The downside is unless you do something like drbd proxy (commercial software) you will want to make sure that you have a low latency connection between them. DRBD uses enough BW is most cases if you have to pay for bandwidth between machines it can quickly get pricey.
|
|
 Add to Favourites
 Print this Article
|
