Programming VIP

Introduction to master-slave replication 1. Master slave replication is implemented based on binlog 2. When new operations occur in the main database, binlog will be recorded 3. Obtain the binlog of the main library from the library for playback 4. The master-slave process is asynchronous Construction of master-slave replication Pre ...

Canal introduction View the official website of Canal Canal means waterway / pipeline / ditch. It is mainly used for incremental log parsing based on MySQL database to provide incremental data subscription and consumption Businesses based on log incremental subscription and consumption include: database mirroring Real time database backup ...

1. Experimental purpose Master the definition and maintenance methods of entity integrity, reference integrity and user-defined integrity.     2. Experimental contents and requirements Define entity integrity and delete entity integrity. Be able to write two ways to define entity integrity   SQL   Statement: define e ...

preface Following the problems mentioned above, this paper studies the flush processing flow of MemStore on HRegionServer, focusing on how to select an hregon to flush to alleviate the pressure of MemStore, and how hregon flush is initiated. 1, How to select an hregon to flush to relieve the pressure of MemStore As mentioned above, i ...

The slicing rules of MyCat are configured in   conf directory   Defined in rule.xml file; Environmental preparation: Back up the contents in schema.xml and configure it   Logical library; <schema name="PARTITION_DB" checkSQLschema="false" sqlMaxLimit="100">      <table name="" dataNode="dn1,dn2,dn3" rule=""/> </s ...

Welcome to the MySQL technical articles shared by the great SQL community. If you have any questions or want to learn, you can leave a message in the comment area below. After seeing it, you will answer itThis article is reproduced from the official account of WeChat, "old leaf teahouse".After the whole MGR cluster is hung up, the mas ...

Welcome to the MySQL technical articles shared by the great SQL community. If you have any questions or want to learn, you can leave a message in the comment area below. After seeing it, you will answer it0. IntroductionWith the same account and password, the manual client connection can succeed, but it fails through MySQL Connectors. Why?1. Ph ...

Implementation of multithreading Implementing threads is the basis of concurrent programming, because we must implement threads before we can continue a series of subsequent operations. Basic implementation mode Runable public class ImplementRunable implements Runnable { @Override public void run() { while (true) { ...

catalogue           1. MySQL read-write separation and master-slave replication principle 2. Why do we do read-write separation 3. When should I separate reading from writing 4. Master-slave replication and read-write separation 5. Replication types supported by mysql 6. Working process of master-slave replication ...

Several basic database operation commands: This article is for learning only, non-commercial use, invasion and deletion update user set password=password('123456')where user='root'; Change Password flush privileges; Refresh database show databases; Show all databases use dbname；Open a database show tables; show database mysql All tables in d ...