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

DeveloperTutorials.com: Upload Files to MySQL using PHP Tutorial

Joakim Nygard's Blog: Timezones in MySQL and PHP

Community News: phpDocumentor Merges with DocBlox for phpDocumentor 2!

Ed Eliot's Blog: Automatic merging and versioning of CSS/JS files with PHP

DevShed: Building Site Registration for Web Application Security


Community Events





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


laravel series development interview zendserver symfony tips list framework bugfix release code community language deployment introduction api threedevsandamaybe conference podcast

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