Overview
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
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (20 chapters)
-
Front Matter
-
The Basics
-
Front Matter
-
-
Installation and Configuration
-
Front Matter
-
-
Daily Tasks and Maintenance
-
Front Matter
-
-
Monitoring and Troubleshooting
-
Front Matter
-
Keywords
About this book
Create and run a real-time, highly-available, and high-redundancy version of the world's most popular open-source database, MySQL. You will understand the advantages and disadvantages of the MySQL NDB Cluster solution, and when MySQL NDB Cluster is the right choice.
Pro MySQL NDB Cluster walks you through the full lifecycle of a MySQL Cluster installation: starting with the installation and initial configuration, moving through online configuration and schema changes, and completing with online upgrades. Along the way, you will learn to monitor your cluster, make decisions about schema design, implement geographic replication, troubleshoot and optimize performance, and much more.
This book covers the many programming APIs that are supported by MySQL NDB Cluster. There's also robust coverage of connecting to MySQL NDB Cluster from Java, SQL, memcached, and even from C++. From any of these languages, you'll be able to connect and store and retrieve data as your applications demand. The book:
- Covers MySQL NDB Cluster concepts and architecture
- Takes you through the MySQL NDB Cluster lifecycle from installation to upgrades
- Guides you through DBA and Developer decisions when working with MySQL NDB Cluster
What You'll Learn
- Understand the shared-nothing architecture behind MySQL NDB Cluster
- Plan, install, and configure a MySQL NDB Cluster environment
- Perform everyday tasks such as backing up, restoring, and upgrading Develop applications from Java, memcached, C++, and SQL
- Troubleshoot and resolve application performance problems
- Master enterprise-level features such the MySQL NDB Cluster Manager
Database administrators and developers who are looking into deploying MySQL NDB Cluster, or who already have a cluster in production and want to increase their knowledge and ability to handle routine administrative tasks and troubleshooting. The book also is for those developers wanting to employ MySQL NDB Cluster as their chosen storage engine from Java, memcached, and C++ applications.
Authors and Affiliations
About the authors
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 technical support 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.Â
Bibliographic Information
Book Title: Pro MySQL NDB Cluster
Authors: Jesper Wisborg Krogh, Mikiya Okuno
DOI: https://doi.org/10.1007/978-1-4842-2982-8
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Jesper Wisborg Krogh and Mikiya Okuno 2017
Softcover ISBN: 978-1-4842-2981-1Published: 06 November 2017
eBook ISBN: 978-1-4842-2982-8Published: 03 November 2017
Edition Number: 1
Number of Pages: XXIX, 690
Number of Illustrations: 54 b/w illustrations, 80 illustrations in colour
Topics: Database Management, Open Source