Tag Info

New answers tagged

0

A lot of testing later, I have the answers. Does the filter apply to the snapshot? Yes. So out of my numbered list, 1 is correct. The reason I didn't really believe this to be true is because when quickly testing this I forgot about the option in Article Properties that controls how the Snapshot is applied. This also made me ask the question after the ...


2

I assume GTID has been already enabled on the master: Stop the master server Copy your data directory to the slave host Start the master. Technically it is not needed, but if you do not feel safe with what you do and want to be 100% sure everything is correct before continuing with replication- you can start it in read-only mode. Once you see that it is ...


2

OBSERVATION #1 The slave needs log-slave-updates in my.ini OBSERVATION #2 Both Master and Slave need binlog_gtid_simple_recovery in my.ini MySQL Restart is required on both Master and Slave to include new options SUGGESTION Since DB is 5GB, just mysqldump the database on the Master. No need for raw copying STEP 01 : On the Master, run this RESET ...



Top 50 recent answers are included