php setop,PHP 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');