题目详情:
发布时间:2020-06-20 22:27:06
[多选题]two.AnexistingasynchronousreplicationsetupisrunningMySQL8.WhichtwostepsareapartofimplementingGTIDreplication?
A.EnableGTIDbyexecutingthisonthemasterandtheslave:SETGLOBALGTID_ENABLED=on;
B.OntheslavealtertheMySQLmasterconnectionsettingwith:
ALTERchannelCHANGEMASTERTOMASTER_AUTO_POSITION=1;
C.ExecutethisontheslavetoenableGTID:RESETSLAVE;STARTSLAVEGTID_NEXT=AUTOMATIC;
D.ExecutethisontheslavetoenableGTID:STARTSLAVEIO_THREADWITHGTID;
E.RestartMySQL(masterandslave.withtheseoptionsenabled:--gtid_mode=ON--log-bin--log-slave-updates--enforce-gtid-consistency
F.OntheslavealtertheMySQLmasterconnectionsettingwith:CHANGEMASTERTOMASTER_AUTO_PSITION=1;
更多"[多选题]two.Anexistingasynchronousrepl"的相关试题: