MySQL High Availability- P14: 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. | architectures supported 480-483 AWS case study 484 487-516 best practices 520-522 characteristics of 479 defined 478 deployment models 480 economical considerations 483-484 elasticity and 482 grid computing and 481 MySQL Enterprise and 473 open source 522 potential benefits 485 replication and 517-520 service models 479 software libraries and 483 transactional computing and 482 use cases 484 vendor support 486 virtualization and 481 clustered indexes 353 comments hash marks in 90 retrieving 177 COMMIT statement logging transactions 75 query events and 234 slave promotion 132 two-phase commit and 150 commit_and_sync function 186 190 compressing tables 345 347 concat function 319 configuration file best practices 404 binary log and 47 59-61 165 configuring masters 13-14 configuring slaves 15 managing replication 24 options supported 58 Server class and 26 SSL considerations 204 troubleshooting replication 400 CONNECTION_ID function row-based replication and 229 session-specific 216 thread ID and 56 57 connect_to helper function 157 consistency see data consistency Console application 271 --console option 315 constraints best practices 337 context events logging queries 51-57 SQL threads and 217-220 contingency plans high availability defined 104 disaster recovery 107 417 master failures 106 planning considerations 106 relay failures 107 slave failures 106 CPU-bound processes 249 Create Basic Task Wizard 43 CREATE FUNCTION statement 69 CREATE INDEX command 538 CREATE PROCEDURE statement 67 CREATE ROUTINE privilege 70 CREATE statement binlog events and 48 ENGINE parameter 334 logging transactions 76 CREATE TABLE IF NOT EXISTS statement 46 135 CREATE TABLE statement implicit commits and 135 logging 51 CREATE TRIGGER statement DEFINER clause 65 security considerations 63 CREATE USER privilege 16 Create_file_log_event 58 credentials getting 498 instances and 500 cron facility 253 268 crontab files 42 CSV storage engine 334 CURDATE function 53 current database binary log .
