Spring Road (40) - declarative transaction management with @ Transactional is so simple

Simple enough To be honest, to implement transaction management and add an annotation to a method, the method automatically implements transactions, which is simple enough. I can't think of anything simpler. This annotation is @ Transactional, which is so excellent. Declarative transaction management ...

Posted by Hi I Am Timbo on Thu, 06 Feb 2020 01:37:05 -0800

MySQL Database - Functions, Transactions, Indexes, Rights Management and Backup, Specifications for Databases

1. MySQL functions Official website: https://dev.mysql.com/doc/refman/5.7/en/func-op-summary-ref.html 1.1. Common Functions -- ==================== Common Functions ============================= -- Mathematical operations SELECT ABS(-8) -- absolute value SELECT CEILING(9.4) -- ceil SELECT FLOOR(9. ...

Posted by undecided name 01 on Wed, 05 Feb 2020 20:01:33 -0800

JDBC development steps

JDBC development steps 1. Registration driver ---Tell the JVM which database driver to use 2. Get connected ---Use the classes in JDBC to complete the connection to the MySQL database 3. Get statement execution platform ---Get the executor object of the SQL statement through the connection object ...

Posted by scross on Wed, 05 Feb 2020 06:10:11 -0800

Ansible Role Management-Roles (Example Demo!!!)

An overview of Roles Roles can automatically load variable files, task s, handlers, and so on, depending on the hierarchy. Simply put, Roles is about including variables, files, tasks, modules, and processors in separate directories and easily. Roles is typically used in scenarios where services are built on hosts, but it can also be used in s ...

Posted by hemoglobina on Tue, 04 Feb 2020 15:13:50 -0800

Spring batch batch processing framework + mysql warehouse + web monitoring record

1, concept Spring Batch is a lightweight batch processing framework suitable for enterprise applications. It is worth noting that unlike other scheduling frameworks, Spring Batch does not provide scheduling functions. 2. Batch process Batch processing can be divided into the following steps: Read data Process data according to business The pr ...

Posted by KindredHyperion on Tue, 04 Feb 2020 05:05:24 -0800

springboot+mybatis for data addition and deletion

springboot+mybatis for data addition and deletion In the previous article about creating springboot projects with idea, let's talk about using mybatis for curd. 1. Database Creation 2. The pom.xml file adds mysql dependencies, etc. <!--mysql rely on--> <dependency> ...

Posted by mahenderp on Mon, 03 Feb 2020 19:52:53 -0800

Ansible script management (example explanation!!!)

inventory host list The default host list of ansible is the / etc/ansible/hosts file. The host list can be set manually or generated dynamically through Dynamic Inventory. Generally, the host name uses FQDN vim /etc/ansible/hosts [webserver] #Square bracket set group name www1.example.org #Define the monit ...

Posted by Arez on Mon, 03 Feb 2020 09:08:23 -0800

Ansible installation and module management (the most complete operation, can follow

1, Ansible installation Environmental preparation Management end: CentOS 7-2 192.168.18.147Managed end 1: CentOS 7-3 192.168.18.128Managed end 2: CentOS 7-4 192.168.18.148 Management side: [root@localhost ~]# systemctl stop firewalld.service [root@localhost ~]# setenforce 0 [root@localhost ~]# yum install epel-release -y [root@localhost ~]# ...

Posted by santhosh_89 on Mon, 03 Feb 2020 07:34:46 -0800

Transaction Delivery Properties for SpringBoot Series Tutorials

Transaction Delivery Properties for the 200202-SpringBoot series of tutorials For mysql, there may be several main points of knowledge about transactions at the isolation level; in the Spring system, there is also a transfer property of knowledge point transactions that is equally important when using transactions. This article will focus on ...

Posted by andy666 on Sun, 02 Feb 2020 20:01:59 -0800

About Queries_per_sec performance counters

[Problem Description] Queries_per_sec (QPS) is two important performance counter metrics for databases.We often require development to inform this parameter to evaluate a load on the database.The following code connects to the server to make a simple query: using (MySqlConnection conn = new MySqlConnection()) { conn.ConnectionString = "Database ...

Posted by Procode on Sun, 02 Feb 2020 18:49:06 -0800