I have an application (Magento) that has an abstracted session storage layer. I'm trying to visualize the best way to store sessions.
mysql Database? I'm thinking a dedicated database with a very large innodb_buffer_pool_size so its basically like RAM Cache with disk backup. I'm thinking of having a seperate DB just for sessions and put the other DB stuff on a separate DB/DB Server.
Memcache? This is great but I am a bit concerned with what happens if the server crashes? I would lose that partition of sessions with the crash because from what I understand Memcache is not distrubuted. Can I make it distrubuted? ( I was just told that I can use pecl memcache module >= 3
tmpfs memory file storage? This works but I would have to sync the session on write with all the other servers using rsync or something that detects when an write happens in that folder. I'm sure something has got to exist for this.
Other solution I am not thinking about? Would love ideas.