How to install LAMP stack on Ubuntu server

LAMP stack is a popular open source software platform for powering database-driven web applications on Linux. LAMP itself is an acronym for Linux, Apache web server, MariaDB database, and PHP dynamic server-side programming language. This tutorial will present a step by step procedure on installing LAMP stack on Ubuntu server, and also guide you to […]
Continue reading…

 

How to install LAMP stack (Apache, MariaDB/MySQL and PHP) on CentOS

LAMP stack is a popular server-side software stack which is used to build and run dynamic web sites and web applications on Linux platforms. The LAMP stack is composed of Apache (as an HTTP server), MariaDB or MySQL (as a database backend), and PHP, Perl or Python (as a server-side programming language), and hence the […]
Continue reading…

 

How to run SQL queries against Apache log files on Linux

One of the distinguishing features of Linux is that, under normal circumstances, you should be able to know what is happening and has happened on your system by analyzing one or more system logs. Indeed, system logs are the first resource a system administrator tends to look to while troubleshooting system or application issues. In […]
Continue reading…

 

How to install LEMP stack (nginx, MariaDB/MySQL and PHP) on CentOS

The LEMP stack is an increasingly popular web service stack, powering mission-critical web services in many production environments. As the name implies, the LEMP stack is composed of Linux, nginx, MariaDB/MySQL and PHP. nginx is a high performance and lightweight replacement of slow and hard-to-scale Apache HTTP server used in the traditional LAMP stack. MariaDB […]
Continue reading…

 

How to install and configure ownCloud on Debian

According to its official website, ownCloud gives you universal access to your files through a web interface or WebDAV. It also provides a platform to easily view, edit and sync your contacts, calendars and bookmarks across all your devices. Even though ownCloud is very similar to the widely-used Dropbox cloud storage, the primary difference is […]
Continue reading…

 

How to find and kill misbehaving MySQL queries

Sometimes the complexity of a relational database system can be overwhelming. Fortunately, that complexity is an advantage, as with MySQL’s tools for managing queries. In this tutorial, I will show you how to find and kill any misbehaving MySQL queries. To view the currently-running queries, log in to the MySQL console and run the ‘show […]
Continue reading…

 

How to repair a crashed WordPress database table

A WordPress database may experience failure and corruption under various circumstances. One of common problems with it is “crashed database.” When that happens, you will find the following error in WordPress error log: WordPress database error Table ‘./my_home/wp_posts’ is marked as crashed and last (automatic?) repair failed for query SELECT post_date_gmt FROM wp_posts WHERE post_status […]
Continue reading…

 

How to set up a lightweight web server on Raspberry Pi

There are a variety of web server software available for Linux-based platforms including Raspbian. Using one of those available web server software, we can turn Raspberry Pi into a 24/7 available portable web server. In this case, however, we must understand that Raspberry Pi has hardware limitations in terms of CPU clock speed, memory, etc. […]
Continue reading…

 

How to upgrade MySQL server on Debian or Ubuntu

One of routine tasks for system admins is to update installed programs with the latest patches and hotfixes, as well as upgrade software to a more recent release with new bells and whistles. The latest MySQL 5.6 was released early this year, targeting better performance and scalability. For those of you wanting to try out […]
Continue reading…

 

How to monitor common services with Nagios

Nagios comes with a wide range of built-in scripts for monitoring services. This tutorial will cover the process of using some of these scripts for checking common services, such as MySQL, Apache web server, DNS, etc. To keep the article focused on service monitoring, we will not be configuring hostgroups or templates, as they have […]
Continue reading…