http://blog.ulf-wendel.de It's all about Nixnutz Tue, 31 Jan 2012 19:02:13 +0000 http://backend.userland.com/rss092 en Why read stale data from an asynchronous MySQL replica (slave)? Fetch it from a local cache instead! Good for the clusters overall load, good for your applications performance. And, possible with PECL/mysqlnd_ms 1.3, the replication and load balancing plugin for PHP MySQL users. The idea is simple Any application using asynchronous MySQL ... http://blog.ulf-wendel.de/2012/peclmysqlnd_ms-faster-slave-accesses/ Is it worth the efforts to cache the results of a MySQL query at the client? In most cases the answer is: try it, measure it! Install the development version of the mysqlnd query cache plugin, which can be used with PDO_MySQL, mysqli and mysql. Set three PHP ... http://blog.ulf-wendel.de/2012/peclmysqlnd_qc-query-cache-statistics-log/ New in the PHP manual: a quickstart for the mysqlnd query cache plugin. PECL/mysqlnd_qc, the mysqlnd query cache plugin, is transparent and ease to use. But, how? Some pointers have been given in assorted presentations, here on my blog and in some, few examples from the manual. Fixed. You ... http://blog.ulf-wendel.de/2012/php-mysqlnd-query-cache-plugin-quickstart-is-online/ New in the PHP manual: a mysqli quickstart. You are new to PHP but you know how to code, you know SQL, you know relational databases and MySQL? Then, I hope, this is for you. All you need is a quick overview on the concepts? The rest is ... http://blog.ulf-wendel.de/2012/php-mysqli-quickstart-is-online/ We are giving PECL/mysqlnd_qc a second chance. PECL/mysqlnd_qc is a query cache plugin for mysqlnd. It can cache any query issued by any PHP MySQL extension using storage handler for process memory, APC, Memcache and SQLlite. Its default invalidation strategy is Time to Live (TTL). Using a more sophisticated invalidation ... http://blog.ulf-wendel.de/2012/peclmysqlnd_-ccc-cloud-cluster-caching/ The MySQL part of the PHP reference manual is currently being restructured: new landing and overview page, mysqli quickstart prepared. Ten years ago, there was the mysql extension and that was it. Today, beginners are faced with three MySQL APIs/extensions, two libraries and more than three library plugins. MySQL support ... http://blog.ulf-wendel.de/2011/php-mysql-documentation-updates/ A single MySQL server is a single point of failure. A single MySQL server can only be scaled vertically by increasing hardware size, which has its limits. That’s two good reasons to migrate from a single MySQL server to a cluster of MySQL servers. However, in cloudy white christmas times, ... http://blog.ulf-wendel.de/2011/load-balancing-for-php-and-mysql/ Christmas time, time for presents! Version 1.2.0-alpha of the free and open source PHP mysqlnd replication and load balancing plugin has been made available on PECL. PECL/mysqlnd_ms makes using any kind of MySQL database cluster easier featuring: Read-write splitting: automatic, SQL hints, can be disabled Load balancing: random, round robin, ... http://blog.ulf-wendel.de/2011/welcome-peclmysqlnd_ms-120-alpha-with-global-transaction-id-support/ What if your PHP application could tell the mysqlnd library what service quality you need when using a MySQL replication cluster? If you wanted read-your-writes, the driver would select replication nodes for you which can offer it. If you can allow replication lag but no more than three seconds, the ... http://blog.ulf-wendel.de/2011/peclmysqlnd_ms-quality-of-service-filter/ The MySQL administration SQL command SHOW PROCESSLIST may read "Waiting for table metadata lock" in its "State" column for a statement. The statement in question is waiting for another transaction to release a metadata lock. Its a state that may appear when using the global transaction ID injection feature ... http://blog.ulf-wendel.de/2011/waiting-for-table-metadata-lock-and-peclmysqlnd_ms/ Baby PECL/mysqlnd_ms 1.2.0-alpha, the PHP MySQL replication and load balancing plugin for mysqlnd, has done its first steps into the direction of global transaction id injection: injection happens, IDs can be queried. A simulated global transaction ids can be described as a transaction counter in a table on a MySQL ... http://blog.ulf-wendel.de/2011/peclmysqlnd_ms-global-transaction-id-injection-status/ The catchy theme/motto of the PECL/mysqlnd_ms 1.2 release will be Global Transaction ID support. Hidden behind the buzzword are two features. We will allow users to request a certain level of service from the replication cluster (keyword: consistency) and we will do basic global transaction ID injection to help ... http://blog.ulf-wendel.de/2011/global-transaction-id-support-for-peclmysqlnd_ms/ Elastic, fantastic: click here to add a MySQL replication database cluster to your cloud configuration. Click - yes, we can! Just one little thing, you need to update your application: consistency model changed. Plan for it. Some thoughts for PECL/mysqlnd_ms 1.x, the PHP mysqlnd replication plugin. Problem: C as in ... http://blog.ulf-wendel.de/2011/consistency-cloud-and-the-php-mysqlnd-replication-plugin/ The mysqli quickstart series is coming to an end. Today, the post is about non-prepared statements. You may also want to check out the following related blog posts: Using MySQL prepared statements with PHP mysqli Using MySQL multiple statements with PHP mysqli Using MySQL stored procedures with PHP mysqli Using mysqli to execute ... http://blog.ulf-wendel.de/2011/executing-mysql-queries-with-php-mysqli/ Opening a database connection is a boring tasks. But do you know how defaults are determined, if values are omitted? Or, did you know there are two flavours of persistent connections in mysqli? Of course you, as a german reader, know it. I blogged about it in 2009 over at ... http://blog.ulf-wendel.de/2011/using-mysql-with-php-mysqli-connections-options-pooling/ The series Using X with PHP mysqli continues. After notes on calling stored procedures and using prepared statements, its time for a multiple statement quickstart. A mighty tool, if used with care… Using Multiple Statements with mysqli MySQL optionally allows having multiple statements in one statement string. Sending multiple statements at ... http://blog.ulf-wendel.de/2011/using-mysql-multiple-statements-with-php-mysqli/ PECL/mysqlnd 1.1.2-stable has been released. The mysqlnd replication and load balancing plugin for PHP 5.3/5.4 finally got the download label it deserves: stable, ready for production use! PECL/mysqlnd_ms makes using any kind of MySQL database cluster easier. Download PECL/mysqlnd from pecl.php.net Documentation at the PHP Reference Manual Key features The release motto of the ... http://blog.ulf-wendel.de/2011/112-stable-release-of-the-replication-and-load-balancing-plugin-for-php/ Starting with PHP mysqli is easy, if one has some SQL and PHP skills. To get started one needs to know about the specifics of MySQL and a few code snippets. Using MySQL stored procedures with PHP mysqli has found enough readers to begin with a “quickstart” or “how-to” series. ... http://blog.ulf-wendel.de/2011/using-mysql-prepared-statements-with-php-mysqli/ A couple of weeks ago a friend of mine asked me how to use MySQL stored procedures with PHP’s mysqli API. Out of curiosity I asked another friend, a team lead, how things where going with their PHP MySQL project, for which they had planned to have most of ... http://blog.ulf-wendel.de/2011/using-mysql-stored-procedures-with-php-mysqli/ The free Mysqlnd replication and load balancing plugin now offers load balancing and lazy connections independent of read write splitting. This makes the plugin attractive for MySQL Cluster users. All nodes participating in a MySQL Cluster can serve all requests, they all accept read and write requests. No statement ... http://blog.ulf-wendel.de/2011/php-and-mysql-cluster-load-balancing-without-rw-split/