Replication复制权限发生变化1) SHOW MASTER STATUS语句更名为SHOW BINLOG STATUS 2) REPLICATION CLIENT权限更名为BINLOG MONITOR 3) SHOW BINLOG EVENTS语句需要BINLOG MONITOR权限 4) SHOW SLAVE HOSTS语句需要REPLICATION MASTER ADMIN权限
在传统认知下,基于binlog为statement语句的复制,触发器会在slave从库上工作;而如果基于binlog为ROW行的复制,触发器不会在slave从库上工作。With statement-based replication, triggers executed on the master also execute on the slave. With row-based replicat
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号