2013/03/20
by admin
1 Comment
Just in time for a PHP 5.5 code freeze, we are brushing over the Replication and Load Balancing plugin (PECL/mysqlnd_ms) and the Query Cache plugin (PECL/mysqlnd_qc) for PHP mysqlnd. PECL/mysqlnd_ms 1.5 is a step up from the previous version whereas … Continue reading
2013/03/20
by admin
1 Comment
Live from the PHP Summit conference in Munich: NoSQL in MySQL. A couple of hours ago I gave a talk about NoSQL in MySQL, contents: what is NoSQL, what is HandlerSocket, what is the InnoDB Memcached Plugin InnoDB and how … Continue reading
2013/02/24
by admin
6 Comments
PECL/mysqlnd_ms is a client-side load balancer for PHP that supports any MySQL cluster. It does read-write splitting, failover, introduces a quality of service concept, supports partitioning and, of course, load balancing. New mysqli API (begin, *savepoint) calls in PHP 5.5.0 … Continue reading
2013/01/28
by admin
2 Comments
I am telling no secret saying MySQL 5.6 GA can be expected to be released soon, very soon. Time to test one of the improvements: MySQL 5.6 speaks SQL and Memcache protocol. In your PHP MySQL apps, try using the … Continue reading
2013/01/17
by admin
5 Comments
I love the new NoSQL systems: more choices! After years of RDBMS dominance there are hundrets of NoSQL systems offering a wide range of data models, data distribution strategies and interfaces. Polyglot persistence describes the market change. I am most … Continue reading
2013/01/10
by admin
Comments Off on Solution for: MySQL 5.6 password expired, PHP can’t connect, application stops
MySQL 5.6 introduces a new features that must be used with great care. A MySQL users password can be marked as expired. This way, a DBA can force a user to set or reset his password. The MySQL user must … Continue reading
2013/01/04
by admin
Comments Off on PECL/mysqlnd_ms and the client failover dilemma – part 1
MySQL Replication has a weak point: the master (primary) is a single point of failure. People ask frequently about client failover. Making a client library failover a client automatically from one server to another is simple. PECL/mysqlnd_ms can do it. … Continue reading
2012/12/30
by admin
Comments Off on … and a Happy New Year!
Picture taken over christmas 2012 near Büsum.
2012/12/19
by admin
1 Comment
It is time for christmas presents: some sharding support and cache locality optimizations are coming with PECL/mysqlnd_ms 1.5. PECL/mysqlnd_ms is a plugin for the mysqlnd library. The plugin adds replication and load balancing support to any PHP MySQL API (mysql, … Continue reading
2012/12/12
by admin
1 Comment
Do I have to look out for a new job? Some analysists say so: NoSQL is getting stronger. Given the prediction it is time for me to learn what NoSQL is. Vote NO for MySQL from Ulf Wendel http://de.slideshare.net/nixnutz/vote-no-for-mysql (Slides: … Continue reading