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

4 keys to success for LibreOffice as a service

The announcement of LibreOffice Online this week came as welcome news to many people concerned about the paucity of online options for those who want software freedom with their online document solutions. But can open source SaaS succeed? The open source community needs a truly open alternative to current mainstream online document collaboration solutions, all of which are compromised by lock-in. LibreOffice Online will offer the full flexibility to deploy in-house or hosted cloud instances while using true open standards for its documents. Read more

Bazel: Google Build Tool is now Open Source

Bazel, the tool that Google uses to build the majority of its software has been partially open sourced. According to Google, Bazel is aimed to build “code quickly and reliably” and is “critical to Google’s ability to continue to scale its software development practices as the company grows.” Read more Also: Q&A: Databases, Open Source & Virtualisation with CEO Vinay Joosery

Ubuntu Kylin 15.04 Beta 2 Is Now Available for Download - Screenshot Tour

After announcing the Ubuntu 15.04 Final Beta and Kubuntu 15.04 Beta 2, it is now time to take a look at the second and last Beta release of the upcoming Ubuntu Kylin 15.04 (Vivid Vervet) operating system that has been designed especially for the Chinese Ubuntu Linux community. Read more Also: Ubuntu MATE 15.04 (Vivid Vervet) Beta 2 Switches to Systemd - Screenshot Tour Ubuntu 15.04 (Vivid Vervet) Final Beta Officially Released - Screenshot Tour

Kubuntu 15.04 Beta 2 Released with KDE Plasma 5 as Default Desktop - Screenshot Tour

Today’s announcement for Ubuntu 15.04 (Vivid Vervet) Final Beta also mentioned the immediate availability for download and testing of Kubuntu 15.04 Beta 2, an official Ubuntu flavor built around the modern and attractive KDE Plasma 5 desktop environment, as well as the KDE Applications project. Read more Also: Xubuntu 15.04 Beta 2 Released, Offers a Neat Xfce 4.12 Experience - Screenshot Tour