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