Shell scripts are files that contain a series of commands which can be executed together. You could also type these commands one by one to run them manually. To use a shell script, you must first write these commands into a text file, and later you can …
I picked up another project today, so I needed to set up a local LAMP environment. To keep things simple, I decided to install everything directly using YUM. After installing MySQL, I needed to set the root password. I’m not sure how everyone else used to set theirs, but I previously used /usr/bin/mysqladmin -u root password ' …
Checking Current Nginx and MySQL Connections
View all current Nginx connections and their statuses:
#netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a]}'
TIME_WAIT 17
ESTABLISHED 3254
LAST_ACK 236
FIN_W …
【Issue Background】In the production environment, the database master-err.log shows: 130111 20:48:07 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_ …
The output of the processlist command shows which threads are running, which can help identify problematic query statements. There are two ways to use this command.
1. Enter the mysql/bin directory and type mysqladmin processlist;
2. Start mysq …
When we are hired to monitor MySQL performance, people expect us to review the MySQL configuration and offer suggestions for improvement. Many are surprised afterward, because we often recommend changing only a few settings, even though there are hundreds of configuration options available. The goal of this article is to …
How to Choose and Configure MySQL Storage Engines
The MySQL database engine depends on how MySQL was compiled during installation. To add a new engine, MySQL must be recompiled. By default, MySQL supports three engines: ISAM, MYISAM, and HEAP. The other two types, INNODB and BERKLEY …
Exploration and Test Results of MHA (MySQL Master Switchover Solution) I. Features of MHA: MHA monitors the master server in a replication architecture. Once a master server failure is detected, it automatically performs failover. Even if some slave servers have not received the latest relay log, MHA automatically identifies the differential relay log from the most up-to-date slave server and applies those logs to other slave servers…
Context: In MySQL 5.5, the Semi-synchronous Replication mode was introduced. In this mode: the master will wait until the binlog has been successfully transmitted and written into the relay log of at least one slave before committing. This way, …
How to Configure MySQL Dual-Master Replication
MySQL master-slave setup is a common task. Today we explain a dual-master configuration. If you have any questions, please leave a comment below:
1. Environment Description.
Host: 192.168.0.231 (A)
Host: 192.168.0.232 (B)
MYSQL version: 5.1.21
2. Grant User Permissions.
A:
mysql> grant replication slave …
