MySQL Clustering


book cover
MySQL® Clustering
By Alex Davies, Harrison Fisk
...............................................
Publisher:
Pub Date: March 20, 2006
Print ISBN-10: 0-672-32855-0
Print ISBN-13: 978-0-672-32855-8
Pages: 216
 



Table of Contents  | Index
overview

Clustering is the final component of MySQL that makes it truly enterprise-level and able to compete fully with proprietary databases such as Oracle and Microsoft SQL Server. The increased number of high-demand, high-productivity corporations and institutions choosing MySQL, including MIT, the Department of Homeland Security, NASA, and Nokia, to name a few, need the benefit of clustering databases for high performance and scalability.

 

MySQL AB has stepped up to the plate to offer advanced, high-availability, reliable clustering. As this demand has increased, so has the need for information. MySQL Clustering offers thorough, authoritative instruction on setting up and administering a MySQL Cluster from the developers of the cluster itself. You will learn about everything from installation and configuration to performance and troubleshooting in this authoritative reference guide to MySQL clustering.



book cover
MySQL® Clustering
By Alex Davies, Harrison Fisk
...............................................
Publisher:
Pub Date: March 20, 2006
Print ISBN-10: 0-672-32855-0
Print ISBN-13: 978-0-672-32855-8
Pages: 216
 



Table of Contents  | Index

   Copyright
   About the Authors
   Acknowledgments
   We Want to Hear from You!
   Introduction
      Introduction to Database Clustering
      Why Use a MySQL Cluster?
      Cluster Terminology
      Designing a Cluster
      What This Book Covers
      Software Versions
      More Sources of Information
    Chapter 1.  Installation
      Before You Begin with MySQL Cluster
      Installing MySQL-Max
      Retrieving the Latest Snapshot from BitKeeper
      Ensuring That MySQL Cluster Works
      Auto-discovery of Databases
      Startup Phases
      Restarting a Cluster
      Testing Your Cluster
      Upgrading MySQL Cluster
      Obtaining, Installing, and Configuring MySQL Cluster on Other Platforms
      RAM Usage
      Adding Tables
      Common Errors While Importing Tables
    Chapter 2.  Configuration
      The Structure of config.ini
      Management Nodes
      Storage Nodes
      SQL Nodes
      Using Multiple Management Nodes
    Chapter 3.  Backup and Recovery
      MySQL Cluster's Native Backup Tool
      Restoring a Backup
      Troubleshooting Backups
    Chapter 4.  Security and Management
      Security for MySQL Cluster
      Managing MySQL Cluster
      Running MySQL in a Chrooted Environment
    Chapter 5.  Performance
      Performance Metrics
      MySQL Cluster Performance
      Benchmarking
      Indexes
      Query Execution
      Data Retrieval in MySQL Cluster
      Physical Factors
      High-Speed Interconnects
    Chapter 6.  Troubleshooting
      What to Look for When Something Goes Wrong
      MySQL Cluster Errors
    Chapter 7.  Common Setups
      Load Balancing and Failover
      Cluster Topographies
      Web Farm/MySQL Farm
      Network Redundancy
    Appendix A.  MySQL Cluster Binaries
      An Overview of Binary Options
      Individual Programs
    Appendix B.  Management Commands
      Displaying the Status of the Cluster/Controlling Nodes
      Logging Commands
      Miscellaneous Commands
    Appendix C.  Glossary of Cluster Terminology
   Index