2014/10/30
by admin
Comments Off on PECL/mysqlnd_ms needs updates for MySQL Group Replication
‘Synchronous’, multi-master, auto-everything – that’s the new MySQL Group Replication (IPC14 talk/slides) in simple words. After torturing PHP developers for decades with MySQL Replication there is now a new replication option which does not require read-write splitting. A system that … Continue reading
2014/08/07
by admin
Comments Off on PECL/mysqlnd_ms: summer time, (connection) pool time – Fabric support internals
The MySQL replication and load balancing plugin for PHP, PECL/mysqlnd_ms, aims to make using a cluster of MySQL servers instead of a single server as transparent as possible. Should you ever want to migrate your PHP app from a single … Continue reading
2014/07/29
by admin
Comments Off on PECL/mysqlnd_ms: how failed XA transactions get fixed
XA transactions are an open standard for distributed transactions. A distributed or global transaction can spawn multiple databases. XA transactions come handy, for example, when data sets are sharded over multiple servers and a business transaction affects multiple shards. The … Continue reading
2014/06/13
by admin
3 Comments
The development version of PECL/mysqlnd_ms now has an very early version of distributed (2PC/XA) transaction support tailored for use with clusters of MySQL servers. XA transactions can span multiple servers in a cluster to ensure transaction guarantees among them. In … Continue reading
2014/05/21
by admin
Comments Off on PHP Unconference Europe, a legend. But lacking PHP…
A legend is born: PHP Unconference Europe, Majorca. Nearly one hundred witnesses exist. The #phpuceu combines the proven concept of an unconference with the beauty of the island of majorca. Within a day after the end of the event, one … Continue reading
2014/05/01
by admin
1 Comment
Majorca! May 2014 – 17./18! Could there be a better place and time on earth for the PHP EU Unconference: sun, fun, plenty of cheap flights, affordable accommodation? The PHP EU Unconference (tickets) is the international version of the national … Continue reading
2014/04/10
by admin
2 Comments
Inspired by Antony, Andrey has implemented a memory optimization for the PHP mysqlnd library. Depending on your usage pattern and the actual query, memory used for result sets is less and free’d earlier to be reused by the PHP engine. … Continue reading
2014/03/13
by admin
1 Comment
PECL/mysqlnd_ms 1.6 is currently being modified to support sharding and fully automatic server and client failover when using MySQL Fabric (slides) to manage a farm of MySQL servers. PECL/mysqlnd_ms is a mostly transparent load balancer that works with all PHP … Continue reading
2014/03/08
by admin
Comments Off on The early MySQL Fabric sharding support for PHP
The MySQL Fabric framework brings two major features: automatic client- and server-side failover and sharding. The manual hints, you need a “Fabric aware driver” for this but it does not list one for PHP. First, you don’t necessarily need new … Continue reading
2014/03/04
by admin
5 Comments
MySQL Fabric is a framework for MySQL Replication high availability, automatic failover and sharding. Technically, a MySQL Fabric daemon monitors a set of MySQL servers and takes appropriate actions upon failure. Clients use Fabric aware drivers to learn about failed … Continue reading