High availability MySQL cookbook : over 50 simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL databases / Alex Davies.

Format:

Book

Author/Creator:

Davies, Alex.

Language:

English

Subjects (All):

MySQL (Electronic resource).

SQL (Computer program language).

Database management.

Physical Description:

1 online resource (276 p.)

Edition:

1st edition

Other Title:

Over fifty simple but incredibly effective recipes focusing on different methods of achieving high availability for MySQL databases

Place of Publication:

Birmingham, U.K. : Packt Open Source, 2010.

Language Note:

English

System Details:

text file

Summary:

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

Contents:

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

Notes:

Includes index.

ISBN:

9786612557408

9781282557406

1282557408

9781847199959

184719995X

OCLC:

796383959