Advertisement

Pro MySQL NDB Cluster

  • Jesper Wisborg Krogh
  • Mikiya Okuno

Table of contents

  1. Front Matter
    Pages i-xxix
  2. The Basics

    1. Front Matter
      Pages 1-1
    2. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 3-21
    3. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 23-64
  3. Installation and Configuration

    1. Front Matter
      Pages 65-65
    2. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 67-83
    3. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 85-140
    4. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 141-174
    5. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 175-236
  4. Daily Tasks and Maintenance

    1. Front Matter
      Pages 237-237
    2. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 239-249
    3. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 251-281
    4. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 283-307
    5. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 309-349
    6. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 351-371
    7. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 373-394
    8. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 395-437
  5. Monitoring and Troubleshooting

    1. Front Matter
      Pages 439-439
    2. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 441-455
    3. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 457-517
    4. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 519-550
    5. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 551-567
  6. Development and Performance Tuning

    1. Front Matter
      Pages 569-569
    2. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 571-609
    3. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 611-654
    4. Jesper Wisborg Krogh, Mikiya Okuno
      Pages 655-680
  7. Back Matter
    Pages 681-690

About this book

Introduction

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

Keywords

Database Management Open Source Clustering High Availability Database administration Pluggable Storage Engine SQL Nodes Data Nodes Replication Backup & Recovery Performance Tuning Information Schema MySQL Enterprise Monitor MySQL Cluster Manager

Authors and affiliations

  • Jesper Wisborg Krogh
    • 1
  • Mikiya Okuno
    • 2
  1. 1.SydneyAustralia
  2. 2.TochigiJapan

Bibliographic information