Linux

How to reduce server load by MySQL caching and optimization

How to reduce server load by MySQL caching and optimization

As the web traffic starts growing, the CMS based websites take more time to load and therefore MySQL server needs to be optimized or at least it should utilize available server resources judiciously in order to meet the future traffic demands. Database caching can significantly improve your CMS performance during peak hours. Although the main factor that affects database performance is how queries have been written but still significant performance boost can be achieved by tweaking MySQL settings. Lets learn how to tweak MySQL settings to optimize and improve its caching in order to get optimum performance and reduce server load.

Read More

How to create backup of MySQL databases using command line on linux server

How to create backup of MySQL databases using command line on linux server

In this post we will show you how to backup your databases in MySQL on your linux server. You must be thinking why is this important? The reason is that most websites make use of a content management system (such as Drupal, Joomla!, Wordpress, phpBB). Content management Systems need databases to store content, articles or posts along with all the necessary settings. Generally these content management systems are written in PHP/Perl and use MySQL as their data backend, so it is very important to create backup of the database at regular intervals.

Read More

How to configure Network IPv4 DNS or DHCP using terminal on Ubuntu server

How to configure Network IPv4 DNS or DHCP using terminal on Ubuntu server

In this post we will show you how to configure your network IPv4, DNS or DHCP using terminal in Ubuntu Linux. Nowadays almost every network gateway uses DHCP based IP address for establishing network connection. The default setting of Ubuntu network interface is for DHCP only. So your network card is automatically detected and configured for automatic DHCP during Ubuntu desktop installation and you rarely need to change it. But sometimes specially on Ubuntu server you will need to manually configure the IP address, DNS or other network options. We will show you how to do this.

Read More