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. ...
Added by danbot26 on Wed, 09 Mar 2022 04:04:29 +0200
1, Database description
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
2.3 SQL statement classification
2.4 importing data
2.5 understanding of SQL script
2.6 common SQL commands
2.7 create ...
Added by paxman356 on Wed, 09 Mar 2022 03:01:36 +0200
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 ...
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 ...
Added by adrianl on Tue, 08 Mar 2022 14:11:44 +0200
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 ...
Added by VirtuosiMedia on Tue, 08 Mar 2022 13:54:03 +0200
1, What is Druid?
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 ...
Added by slimboy007 on Tue, 08 Mar 2022 09:28:11 +0200
MySQL group replication (multi master mode)
Official website: https://dev.mysql.com/doc/refman/5.7/en/group-replication.html
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 ...
Added by johnny on Tue, 08 Mar 2022 02:34:19 +0200