Debian Tutorials Copy/Paste tutorials for Debian Linux

4Oct/090

MySql database replication (master/slave)

In this tutorial we'll create a simple one-way master/slave database replication. You must have at least one master and one slave but you can use multiple slaves.

Master

1. Configure master to listen on all ip addresses (pico /etc/mysql/my.cnf)

#bind-address = 127.0.0.1