Evaluation of Database-Level Replication and Binary Logging Options
When evaluating replication options, the slave begins by checking to see whether there are any --
replicate-do-db [2010] or --replicate-ignore-db [2011] options that apply. When using --
binlog-do-db [2041] or --binlog-ignore-db [2043], the process is similar, but the options are
checked on the master.
With statement-based replication, the default database is checked for a match. With row-based
replication, the database where data is to be changed is the database that is checked. Regardless
of the binary logging format, checking of database-level options proceeds as shown in the following
diagram.
... zobacz całą notatkę
Komentarze użytkowników (0)