Apache Access Logs Centralising Apache logs can be useful in many scenarios. Let’s get the basics 1st. So Apache logs can be defined as In order to effectively manage a web server, it is necessary…
Browsing Category MySQL
MySQL Load Balancing With HAProxy
Loading balancing is a hot topic when it comes to high availability(HA). You can distribute the workload among server using a load balancer such as HAProxy. Today we are going to take a look at MySQL…
MySQL Master-Master Replication
What’s MySQL Replication Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). So MySQL Master-Master Replication In other words MySQL replication is…
#1093 – You can’t specify target table ‘table_name’ for update in FROM clause
Have you ever got this MySQL error? Oh! You are searching for a solution right? You have come to the right place. Let me give you the simplest answer and it works charm. For the time…
How to do MySQL Indexing
MySQL Indexes! Whooh! Let me tell you what my experience about indexing a table. I had a SQL query which took 8-9 secs to fetch the data I want. After indexing now it only takes 1…