MySQL - group replication
MySQL - group replication
1. Group replication model
2. Group replication principle
3. Realize group replication
1. Group replication model
Group replication model
MySQL group replication is a new function introduced in MySQL 5.7.17, which realizes high availability mainly from replication. It ...
Added by woza_uk on Tue, 10 Mar 2020 10:28:52 +0200
[SpringBoot] data persistence: mybatis uses
If you eat when you are hungry, sleep when you are sleepy, drink when you are thirsty, life will be boringSource address: https://github.com/keer123456789/springbootstudy/tree/master/mybatisdemo
1. Project configuration
1.1 maven dependency configuration
It mainly depends on mysql and mybatis. Pa ...
Added by jsscart on Mon, 09 Mar 2020 05:23:39 +0200
Function index (Generated Column) and SQL optimization in MySQL
There is no function index function of Oracle in MySQL. It is not accurate to call the Generated Column of MySQL as "function index", but it can achieve the same effect as the function index. Some people also call this feature "derived column".
What is Generated Column
The value of Generated Column is calculated according to ...
Added by bettyatolive on Sun, 08 Mar 2020 11:44:01 +0200
Continued on the problem of Canal dynamicTopic
Continued on the problem of Canal dynamicTopic
Recently, I set up a set of canal in a new company. I set canal.mq.topic and canal.mq.dynamicTopic according to < < dynamictopic question > >
The intention is to send some messages that do not match the dynamic topic matching statements to a d ...
Added by limey on Sat, 07 Mar 2020 16:02:18 +0200
MySQL database in Linux practice -- master-slave replication
MySQL high availability scheme
Low read and write concurrency and low data volume scheme
Scheme I: dual computer high availability scheme
(1) Database schema
(2) Features
One machine A is used as the read-write library, the other B is used as the backup library; Library B is used as the read-write ...
Added by GrayFox12 on Sat, 07 Mar 2020 09:04:50 +0200
[SequoiaDB] Tech | in a few minutes to realize container deployment of SequoiaDB
With the increasing business load, containerization and virtualization have become the necessary capabilities for all kinds of online applications. For distributed database, containerization is also a good way to improve rapid deployment and operation and maintenance efficiency.
We have re optimi ...
Added by falcons on Fri, 06 Mar 2020 06:40:05 +0200
6.SQL injection and bypass
Article directory
1, GET request blind annotation
1. Introduction to blind note
Introduction to blind notes
Types of blindness
2.GET blind injection based on time
Principle overview
Determine whether there is injection point
Judge database length
Judge database name
3.GET blind annotation based ...
Added by GuiltyGear on Thu, 05 Mar 2020 07:06:47 +0200
1. Start from zero
Introduction to jOOQ
jOOQ Is an ORM framework that allows you to quickly build secure SQL statements with type constraints using Java code and a smooth API
jOOQ allows us to focus on business logic, while the basic interaction between Java and SQL can be handled by jOQ.jOOQ generally supports many ...
Added by dey.souvik007 on Wed, 04 Mar 2020 03:14:29 +0200
Python reptile battle - crawling historical weather data
Recently, the project needs to crawl the historical weather data of Hefei City, analyze several weather data websites, and finally select Weather post website . discuss the problems encountered in the implementation process for future reference.
Step analysis
Here, I use the requests library beautiful ...
Added by modcar on Tue, 03 Mar 2020 12:04:54 +0200
MySQL Multi-Instance Profile Start and Close in One File
One time when I was helping my friends solve problems, their server's MySQL was multi-instance, on which I made a master-slave configuration. Before I used multiple instances, I used multiple configuration files. This article mainly describes how to start and close multiple instances in a configuration file.
Profile Content
[ ...
Added by guybrush on Mon, 02 Mar 2020 18:20:49 +0200