Which three statements are true about MySQL replication? (Choose three.)
Which three statements are true about MySQL replication? (Choose three.)
Replication can only use TCP/IP connections, ensuring secure and reliable communication between the master and slave instances. Any MySQL instance in a replication setup can act as a master to multiple slaves, allowing for scalability and distribution of read queries, but each instance can only have one master to maintain consistency in data replication. To enable replication, binary logging must be enabled on the master so that all changes are recorded and can be applied to the slaves.
ACF G IS NOT RIGHT. The slave does not need to be able to select data. It just needs to be able to get to the binlog and download commands.
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html "Note Replication cannot use Unix socket files. You must be able to connect to the replication source server using TCP/IP." For replication, you just need to be able read the binlogs. You do not need access to the tables on the master, so G is not it. A is.
C. Each instance in a replication topology must have a unique server ID. This is important to ensure that each instance can be uniquely identified in the replication process. F. Binary logging must be enabled on the master in order to replicate to other instances. Binary logging is essential for the master server to record changes that need to be replicated to the slave servers. G. A replication user must have the SELECT privilege for all tables that need to be replicated. The replication user on the slave server needs the SELECT privilege on the tables it's replicating to retrieve the data changes from the master.