JEECG containerization deployment
There is a Dockerfile in the JEECG code. The basic idea is to take CentOS as the basic image, in which nginx, jdk, MySQL and redis are installed. The...
Beginner's understanding of Java design pattern
The structural pattern of Java design pattern 1. Adapter mode Adapter mode of class 1.1 1.2 adapter mode for objects 1...
type column parsing of explain
1,const Indicates that the execution step returns at most one row of data. const usually appears in the equivalent query...
Summary of JDBC basic knowledge
Refer to the summary of Java language programming foundation version 10
...
The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese code scrambling, it can be used for personal test!)
The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese scrambling) 1, Log in ...
How to store IP address effectively in MySQL
A few days ago, a friend of a Miao went for an interview. He came back and told me that the interviewer asked him how hi...
ES7 learning notes GEO location search
The basic content of ES is almost introduced. At last, let's take a look at GEO location search. Now most apps have loca...
All MySQL installation and deployment methods
catalog 1, Foreword 2, About MySQL installation 3, Deployment planning 3.1 server planning 3.2 database directory plan...
Centos7 MySQL installation master-slave replication configuration
Installation Dependency yum search libaio # Retrieving related information yum install libaio # Install Dependent Packag...
A reusable distributed transaction message architecture based on RabbitMQ
premise
Distributed transaction is a more dif...
[open source]. Net orm FreeSql 1.5.0 latest version (serial number: long time no see)
The beginning of nonsense
This article is the...
Custom Spring Boot starter
When we use spring boot to develop applications quickly, we often introduce many libraries that start with spring boot s...
PHP PDO mysql abstraction layer
Using PDO constructor to connect database and DSN <?php $dbms = 'mysql'; $dbname = 'test'; $user = 'root'; $pwd = '1...
fio storage performance manometry
1. Environmental Instructions: This demo is a dellr620 physical server with centos7.6 x86_64-bitThe hardware-related inf...
Master the basic Oracle syntax quickly, let you come and go freely
This article, let's continue the previous installation, explain the basic syntax of Oracle, so that you can operate and ...
Docker data management and network communication, port mapping
Bibliography:
1. Data management of docker 1. Data Volume...
User and Rights Management for MySQL
In MySQL 5.7.24, information about users and user permissions is stored in the user table of mysql library, which can be...
The difference between [MySQL] char and varchar
CHAR and VARCHAR types are similar, but they are saved and retrieved in different ways. Their maximum length and whether...
Mysql dual host hot standby and implementation of Mysql dual host and high availability with preserved
There are two ways of mysql hot standby:
Hot standby of m...
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...
docker mysql8 master-slave configuration
The mysql of this pull is version 8, which is used to build master-slave replication
...
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 re...
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 r...
Zabbix monitoring MySQL under Windows
1. Create monitoring account in MySQL GRANT PROCESS,REPLICATION CLIENT ON *.* TO mysql_monitor@'localhost' IDENTIFIED BY...
Which is more efficient about the select statement with the maximum id + 1 in the table?
Requirement: take the maximum id value + 1 in the stock table as the next id value.
...
Java learning notes 50 (DBCP connection pool)
In actual development, connecting database is a very resource consuming operation. However, we need to connect database ...