Answer to Question #221589 in Databases | SQL | Oracle | MS Access for coleworld

Question

PRODUCE A TWO PAGE REPORT ON MYSQL STORAGE ENGINES OR TABLE TYPE

Answer 1

Which of the following correctly describes the functioning of the MySQL Federated Storage Engine?

A. Tables defined in the local MySQL database as being remotely linked are automatically replicated from the remote host to the localhost.

B. Local and remote MySQL servers share common storage through clustering provided by the Federated engine, which permits any server to share linked data with any other MySQL host participating in the Federated Cluster Block (FCB).

C. The MySQL engine on the local host reads the SQL statements, performs internal transformations, and then accesses the remote Federated table via its client API. The remote host returns results to the localhost, which then returns results as if they had been produced locally.

D. The Federated Storage Engine relies on NDB to spread the data and processing load over multiple computers, greatly enhancing performance and reliability.