Introduction to ansible
ansible is a new automatic operation and maintenance tool. Based on Python development, it integrates the advantages of many operation and maintenance tools (puppet, cfengine, chef, func, fabric), and realizes batch system configuration, batch program deployment, batch run command and other functions.
Posted on Sat, 01 Feb 2020 11:29:55 -0500 by jets
1 connection pool
In actual development, "get Connection" or "release resources" are two processes that consume system resources very much. In order to solve this kind of performance problem, we usually use Connection pool technology to share Connection. In this way, we don't need to creat ...
Posted on Fri, 31 Jan 2020 17:07:16 -0500 by jaronblake
1.mysql configuration file
I. linux:/etc/my.cnf file windows:my.ini file
Binary log logbin: master-slave copy error log: it is off by default, recording serious warning and error information, details of each startup and shutdown.
Query log: log
Data file:. myd (store data). myi (store index) frm (store table structure)
Posted on Fri, 31 Jan 2020 16:28:53 -0500 by Cheers
Multi instance configuration of MySQL
In a physical machine, multiple test environments are needed, so multiple instances of building database are needed. Multiple instances means running multiple programs, and there is no influence between instances. Note that the ports you listen to need to be different. That is to say, running many mysql in ...
Posted on Fri, 31 Jan 2020 14:54:36 -0500 by lunarul
Please create your springboot project first
Add mybatis generator to the project
1. Add plugin in pom
Posted on Fri, 31 Jan 2020 14:29:32 -0500 by trrobnett
1, When operating the database, using the prepared statement will greatly improve the performance advantages of operating the database as follows:
1). Readability and maintainability of the code. (use placeholders to represent parameters?)
2) can maximize performance (precompile), MySQL does not support performance optimizat ...
Posted on Fri, 31 Jan 2020 14:07:15 -0500 by leebo
1.Get into mysql Command line, entering root And password
[root@localhost ~]# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.7.22 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved ...
Posted on Fri, 31 Jan 2020 12:16:12 -0500 by chriztofur
Updatable view is to update, insert and delete data in basic table through view. View is a virtual table, that is, the update of view, which is essentially the update base table. But the construction of views is often defined by multiple table join queries, combined with aggregate functions, group filtering, and so on. For this ...
Posted on Fri, 31 Jan 2020 10:33:51 -0500 by kaeRock
After reading several blogs, I also refer to other people's documents and row many holes. It's done
Summarize the steps:
1. Download openssl
2. Generate CA organization and certificate.
3. Generate the corresponding certificate and key for the master and slave of mysql
4. Modify mysql configuration file
Posted on Fri, 31 Jan 2020 10:29:47 -0500 by mirana
MySQL 5.7 has cancelled MySQL install dB and changed to systemd to deploy multiple instances
Steps are as follows
1. Change my.cnf (directly add it to the configuration mysql is using)
# For advice on how to change settings please see
# R ...
Posted on Fri, 31 Jan 2020 04:22:05 -0500 by colby.anderson