Installation and use of PostgreSQL database under CentOS 7 system

[summary] if the server where CentOS is located is limited to security reasons and the customer does not configure us to access the Internet, how to install the PostgreSQL database? This article will explain in detail how to install PostgreSQL12 database offline on CentOS7 system through specific steps. 1 offline installation package preparati ...

Posted by rathlon on Wed, 01 Dec 2021 00:41:39 -0800

MySQL's first experience of MyBatis 3

1, Annotation development 1.1 comparison between annotations and xml xml: as a configuration file Advantages: it can extract content (decoupling), clear configuration, convenient positioning and easy to findDisadvantages: complicated configuration Note: xml development can be replaced Advantages: fast development speed and no cumbersom ...

Posted by aff on Tue, 30 Nov 2021 23:19:57 -0800

2021SC@SDUSC hbase code analysis HFile analysis

2021SC@SDUSC hbase source code analysis (x) HFile analysis (2) 2021SC@SDUSC 2021SC@SDUSC 2021SC@SDUSC 2021SC@SDUSC HFileBlock HFileBlock mainly includes two parts: BlockHeader and BlockData. BlockHeader mainly stores Block related metadata, and BlockData is used to store specific data. The core field in Block metadata is the BlockType ...

Posted by Dave96 on Mon, 29 Nov 2021 21:21:59 -0800

Basic concepts of Oracle Database

Author: threedaymanSource: Hang Seng LIGHT cloud communityBasic conceptsdatabaseoracle database is the physical storage of data. Including data file ORA or DBF, control file, online file, log file and parameter file. oracle has only one database, which is managed by users. The process of creating a database in mysql database is to create a data ...

Posted by AP81 on Mon, 29 Nov 2021 19:03:07 -0800

Aggregation operation of MongoDB learning

Basic operation of MongoDB learningThe aggregation operation of mongo is similar to the query of mysqlSQL operations / functionsmongodb aggregation operationwhere$matchgroup by$grouphaving$matchselect$projectorder by$sortlimit$limitsum()$sumcount()$sumjoin$lookupThe following examples are compared with sqlThe following is a basic structure for ...

Posted by asfaw on Mon, 29 Nov 2021 17:44:57 -0800

redis cluster and sentinel mode -- 03

192.168.80.51Main db01192.168.80.11From web04192.168.80.9From web03 1. Cluster preparation To realize master-slave, please back up the data first First, a single node redis has been installed Single node installation https://blog.csdn.net/ncnhhm/article/details/121443981 Master node profile daemonize yes bind 192.168.80.51 port ...

Posted by Grunt on Mon, 29 Nov 2021 02:17:48 -0800

Practice of communication model based on channel

prefaceAs the data structure of Go core and the communication mode between Goroutine, Channel is an important structure supporting the high-performance concurrent programming model of Go language. This section will introduce the design principle, data structure and common operations of pipeline Channel, such as Channel creation, sending, receiv ...

Posted by spasme on Sun, 28 Nov 2021 23:52:47 -0800

mysql regular master-slave replication and GTID based master-slave replication

1, Environment deployment   192.168.113.129   193.168.113.130     For the binary deployment method of mysql5.7, see mysql5.7 binary deployment   2, mysql replication based on binary log points 1. Create a replication account on mysql master-slave >create user slave@'192.168.113.%' identified by '123456'; 2. Authorize the account t ...

Posted by pha3dr0n on Sun, 28 Nov 2021 22:02:10 -0800

postgreSQL source code analysis -- establishment and use of index -- Hash index

2021SC@SDUSC catalogue Hash index In addition to using B-Tree index, postgreSQL can also use hash index. Hash index has faster query speed. This article mainly explains the principle of hash index, compares it with B-Tree, and analyzes the relevant data structure of hash index in the source code. Hash indexing principle Hash table The ...

Posted by incubi on Sun, 28 Nov 2021 18:57:01 -0800

Notes of Xinfeng mall project

New bee mall project notes 1. Start the project and access the api online documentation http://localhost:8080/swagger-ui.html [the external chain image transfer fails. The source station may have an anti-theft chain mechanism. It is recommended to save the image and upload it directly (img-ge9fugsh-163811491017) (C: \ users \ Chen \ appdata ...

Posted by jdpatrick on Sun, 28 Nov 2021 16:33:55 -0800