MySQL HA/Scalability Guide

Abstract

This is the MySQL HA/Scalability Guide extract from the MySQL Reference Manual.

For legal information, see the Legal Notices.

For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users.

For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library.

Document generated on: 2017-07-20 (revision: 53027)

---

Table of Contents     [+/-]

Preface and Legal Notices

1 High Availability and Scalability

2 Using ZFS Replication     [+/-]

2.1 Using ZFS for File System Replication

2.2 Configuring MySQL for ZFS Replication

2.3 Handling MySQL Recovery with ZFS

3 Using MySQL with memcached     [+/-]

3.1 Installing memcached

3.2 Using memcached     [+/-]

3.2.1 memcached Command-Line Options

3.2.2 memcached Deployment

3.2.3 Using Namespaces

3.2.4 Data Expiry

3.2.5 memcached Hashing/Distribution Types

3.2.6 Using memcached and DTrace

3.2.7 Memory Allocation within memcached

3.2.8 memcached Thread Support

3.2.9 memcached Logs

3.3 Developing a memcached Application     [+/-]

3.3.1 Basic memcached Operations

3.3.2 Using memcached as a MySQL Caching Layer

3.3.3 Using libmemcached with C and C++

3.3.4 Using MySQL and memcached with Perl

3.3.5 Using MySQL and memcached with Python

3.3.6 Using MySQL and memcached with PHP

3.3.7 Using MySQL and memcached with Ruby

3.3.8 Using MySQL and memcached with Java

3.3.9 Using the memcached TCP Text Protocol

3.4 Getting memcached Statistics     [+/-]

3.4.1 memcached General Statistics

3.4.2 memcached Slabs Statistics

3.4.3 memcached Item Statistics

3.4.4 memcached Size Statistics

3.4.5 memcached Detail Statistics

3.4.6 Using memcached-tool

3.5 memcached FAQ