Examples
Setup
Setup
Setup
The plugin is implemented as a PHP extension. See
also the installation instructions to install this extension.
Compile or configure the PHP MySQL extension (API)
(mysqli, PDO_MYSQL, mysql). That extension must use
the mysqlnd library as
because mysqlnd_memcache is a plugin for the mysqlnd library. For
additional information, refer to the mysqlnd_memcache
installation instructions.
Then, load this extension into PHP and activate the
plugin in the PHP configuration file using the PHP configuration
directive named mysqlnd_memcache.enable.
Example #1 Enabling the plugin (php.ini)
; On Windows the filename is php_mysqnd_memcache.dll ; Load the extension extension=mysqlnd_memcache.so ; Enable it mysqlnd_memcache.enable=1
Follow the instructions given in the » MySQL Reference Manual on installing
the Memcache plugins for the MySQL server. Activate the plugins
and configure Memcache access for SQL tables.
The examples in this quickguide assume that the
following table exists, and that Memcache is configured with access
to it.
Example #2 SQL table used for the
Quickstart
CREATE TABLE test( id CHAR(16), f1 VARCHAR(255), f2 VARCHAR(255), f3 VARCHAR(255), flags INT NOT NULL, cas_column INT, expire_time_column INT, PRIMARY KEY(id) ) ENGINE=InnoDB; INSERT INTO test (id, f1, f2, f3) VALUES (1, 'Hello', 'World', '!'); INSERT INTO test (id, f1, f2, f3) VALUES (2, 'Lady', 'and', 'the tramp'); INSERT INTO innodb_memcache.containers( name, db_schema, db_table, key_columns, value_columns, flags, cas_column, expire_time_column, unique_idx_name_on_key) VALUES ( 'plugin_test', 'test', 'test', 'id', 'f1,f2,f3', 'flags', 'cas_column', 'expire_time_column', 'PRIMARY KEY');