MySQL High Availability- P13: A lot of research has been done on replication, but most of the resulting concepts are never put into production. In contrast, MySQL replication is widely deployed but has never been adequately explained. This book changes that. Things are explained here that were previously limited to people willing to read a lot of source code and spend a lot of time debugging it in production, including a few late-night sessions. | replication threads 371 scripting clone operation 35-36 security and 64 Server class 26-28 server logs and 315 server roles 28-30 structure considerations 20-22 46-50 troubleshooting 392 --verbose option 564 binary log events defined 46 logging statements 61-66 structure considerations 46-50 troubleshooting 389-391 binlog dump thread 371 binlog file format version 48-50 84 binlog file rotation 83 binlog files creating 88 creation time 98 dumping contents 88 functionality 47 processing order 92 purging 85 86 reading remotely 93 shared disks and 117 binlog index file functionality 47 purging 85 87 binlog injector thread 554 binlog-cache-size option 99 binlog-cache-size server variable 84 binlog-do-db option 59-61 163 315 369 binlog-format option 230 231 553 binlog-ignore-db option 59-61 163 315 369 binlog-in-use flag 81 84 96 binlog-max-row-event-size option 231 Binomial tail distribution 105 Blackhole storage engine 160 334 bootstrapping a slave 30 Bott Ed 283 browser plug-ins 494 buckets defined 491 buffer pools defined 353 monitoring 360-363 Bunce Tim 429 business continuity see information integrity C CA certification authority 203 204 CACHE INDEX command 350 Cacti tool 252 CALL statement 68 central store duplicating 156 certification authority CA 203 204 chain topology 402 CHANGE MASTER command cloud computing and 518 connecting to downstream server 144 IGNORE_SERVER_IDS option 144 398 399 master heartbeats 383 master status variables and 376 MASTER_HOST option 202 noting slave position 118 troubleshooting replication 400 troubleshooting slaves 393 395 usage example 145 CHANGE MASTER TO command configuring replication 199 configuring slaves 32 CONNECT_RETRY parameter 215 creating slaves 30 hot standby and 114 MASTER_SSL option 204 MASTER_SSL_CAPATH option 204 MASTER_SSL_CERT option 204 MASTER_SSL_KEY option 204 privilege considerations 16 replication status information 207 slave promotion 129 134 usage example 15 channel defined 554 checksumming 251 circular .
