Advanced MySQL Replication Techniques (80 tags)
MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over. Giuseppe Maxia shows how.
Live Backups of MySQL Using Replication (42 tags)
One of the difficulties with a large and active MySQL database is making clean backups without having to bring the server down. A simple method to ensure reliable backups is to set up replication for MySQL. Russell Dyer, author of MySQL in a Nutshell, walks through the process of using replication for data backups.
Building and Configuring Slony (4 tags)
Slony is the intended replication project for the PostgreSQL database. Now that you know what it is, how do you use it? A. Elein Mustain demonstrates how to build, install, and configure Slony.
Introducing Slony (4 tags)
Slony is an experimental new feature intended to introduce powerful replication to PostgreSQL. It's a complicated problem, though. Elein Mustain introduces the Slony project, its aims, and the goals of Slony-I, the first milestone.
Modifying Slony Clusters (3 tags)
Slony is the intended replication project for the PostgreSQL database. As you might expect, it supports changing your cluster's configuration. A. Elein Mustain demonstrates how to add nodes, switch masters, fail gracefully, and change schemas with Slony.