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/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
2012/11/22
by admin
11 Comments
PHP MySQL developers are confronted with three PHP MySQL APIs. That is confusing. Since mid 2012 the PHP manual suggests not to use the oldest and original PHP MySQL extension any more to cure the situation. Please, swap out ext/mysql … Continue reading
2012/11/08
by admin
Comments Off on MySQL Plugin development: public API?
The MySQL Plugin API is a neat way to add functionality to the MySQL server. Any user of MySQL is using it: see the storage engine plugins listed by SHOW PLUGINS. There are many types of plugins. For example, the … Continue reading