I have a drupal 7 site.
Running a auto login feature when people click on my newsletter.
A hook is fired when they visit the site to check for the cookie. my setup : Background info : I am already using Memcache, APC, Varnish,
2 Varnish Servers (8 GB)
1 Db percona server (32 GB)
1 HaProxy 4
Webservers, 16 GB
my question is, Performance wise. I can see that my server cannot handle 8000 users logging in.
Is there any way to make this impact on the server more "soft" in terms of performance. So my DB doesnt go down. when 8000 request auto login at the same time.
Ex: 1 request to auto login, causing 3-4 query to DB via the core Drupal API if so if I get 1000 users at the same time I got 3000 queries to DB -> DB cannot handle the load. What to do ?!