Mysql – How to add new slave server to existing Mysql master slave replication

Double check that your character sets on the databases and connections are what you expect them to be - your replication choking on a statement with a non-ASCII character is immediately suspicious.

Look at the master's binary log to see how the statement it logged is different from the statement that the replica is trying to execute - that will offer clues to the problem.

Sadly, you should also make sure that the versions of the server for both the master and slave are the same. I recently encountered a weird instance where we had bad SQL trying to update a non-NULL numeric column to NULL. In the version that the master was running, MySQL silently converted it to 0, but in the version that the replica was running, it was an error.

Also, instead of doing CHANGE MASTER to fix the replica, you should be doing

STOP SLAVE;
[correct and execute whatever statement is the problem]
SET GLOBAL sql_slave_skip_counter = 1;
START SLAVE;

http://dev.mysql.com/doc/refman/5.1/en/set-global-sql-slave-skip-counter.html

I am assuming an operational replication configuration with your MySQL servers.

First, you create the database on the master. On the slaves, you update your cnf specifying replicate-do-db for the new databases. replicate-do-db is configured in either the cnf or as a flag (--replicate-do-db) and cannot be changed dynamically as a variable.td

From that point, you can populate the schema and master on the data and replicate down.

You can also create and populate the database on the master and all slaves then enable replicate-do-db. The key is making sure that the data matches before enabling replication on the slaves.