MySQL -- read write separation

MySQL -- read write separation 1: Principle Read write separation is to write only on the master server and read only on the slave server The primary database processes transactional queries, while the secondary database processes select queries Database replication is used to synchronize chan ...

Posted on Mon, 13 Jan 2020 04:44:15 -0800 by playaz

Batch rewriteBatchedStatements=true

Recently, we are optimizing the performance of mass data insertion. The original mass data insertion method used in the project is the foreach splicing SQL method of Mybatis. I found that no matter the method changed to Mybatis Batch submission or native JDBC Batch does not work. In fact, when insert ...

Posted on Sun, 12 Jan 2020 23:34:34 -0800 by Hyperjase

Spring cloud's Hystrix and service monitoring Dashboard for dealing with avalanche effect

Article directory Preface The concept and reason of avalanche effect Avalanche effect Using the Hystrix processing strategy Hystrix case test summary Preface This chapter is no longer a configuration file as before, but a case study of how to deal with avalanche effect. Because avalanche effec ...

Posted on Sun, 12 Jan 2020 05:56:34 -0800 by shaitand

MHA high availability configuration and failover

Problems in traditional MySQL master-slave architecture Single point failure The main server is down, resulting in the failure of data writing MHA MHA overview A set of excellent high availability software for failover and master-slave promotion in mysql high availability environment Composition ...

Posted on Sun, 12 Jan 2020 04:32:18 -0800 by TimUSA

Join usage in MySQL

Article directory Join usage in SQL #1 environment #2 create table and insert data #3 start #3.1 inner join #3.2 left join #3.3 right join #3.4 full join Join usage in SQL #1 environment MySQL5.7 Mac #2 create table and insert data Create two new tables tableA and tableB mysql> creat ...

Posted on Sun, 12 Jan 2020 00:04:57 -0800 by AbraCadaver

Ribbon load balancing of spring cloud and Feign consumer call service

Ribbon load balancing of spring cloud and Feign consumer call service 1. Get to know the Ribbon Microservice calls Ribbon 2. Ribbon load balancing Ribbon load balancing 3. Feign introduction and Application 1. Get to know the Ribbon Ribbon is a load balancer published by Netflix, which helps to ...

Posted on Sat, 11 Jan 2020 05:46:35 -0800 by cbcampbell

Spring cloud fuse Hystrix and service monitoring Dashboard

Service avalanche effect When there are problems such as inaccessibility, exception and timeout in the requested service, the user's request will be blocked and other functions will be affected, If there are unreachable services in the requests of multiple users, they will all fall into a blocked st ...

Posted on Sat, 11 Jan 2020 05:08:32 -0800 by Rushyo

MHA High Speed Available Clusters

MHA High Speed Available Clusters Article Directory MHA High Speed Available Clusters Preface 1. Cluster Server 2. Clustering 3.MHA 1. Summary of advantages of MHA 2.MHA Workflow 1. Infrastructure of MHA for Enterprise Website 2. Causes of MHA Formation 3.MHA Workflow 3. Build MHA High Availab ...

Posted on Fri, 10 Jan 2020 20:24:38 -0800 by amithn12

mysql backup and crontab automatic backup under Linux

Using mysql dump of mysql to backup and restore data under liunx The crontab command can help us to automatically and regularly back up the database. Backing up a database #Create backup directory first mkdir -p /var/local/backup cd /var/local/backup #Backup database mysqldump -uusername -ppassword database > databas ...

Posted on Fri, 10 Jan 2020 09:25:06 -0800 by busin3ss

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