Archiv für den Monat May, 2011

Wonders of Global Transaction ID injection

Friday, May 20th, 2011

SQL injection is wonderful! MySQL Proxy can do it, mysqlnd plugins - even written in PHP (not Lua or C) - can do it. Global Transaction IDs are wonderful. A mashup of the PHP replication plugin and global transaction ID injection, makes your replication cluster fail-over much smoother and opens up an opportunity […]

PHP replication plugin future: eventual consistent, eventual served from cache!

Tuesday, May 17th, 2011

While Andrey is busy implementing partitioned replication infrastructure code for the PHP replication and load balancing plugin (PECL/mysqlnd_ms), I continued my search for ideas to steal. Mr. Robert Hodges, I’ve robbed the idea of a service level and caching.. If an application is able to function with stale data read from a MySQL replication slave, […]

Partitioning support for the PHP replication plugin

Thursday, May 12th, 2011

The Mysqlnd replication and load balancing plugin alpha release has focused on laying foundations for read-write splitting and load balancing. Thus, we can now look into more juicy topics such as support of schemata based partitioning to increase the granularity of load balancing. Not every slave server needs to replicate all schemata (databases) and tables […]

Stille Diskographie

Wednesday, May 4th, 2011

Frühlingsputz: weg mit den alten Zeitungen! Noch mehr Wohnung kann ich mir nicht leisten!
Halt: das sind keine Fotomagazine, keine Geo-Hefte, keine Airbrush-Magazine und auch keine normalen Computerzeitschriften. Was mir in die Hände fällt sind Belegexemplare. Genussvoll blättere ich im moderigen Papier. Gedanken kommen auf. Als ich das schrieb, saß ich mit dem Dell-Notebook, […]