- Data needs to be available 24 x 7. - Frequent backups are required to protect

Question

- Data needs to be available 24 x 7.
       - Frequent backups are required to protect against data loss.
       - Widespread use of LAMP (LINUX, Apache, MySQL, PHP) throughout the organization.
       - The system needs to serve both OLTP and DSS needs.
       - Plentiful availability of low performance computers.
       - Users are disbursed over a number of different locations.
       - The organization’s MySQL applications can readily be modified to write data to a master MySQL instance, while performing reads against replicas.

Explanation / Answer

Plentiful availability of low performance computers is not a wise for my sql replication

Explantion

Replication enables data from one MySQL database server (the master) to be copied to one or more MySQL database servers (the slaves). Replication is asynchronous by default;
slaves do not need to be connected permanently to receive updates from the master. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.