Setting up a dedicated server is easy. Operating it is difficult.
Thankfully there are many control panels that make the job of system administrator easy. However one must know what exactly to do after the system is up and running The list is endless, but there are some important things that almost every system admin must do.
The foremost worrying thing for me was to ensure that the system performance is up to the mark.
In my case I had a unique challenge – My website experiences 100K + visitors every day and peak loads of 1000 + users at a time.
This happens quite d few times in a day. All these users need to connect to DB to fetch some information. To handle this peak load I made following settings in my VirtualMin system :
- Increase max DB connections in MySQL settings such that it can handle peak load.
- Increase the max execution time allowed for PHP Script.
- Increase max processed allowed by FcglD script
- Increase the max processing time / IO Timeout for FcgID scripts.
How to troubleshoot problems:
- Monitor the Apache error logs for your server.
- Monitor the MySQL errors to see if there are aborted connections or clients.
- Monitor slow queries in MySQL.
- Login to your PHPMyAdmin with your root user and see the recommendations.
Ensure you do the following :
- Setup regular server Backup – preferable a daily backup.
- Make sure, you copy the backup on a different machine / system regularly.
- Ensure OS and security updates are installed regularly.
As I come across other important settings / configuration to manage the system, I’ll list down more.