问题描述:
[单选]
A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:目前正在使用简单的主从复制。从显示从属状态输出中提取以下信息:The table mytable on the slave contains the following:从属服务器上的表mytable包含以下内容:…You have issued a STOP SLAVE command. One or more statements are required before you canissue a START SLAVE command to resolve the duplicate key error.Which statement should be used?您已发出停止从属命令。您需要一个或多个语句才能执行此操作发出START SLAVE命令以解决重复密钥错误。哪个是否应该使用语句?
A.SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
B.SET GTID_NEXT=”CONSISTENCY”; BEGIN; COMMIT; SET GTID_NEXT=” AUTOMATIC’;
C.SET GLOBAL enforce_gtid_consistency=ON
D.SET GTID_EXECUTED=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;
E.SET GTID_NEXT=”38f32e23480a7-32a1-c323f78067fd37821 : 9”; BEGIN; COMMIT; SET GTID_NEXT=”AUTOMATIC”;
参考答案:查看无
答案解析:无
☆收藏
答案解析:无
☆收藏
上一篇:You inherit a legacy database system when the previous DBA, Bob, leaves the company.You are notified that users are getting the following error( )()当上一个DBA Bob离开公司时,您将继承一个遗留数据库系统。系统会通知您,用户收到以下错误( )mysql> CALL film_in_stock (40, 2, @count);ERROR 1449 (HY000)( ) The user specified as a definer (‘bob’@’localhost’) does not exist指定为定义者的用户(“bob”@“localhost”)不存在How would you identify all stored procedures that pose the same problem?如何识别所有引起相同问题的存储过程?
下一篇:自然拼读的产品亮点是()
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.顾客对补充条款要求比较苛刻的 2.若店铺没有遵守先收定金后订货 3.团购业务概不赊帐,遵循货款当
