Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database account cleaning method, device and electronic equipment

A cleaning method and database technology, applied in the database field, can solve the problems of unfavorable database high availability, database nodes cannot be accessed, etc., and achieve the effect of high availability

Active Publication Date: 2021-09-24
TENCENT TECH (SHENZHEN) CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, when the middleware is down or the service is unavailable, the business service cannot be accessed by any database node, which is not conducive to the high availability of the database

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database account cleaning method, device and electronic equipment
  • Database account cleaning method, device and electronic equipment
  • Database account cleaning method, device and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and will fully convey the concept of example embodiments to those skilled in the art.

[0056] Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided in order to give a thorough understanding of embodiments of the present disclosure. However, those skilled in the art will appreciate that the technical solutions of the present disclosure may be practiced without one or more of the specific details, or other methods, components, means, steps, etc. may be employed. In other instances, well-known methods, ap...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The disclosure relates to the technical field of databases, and provides a database account cleaning method and device, and electronic equipment. Wherein, the method includes: a cleaning method of a database account, including: collecting current connection information and historical cumulative connection information of the account at a node at each point in time; 1 The historical cumulative connection information collected at time point 1 determines whether the node has been restarted between the i-1 time point and the i-th time point, i is an integer greater than 1; in response to the node from the i-1 time point to the i-th It has been restarted between the i time points, update the last login time of the first account corresponding to the current connection information collected at the i time point to the i time point; based on the last login time of the first account on the node, clear the first account . The technical solution can effectively guarantee the data security of the database and is conducive to improving the high availability of the database.

Description

technical field [0001] The present disclosure relates to the technical field of databases, in particular, to a method and device for clearing database accounts, and an electronic device for implementing the method for clearing database accounts. Background technique [0002] Database security management is an important measure to ensure data security. Among them, the management of database account rights is an important part of security management. Abnormal accounts (for example, account privileges are enlarged) are a great security risk to the database. Therefore, it is necessary to clean up abnormal accounts in the database. [0003] In the account clearing solution in the related technology, the structural diagram of the database architecture is as follows: figure 1 , setting up database middleware between the database cluster and the business service. Specifically, the middleware establishes connections with node 1, node 2...node n in the database cluster respectively...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/215G06F16/21G06F16/22
CPCG06F16/215G06F16/217G06F16/2282
Inventor 禤欢子沈登徽
Owner TENCENT TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products