Construction and operation of MongoDB Replica Set

1, Build three Mongodb instances See the following for the construction steps: Construction of MongoDB. The planning is as follows: ipMongoDB portReplica roleMongodb version172.16.113.13727017Primary3.2.10172.16.113.13727018Secondary3.2.10172.16.113.12927017Secondary3.2.10 Parameter Description: parameterexplainExamplereplSetReplica set ...

Posted by gewthen on Wed, 29 Sep 2021 15:37:42 -0700

Set up a Linux server on your mobile phone

Install SSHD Install sshd apt update && apt upgrade # Update Terminal Package apt install openssh Start sshd sshd Set sshd self-start echo "sshd" >> ~/.bashrc Set User Name Password Get the username, I have the username u0_a173 here whoami u0_a173 Set Password passwd Remote landing ssh -p 8022 u0_a173@192.168.1 ...

Posted by Rusnoff on Wed, 29 Sep 2021 09:25:18 -0700

Detailed explanation of Mbatis batch execution error report

mybatis batch insert or update is a good solution to save resources and connections in many business scenarios. However, sometimes when the database configuration, especially the connection timeout and waiting time, is unreasonable, the following errors may be reported when performing batch operations. 1. Examples of error reporting: com.mysq ...

Posted by MrSarun on Tue, 28 Sep 2021 21:14:06 -0700

MySQL 8.0 password management policy

Author: Sri Sakthivel Original link: https://www.percona.com/blog/enhanced-password-management-systems-in-mysql-8-part-1 MySQL 8.0 has many improvements in password management. This article will introduce the following two features. Password reuse strategyGenerate random password |1 password reuse strategy This policy is simply to restr ...

Posted by mad81 on Tue, 28 Sep 2021 19:55:08 -0700

SQL server stored procedure learning record

https://www.cnblogs.com/c-supreme/p/9482321.html In short, a stored procedure is a collection of one or more sql statements, which can be regarded as a batch file, but its function is not limited to batch processing. 1, Overview of stored procedures Stored procedures in SQL server use t_ Code snippet written in SQL. Its purpose is to easily ...

Posted by twsowerby on Tue, 28 Sep 2021 04:03:54 -0700

CentOS 7 postgresql13 installs zhparser and configures Chinese full-text retrieval

Requirements: use postgresql13 to test the Chinese full-text retrieval function Install postgresql13 database I use the docker container to install and test 1. Create a centos7 image container docker run -di --name postgres13 --privileged=true -p 5432:5432 centos:7 /usr/sbin/init docker exec -it postgres13 bash 2. Install yum source ...

Posted by tlawless on Mon, 27 Sep 2021 21:32:17 -0700

Soci operation database (soci: database operation Library)

1. Reasons for choosing soci slightly 2. Characteristics of soci ① Enter sql statements in stream mode ② Pass and parse parameters through into and use syntax ③ Support connection pool and thread safety remarks: It can be seen that it is only a lightweight package, so it also has greater flexibility. The back end supports oracl ...

Posted by neuromancer on Mon, 27 Sep 2021 21:08:10 -0700

ORACLE stored procedure

1 what is a stored procedure (a set of sql statements compiled in advance and stored in the database) 1.1 Stored Procedure In a large database system, a set of SQL statements to complete specific functions are stored in the database and called again after the first compilation. There is no need to compile again. The user calls the stored proc ...

Posted by oliverj777 on Mon, 27 Sep 2021 10:10:49 -0700

[Mybatis] explain the core configuration file

🌈 I'm lucky to meet you. I'm Xiao Xiang. Have a big factory dream, work hard! Come on, stranger! 🌈 ☁️ This article is the notes and experience of learning Mybatis from the crazy God of station B. if it is useful to you, thank you for your praise. The article inevitably has shortcomings. Please point out that I will correct it in time! T ...

Posted by vyb3 on Sat, 25 Sep 2021 11:44:36 -0700

Redis data type

1, String data type Overview: string is the most basic type of redis. It can store up to 512MB of data. String type is binary secure, that is, it can store any data, such as numbers, pictures, serialized objects, etc 1. SET/GET/APPEND/STRLEN redis 127.0.0.1:6379> exists mykey #Judge whether the key exists, return 1 if it exists, ...

Posted by dvd420 on Sat, 25 Sep 2021 03:27:13 -0700