mybatis reverse engineering

First, create a test class: Write the following code in the main method: List <String> warnings = new ArrayList <String>(); boolean overwrite = true; File configFile = new File("generator.xml"); ConfigurationParser cp = new ConfigurationParser(warnings); Configuration config = cp.parseConfiguration(configFile); DefaultShellCallback ...

Posted on Sat, 07 Dec 2019 14:22:37 -0500 by Krik

One SQL causes server overload

At about 9:30 in the morning, the salesperson reported that their page was opened slowly, and the subsequent page appeared 502. Then I receive the alarm and log in to the database server to check the cpu 400% load 30 or so Enter the database and find many slow queries It was thought that these slow queries came from the daily scheduled task ...

Posted on Sat, 07 Dec 2019 13:28:38 -0500 by Liquix

Docker builds gitlab using external database

build mysql and redis used by the official gitlab image are nested internally. Below are images using external databases: sameersbn/gitlab. Deploy database mysql Run container mkdir -p /home/bubao/disk/data1/opt/mysql/{data,conf.d} docker run --name mysql \    --restart=always \    --env MYSQL_ROOT_PASSWORD=123456 \    --volume ...

Posted on Sat, 07 Dec 2019 07:53:03 -0500 by careym1989

MySQL-8.0.12 source installation instance

1. After downloading the corresponding version through the official website, upload it to the / usr/local/src directory of the ECS through FTP 2. Decompress the file [root@JSH-01 src]# ls mysql-boost-8.0.12.tar.gz [root@JSH-01 src]# tar zxvf mysql-boost-8.0.12.tar.gz [root@JSH-01 src]# ls mysql-8.0.12 mysql-boost-8.0.12.tar.gz 3. Rename folder ...

Posted on Sat, 07 Dec 2019 05:38:15 -0500 by chemoautotroph

MySQL Index and Transaction, Storage Engine MyISA and InnoDB

MySQL indexes and transactions, views, storage engines MylSAM and lnnoDB The concept of index Indexes in databases are similar to catalogs in books: 1. - In this book, you don't have to read the whole book to use the catalog to quickly find the information you need.2. The table of contents in the book is a list of words with page numbers cont ...

Posted on Sat, 07 Dec 2019 03:42:09 -0500 by BigMike

MySQL MHA high availability solution

2.1 precautions before deployment Here, only mysql is deployed on the [10.0.0.11] server. The deployment on other machines (12, 13, 14) is the same as here. Only the configuration in the configuration file needs to be changed. 01: server ID cannot be the same 02: the file name of the corresponding log file should not be the same, for example: ...

Posted on Sat, 07 Dec 2019 01:38:00 -0500 by 7khat

Mac OS Mojave downgrades MySQL 5.7 installation

Preface Since Mac OS was upgraded to Mojave, there have been many small problems. Now, using Homebrew to install MySQL is also version 8.0 by default. Components similar to Python we rely on may not support higher versions. Some updates and adjustments of the new version cause the unavailability of Sequel Pro and mysqldb. Of course, we can also ...

Posted on Fri, 06 Dec 2019 21:30:30 -0500 by Gummie

Mysql master-slave relationship building

MySQL master-slave building Build a separate master-slave database -Turn off firewall $ systemctl stop firewalld.service -Build mysql Build with yum source Binary log is configured on the main database -Configure Master to use binary log file location based replication Binary logging must be enabled and a unique server ID established, ot ...

Posted on Fri, 06 Dec 2019 20:15:28 -0500 by CowbellMaster

python easy installation tutorial

conda A python multi version and python package management tool download We choose the mini version and download the used package as required Minionda installation documentation Download other historical versions conda installation bash Miniconda3-latest-MacOSX-x86_64.sh conda use Create python specified environment conda create ...

Posted on Fri, 06 Dec 2019 18:11:34 -0500 by jbruns

Install and compile PHP7.X

Before installing this php version, you must install two other installation environments, Apche and myql, because the path is based on these twohttps://blog.51cto.com/popli3/2357295https://blog.51cto.com/popli3/2357211 Install PHP Install yum environment (aliyun's yum environment) [root@minion-1 ~]#yum -y install bzip2-devel libmcrypt-deve ...

Posted on Fri, 06 Dec 2019 15:25:38 -0500 by matt2012