Librenix  
(Show all MySQL articles . . .
)  
Headlines | Linux | Apps | Coding | BSD | Admin | News
Information for Linux System Administration 

Skip Certain Errors In MySQL Replication

Up
vote
Down

MySQL replication is nice, however it can happen that it stops because of an error, and restoring a working replication can be hard - you need to set locks on the master to get a consistent MySQL dump, and during that time websites are not accessible. However there's a way to make the MySQL slave ignore certain errors using the slave-skip-errors directive.
 read more | score:7293 | -falko, March 3, 2013
More Sysadmin articles...

Tallahassee Abstract Art

admin headlines

Virtual Users/Domains with Postfix, Courier, MySQL, SquirrelMail (CentOS 6.3)

Tutorial: Install a Streaming Audio Server with Icecast 2.3.3 on CentOS 6.3 x86_64 Linux

Tutorial: Build a CentOS 6.3 x86_64 Server

RAW Devices In VirtualBox

OpenVZ Mount Tutorial: Mount Host Devices, Partitions, Directories in Containers (Debian, Ubuntu)

Enable SquirrelMail on Debian

 

Firefox sidebar

Site map

Site info

News feed

Features

Login
(to post)

Search

 
Articles are owned by their authors.   © 2000-2012 Ray Yeargin