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

Abstract Art by Ray Yeargin

admin headlines

Encrypt your Data with EncFS (Ubuntu 12.10)

Running Question2Answer on Nginx on Debian 6, Ubuntu 12.10

Tutorial: Manage Headless VirtualBox with phpvirtualbox (Fedora 17)

Tutorial: Install, Upgrade to latest Rsyslog on CentOS 5/6

KVM Virtualization on OpenSUSE 12.1

Tutorial: Build a CentOS 6.2 x86_64 server with nginx

 

Firefox sidebar

Site map

Site info

News feed

Features

Login
(to post)

Search

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