I’m awaiting a dedicated database-server for the websites. In order to set up a secure and fast database-connection in a distributed environment, I played around with mysql-connections over an SSH-tunnel. I used this really good tutorial (German though) . I will also set up a watchdog for watching and restarting the link.
The new server will serve as primary database-server and all connections will be tunneled through SSH. The website the servers are for broke through the 90.000 visitor/day barrier on tuesday and it’s still growing …
