پرو مای‌اس‌کیوال ان‌دی‌بی کلاستر

Front Matter ....Pages i-xxix Front Matter ....Pages 1-1 Architecture and Core Concepts (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 3-21 The Data Nodes (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 23-64 Front Matter ....Pages 65-65 System Planning (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 67-83 Configuration (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 85-140 Installation (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 141-174 Replication (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 175-236 Front Matter ....Pages 237-237 The NDB Management Client and Other NDB Utilities (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 239-249 Backups and Restores (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 251-281 Table Maintenance (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 283-307 Restarts (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 309-349 Upgrades and Downgrades (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 351-371 Security Considerations (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 373-394 MySQL Cluster Manager (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 395-437 Front Matter ....Pages 439-439 Monitoring Solutions and the Operating System (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 441-455 Sources for Monitoring Data (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 457-517 Monitoring MySQL NDB Cluster (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 519-550 Typical Troubles and Solutions (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 551-567 Front Matter ....Pages 569-569 Developing Applications Using SQL with MySQL NDB Cluster (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 571-609 MySQL NDB Cluster as a NoSQL Database (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 611-654 MySQL NDB Cluster and Application Performance Tuning (Jesper Wisborg Krogh, Mikiya Okuno)....Pages 655-680 Back Matter ....Pages 681-690 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. 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.