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

Kevin Boyd: Retrofitted Login Throttling

Thilanka Kaushalya's Blog: How to use Mysql Transactions with PHP

Mike Willbanks' Blog: Zend Framework Cache Backend Libmemcached + Session Cache

DevShed: Classes as PHP Functions

PHPMaster.com: Getting Started with Varnish


Community Events





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


configure threedevsandamaybe interview unittest wordpress community bugfix laravel application podcast series list introduction developer api release language install code library

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