【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 …
One of the daily tasks of a system administrator is upgrading services, applying patch packages, or adding some fancy new features. In early 2013, the latest MySQL 5.6 was released, aiming to deliver better performance and scalability. If you’re a bit interested, you can check out this article I wrote on How to Deb …
PHP frameworks are highly useful tools that help developers build clean, organized, and structured web applications while also accelerating the speed of creation and maintenance. Here, we will introduce the top 10 most popular PHP frameworks (in no particular order). Laravel
This …
1 MySQL Cluster Version Master-Slave Setup Guide MySQL master-slave servers can synchronize databases, tables, and table contents. You can also specify to synchronize only a certain database or table, or exclude specific databases or tables from synchronization. How synchronization works: Master-slave database synchronization primarily …
