What is replicate do db?
replicate-do-db makes the slave just read statements from the relay log, that are for the specified DB. replicate-do-db has no effect on the master, since there is no relay log to read from. The LOCK TABLES part is there, so that the data is consistent.
What is binlog_ do_ db?
The binlog_do_db option allows you to configure a replication master to write statements and transactions affecting databases that match a specified name into its binary log. Since the filtered statements or transactions will not be present in the binary log, its replication slaves will not be able to replicate them.
What is Sync_binlog in MySQL?
When the limit is reached, MySQL has to perform a binary log rotation. With sync_binlog=0, all previous writes to the binary log are cached in the OS cache, and during rotation, MySQL forces synchronous flushing of all changes to disk. The obvious solution is to enable more frequent sync writes of binary logs.
What is multi threaded replication?
Replication SQL thread. A replica uses two threads to separate reading updates from the source and executing them into independent tasks. A replica with slave_parallel_workers set to a value greater than 0 is called a multithreaded replica. With this setup, transactions that fail can be retried.
What does ignore DB mean in MySQL replication?
Each Slave will receive the full binary log, but will only replicate changes related to the selected databases (i.e. databases not excluded by replicate-ignore-db — this list would be different on each Slave). ( mysql database being a system database, it should be ignored from both ends, unless you really, really really know what you are doing).
How to ignore a statement in a replication slave?
The replicate_ignore_db system variable allows you to configure a replication slave to ignore statements and transactions affecting databases that match a specified name. This system variable will not work with cross-database updates with statement-based logging or when using mixed-based logging and the statement is logged statement based.
How to change replication filter replicate _ rewrite _ DB?
The following statement rewrites statements occurring on database db1 on the source to database db2 on the replica: CHANGE REPLICATION FILTER REPLICATE_REWRITE_DB = ( (db1, db2)); The statement just shown contains two sets of parentheses, one enclosing the pair of database names, and the other enclosing the entire list.
What are the rules for replication in MySQL?
I have multiple slave “2 slave” must replicate MySQL table where as in other 2 should not be overwriten. Where as every other table will be replicated. Reading this: http://dev.mysql.com/doc/refman/5.6/en/replication-rules-db-options.html didnt make me clear enough.