分类：单主多主模式

2020
09-24

mysql MGR 单主多主模式切换知识点详解

主库执行CREATEDATABASEtestCHARACTERSETutf8COLLATEutf8_general_ci;usetest;createtableifnotexistsh1(idint(10)PRIMARYKEYAUTO_INCREMENT,namevarchar(50)NOTNULL);insertintotest.h1values(1,"wang"),(2,"guo"),(3,"yang"),(4,"he");select*fromtest.h1;从库测试deletefromtest.h1whereid>3;ERROR1290(HY000):TheMySQLserverisrunningwiththe--super-read-onlyoptionsoitcannot... 继续阅读 >