1. Create database:
mysql> create database test ; // Create a database in mysql. The ID of the database is test.
[root@host] # mysqladmin -u root -p create test; / / create a database under linux. The database ID is test.
2. Delete database:
mysql> drop database test ; // Delete the database in mysql. The ID o ...
Posted on Thu, 14 May 2020 08:30:58 -0700 by baldwinw
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
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