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 the MySQL Forums, where you can discuss your issues with other MySQL users.

Document generated on: 2020-03-02 (revision: 65196)

---

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