Admins eHow SysAdmin Tips & Tricks

April 9, 2011

How to optimize MySQL server configuration ?

Filed under: MySQL — Tags: , , , — admin @ 7:23 pm

There are already many guides on the Internet on how to optimize MySQL server, MySQL is a very popular opensource database engine.
but most of such guides are too technical or too general or too specific which will not fit for any configuration.
What I have found and seems very promising, is a perl script which analyses your MySQL server and makes some recommendations regarding how to change your configuration to optimize the performance.
I tried it on a production hosting server and results were satisfactory, I am sure such scripts still can not beat database engineers, but if you dont have enough money to hire a a database engineer. they can be handful 😉

Here is the explanation from its website :

MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.

You can find the script and guide on this link : http://mysqltuner.com/

July 28, 2010

Hamachi Alternatives quick list

Filed under: General — Tags: , , , , , , — admin @ 9:36 pm

Here is a quick list of Hamachi ( zero-configuration virtual private network (VPN) ) alternatives :
tinc : http://www.tinc-vpn.org
gbridge : http://www.gbridge.com/
socialvpn : http://socialvpn.wordpress.com/
remobo : http://www.remobo.com/
wippien : http://www.wippien.com/
n2n : http://www.ntop.org/n2n/
tunngle : http://www.tunngle.net/en/
comodo easy vpn : http://easy-vpn.comodo.com/

Powered by WordPress