User Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server creates on the fly while processing queries. However, the two types of table...
Using different storage engines on master and slave. It is possible to replicate transactional tables on the master using nontransactional tables on the slave. For example, you can replicate an InnoDB master table as a
Using GTIDs for Failover and Scaleout There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) in MySQL 5.6.9 and later for provisioning a new slave which can then be used for scaleout, being promoted to master as necessary for failover. In this se...
Using libmemcached with C and C++ The libmemcached library provides both C and C++ interfaces to memcached and is also the basis for a number of different additional API implementations, including Perl, Python and Ruby. Understanding the core ...
Using MySQL and memcached with Java The com.danga.MemCached class within Java provides a native interface to memcached instances. You can obtain the client from https://github.com/gwhalin/Memcached-Java-Client/downloads. The Java class uses ha...
Using MySQL and memcached with Perl The Cache::Memcached module provides a native interface to the Memcache protocol, and provides support for the core functions offered by memcached. Install ...
Using MySQL and memcached with PHP PHP provides support for the Memcache functions through a PECL extension. To enable the PHP memcache extensions, build PHP using the --enable-memcache option to configure when building from source. If you ar...
Using MySQL and memcached with Python The Python memcache module interfaces to memcached servers, and is written in pure Python (that is, without using one of the C APIs). You can download and ...
Using MySQL and memcached with Ruby There are a number of different modules for interfacing to memcached within Ruby. The Ruby- MemCache client library provides a native interface to memcached that does not require any external libraries, such...
Using MySQL Proxy There are a number of different ways to use MySQL Proxy. At the most basic level, you can allow MySQL Proxy to pass queries from clients to a single server. To use MySQL Proxy in this mode, you just have to specify on the command line the backend server to which the proxy should...
