Performance
Performance is a very important topic when dealing with any database setup. One of the main reasons to use a cluster over a nonclustered database is the ability to get better performance and scalability compared to using a database that is confined to a single host. This chapter discusses many of the concepts related to performance and scalability, as well as how to ensure that you get the maximum from your MySQL Cluster setup.
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
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
Common Setups
A MySQL Cluster Binaries
B Management Commands
- B Management Commands
- Displaying the Status of the Cluster/Controlling Nodes
- Logging Commands
- Miscellaneous Commands
C Glossary of Cluster Terminology
Index
MySQL Clustering
ISBN: 0672328550
EAN: 2147483647
EAN: 2147483647
Year: N/A
Pages: 93
Pages: 93
Authors: Alex Davies, Harrison Fisk
