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:8159 | -falko, March 3, 2013
More Sysadmin articles...

Buy Art Online with a Free Return Policy

admin headlines

Gluster 3.4.2 on Two Node Controller+Compute Neutron GRE+OVS Fedora 20 Cluster

10 basic examples of Linux ps command

Running ownCloud 5.0 On Nginx (LEMP) On Debian Wheezy

Running SilverStripe On Nginx (LEMP) On Debian Wheezy/Ubuntu 13.04

Quantum basic RDO setup (grizzly) to have original LAN as external on CentOS 6.4

Step By Step Ubuntu 13.04 (Raring Ringtail) LAMP Server Setup

 

Firefox sidebar

Site map

Site info

News feed

Features

Login
(to post)

Search

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