MySQL
Multiple Choice
Answer as soon as possible
1. What does the
pt-table-checksum tool do?
(a) It adds a column to every table in every database, that will be
populated with the checksum of the row, so that when data is
changed, the data can be verified when replicated.
(b) It calculates checksums on every table that can be used to
compare a table on a master and slave to see if the data
matches.
(c) It installs and runs a checksum plugin into MySQL to help
enforce security during replication.
(d) None of the above.
2. What does the pt-table-sync
tool do?
(a) Starts the slave in a special mode that does a 2-way sync,
syncing data from master to slave and slave to master.
(b) Marks certain databases and tables for replication so that only
changes on those databases and tables get replicated to the slave
during normal replication.
(c) Compares the data in the master and slave tables and if
differences are found, sends the changes to the slaves so that they
will once again be in sync with the master.
(d) None of the above.
3. The pt-table-sync tool
works by re-applying the required change to the master so that it
can be replicated to all the slaves.
(a) True
(b) False
4. The pt-slave-find
tool:
(a) When run on the slave will find that slave's master.
(b) When run on the master will find that master's slaves.
(c) Reconnects a slave to its master after a replication
error.
(d) None of the above.
5. What do the --print and --execute options in
the pt-table-sync tool?
(a) Normally the pt-table-sync tool syncs the data silently, you
need the --print option to print the output as it executes.
(b) The --print option prints the changes what will be executed.
The --execute option will executes those changes.
(c) None of the above.
2)Answer
a)Starts the slave in a special mode that does a 2-way sync, syncing data from master to slave and slave to master.
3)Answer
a)True.
pt-table-sync in this pt means percona tool kit. This tool is used to make the changes. It always makes the changes on the replication master, never the replication slave directly.
MySQL Multiple Choice Answer as soon as possible 1. What does the pt-table-checksum tool do? (a)...
Use MySQL Workbench for these questions. Do NOT use Lucidchart. MySQL Workbench has more capability than Lucidchart, as it allows creation of DDL SQL from the model. Turn in 1 Workbench file , 1 document with the forward-engineered sql statements, and a Word document with your inserted data. This problem mimics the one from the previous assignment. Model it in Workbench, then forward-engineer the database script and import into your database. If the import fails, fix it in the model,...
Please do not delete the questions. 1. What is the purpose of a database? 2. What is the reason to use a database over a spreadsheet? 3. Based on the previous answers (#1 & #2), there is a simple rule of thumb. A spread sheet is used when there is _________________________. A database is used when there are _________________________. 4. Please answer followings. a) A group of 8 bits is called a ____________ (from Chapter 4). b) The answers of...
OPS Practice quiz 2. The benefits of risk pooling depend on the behavior of demand from one market relative to demand from another. True False 3. What is Supply Chain Management? A set of approaches utilized to efficiently integrate suppliers, manufacturers, warehouses and stores so that merchandize is produced, distributed at the right quantities, to the right locations and at the right time in order to minimize system wide costs while satisfying service level requirements. The management of the flow...
Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...
Discussion questions 1. What is the link between internal marketing and service quality in the airline industry? 2. What internal marketing programmes could British Airways put into place to avoid further internal unrest? What potential is there to extend auch programmes to external partners? 3. What challenges may BA face in implementing an internal marketing programme to deliver value to its customers? (1981)ǐn the context ofbank marketing ths theme has bon pururd by other, nashri oriented towards the identification of...
How can we assess whether a project is a success or a failure? This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...