MHA of MySQL high availability cluster

1, MHA introduction At present, MHA (Master High Availability) is a relatively mature solution in the aspect of MySQL high availability. It is developed by yoshimaton (now working for Facebook), a Japanese DeNA company. It is an excellent high availability software for failover and master-slave improvement in MySQL high availability environm ...

Posted on Sat, 22 Feb 2020 12:24:43 -0500 by dahwan

Redis5.x two persistence methods and master-slave replication configuration

Pay attention to the official account number: CoderBuff, reply to "redis" and get the complete version of Redis5.x tutorial PDF. Redis5.x tutorial directory Chapter I preparation Chapter II data types Chapter III orders Chapter IV configuration Chapter 5 Java client (I) Chapter VI affairs Chapter 7 distributed lock Chapter 8 Java cli ...

Posted on Sat, 22 Feb 2020 10:21:27 -0500 by illushinz

Two layer load balancing architecture based on Keepalived -- configure the second layer server as lnmp environment

Article directory I. Preface Experimental thought Experimental environment 2, Configure the second tier server as lnmp environment Test lnmp environment I. Preface Experimental thought In the previous article, two active and standby mode hosts are deployed to form the first layer of load bal ...

Posted on Sat, 22 Feb 2020 07:53:54 -0500 by .-INSANE-.

[Emlog optimization] cache file optimization speed up article publishing speed up cache speed

Today, the webmaster of preferred resources continues to share the optimization of the Emlog website. How to speed up the caching speed of the website and the publishing speed of the articles? The previous article talked about a very rough method, which is simple and effective, but this is not in lin ...

Posted on Sat, 22 Feb 2020 00:22:31 -0500 by accident

A simple addition, deletion, modification and query of sprigboot+jpa

Recently, I have taught myself some basic usage of springboot on mooc.com, and I have learned some relevant knowledge on the way to use it. Next, I will write down my learning achievements: This record is a simple addition, deletion, modification and query of mysql database using springboot+jpa. After a ...

Posted on Fri, 21 Feb 2020 05:03:10 -0500 by kyllerj

Microservice provider

After we have created the total project of a project, we need to write an api sub module, which is generally called an entity class. We need entity class data to call this sub module. First, we import a lombok in pom: <dependencies> <dependency> <groupId>org.proje ...

Posted on Fri, 21 Feb 2020 01:38:30 -0500 by bigbstanley

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