High Availability MySQL Cookbook.

High Availability MySQL Cookbook.

Over 60 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL database.

Saved in:
Bibliographic Details
Main Author: Davies, Alex
Format: eBook
Language:English
Published: Birmingham : Packt Pub., 2010.
Subjects:
SQL (Computer program language)
Database management.
Database management
Online Access:Click for online access
Table of Contents:
  • 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 ...

Similar Items