Language Selection

English French German Italian Portuguese Spanish

How To Set Up Database Replication In MySQL

Filed under
HowTos

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. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

In this tutorial I will show how to replicate the database exampledb from the master with the IP address 192.168.0.100 to a slave. Both systems (master and slave) are running Debian Sarge; however, the configuration should apply to almost all distributions with little or no modification.
Both systems have MySQL installed, and the database exampledb with tables and data is already existing on the master, but not on the slave.

Full Story.

More in Tux Machines

Review: Ubuntu 16.04 LTS (Xenial Xerus)

When we get to our Conclusion, we always find recent Ubuntu releases a little difficult to summarize. This is probably because each new release does not really bring major changes to the table anymore, rather they all seem to feel like just another update. In truth, that’s all they really are. But when third-party Linux distributions continue to innovate and give their users something fresh each time a new release is delivered, we can’t help but wonder why Ubuntu Developers can not achieve the same. Yet we can not quite put our finger on what Canonical are doing wrong. Essentially, they’re not really doing anything wrong. They are just not really offering anything fresh, new or innovative anymore. Read more

Today in Techrights

Gorgeous Live Voyager 16.04 Linux OS Comes Hot on the Heels of Ubuntu 16.04 LTS

The team of developers behind the Live Voyager desktop-oriented operating system have announced today, May 1, 2016, the release and immediate availability for download of Voyager 16.04 LTS. Read more

BlackArch Linux Now Provides over 1,400 Penetration Testing Tools, New ISO Lands

The BlackArch Linux devs have been preparing this for months, but now it is finally here, the new ISO image of the Arch Linux-based operating system designed for hackers and security professionals. Read more