Pro MySQL NDB Cluster (eBook)
XXIX, 690 Seiten
Apress (Verlag)
978-1-4842-2982-8 (ISBN)
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.
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 Who This Book Is For 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.
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 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.
IntroductionI: The Basics 1. Architecture and Core Concepts2. The Data Nodes II: Installation and Configuration 3. System Planning4. Configuration5. Installation6. ReplicationIII: Daily Tasks and Maintenance 7. The NDB Management Client and Other NDB Utilities8. Backups and Restores9. Table Maintenance10. Restarts11. Upgrades and Downgrades12. Security Considerations13. MySQL Cluster ManagerIV: Monitoring and Troubleshooting 14. Monitoring Solutions and the Operating System15. Sources for Monitoring Data16. Monitoring MySQL NDB Cluster17. Typical Troubles and SolutionsV: Development and Performance Tuning 18. Developing Applications Using SQL with MySQL NDB Cluster19. MySQL NDB Cluster as NoSQL Database20. MySQL NDB Cluster and Application Performance Tuning
Erscheint lt. Verlag | 3.11.2017 |
---|---|
Zusatzinfo | XXIX, 690 p. 134 illus., 80 illus. in color. |
Verlagsort | Berkeley |
Sprache | englisch |
Themenwelt | Informatik ► Datenbanken ► MySQL |
Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge | |
Schlagworte | Backup & Recovery • Clustering • database administration • Database Management • Data Nodes • High Availability • Information Schema • MySQL Cluster Manager • MySQL Enterprise Monitor • Open Source • Performance • Pluggable Storage Engine • Replication • SQL Nodes • Tuning |
ISBN-10 | 1-4842-2982-7 / 1484229827 |
ISBN-13 | 978-1-4842-2982-8 / 9781484229828 |
Haben Sie eine Frage zum Produkt? |
Größe: 13,8 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich