Comments on How To Set Up MySQL Database Replication On Fedora 10
How To Set Up MySQL Database Replication On Fedora 10 This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though. I will use Fedora 10 for the master and slave in this tutorial.
5 Comment(s)
Comments
This tutorial shows a number of very dangerous bad practices.
The following configuration options have been deprecated for YEARS, with good reasons:
master-host=192.168.0.100
master-user=slave_user
master-password=slave_password
master-connect-retry=60
And this configuration option is also very dangerous, because it does not do what the author says it does, nor what people usually think it does:
replicate-do-db=exampledb
This tutorial is truly the blind leading the blind.
Thanks, but can you post the "new-way-of-doing-things"?
Thanks for pointing out potential security issues. Like the other comment, please teach us the new improved way of taking care of those parameters.
Simply use the pseudo-SQL statements ;-)
Atención usuarios Centos 5.3 y MySQL 5.0.45:
antes de Ejecutar el comando CHANGE MASTER TO MASTER_HOST='192.168.0.100', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=98; en el esclavo, primero ejecute este otro: RESET SLAVE; de lo contrario le saca un error similar a este:
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
Information for Centos 5.3 and MySQL 5.0.45 users:
Before to Run the instruction CHANGE MASTER TO MASTER_HOST='192.168.0.100', MASTER_USER='slave_user', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=98; first run this other one: RESET SLAVE; other way probably you'll get an error like this:
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log