MySQL考试

<{p}>Choose two.<{br/}>You have semi-synchronous replication configured and working with one slave.<{br/}>rpl_semi_sync_master_timeout has never been reached.<{br/}>You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.<{br/}>Which two statements are true?<{/p}>

发布于 2021-02-25 23:46:31

【多选题】
A The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.
B Reads from the slave can return outdated data until the value of the rpl_semi_sync_master_timeout variable is reached.
C No committed transactions are lost.
D Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.
E A small amount of committed transactions may be lost in case they were committed just before the disk failure.
F As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.

关注者

0

被浏览

34

卡姿兰小眼睛 2023-02-25

你真的快乐吗？或许只是低着头不想说话……

此回答被采纳为最佳答案，开通VIP会员可查看

1 个回答

撰写答案

请登录后再发布答案，点击登录

关于作者

cr9

这家伙很懒，什么也没写！

提问

回答

1082

被采纳

1082

关注TA

发私信

相关问题

1

美国生产与质量中心的英文简称是()。

2

<{p}>Choose two.<{br/}>You administer a three node, single primary InnoDB Cluster.<{br/}>Examine cluster.status() displayed here:<{br/}>"statusText": "Cluster is ONLINE and can tolerate up to ONE failure."<{br/}>Which two statements are true?<{/p}>

3

<{p}>Choose three.<{/p}><{p}>Which three statements are true about MySQL Enterprise Firewall?<{/p}>

4

APQC流程分类框架将组织的流程分为()类()组。

5

<{p}>Choose two.<{/p}><{p}>Which two statements are true about general tablespaces?<{/p}>

6

<{p}>Choose two.<{/p}><{p}>Which two statements are true about raw binary backups?<{/p}>

7

不属于管理与支持过程的流程的是()。

8

<{p}>Choose two.<{/p}><{p}>You are investigating performance problems in a MySQL database; all data fits in memory.<{/p}><{p}>You determine that SELECT queries to one table is the main cause for poor response times.<{/p}><{p}>Which two have the biggest potential for eliminating the problem?<{/p}>

9

<{p}>Choose three.<{/p}><{p}>Which three methods display the complete table definition of an InnoDB table?<{/p}>

10

()是最早提出服务设计的学者之一。

发布
问题

手机
浏览

扫码手机浏览

在线
客服