MySQL 5.7 Multi-Instance Installation Configuration

1. Background description MySQL multi-instance concept Simply put, it is to open multiple different service ports (e.g. 3306, 3307) on a single server and run multiple MySQL service processes, which provide their services through different socket s listening on different service ports. b. MySQL multi-instance roles and problems Effective uti ...

Posted on Wed, 07 Aug 2019 01:44:24 -0700 by JunbinDuan

Operations Note 37 mysql Auto-switch (keep alived + homemade script)

Summary: keepalived is a very flexible high-availability solution, because of its port detection features, so that he can basically complete the high availability of all basic services, but because of flexibility, you need to configure a lot of your own, the most important thing is to write different scripts for different places. Cluster Topo ...

Posted on Sat, 13 Jul 2019 15:30:20 -0700 by o2cathy

MySQL'In Place'upgrade practices, from 5.1 to 5.7

Following is the translation of the last article: Use the'In place'method to upgrade directly from 5.0 to 5.7 Here I record the process of my practice.1. Environmental preparation    Database A    Version: 5.1    Character set: latin1    Engine: MyISAM  &n ...

Posted on Sun, 23 Jun 2019 15:22:40 -0700 by Snooble

High Performance mysql Chapter 8 Optimize Server Settings Read Notes

High performance mysql July 11, 2017 Chapter 8 Optimizing Server Settings If you do not know the configuration path $ which myslqd /usr/sbin/mysqld –verbose –help | grep -A 1 'Default options' 8.3 Create mysql configuration file Do not place the Socket and PID files in the default Mysql compilation location. This may cause some errors ...

Posted on Fri, 14 Jun 2019 10:53:13 -0700 by bernard_hinault

Linux Installation Configuration MySQL

MySQL Download MySQL Download Address environmental information MySQL : 5.5.17-1.el6.x86_64.rpm Linux : Red Hat Enterprise Linux Server release 6.5 (Santiago) install Check if installed rpm -qa|grep -i mysql If returned: mysql-libs-5.1.71-1.el6.x86_64 Represents that the library files have been installed and need to be uninsta ...

Posted on Sun, 09 Jun 2019 12:15:05 -0700 by Sesquipedalian

MySQL Self-Increasing ID Reset Problem

Innodb engine: The Innodb table records the maximum ID of the self-increasing primary key in memory. Restarting the database will result in the maximum ID reset.(It is said that 8.0 will save the maximum ID added to the table for verification)In the first case:There is no data behind the deleted empty data. After reboot, AUTO_INCREMENT will qu ...

Posted on Tue, 26 Mar 2019 00:21:27 -0700 by knelson

zabbix monitors mysql metrics and supports all variables under variables and STATUS

Recently, when dealing with zabbix monitoring mysql, we encountered some problems. Now we record them.There is no user name password information in the default script. If the root is set to not allow local login with empty password, the data will not be accepted.Specifically, you can test it with agent_get in zabbix server or proxy zabbix_get - ...

Posted on Thu, 21 Mar 2019 19:16:01 -0700 by clonemaster

MySQL 5.6 Binary Deployment

Download mysql and check MD5 [root@hadoop-01 ~]# cd /usr/local [root@hadoop-01 local]# wget https://downloads.mariadb.com/archives/mysql-5.6/mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz [root@hadoop-01 local]# wget https://downloads.mariadb.com/archives/mysql-5.6/mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz.md5 [root@hadoop-01 loc ...

Posted on Wed, 30 Jan 2019 08:45:15 -0800 by walnoot

Build a pure LAPM environment: CentOS 7.3 + Apache 2.4.29 + Php 5.6.35 + MySQL 5.6.24 (1-MySQL 5.6.24 installation)

The LAPM environment has been built many times in a year. Every time there are many pits, and then a little bit to solve them. Eventually, it was all over, but I was really tired and paralyzed. Tired, I think: Fortunately, it has been built, and I don't think it will be built in the future. So the whole process is not record ...

Posted on Tue, 25 Dec 2018 09:12:06 -0800 by darkwolf