MySQL Read-Write Separation Reality

1. MySQL Read-Write Separation Concept The principle of MYSQL read-write separation is to let Master database handle transactional add, delete, modify, update operations (create, insert, update, delete) and Slave database handle query operations (select). MySQL read-write separation is based on MySQL master-slave replication, which can guarant ...

Posted by fareedreg on Mon, 08 Jun 2020 10:08:09 -0700

One way master-slave synchronous configuration of mysql under windows

View mysql profile address mysql --help|grep 'my.cnf' ps aux|grep mysql|grep 'my.cnf' The configuration is divided into two parts, the master server part and the slave server part In this test, the master and slave of the two machines are synchronized, and the environment is windows (the same as Linux) Main server ip:192.168.1.199 Slave serve ...

Posted by busnut on Sun, 07 Jun 2020 19:52:27 -0700

E chat SDK introduction: compiling instant messaging backend projects from source

2. Introduction to mobile rear end: E chat SDK provides a basic back-end community version source code. By compiling / modifying the back-end source code, you can achieve deeper business customization, such as file upload / download, online / offline monitoring, API permission function, cluster function, etc. The backend project uses springboot ...

Posted by aaadee on Sun, 07 Jun 2020 02:25:40 -0700

SpringCloud+Vue Online Education Project - Integrating canal Data Synchronization

Introduction to Canal 1. Application Scenarios In the previous statistical analysis function, we have taken a service call to obtain statistics, which is highly coupled and relatively inefficient. At present, I take another way to achieve this by synchronizing the database tables in real time. For e ...

Posted by Labbat on Sat, 06 Jun 2020 19:30:27 -0700

Installation, configuration and use of Sqoop

Article catalog title Introduction and characteristics summary Working mechanism Installation and configuration Common command operations of Sqoop Import data from the database into HDFS Export data on HDFS to database Introduction and characteristics Sqoop is a Hadoop And data transfer tools ...

Posted by Bac on Sat, 06 Jun 2020 04:23:27 -0700

High Availability Scheme Implementation of MySQL Master Replication+keepalived

1 Preface One MySQL host in the production environment has a single point of failure, so we want to make sure that MySQL is highly available, that is, two MySQLsServer If one of the MySQL servers hangs up, the other can take over immediately. MySQL's highly available solutions are generally as follows: keepalived+dual master MHA PXC MMM Hear ...

Posted by jwbworks on Fri, 05 Jun 2020 18:17:35 -0700

A simple way to use Mysql cursor

1, Introduction to cursors 1. Introduction to cursors Cursor is a database query stored on MySQL server. It is not a select statement, but a result set retrieved by the statement. With the cursor, the result set can be processed row by row conveniently. The design of cursors is the idea of data buffer, which is used to store the results of S ...

Posted by Selkirk on Fri, 05 Jun 2020 01:53:14 -0700

Docker storage volume for kubernetes

docker storage volume Data Volume Why data volumes (storage volumes) are needed The docker image is made up of multiple read-only layers. When the container is started, the docker loads the read-only layer and adds a read-write layer to the mirror layer. If the running container modifies an existing file, the file will be copied from the ...

Posted by eternalprophet on Thu, 04 Jun 2020 10:35:35 -0700

Talk about puma's Parser

order This paper mainly studies the Parser of puma Parser puma/puma/src/main/java/com/dianping/puma/parser/Parser.java public interface Parser extends LifeCycle { BinlogEvent parse(ByteBuffer buf, PumaContext context) throws IOException; } The Parser inherits the life cycle interface, which defines the parse method and resolves ByteBuffer ...

Posted by monkeypaw201 on Wed, 03 Jun 2020 07:39:03 -0700

How to insert tens of millions of data quickly and safely?

Author: ksfzhaohui https://my.oschina.net/OutOfMemory/blog/3117737 Recently, there is a demand to analyze an order file, and the description file can reach tens of millions of data, each data is about 20 fields, each field is separated by commas, and it needs to be stored in half an hour as much as possible. thinking 1. Estimate file size Bec ...

Posted by brendan2b on Tue, 02 Jun 2020 19:13:02 -0700