Other Information About MySQL High Availability: Tools for Building Robust Data Centers [Paperback]
Â«????mysql(?????)Â» foreword preface part ?. replication 1. introduction what's this replication stuff anyway? so, backups are not needed then? what's with all the monitoring? is there anything else i can read? conclusion 2. mysql replication fundamentals basic steps in replication configuring the master configuring the slave connecting the master and slave a brief introduction to the binary log what's recorded in the binary log watching replication in action the binary log's structure and content python support for managing replication
.basic classes and functions operating system server class server roles creating new slaves cloning the master cloning the slave scripting the clone operation performing common tasks with replication reporting conclusion 3. the binary log structure of the binary log binlog event structure logging statements logging data manipulation language statements logging data definition language statements logging queries load data infile statements binary log filters triggers, events, and stored routines stored procedures stored functions events special constructions nontransactional changes and error handling logging transactions transaction cache distributed transaction processing using xa binary log management the binary log and crash safety binlog file rotation incidents purging the binlog file the mysqlbinlog utility basic usage interpreting events binary log options and variables conclusion 4. replication for high availability redundancy planning slave failures master failures relay failures disaster recovery procedures hot standby dual masters semisynchronous replication slave promotion circular replication conclusion 5. mysql replication for scale-out scaling out reads, not writes the value of asynchronous replication managing the replication topology example of an application-level load balancer hierarchal replication setting up a relay server adding a relay in python specialized slaves filtering replication events using filtering to partition events to slaves data sharding shard representation partitioning the data balancing the shards a sharding example managing consistency of data consistency in a nonhierarchal deployment consistency in a hierarchal deployment conclusion 6. advanced replication replication architecture basics the structure of the relay log the replication threads starting and stopping the slave threads running replication over the internet setting up secure replication using built-in support setting up secure replication using stunnel finer-grained control over replication information about replication status options for handling broken connections how the slave processes events housekeeping in the i/o thread sql thread processing slave safety and recovery syncing, transactions, and problems with database crashes rules for protecting nontransactional statements multisource replication row-based replication options for row-based replication mixed-mode replication events for handling row-based replication event execution events and triggers filtering conclusion part ?. monitoring and disaster recovery 7. getting started with monitoring ways of monitoring benefits of monitoring system components to monitor processor memory disk network subsystem monitoring solutions linux and unix monitoring process activity memory usage disk usage network activity general system statistics automated monitoring with cron mac os x monitoring system profiler console activity monitor microsoft windows monitoring the windows experience .the system health report the event viewer the reliability monitor the task manager the performance monitor monitoring as preventive maintenance conclusion 8. monitoring mysql what is performance? mysql server monitoring how mysql communicates performance performance monitoring sql commands the mysqladmin utility mysql gui tools mysql administrator mysql query browser server logs third-party tools the mysql benchmark suite database performance measuring database performance database optimization best practices best practices for improving performance everything is slow slow queries slow applications slow replication conclusion 9. storage engine monitoring myisam optimizing disk storage tuning your tables for performance using the mylsam utilities storing a table in index order compressing tables defragmenting tables monitoring the key cache preloading key caches using multiple key caches other parameters to consider innodb using the show engine command using innodb monitors monitoring'logfiles monitoring the buffer pool monitoring tablespaces using information_schema tables other parameters to consider conclusion 10. replication monitoring getting started server setup inclusive and exclusive replication replication threads monitoring the master monitoring commands for the master master status variables monitoring slaves monitoring commands for the slave slave status variables replication monitoring with mysql administrator other items to consider networking monitor and manage slave lag causes and cures for slave lag conclusion 11. replication troubleshooting what can go wrong problems on the master problems on the slave advanced replication problems tools for troubleshooting replication best practices know your topology check the status of all of your servers check your logs check your configuration conduct orderly shutdowns conduct orderly restarts after a failure manually execute failed queries common procedures reporting replication bugs conclusion 12. protecting your investment what is information assurance? the three practices of information assurance why is information assurance important? information integrity, disaster recovery, and the role of backups high availability versus disaster recovery disaster recovery the importance of data recovery backup and restore backup utilities and os-level solutions the innodb hot backup application physical file copy the mysqldump utility xtrabackup logical volume manager snapshots comparison of backup methods backup and mysql replication backup and recovery with replication pitr automating backups conclusion 13. mysql enterprise getting started with mysql enterprise subscription levels installation overview mysql enterprise components mysql enterprise server mem mysql production support using mysql enterprise installation fixing monitoring agent problems monitoring query analyzer further information conclusion part ?. high availability environments 14. cloud computing solutions what is cloud computing? cloud architectures is cloud computing an economical choice? cloud computing use cases cloud computing benefits cloud computing vendors aws a brief overview of technologies how does it all work? amazon cloud tools getting started working with disk where to go from here mysql in the cloud mysql replication and ec2 best practices for using mysql in ec2 open source cloud computing conclusion 15. mysql cluster what is mysql cluster? terminology and components how does mysql cluster differ from mysql? typical configuration features of mysql cluster local and global redundancy log handling redundancy and distributed data architecture of mysql cluster how data is stored partitioning transaction management online operations example configuration getting started starting a mysql cluster testing the cluster shutting down the cluster achieving high availability system recovery node recovery replication achieving high performance considerations for high performance high performance best practices conclusion appendix: replication tips and tricks index
Feedback for MySQL High Availability: Tools for Building Robust Data Centers [Paperback]
No rating yet for this product. be the first to rate this product.