June 18, 2013

Post: Read/Write Splitting with PHP Webinar Questions Followup

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

Post: Percona sessions at the MySQL conference

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

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… we’re looking for. Things are much easier with say memcached session storage – this does not cause any locks for parallel session use so only…

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)