Spring Boot integrates Flyway to realize database version control

In the iterative development of the project, it is inevitable to update the database Schema, such as adding a new table, adding fields to the table or deleting fields, etc., so when I perform a series of operations on the database, how to quickly synchronize on the computers of other colleagues? How to quickly synchronize on test / production s ...

Posted on Thu, 07 May 2020 23:15:56 -0400 by furma

Index type for MySQL

MySQL index is very important for the efficient operation of MySQL. Indexing can greatly improve the speed of MySQL retrieval. For example, if a reasonably designed and indexed MySQL is a Lamborgini, then a human tricycle is a MySQL that does not design and use an index. Using the catalog page (index) of a Chinese dictionary as an example, we ...

Posted on Thu, 07 May 2020 18:22:54 -0400 by dave007

Logging user login information using init_connect parameter

Note: The content of the article originated from the Internet and was based on our own experiments; however, the address of the reference article was not recorded at that time. If you find any infringement problems, please leave a message. ~Special Reminder: If concurrency is high, this may affect performance and should be fully evaluated bef ...

Posted on Thu, 07 May 2020 16:15:58 -0400 by sparshdharam

MySQL - view running threads - SHOW PROCESSLIST

1: The goal is clear, which can be achieved by the following commands. The specific effect is shown in the figure below show full processlist; select * from information_schema.processlist;   SELECT * FROM sys.processlist order by conn_id;   2: The meaning of the field can also be guessed from the name. The specific inform ...

Posted on Thu, 07 May 2020 10:45:44 -0400 by ianr

docker mysql8 master-slave configuration

The mysql of this pull is version 8, which is used to build master-slave replication   With the upgrade of mysql image, the mount directory in the previous docker run command will be invalid. Make a record The master and slave file directories are the same, so we need two copies of the following operations for conf configuration master - ...

Posted on Thu, 07 May 2020 01:17:16 -0400 by aaronxbond

Solve 1032 error report of online master-slave replication

The reason for the error is that the master database service is restarted abnormally, which causes the slave database replication to report 1032 errors In other cases, the slave does not limit the read-only permission. When the development or operation and maintenance personnel mistakenly delete the data on the slave database, which results in ...

Posted on Wed, 06 May 2020 10:09:24 -0400 by maxpup979

MySql basic instructions

1. Start MySql /etc/init.d/mysql start Run successfully: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Orac ...

Posted on Tue, 05 May 2020 19:45:23 -0400 by purplehaze

Configure Tomcat's virtual host and build java application (I)

Requirement: use Tomcat to deploy a Java application (zrlog blog). Add a virtual host [root@dl-001 src]# vim /usr/local/tomcat/conf/server.xml //Add the following configuration <Host name="www.123.cn" appBase="" unpackWARs= "true" autoDeploy="true" xmlValidation="false" xmlNamespaceAware="false"&gt ...

Posted on Tue, 05 May 2020 16:13:59 -0400 by babybird11

Instructions for mysql5.7 General tablespace

Note: the content of the article originated from the network and was obtained through our own experiment; however, the reference article address was not recorded at that time. If you find any infringement problem, please leave a message. ~~General tablespace is a shared innodb tablespace, similar to ibdata1. You can store multiple tables unde ...

Posted on Tue, 05 May 2020 15:22:18 -0400 by MikeDXUNL

Go learning notes - using MySQL database

2017-12-28 15:17:31    At present, there are many drivers supporting MySQL in Go, some of which support database/sql standards, and some of which use their own implementation interfaces. The commonly used ones are as follows:   https://github.com/Go-SQL-Driver/MySQL supports database/sql, all written in go. Https://github.com/ziutek/mysql supp ...

Posted on Tue, 05 May 2020 14:55:35 -0400 by rharden