Linux.com

Home News Enterprise Computing Systems Management How To Set Up MySQL Database Replication With SSL Encryption On Debian Lenny

How To Set Up MySQL Database Replication With SSL Encryption On Debian Lenny

This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). 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.

Read more at HowtoForge
 

Comments

Subscribe to Comments Feed

Upcoming Linux Foundation Courses

  1. LFS422 High Availability Linux Architecture
    08 Sep » 11 Sep - Raleigh, NC
    Details
  2. LFS426 Linux Performance Tuning
    08 Sep » 11 Sep - New York
    Details
  3. LFS520 OpenStack Cloud Architecture and Deployment
    08 Sep » 11 Sep - Virtual
    Details

View All Upcoming Courses

Become an Individual Member
Check out the Friday Funnies

Sign Up For the Linux.com Newsletter


Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board