In the previous article in this article, https://blog.51cto.com/8355320/2463218I used the manual source code to install MySQL 5.7.28, the installation process is still time consuming, I wrote a shell automatic installation script, please refer to the script I have no problems testing, script I have two times to modify the instance name and var ...
Posted on Thu, 09 Jan 2020 09:28:18 -0800 by west4me
1: first check whether the database address and quantity in schema.xml are configured correctly
2: check the mycat.log log log to see the specific errors. Personal error:
can't connect to mysql server ,errmsg:Host '192.168.100.196' is blocked because of many connection errors
Too many wrong connections cause blocking
Cause: the same ip bloc ...
Posted on Mon, 09 Dec 2019 18:42:02 -0800 by user___
1.1 MySQL 5.7x solution
1.1.1 first method
Use other users with super authority to make changes (without stopping the service), for example: chenliang @% user management
All libraries (*. *), permissions are all
#Log in the corresponding instance at the command line
mysql -uchenliang -p -h127.0.0.1 -P3306
#Use the update command to change th ...
Posted on Mon, 02 Dec 2019 19:59:15 -0800 by CoderDan
Starting from zabbix 3.4, zabbix has its own monitoring template for mysql, which is convenient for direct monitoring of mysql database on linux without any configuration. However, m is required for mysql database on windows, which cannot be directly monitored. After continuous inquiry, the monitoring method has been found, refer to https://bl ...
Posted on Sat, 09 Nov 2019 08:20:42 -0800 by babygodzilla
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