Hand in hand to teach you to customize a Druid Filter to record sql, and combine Nacos to realize dynamic switch and judge threshold adjustment

1, Background Durid is a widely used database connection pool, which has superior performance, powerful monitoring mechanism, and also supports expansion through the mechanism of filter. Druid has a StatFilter for slow sql recording, but I found some shortcomings in using it: The print log of this Fi ...

Posted by jonsof on Mon, 29 Jun 2020 04:13:38 +0200

SpringBoot essay - SpringBoot integrated Druid

1. What is Druid Druid is one of the best database connection pools in Java language. Druid can provide powerful monitoring and extension functions. 2. Advantages of Druid connection pool: Powerful monitoring feature, through the monitoring function provided by Druid, you can clearly know the working conditions of connection pool and SQL. ...

Posted by Nik on Fri, 29 May 2020 16:55:46 +0200

Integration of ssm based on annotation

ps: it's relatively simple. It's used to lay the foundation for us to use springboot 1: Objectives Integration: springmvc+spring+mybatis+maven Small function: query all user information 2: Integration ideas: pom dependency configuration file Run through a small function 3: Integration steps: (1) New maven project (2) pom dependency ...

Posted by dbradbury on Thu, 23 Apr 2020 12:14:24 +0200

Spring boot 2.0 integrated data source Druid

Preface After a noisy day, problems such as too many redirects to visit the Druid login interface and no login interface can be seen are finally solved. Let's go through how to integrate Druid on native JDBC. 1, Create a new project integrating JDBC data sources [1] Introduction of starter [2] Confi ...

Posted by kurios on Mon, 24 Feb 2020 13:42:36 +0100

springboot ~ integrated DataSource and Druid monitoring configuration

introduce Druid is first a database connection pool. Druid is the best database connection pool at present, surpassing other database connection pools in function, performance and scalability. Druid has deployed more than 600 applications in Alibaba, which has passed the severe test of large-scale deployment of production environment for more t ...

Posted by siric on Wed, 19 Feb 2020 04:40:15 +0100

Learn springboot step by step -- the story of springboot and Druid

Add dependency <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.1.0</version> </dependency> Configure connection pool # JDBC configuration spring.datasource.type=com.al ...

Posted by drayfuss on Thu, 28 Nov 2019 20:42:12 +0100

Common indicators of Apache druid calculation

Druid supports SQL [ EXPLAIN PLAN FOR ] [ WITH tableName [ ( column1, column2, ... ) ] AS ( query ) ] SELECT [ ALL | DISTINCT ] { * | exprs } FROM table [ WHERE expr ] [ GROUP BY exprs ] [ HAVING expr ] [ ORDER BY expr [ ASC | DESC ], expr [ ASC | DESC ], ... ] [ LIMIT limit ] [ UNION ALL <another query> ] Duration data type The duration ...

Posted by naveenbj on Thu, 28 Nov 2019 17:12:13 +0100

Based on Maven, control spring boot configuration file gracefully

background As we all know, in the process of software development, we usually have production environment, development environment, test environment and so on. For these environments, we need to set different values for the same parameters in the configuration file. Then, how to switch simply, elegantly and quickly? Solution I. use the Pro ...

Posted by yujikaido on Sun, 24 Nov 2019 22:46:19 +0100

Spring Boot2 series of tutorials integrating MyBatis multiple data sources

About the configuration of multiple data sources, I have introduced the configuration of multiple data sources of JdbcTemplate with you. That is relatively simple. This article will talk about the configuration of multiple data sources of MyBatis with you. In fact, as for multi data sources, my attitude is the same as before. For complex data s ...

Posted by andrin on Mon, 18 Nov 2019 05:21:34 +0100

An implementation of read-write separation of springboot mybatis

First of all, consider using cache for processing. If the cache is not enough, then use read-write separation for implementation application.yml configures two data sources #Default usage configuration spring: profiles: active: dev --- #Development and configuration spring: profiles: dev datasource: master: jdbc-url: jdbc: ...

Posted by Jason_London on Fri, 08 Nov 2019 19:35:17 +0100