Construction of microservice parent project

1. Steps of building parent project based on IDEA New maven project 2. Name of aggregation parent project Maven selected version Character encoding settings Annotation effective activation Java version selection 8 File Type filtering 2.pom file description 1.pom Document conten ...

Added by pha3dr0n on Sat, 14 Mar 2020 16:44:16 +0200

Mybatis generator automatically generates code and integrates swaggerui

Introduce dependency: <!-- MyBatis generator --> <dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-core</artifactId> <version>1.3.7</version> </dependency> <!--Mysql Database driven--> <depend ...

Added by JamesyBHOY on Sat, 14 Mar 2020 16:25:58 +0200

Common functions of MySQL data processing

The built-in functions of MySQL can be roughly divided into the following categories: 1. Processing text functions of text data (such as splicing, case conversion, etc.); 2. A numerical function (such as an algebraic operation) that processes numerical data; 3. Date time class function; 4. System ...

Added by tecate1 on Fri, 13 Mar 2020 16:48:45 +0200

brew installs mysql on Mac OS

I am trying to set up MySQL on Mac OS 10.6 using Homebrew through brew install mysql 5.1.52. All went well, and MySQL install dB was also successful. However, when I try to connect to the server using the following methods: /usr/local/Cellar/mysql/5.1.52/bin/mysqladmin -u root password 'mypass' I get: /usr/local/Cellar/mysql/5.1.52/ ...

Added by freakuency on Fri, 13 Mar 2020 08:04:52 +0200

Saltstack automatic operation and maintenance tools - preliminary environment deployment

Saltstack automatic operation and maintenance tools - preliminary environment deployment Document reference: 1.1 GitHub address;           https://github.com/ansible/ansible           https://github.com/saltstack/salt  1.2. Record the execution to mysql;        https://docs.saltstack.com/en/latest/ref/returners/all/       1, Comparison betwee ...

Added by imstupid on Fri, 13 Mar 2020 06:38:18 +0200

Analysis of distributed DBLE LOAD DATA function implementation

Author: Lu Lu Those who love technology and are willing to share are mainly engaged in the research of database related technology. Source: original contribution *Aikesheng is produced by the open source community. The original content cannot be used without authorization. Please contact the editor for reprint and indicate the source. 1. o ...

Added by Superian on Thu, 12 Mar 2020 11:42:09 +0200

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