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

Sebastian Bergmann's Blog: Getting Started with Hamcrest

SitePoint PHP Blog: Find and Correct Misspelled Words with Pspell

Job Posting: 65media Seeks PHP/MySQL Developer (Marina del Rey, CA)

Scott Johnson\'s Blog: Your Simple PHP Code Snippet for Monday

php|architect: Creating RRD graphs in PHP


Community Events





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


list opinion library podcast bugfix release series symfony introduction interview framework api deployment voicesoftheelephpant community package tips language laravel install

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