Cause: To upgrade the mysql database in the native test environment, you need to upgrade the database step by step by executing the sql files of the mysql database, so find some articles about mysql to upgrade the sql files needed to upgrade the database in batch.
First, you need to traverse the sql files in the directory where ...
Posted on Thu, 20 Feb 2020 21:19:53 -0500 by Ghostu
In order to facilitate subsequent communication, a ** Stack-Java Technology Exchange Group ** was created in the morning of 2020,213, which also facilitates active participation by scanning QR codes.
If the QR code is out of date, you can add the mini-signal (lastpass4u) of the stack culture-assistant and let him pull you into the g ...
Posted on Thu, 20 Feb 2020 20:16:45 -0500 by curlious
MMM for MySQL High Availability Cluster
1. Introduction to MMM
MMM is Multi-Master Replication Manager for MySQL (mysql multiple master replication manager), which is based on perl.A scalable suite of scripts for monitoring, failover, and management of MySQL master replication configurations (only one node can be written at any time) and MMM ...
Posted on Thu, 20 Feb 2020 11:43:56 -0500 by gothica
1. ls command
View the visible files, folders and their related permissions in the current directory
Common parameters: - l list view
-al view all, including hidden files and folders
[root@qinshengfei bin]# ls --color in color
[root@qinshengfei bin]# ls -l detail list catalog file
[root@qinshengfei bin]# ls -a shows all files, inc ...
Posted on Thu, 20 Feb 2020 04:37:18 -0500 by tomm098
Follow up source code
Introduction to Recycler inner class
Recycler creation and some properties
Get object from Recycler
Stack creation and some properties
Pop pop up object
Recycle objects to Recycler
Same thread recycle
Different thr ...
Posted on Thu, 20 Feb 2020 03:24:08 -0500 by kannjihyun
We all know that the LAMP platform is the most widely used web server architecture, of which "A" corresponds to Apache, a web service software. However, over time, more and more enterprises begin to use Nginx as a black horse, and LNMP or LEMP architecture has also been favored by more and more Lions.If you are idle, write about the ...
Posted on Wed, 19 Feb 2020 13:14:45 -0500 by gyoung
Tar (pack compression)
Command name: gzip
English original meaning of command: GUN zip
Command path: / bin/gzip
Execute permission: all users
Function Description: compressed file
#Compressed file format.gz
# Compressed file
gzip /tmp/serv ...
Posted on Wed, 19 Feb 2020 08:05:43 -0500 by Zallus
Deploying HaProxy based on MyCat for high availability
In a real project, the Mycat service also needs to consider high availability. If the server Mycat is on is down or the Mycat service fails, it needs a standby machine to provide service and the Mycat cluster needs to be considered.
1. High Availability Scheme
You can use HAProxy+Keepal ...
Posted on Tue, 18 Feb 2020 11:13:15 -0500 by Bunyip
mysql high availability architectures include MHA, mmm, PXC, MGR, etc. among them, the data consistency of MHA and MMM is worse than that of PXC and MGR, because PXC and MGR are strong consistency, and the implementation principle is not introduced here. This blog mainly writes down MMM high availability architecture.
Mmm is based on perl. It ...
Posted on Tue, 18 Feb 2020 04:15:18 -0500 by thessoro
Warm tip: if you can't see the picture clearly by using the computer, you can use the mobile phone to open the article and click the picture in the article to enlarge and view the original HD picture.
github of Fayson:
Tip: the code block can be viewed by sliding le ...
Posted on Tue, 18 Feb 2020 03:02:35 -0500 by sharal