Select Page

Live Backups of MySQL Using Replication

I am using Mambo now since august 2003 together with a mysql database (the most popular open source database). Right now I am doing backup on a weekly basis manually using the plesk panel of my provider. I found this article interesting even if it does not resolve my problem of backup.  As soon as I find something interesting, I will publish it (plesk script, CGI tool …). Back to the article, it is in fact more an example of database replication for an enterprise:

One of the difficulties with a large and active MySQL database is making clean backups without having to bring the server down. Otherwise, a backup may slow down the system and there may be inconsistency with data, since related tables may be changed while another is being backed up. Taking the server down will ensure consistency of data, but it means interruption of service to users. Sometimes this is necessary and unavoidable, but daily server outages for backing up data may be unacceptable. A simple alternative method to ensure reliable backups without having to shut down the server daily is to set up replication for MySQL.  Read more HERE at the open source web plattform of O’Reilly

About The Author

Cédric Walter

I worked with various Insurances companies across Switzerland on online applications handling billion premium volumes. I love to continuously spark my creativity in many different and challenging open-source projects fueled by my great passion for innovation and blockchain technology.In my technical role as a senior software engineer and Blockchain consultant, I help to define and implement innovative solutions in the scope of both blockchain and traditional products, solutions, and services. I can support the full spectrum of software development activities, starting from analyzing ideas and business cases and up to the production deployment of the solutions.I'm the Founder and CEO of Disruptr GmbH.