BoneCP used by friend company Mysql connection pool, the application accesses Mysql as domain name, which is configured as follows:
All middleware access is through th ...
Added by navtheace on Sun, 15 Mar 2020 04:17:09 +0200
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
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
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
Check the source code, Firefox f12, viewer.
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
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 high availability scheme
Low read and write concurrency and low data volume scheme
Scheme I: dual computer high availability scheme
(1) Database schema
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
1, GET request blind annotation
1. Introduction to blind note
Introduction to blind notes
Types of blindness
2.GET blind injection based on time
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
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
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