Zabbix Monitoring Client and Mail, WeChat Alarm

The zabbix server-side deployment is available for reference: https://blog.51cto.com/14227204/2474670Note: This article is based on the above link 1. Install Zabbix agent sideHere I started a server with IP 192.168.171.134 to act as an agent side [root@agent /]# mkdir /zabbix # Personal habits, negligible [root@agent /]# cd /zabbix/ [ ...

Posted on Fri, 06 Mar 2020 10:38:41 -0800 by PDP11

CentOS7.5 source shell script automatically installs more than MySQL 5.7.28 instances

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

Unable to connect to mysql database

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___

What to do if the password of MySQL super user is forgotten

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

Using official template to monitor mysql database on windows on ZABBIX ZABBIX

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

Optimization of mysql-system status view-location problem, analysis of sql, index

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; mysqladmin extended-status show st ...

Posted on Sun, 06 Oct 2019 07:41:37 -0700 by osusano

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