单选题Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）AMySQL ReplicationBDistributed Replication Block DeviceCWindows Server Failover ClusteringDMySQL Cluster
单选题
Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）
A
MySQL Replication
B
Distributed Replication Block Device
C
Windows Server Failover Clustering
D
MySQL Cluster
参考解析
解析：
暂无解析
相关考题：
单选题You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）AIncrease the value of table_definition_cacheBIncrease the value of table_open_cache_instancesCDecrease the value of table_open_cache_instancesDIncrease the value of table_open_cacheEDecrease the value of table_definition_cacheFDecrease the value of table_open_cache
单选题MySQL is installed on a Linux server and has the following configuration: What is the purpose of changing ownership of datadir to the ‘mysql’ user?（）A MySQL requires correct file ownership while remaining secureB MySQL needs to be run as the root user, but file cannot be owned by itC MySQL cannot be run as the root user
单选题You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?（）ASTOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVEBSTOP SLAVE; BEGIN; SET GTID_IGNORE=aaa-bbb-ccc-ddd-eee: 3; COMMIT; START SLAVECSTOP SLAVE; SETGTID_NEXT=aaa-bbb-ccc-ddd-eee: 3; BEGIN; COMMIT; SET GTID_NEXT=AUTOMATIC; START SLAVEDSTOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
单选题Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）AMySQL ReplicationBDistributed Replication Block DeviceCWindows Server Failover ClusteringDMySQL Cluster
单选题While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?（）AActivating the MySQL Enterprise thread pool pluginBRelocating your data and log files to separate storage devicesCDisconnecting idle localhost client sessionsDImplementing storage engine data compression options
多选题Mysqldump was used to create a single schema backup; Shell mysqldump –u root –p sakila sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?（）AMysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';BShell＞ mysql –u root –p sakila sakila2013.sqlCShell＞ mysql import –u root –p sakila sakila2013.sqlDShell＞ mysql –u root -p –e 'use sakila; source sakila2013.sql'EShell＞ mysql –u root –p –silent ＜ sakila2013.sql