Automatic operation and maintenance tool ansible -- installation and module management

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

Java database 03 connection pool

1 connection pool 1.1 INTRODUCTION 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

mysql advanced (1) lecture 1-13

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) 2, ...

Posted on Fri, 31 Jan 2020 16:28:53 -0500 by Cheers

Mysql multi instance configuration

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

Using mybatis generator to generate code in spring boot

Please create your springboot project first Add mybatis generator to the project 1. Add plugin in pom <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.5</version> <dependencies> &l ...

Posted on Fri, 31 Jan 2020 14:29:32 -0500 by trrobnett

Performance comparison of mysql batch operation

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

mysql user management and permission setting under centos7

1.Get into mysql Command line, entering root And password [root@localhost ~]# mysql -u root -p Enter password: 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

MySQL updatable view

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

mysql master-slave replication encryption (ssl)

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 5 ...

Posted on Fri, 31 Jan 2020 10:29:47 -0500 by mirana

Mysql 5.7 multi instance deployment

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 # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html [mysqld] # # R ...

Posted on Fri, 31 Jan 2020 04:22:05 -0500 by colby.anderson