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

The Bakery: New Updates - Helpers, Tutorial and Articles

Graham Bird's Blog: Extra-pretty URLs with slugs

Zend Developer Zone: 30 Minutes with Chris Hartjes

Zend Developer Zone: Building AutoComplete Inputs with PHP, PEAR, Dojo and YUI

NETTUTS.com: How to Set Up a Killer WordPress Testing Environment Locally


Community Events

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


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

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