MySQL

High Availability MySQL

Basic Guideline for High Availability MySQL Replication DRBD HA We are discussing DRBD HA here. So first things to go is DRBD HA Following Steps are required: Preparation of OS : DRBD Preparation OS : We need to reserve a huge physical volume which would be later used as a DRBD volume. Don’t specify any file system type. fdisk /dev/sda…

Continue Reading

MySQL

MySQL Slow Query Log

Start MySQL Server: /etc/init.d/mysqld start Syntax for /etc/my.cnf in Red Hat Family Machine : [mysqld] set-variable=long_query_time=1 log-slow-queries=/var/log/mysql/log-slow-queries.log log-queries-not-using-indexes The 2nd line under [mysqld] turns on slow query log and logs all slow queries to log-slow-queries.log in the MySQL data directory. The 1st line indicates that any queries that took more than 1 seconds to execute need to be logged. The…

Continue Reading

MySQL

Common Replication Administration Tasks

Common Replication Administration tasks : 1. Checking the Replication Status. The most common task when managing a replication process is to ensure that replication is taking place and that there has been no errors between the slave and the master. On Slave Server (192.168.36.2) mysql>     Show slave statusG The key fields from the status report to examine are: Slave_io_state: indicates…

Continue Reading

MySQL

MySQL Replication

Implementing Master-Slave Replication: Master-Slave replication is mainly for scale-out solutions- spreading the load among the multiple slaves to improve the performance. And for Analytics – while the analysis of the information can take place on the slave without affecting the performance of the master. The target uses for Replication in MySQL include: Scale-out solutions: spreading the load among multiple slaves…

Continue Reading

MySQL

MySQL’s FEDERATED storage engine

One of the most exciting features introduced in MySQL 5 is the federated engine. The ability to access data from a remote server without the constraints of replication tickles every programmer’s fancy. The Federated engine allows a DBA to create logical pointers to tables that exist on other MySQL servers and thereby link together separate data islands to form one…

Continue Reading

Apache, Linux, MySQL, PHP

LAMP

LAMP is the combination of Linux + Apache + MySQL + PHP (PHP/PERL/Python). Linux is a free Unix-type operating system originally created by Linus Torvalds with the assistance of developers around the world. Developed under the GNU General Public License , the source code for Linux is freely available to everyone. Apache is the most popular web server on the…

Continue Reading