Programmer Group

Author: Du Jinyang More convenient data archiving Pt Archiver Some time effective data need to be archived and recycled when certain conditions are met. PT archiver tool can help us to archive and recycle data lines quickly # Archive to another database and delete the corresponding rows in the original table pt-archiver --source h=172.20.134. ...

Spring boot integrates redis + spring cache for caching github source code: https://github.com/xivinChen/SpringBoot 1, Cache user 1. First, create the springboot redis cache module and copy the contents of the springboot restful API. 2. Modify the three-tier architecture, that is, add the service tier Add the service.UserService interface, ...

1, Preliminary preparation 1. First, ensure that MySQL version 8.0 database is installed on the host 2. Go to the official website to download the database connection tool. MySQL version 8.0 database requires the latest connect jar connector. Otherwise, an exception of "Could not create connection to database server - ja ...

Recently, I have set up my personal blog. Here is the link: Babble of tobe The article will be updated in blogs and public numbers first. The so-called Transaction is to maintain the integrity of the database by ensuring that batch operations are either fully executed or not executed at all. Take A rotten Street example: A transfers 1000 yuan t ...

SpringBoot and Mybatis configure multiple data sources to connect to multiple databases Currently Mybatis is the framework for the industry to operate databases, but in many business scenarios, we need to configure multiple data sources in one project to implement business logic.You can also implement multiple data sources in SpringBoot and wr ...

Guidance: Author: Zheng Songhua, Zhi Shu Tang's SQL Optimized Class Teacher, Net Name: Rabbit Riding Tortoise Today, I would like to share some articles about not in, not exists.In fact, this can be summarized as exists to in, which was treated differently in previous versions of mysql until version 8.0.16. Prior to version 16, in could be op ...

MySQL Full Backup and Recovery The main content of this paper Classification of database backups MySQL Full Backup and Recovery MySQL Differential Backup and Recovery MySQL Incremental Backup Concept MySQL backup recovery operation 1. Preface With the rapid development of office automation and e-commerce, enterprises rely more and more on in ...

Monitoring is very important for operations and maintenance, which can be called the eyes of operations and maintenance personnel.A good monitoring system can help operators quickly find the root cause of the problem, reduce downtime, and improve the speed of troubleshooting.It can be seen from this that, as an operation and maintenance person ...

Learning Notes: docker deploys highly available MySQL clusters Environmental Science CentOS 7.5 (IP:106.xx.xx.xx) Docker 18.06.0-ce 1. docker settings # Define Subnets docker network create --subnet=172.18.0.0/16 net1 2. mysql Cluster (5) Using the Percona-XtraDB-Cluster scheme Connect 106.xx.xx.xx:30001-3000 ...

background In traditional architectures, you can use spring's @Transactional for declarative or programmatic transaction management, but if multiple data source operations are involved in our code, spring's @Transactional transaction management mechanism will fail, so we can consider using a two-phase commit solution.Let's take mysql as an exa ...