You have replication configured, which consists fo one master and one slave on defferent hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database. Which replication filter contributes to your goal?

单选题

You have replication configured, which consists fo one master and one slave on defferent hosts with an asynchronous replication channel between them.Your goal is to decrease the amount of data that is transferred between these two hosts.It is confirmed that the slave instance does not need to have data from the example database. Which replication filter contributes to your goal?

答案解析

多选题

You have semi-synchronous replication configured and working with one slave. rpl_semi_sync_master_timeout has never been reached.You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.Which two statements are true?

答案解析

单选题

Choose the best answer.You have configured GTID-based asynchronous replication with one master and one slave. A user accidentally updated some data on the slave.To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

答案解析

单选题

--Have you ________to Shanghai--Yes,I have

答案解析

单选题

Choose the best answer.You use Row Based Replication and need to see pseudo-SQL statements for the replication event that is located in the log_file position NNNNN file.Which command should you use?

答案解析