Question

Which among the following options is a challenge in the Master-Slave Replication model?

1:Availability

2:All the options

3:Load Balancing

4:Write Resilience

Answer 1

Answer:

4

Explanation:

write resilience

Answer 2

Answer:

The answer to the given question is:

4. Write Resilience

Explanation:

MySQL replication is a process of automatically copying data from one MySQL database server (server) to one or more MySQL database servers (server). It is commonly used to extend read access across multiple servers for scalability, although it can also be used for other purposes such as failover or data analysis on the server. in order not to overload the master

Since the master-slave replica is a one-way (master-to-slave) replica, only the master database is used for write operations. In contrast, read operations can be spread across multiple database slaves. If master-slave replication is used as a scalable solution, you must define at least two data sources, one for write operations and the second for read operations.

#SPJ2