mysqlnd_ms:mysqlnd_ms pecl php扩展的分支

# mymysqlnd_ms This is a fork of the mysqlnd replication and load balancing plugin pecl extension [mysqlnd_ms](http://php.net/manual/en/book.mysqlnd-ms.php). 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](https://gist.github.com/sergiotabanelli/ce992b630d08a0bc7a9cec7c577638f5) >**DOCUMENTATION IS SLIGHTLY DIFFERNET FROM ORIGINAL ONE AND IT IS STILL NOT READY, YOU CAN FIND IT STARTING FROM [DOCS](docs/BOOK.md) DIRECTORY** # MAJOR CHANGES Most changes are in [Global transaction IDs](docs/BOOK/QUICKSTART-AND-EXAMPLES/GLOBAL-TRANSACTION-IDS.md) injection implementation and session consistency implementation of the [Quality Of Service filter](docs/BOOK/QUICKSTART-AND-EXAMPLES/SERVICE-LEVEL-AND-CONSISTENCY.md). * PHP7.x porting * [New QOS session consinstency](docs/BOOK/QUICKSTART-AND-EXAMPLES/SERVICE-LEVEL-AND-CONSISTENCY.md) and [transaction id injection](docs/BOOK/QUICKSTART-AND-EXAMPLES/GLOBAL-TRANSACTION-IDS.md) * [Server side read consistency](docs/BOOK/QUICKSTART-AND-EXAMPLES/SERVICE-LEVEL-AND-CONSISTENCY.md#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](docs/BOOK/QUICKSTART-AND-EXAMPLES/SERVICE-LEVEL-AND-CONSISTENCY.md#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](docs/BOOK/QUICKSTART-AND-EXAMPLES/SERVICE-LEVEL-AND-CONSISTENCY.md#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](docs/BOOK/QUICKSTART-AND-EXAMPLES/SERVICE-LEVEL-AND-CONSISTENCY.md#simple-client-side-write-consistency) * Multi master write consistency * Multi master write consistency logical partitions * New [config_dir](docs/BOOK/INSTALLING-CONFIGURING/RUNTIME-CONFIGURATION.md#mysqlnd_ms.config_dir) ini directive for connection based json config files * New [master_on](docs/BOOK/INSTALLING-CONFIGURING/RUNTIME-CONFIGURATION.md#mysqlnd_ms.master_on) ini directive for rw splitting * New [mysqlnd_ms_set_trx](docs/BOOK/MYSQLND_MS-FUNCTIONS/MYSQLND_MS_SET_TRX.md) and [mysqlnd_ms_unset_trx](docs/BOOK/MYSQLND_MS-FUNCTIONS/MYSQLND_MS_UNSET_TRX.md) 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](docs/BOOK.md) DIRECTORY** >**WORK IN PROGRESS** ## PHP7.x porting The `mymysqlnd_ms` extension has been tested on PHP5.x (5.5, 5.6) and PHP7.x (7.0, 7.1, 7.2, 7.3, 7.4) with no ZTS and ONLY ON LINUX (centos 6 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](https://github.com/sergiotabanelli/mymysqlnd_ms/issues)