The ultimate guide to high-availability and high-performance in MySQL

Ensures that you know how MySQL NDB Cluster works and the projects for which it is appropriate to use

Provides guidelines and best practices for schema creation, and details of the five APIs

Helps with proactive monitoring for performance and troubleshooting

The ultimate guide to high-availability and high-performance in MySQL Ensures that you know how MySQL NDB Cluster works and the projects for which it is appropriate to use Provides guidelines and best practices for schema creation, and details of the five APIs Helps with proactive monitoring for performance and troubleshooting

Autorentext
Jesper Wisborg Krogh is a member of the Oracle MySQL Support team and has spoken on several occasions at Oracle OpenWorld. He has a background with a Ph.D. in computational chemistry before changing to work with MySQL and other software development in 2006. Jesper lives in Sydney, Australia and enjoys spending time outdoors walking, traveling, and reading. His areas of expertise include MySQL Cluster, MySQL Enterprise Backup, and the Performance and sys schemas. He is an active author in the Oracle Knowledge Base, and regularly blogs on MySQL topics.

Mikiya Okuno is a member of the Oracle MySQL Support team based in Japan, and has written four database related books in Japanese. He joined the MySQL support team in 2007 when MySQL AB was an independent company. Before joining MySQL, he worked at Sun Microsystems (which acquired MySQL AB, then was acquired by Oracle) as a technical support engineer. He brings over 16 years of technicalsupport experience in the computer industry. Mikiya is a self-confessed computer geek, and loves Gentoo Linux OS and ErgoDox keyboard for his desktop. Emacs is his preference.

Inhalt
Introduction.-.- I: The Basics.- 1. Architecture and Core Concepts.-2. The Data Nodes .-.- II: Installation and Configuration .- 3. System Planning.-4. Configuration.-5. Installation.-6. Replication.-.- III: Daily Tasks and Maintenance.- 7. The NDB Management Client and Other NDB Utilities.-8. Backups and Restores.-9. Table Maintenance.-10. Restarts.-11. Upgrades and Downgrades.-12. Security Considerations.-13. MySQL Cluster Manager.-.-IV: Monitoring and Troubleshooting.-14. Monitoring Solutions and the Operating System.-15. Sources for Monitoring Data.-16. Monitoring MySQL NDB Cluster.-17. Typical Troubles and Solutions.- V: Development and Performance Tuning .- 18. Developing Applications Using SQL with MySQL NDB Cluster.-19. MySQL NDB Cluster as NoSQL Database.-20. MySQL NDB Cluster and Application Performance Tuning.