Find a way to sync 2 mysql servers
Quest details: i'm looking for a way to backup and synchronize 2 mysql databases on seperate servers. basically, i'm looking to setup a scenario where a primary site would be used regularly but a secondary site would run on a different server and would always keep it's database up-to-date with the primary server (in case of failure).
Items posted to quest 
- Check out chapter six of the mysql manual. It's all about replication.By danielh, 2 years 6 weeks ago
- This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node.By techblog, 2 years 6 weeks ago
- This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.By techblog, 2 years 6 weeks ago
- Russell Dyer, author of MySQL in a Nutshell, walks through the process of using replication for data backups in MySQL.By techblog, 2 years 5 weeks ago
- Giuseppe Maxia shows how to build a high-availability master/slave replication system in MySQL 5.x.By techblog, 2 years 5 weeks ago
Add this quest to your blog. Paste this code into your post
CODE:
Your Status
Get notified when a post is added to this quest. register now; it is free!
Registration is quick and easy.
Learn about questing and how you can start your own quest for knowledge.
Already a member? Please login to participate in this quest
Already a member? Please login to participate in this quest
