The initial stage of system development pays attention to function realization, and data is relatively small. With the increase of data volume, performance problems will gradually become prominent.
Query system status information
show [sesison |global ] status;
show st ...
Posted on Sun, 06 Oct 2019 07:41:37 -0700 by osusano
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
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
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
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
MySQL Download Address
MySQL : 5.5.17-1.el6.x86_64.rpm
Linux : Red Hat Enterprise Linux Server release 6.5 (Santiago)
Check if installed
rpm -qa|grep -i mysql
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
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
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
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
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