mysql database batch execution sql files for database operations [windows version]

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. Organize ideas: First, you need to traverse the sql files in the directory where ...

Posted on Thu, 20 Feb 2020 21:19:53 -0500 by Ghostu

Detailed analysis of MySQL execution plan and cost model

background 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

# IT Stars Are Not Dreams# MMM for MySQL High Availability Clusters

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

The most concise Linux commands

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

Use and analysis of [Netty] Recycler

Article directory Preface Experiment code: 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 Control frequency Different thr ...

Posted on Thu, 20 Feb 2020 03:24:08 -0500 by kannjihyun

Building LNMP Architecture Based on centos 7

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

Compression and decompression command in linux

Catalog gzip gunzip Tar (pack compression) Tar (unpack) zip unzip bzip2 bunzip2 gzip explain Command name: gzip English original meaning of command: GUN zip Command path: / bin/gzip Execute permission: all users Function Description: compressed file grammar #Compressed file format.gz gzip [file] Example # Compressed file gzip /tmp/serv ...

Posted on Wed, 19 Feb 2020 08:05:43 -0500 by Zallus

# IT Stars Are Not Dreams#MySQL High Availability Clusters for High Availability Based on MyCat Deployment HaProxy

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 - MMM architecture deployment

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

0429 how to install HDP3.0.1 in RedHat 7.4

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: https://github.com/fayson/cdhproject Tip: the code block can be viewed by sliding le ...

Posted on Tue, 18 Feb 2020 03:02:35 -0500 by sharal