i have performance issue regarding sessions, i'm using the following components 1. MongoDB as my application database 2. MySQL as my analytics database 3. Memcache to reduce call to MongoDB
My application is based on Amazon Servers, MongoDB installed on a standalone instance, MySQL on RDS and the application itself installed on a standalone instance.
I tried to remove the session handling between MongoDB and MySQL saw that MongoDB has better performance but still it is very slow.
I heard about Elastic Cache but i'm not sure this is the suitable solution, and i wonder What is the best practice for session handling in Amazon.
BTW, my code is written in PHP, my client is flash.
Thanks.