High availability MySQL cookbook over 50 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL databases
Over 60 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL database
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, U.K. :
Packt Open Source
2010.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628447106719 |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; Table of Contents; Preface; Chapter 1: High Availability with MySQL Cluster; Introduction; Designing a MySQL Cluster; Creating an initial cluster configuration file-config.ini; Installing a management node; Starting a management node; Installing and starting storage nodes; Installing and starting SQL nodes; Creating a MySQL Cluster table; Restarting a MySQL Cluster without downtime; Recovering from a cluster shutdown; Chapter 2: MySQL Cluster Backup and Recovery; Introduction
- Importing SQL files to a MySQL server and converting them to MySQL ClusterTaking an online backup of a MySQL Cluster; Restoring from a MySQL Cluster online backup; Restricting write access to a MySQL Cluster with single-user mode; Taking an offline backup with MySQL Cluster; Chapter 3: MySQL Cluster Management; Introduction; Configuring multiple management nodes; Obtaining usage information; Adding storage nodes online; Replicating between MySQL Clusters; Replication between clusters with; a backup channel; User-defined partitioning; Disk-based tables; Calculating DataMemory and IndexMemory
- Chapter 4: MySQL Cluster TroubleshootingIntroduction; Single storage node failure; Multiple storage node failures; Storage node partitioning and arbitration; Debugging MySQL Clusters; Seeking help; NIC teaming with MySQL Cluster; Chapter 5: High Availability with MySQL Replication; Introduction; Designing a replication setup; Configuring a replication master; Configuring a replication slave; without syncing data; Configuring a replication slave,; migrating data with a simple SQL dump; Using LVM to reduce downtime; on a master when bringing a slave online; Replication safety tricks
- Multi Master Replication Manager (MMM):initial installation; Multi Master Replication Manager (MMM):; installing the MySQL nodes; Multi Master Replication Manager (MMM):; installing monitoring node; Managing and using; Multi Master Replication Manager (MMM); Chapter 6: High Availability with MySQL and Shared Storage; Introduction; Preparing a Linux server for shared storage; Configuring two servers for shared storage MySQL; Configuring MySQL on shared storage with Conga; Fencing for high availability; Configuring MySQL with GFS; Chapter 7: High Availability with Block Level Replication
- IntroductionInstalling DRBD on two Linux servers; Manually moving services within a DRBD cluster; Using heartbeat for automatic failover; Chapter 8: Performance Tuning; Introduction; Tuning the Linux kernel IO; Tuning MySQL Cluster storage nodes; Tuning MySQL Cluster SQL nodes; Tuning queries within a MySQL Cluster; Tuning GFS on shared storage; MySQL Replication tuning; Appendix A: Base Installation; Appendix B: LVM and MySQL; Appendix C: Highly Available Architectures; Single-site architectures; Multi-site architectures; Summary of options; Index
