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