MySQL Clustering

ISBN: 0672328550
EAN: 2147483647

Year: N/A
Pages: 93

Authors: Alex Davies, Harrison Fisk

BUY ON AMAZON

Installation

• 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

Configuration

• Configuration
• The Structure of config.ini
• Management Nodes
• Storage Nodes
• SQL Nodes
• Using Multiple Management Nodes

Backup and Recovery

• Backup and Recovery
• MySQL Clusters Native Backup Tool
• Restoring a Backup
• Troubleshooting Backups

Security and Management

• Security and Management
• Security for MySQL Cluster
• Managing MySQL Cluster
• Running MySQL in a Chrooted Environment

Performance

• Performance
• Performance Metrics
• MySQL Cluster Performance
• Benchmarking
• Indexes
• Query Execution
• Data Retrieval in MySQL Cluster
• Physical Factors
• High-Speed Interconnects

Troubleshooting

• What to Look for When Something Goes Wrong
• MySQL Cluster Errors

Common Setups

• Common Setups
• Load Balancing and Failover
• Cluster Topographies
• Web Farm/MySQL Farm
• Network Redundancy

A MySQL Cluster Binaries

• A MySQL Cluster Binaries
• An Overview of Binary Options
• Individual Programs

B Management Commands

• B Management Commands
• Displaying the Status of the Cluster/Controlling Nodes
• Logging Commands
• Miscellaneous Commands

C Glossary of Cluster Terminology

• C Glossary of Cluster Terminology

Index