mymysqlnd_ms

This is a fork of the mysqlnd replication and load balancing plugin pecl extension mysqlnd_ms.

For an introduction to replication lag cure and multi-master write conflicts management check MYSQLND_MS REVAMPED: Single and multi-master read/write consistency enforcing in MySQL async clusters with PHP and mysqlnd_ms extension

DOCUMENTATION IS SLIGHTLY DIFFERNET FROM ORIGINAL ONE AND IT IS STILL NOT READY, YOU CAN FIND IT STARTING FROM DOCS DIRECTORY

MAJOR CHANGES

Most changes are in Global transaction IDs injection implementation and session consistency implementation of the Quality Of Service filter.

• PHP7.x porting
• New QOS session consinstency and transaction id injection
• Server side read consistency (mysql >= 5.7.6 with --session-track-gtids=OWN_GTID)
  • Mysql native built-in read consistency
  • PHP session_id read consistency enforcing
• Server side write consistency (mysql >= 5.7.6 with --session-track-gtids=OWN_GTID)
  • Multi master write consistency
  • Multi master write consistency logical partitions
• Client side read consistency
  • Distinct master connection for client side read consistency and gtid injection
  • Client side transaction id injection with memcached mysql plugin
• Simple client side write consistency
  • Multi master write consistency
  • Multi master write consistency logical partitions
• New config_dir ini directive for connection based json config files
• New master_on ini directive for rw splitting
• New mysqlnd_ms_set_trx and mysqlnd_ms_unset_trx php functions for application based transaction tracking

Any suggestions or comments are very welcome.

DOCUMENTATION IS SLIGHTLY DIFFERNET FROM ORIGINAL ONE AND IT IS STILL NOT READY, YOU CAN FIND IT STARTING FROM DOCS DIRECTORY

WORK IN PROGRESS

PHP7.x and PHP8.x porting

The mymysqlnd_ms extension has been tested on PHP5.x (5.5, 5.6), PHP7.x (7.0, 7.1, 7.2, 7.3, 7.4) and PHP8.x (8.0, 8.1) with no ZTS and ONLY ON LINUX (centos 7 but i hope it works on any linux distribution). Requires libxm2, libmemcached and php json extension.

INSTALL

• Download or clone from Github.
• Install php-devel and php json package for your distribution and PHP version.
• Install libmemcached and libxml2 development packages for your distribution.
• from your cloned or downloaded directory run:

cd /path/to/mymysqlnd_ms
phpize
./configure
make
sudo make install

TESTS

Tests are not mocked and need 4 effective running mysql instances. With Docker there is a docker-compose.yml that could be used to build and run tests for centos 7.

From your source directory run:

docker-compose -f "docker-compose.yml" up -d --build

then open a shell on mysqlnd_ms running container, then compile and test, default php is php 5.5, if you want to compile against a different php version use module load and module unload. More or less this way:

module load php72
make distclean
phpize
./configure
make
make test

Without Docker there is a simple stupid script tests/make_sandbox.sh that installs the needed instances. To run it you need to install https://mysqlsandbox.net/ then download a mysql tarball extract it under $HOME/opt/mysql then rename the extracted directory to mysql version, i.e:

cd $HOME/opt/mysql
tar xvzf /path/to/mysql-5.7.24-el7-x86_64.tar.gz
mv mysql-5.7.24-el7-x86_64 5.7.24

cd /path/to/mysqnd_ms
./tests/make_sandbox.sh 5.7.24
make test

Some tests will still fail but those are test bugs not code bugs...

If you find any problems open an issue on Github