News Feed
Sections




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

Johannes Schlüter:
Sharding PHP with MySQL Fabric
October 10, 2013 @ 08:30:16

Johannes Schlüter has a new post to his site today showing how to use the MySQL Fabric functionality to do sharding in your PHP application. The MySQL Fabric (recently released) is "an integrated environment for managing a farm of MySQL server supporting high-availability and sharding."

As this release of Fabric put the focus on sharding, this is what I want to show here, too. A general introduction to MySQL Fabric and its sharding features can be found on VN's blog so I'll be quite fast in some areas, for details please refer to the documentation and the mentiond blogs.

He walks you through the installation of the support for Fabric and how to configure it for storage. He then creates some groupings/shards with the "mysqlfabric" command line tool and sets up the sharding rules. Next up is the installation of the mysqlnd_ms extension for PHP and configuring it via a JSON file and in the php.ini. A sample test script is included showing how to create a table, insert a record and pull it back out from the sharded setup.

0 comments voice your opinion now!
sharding mysql fabric tutorial install configure extension

Link: http://schlueters.de/blog/archives/175-Sharding-PHP-with-MySQL-Fabric.html

blog comments powered by Disqus

Similar Posts

C. Sadeesh Kumar's Blog: Smart File Type Detection Using PHP

php|architect Blog: WordPress 404 Plugin built on Bing Wrapper

php|architect: Writing an AJAX-based Visual Rating System with PHP

Developer.com: Scaffolding with CakePHP - Managing Your Fantasy Football Team

Matthew Leverton\'s Blog: How to add a custom CAPTCHA to phpBB2


Community Events





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


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

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