News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Ulf Wendel's Blog:
PECL/mysqlnd_ms compared to a classic
September 28, 2011 @ 08:43:57

Ulf Wendel has a new post that compares the performance of a classic method for using the mysqlnd plugin in MySQL replication to mysqlnd_ms, the replication and load balancing plugin for the mysqlnd driver (that works with the mysql and mysqli functionality and is, as of this beta of PHP, the default driver for MySQL connections).

Recently I was asked if PECL/mysqlnd_ms should be used to add MySQL replication support to a yet to be developed PHP application. The mysqlnd plugin, which supports all PHP MySQL extensions (PDO, mysqli, mysql), stood up against a classical, simple, proven and fast approach: one connection for reads, one connection for writes. Let's compare. This is a bit of an unfair challenge, because PECL/mysqlnd_ms was designed as a drop-in for existing applications, not optimized for those starting from scratch, *yell*... The plugin stands up quite well, anyway!

He starts with a look at the "classical pattern" of using a factory or singleton to make a database object instance that gives back different connections for reads versus writes (slave vs master). The mysqlnd_ms plugin allows you to define configuration settings to tell the queries to automatically go to certain places for different actions. For example, you could use "master_on_write" to tell it to use a master node if you're doing an INSERT or UPDATE versus a SELECT. He also shows a more complex example using a SQL hint and one issue that might come from the "human element" - not paying attention to database character sets.

0 comments voice your opinion now!
pecl mysqlnd mysqlndms mysql replication configuration automatic


blog comments powered by Disqus

Similar Posts

Kevin Schroeder's Blog: Setting up a connection to the Zend Developer Cloud on Linux

PHPBuilder.com: Using PHP Configuration Patterns Properly

Community News: Latest PECL Releases for 09.26.2006

Code2Learn.com: Using HighCharts with php , MySQL and CodeIgniter

Community News: Latest PECL Releases for 01.01.2008


Community Events

Don't see your event here?
Let us know!


release voicesoftheelephpant framework series api library extension symfony2 introduction version example opinion conference interview install laravel performance community podcast php7

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework