Cargando…
High Availability MySQL Cookbook.
Over 60 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL database.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2010.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- High Availability MySQL Cookbook; High Availability MySQL Cookbook; Credits; About the Author; About the Reviewers; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 1. High Availability with MySQL Cluster; Introduction; Designing a MySQL Cluster; How to do it ... ; How it works ... ; There's more ... ; Creating an initial cluster configuration file-config.ini; How to do it ... ; There's more ... ; Installing a management node; How to do it ... ; Starting a management node; How to do it ...
- There's more ... Installing and starting storage nodes; Getting ready; How to do it ... ; There's more ... ; Installing and starting SQL nodes; How to do it ... ; Creating a MySQL Cluster table; How to do it ... ; Restarting a MySQL Cluster without downtime; Getting started; How to do it ... ; Recovering from a cluster shutdown; How to do it ... ; How it works ... ; There's more ... ; 2. MySQL Cluster Backup and Recovery; Introduction; Importing SQL files to a MySQL server and converting them to MySQL Cluster; How to do it ... ; There's more ... ; Taking an online backup of a MySQL Cluster; Getting ready.
- How to do it ... There's more ... ; Preventing commands hanging; Aborting backups in progress; Defining an exact time for a consistent backup; Restoring from a MySQL Cluster online backup; How to do it ... ; Restricting write access to a MySQL Cluster with single-user mode; How to do it ... ; There's more ... ; Taking an offline backup with MySQL Cluster; How to do it ... ; There's more ... ; Importing a cluster SQL file to an unclustered MySQL Server; Running mysqldump for a consistent backup; 3. MySQL Cluster Management; Introduction; Configuring multiple management nodes; Getting ready; How to do it ...
- There's more ... See also; Obtaining usage information; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Adding storage nodes online; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Replicating between MySQL Clusters; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Replication between clusters with a backup channel; How to do it ... ; There's more ... ; See also; User-defined partitioning; Getting ready; How to do it ... ; There's more ... ; Disk-based tables; Getting ready; How to do it ... ; How it works ... ; There's more ...
- Calculating DataMemory and IndexMemoryGetting ready; How to do it ... ; There's more ... ; See also; 4. MySQL Cluster Troubleshooting; Introduction; Single storage node failure; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Multiple storage node failures; Getting ready; How to do it ... ; Storage node partitioning and arbitration; Getting ready; How to do it ... ; How it works ... ; Debugging MySQL Clusters; Getting ready; How to do it ... ; There's more ... ; Firewalls; Host resolution; Memory; Seeking help; Getting ready; How to do it ... ; There's more ...