June 18, 2013

Post: Worse than DDOS

…. If you’re using PHP functions make sure default_socket_timeout has proper value or set it per session. Set Curl Timeouts… stages and just setting timeout is not enough. Beware of PHP sessions “files” handler I already wrote about this topic, but when… are much easier with say memcached session storage – this does not cause any locks for parallel session use so only the process which…

Post: Read/Write Splitting with PHP Webinar Questions Followup

Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars.  If you missed it, you can still… scalabilty? A: It depends how you store $_SESSION.  I have audited sites that stored $_SESSION in the MySQL database for persistence, but… session table.  For best scalability, I’d recommend storing $_SESSION in an in-memory data store such as Memcached or APC.  Store in $_SESSION

Comment: Beyond great cache hit ratio

Jonathan, use repcached patch for memcached – it is stable solution that we used to share php session state over cluster (php stores session via memcache handler)

Post: Percona sessions at the MySQL conference

…Enhancements to MySQL and InnoDB Fernando Ipar: PHP Object-Relational Mapping Libraries In Action …: Instrumenting your Application for MySQL and Memcached Peter Zaitsev: InnoDB Architecture and Performance Optimization …also want to attend the Maatkit BoF session. We look forward to seeing you there…

Comment: PHP Sessions - Files vs Database Based

We store our PHP sessions (and everything else we can) in Memcached. I would HIGHLY recommend it.