BoneCP Connection Pool Reconnection Mechanism Analysis

1. Background BoneCP used by friend company Mysql connection pool, the application accesses Mysql as domain name, which is configured as follows:   jdbc:mysql://order.mysql.xx.cn:3306/order?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true All middleware access is through th ...

Added by navtheace on Sun, 15 Mar 2020 04:17:09 +0200

Analysis of distributed DBLE LOAD DATA function implementation

Author: Lu Lu Those who love technology and are willing to share are mainly engaged in the research of database related technology. Source: original contribution *Aikesheng is produced by the open source community. The original content cannot be used without authorization. Please contact the editor for reprint and indicate the source. 1. o ...

Added by Superian on Thu, 12 Mar 2020 11:42:09 +0200

Gausdb 100 stand alone upgrade Guide

The purpose of this article is to introduce how to upgrade GaussDB stand-alone database from 1.0.0 to 1.0.2. Single machine supports automatic upgrade of small version and binary upgrade. For automatic upgrade, only one upgrade command needs to be executed on the node. 1. Upload package and decompress Upload the following two packages to the s ...

Added by suntra on Thu, 12 Mar 2020 11:37:15 +0200

Function index (Generated Column) and SQL optimization in MySQL

There is no function index function of Oracle in MySQL. It is not accurate to call the Generated Column of MySQL as "function index", but it can achieve the same effect as the function index. Some people also call this feature "derived column". What is Generated Column The value of Generated Column is calculated according to ...

Added by bettyatolive on Sun, 08 Mar 2020 11:44:01 +0200

bugkuCTF practice platform

web 1.web2 Check the source code, Firefox f12, viewer. 2. calculator f12 viewer, find the following line: <input type="text" class="input" maxlength="1"> Change maxlength to the number of digit ratio results, and you can enter it. 3.web foundation $ This is really the foundation. When get reques ...

Added by ccb on Sun, 08 Mar 2020 05:59:24 +0200

Continued on the problem of Canal dynamicTopic

Continued on the problem of Canal dynamicTopic Recently, I set up a set of canal in a new company. I set canal.mq.topic and canal.mq.dynamicTopic according to < < dynamictopic question > > The intention is to send some messages that do not match the dynamic topic matching statements to a d ...

Added by limey on Sat, 07 Mar 2020 16:02:18 +0200

MySQL database in Linux practice -- master-slave replication

MySQL high availability scheme Low read and write concurrency and low data volume scheme Scheme I: dual computer high availability scheme (1) Database schema (2) Features One machine A is used as the read-write library, the other B is used as the backup library; Library B is used as the read-write ...

Added by GrayFox12 on Sat, 07 Mar 2020 09:04:50 +0200

6.SQL injection and bypass

Article directory 1, GET request blind annotation 1. Introduction to blind note Introduction to blind notes Types of blindness 2.GET blind injection based on time Principle overview Determine whether there is injection point Judge database length Judge database name 3.GET blind annotation based ...

Added by GuiltyGear on Thu, 05 Mar 2020 07:06:47 +0200

High salary test required: 3 steps to teach testers to crack sub query

Testers often check whether the data in the database is correct due to work reasons. At this time, they need to frequently use multi table queries. In multi table query, inner join is the most widely used, followed by sub query. Why are subqueries widely used in work? The reason is that subqueries ...

Added by j152 on Wed, 04 Mar 2020 10:41:09 +0200

1. Start from zero

Introduction to jOOQ jOOQ Is an ORM framework that allows you to quickly build secure SQL statements with type constraints using Java code and a smooth API jOOQ allows us to focus on business logic, while the basic interaction between Java and SQL can be handled by jOQ.jOOQ generally supports many ...

Added by dey.souvik007 on Wed, 04 Mar 2020 03:14:29 +0200