Database Management
MySQL
Subjective
Oct 01, 2025
Explain MySQL replication and its types.
Detailed Explanation
MySQL replication copies data from master to slave servers for backup and load distribution.
Types:
• Master-Slave: One master, multiple slaves (read-only)
• Master-Master: Multiple masters (bidirectional)
• Statement-based: Replicates SQL statements
• Row-based: Replicates actual data changes
• Mixed: Combines both approaches
Configuration:
server-id=1
log-bin=mysql-bin
binlog-format=ROW
Discussion (0)
No comments yet. Be the first to share your thoughts!
Share Your Thoughts