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's Blog:
High Performance PHP Session Storage on Scale
November 18, 2011 @ 10:13:25

In this new post to his blog, Johannes Schlüter looks at a high-performance solution to the usual storing PHP session information via a memcache frontend with a MySQL Cluster backend.

Unfortunately even such a system [using MySQL and InnoDB tables] has limits and unfortunately replication is no good solution here to scale further as we will always need a master for writing the updated session data. By using replication we can take some load from it and we can configure a slave which can be promoted to master to keep session alive if the primary master machine fails but at some point in time we need another solution ... but, happy news, again: One doesn't have to look far as MySQL cluster will be happy to help. MySQL Cluster "is a high-availability, high-redundancy version of MySQL adapted for the distributed computing environment," as the MySQL documentation states.

He describes the setup (after pointing to this post about installing MySQL Cluster for memcache) and includes some sample code/SQL/ini settings you'll need to use to get PHP's memcached functionality to cooperate with it.

0 comments voice your opinion now!
performance session storage mysql cluster memcache frontend backend


blog comments powered by Disqus

Similar Posts

Zend Developer Zone: The ZendCon Sessions Ep 14: Performance Tuning for PHP with Oracle Database

Developer.com: Creating a Code Search Engine with PHP and MySQL

Sebastian Bergmann's Blog: Xdebug Performance Boost

Job Posting: Radiant Recruiting Seeks Senior PHP/MySQL Developers (Dallas, Tx)

WeberDev.com: Using Adobe\'s Flex Builder tool to connect a PHP backend to the front end


Community Events

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


community voicesoftheelephpant podcast framework list library release example unittest video laravel opinion php7 series language laravel5 version interview introduction api

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