Programming VIP

The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.[toc]This paper introduces how to deploy MySQL Router in the front end of MGR cluster to realize read-write separation, read load balancing and automatic failover.MySQL Router is a lightweight middleware. ...

catalogue 1, Database description 1. Database 1.1 common database management systems 1.2 login to mysql 1.3 change password 1.4 mysql uninstall 2. MySQl details 2.1 relationship between SQL, DB and DBMS Table 2.2 2.3 SQL statement classification 2.4 importing data 2.5 understanding of SQL script 2.6 common SQL commands 2.7 create ...

1. Restraint 1.1 concept Constraints are rules that act on columns in a table and are used to restrict the data added to the table For example, we can restrict the id column so that its value cannot be repeated and cannot be null. The existence of constraints ensures the correctness, effectiveness and integrity of data in the database Addin ...

Spring boot(6) data access Learning video: https://www.bilibili.com/video/BV19K4y1L7MT?p=62&spm_id_from=pageDriver 1. Automatic configuration of data source - HikariDataSource 1.1 importing JDBC scenarios <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spr ...

1. Introduction 1.1 what is mybatis ● MyBatis is an excellent persistence layer framework ● it supports custom SQL, stored procedures and advanced mapping. ● MyBatis eliminates almost all JDBC code and the work of setting parameters and obtaining result sets. MyBatis can configure and map primitive types, interfaces and Java POJO s (Plain Old ...

1. TTL of tables and columns Defines the lifecycle of the value You can set for the entire table or for each individual column. Table level TTL can also specify the logic to automatically move data between disks and volumes. The table that sets TTL must contain fields of type Date or DateTime. To define the life cycle of data, you n ...

Use syntax mysqlbinlog [options] log-files Description of common parameters parameterdescribe-?, --helpHelp information--base64-output=nameOutput format: 'auto': Auto by default‘ never ': output in binlog event format‘ Decode rows': output pseudo SQL in annotation mode-d, --database=nameList only entries for this database (only lo ...

1, What is Druid? 1.1 concept Druid is a database connection pool implementation on Alibaba's open source platform. It combines the advantages of C3P0, DBCP, Proxool and other DB pools, and adds log monitoring. It can well monitor the connection of DB pool and the execution of SQL. It can be said that it is a DB connection pool for monitoring ...

A preliminary introduction to TableResolver The functions introduced in the introduction can be realized only by configuring XML, which is very convenient. However, in the actual project, the situation will be more flexible and changeable, which can not be covered only through configuration. From the beginning, we will introduce how to extend ...

MySQL group replication (multi master mode) Official website: https://dev.mysql.com/doc/refman/5.7/en/group-replication.html brief introduction MySQL group replication is a MySQL Server plug-in that enables you to create elastic, high availability, fault-tolerant replication topologies. Based on GTID.Group replication is a technology that ...