What Makes You Worried About MySQL?

Today everyone want their website to be implemented in dynamic programming language such as PHP, ASP, Etc that requires the use of MySQL databse to store user information ,passwords, senitive data. More the database entries, the bigger is your database. Sometimes MySQL server can act as your server enemy and takes much of your server resources which you can also see using top command or if you have cpanel/WHM you can directly check by clicking on top right corner link which looks like Load Averages: 0.01 0.05 0.07 upon logging in.

If you see MySQL taking high cpu load then you should worry. Try finding which database is causing trouble by running mysqladmin proc stat and some other random linux commands. If you successfully find it tell your developer to optimizie the website because poorly written code may be it’s cause and upon rectification you may also see the difference in the load.

Finally try to tune and optimize MySQL server using MySQLTuner. MySQLTuner is a perl script which overview web server and pop out some recommendations about improvements and stability for MySQL. I will not elaborate more about this tool as you can easily get more infomation on its own website (https://github.com/rackerhacker/MySQLTuner-perl#readme).

Read More

Are You Taking Advantage Of Security Questions In Cpanel/WHM?

Now a days due to immense of hacking attempts, webmasters have to take extra security measures to protect their server from anonymous attacks. A hacker can get your password by brute forcing your account, by infecting your pc and Etc. Are you worried they have your cpanel/WHM password? Choosing cpanel can make you feel safe about your server security.

Cpanel/WHM gives an advantage to rule over even if the attacker have your root password. Their security Questions feature adds a protecting layer between your cpanel login and GUI enterface of your server, if there is cpanel access from unauthorised ip. Whenever an ip which is not whitelisted access cpanel/WHM account then there is a popup of 4 security Questions and upon successfull answer only user will be able to enter Administrator panel or will be directly thrown out of web server. Isnt that great?

Cpanel have more stunning security features which makes it first choice of Web Administrator’s. I will be exploring more features in next post. For more information related to Security Questions see the link below:

http://docs.cpanel.net/twiki/bin/view/AllDocumentation/WHMDocs/SecurityQuestions

Read More