Redis installation and cluster deployment
1, redis compilation and installation
Download the installation package, unzip it and compile it Edit the script file of the built-in installer and comment the following
[root@server1 redis-6.2.4]# cd utils/
[root@server1 utils]# vim install_server.sh
[root@server1 utils]# ./install_server.sh xs ##Execute installation script
Afte ...
Posted by idweb on Fri, 24 Sep 2021 08:52:33 -0700
SQL 2008 - database creation and management
SQL Server 2008 database structure
System database
master A database that records all system level information of the SQL Server systemmsdbTemplate database for all user databases and tempdb databasemodelUsed by SQL Server agent to schedule alerts and jobstempGlobal resources available to all users connected to the SQL Server instance, save a ...
Posted by Robban on Thu, 23 Sep 2021 07:29:27 -0700
Automatic master-slave switching of redis
Setting redis master-slave is mainly used to edit configuration files on different hosts
We have three main engines ready
server1, server2 and server3 respectively
The master-slave automatic switching of redis is based on sentinel
1. The Sentinel system of Redis is used to manage multiple Redis servers (instance s). The system performs the ...
Posted by CWebguy on Thu, 23 Sep 2021 07:01:18 -0700
Mybatis complete notes
1. Introduction
1.1. What is Mybatis
MyBatis is an excellent persistence layer frameworkIt supports custom SQL, stored procedures, and advanced mapping.MyBatis eliminates almost all JDBC code and the work of setting parameters and obtaining result setsMyBatis can configure and map primitive types, interfaces and Java POJO s (Plain Old Jav ...
Posted by gregor63 on Wed, 22 Sep 2021 07:16:35 -0700
[SSM] use SSM framework to realize data paging management
When writing projects using SSM framework, sometimes the data obtained from the database is too large and will not be displayed in the web page. In order to avoid this situation, data paging can be used to effectively manage data.
What's wrong? I hope you guys can correct me!
1. First look at the effect 2. To complete the paging function, it ...
Posted by jonzy on Wed, 22 Sep 2021 01:14:35 -0700
[5-2] database foundation
Database foundation
Database: a collection that stores, maintains, and manages dataDataBase Management System (DBMS)
Common database management system
Oracle
Relational type
MySQL
Relational type
DB2
Microsoft SQL Server
Three paradigms
First normal form (1NF): no duplicate columns;The second normal form (2NF): attributes are complete ...
Posted by sandrob57 on Tue, 21 Sep 2021 16:14:57 -0700
Database and SQL language foundation (including detailed installation steps of MySQL compressed package environment)
1. Introduction to database
Baidu's definition of database is: "database is" a warehouse for organizing, storing and managing data according to data structure ". It is a collection of large amounts of data stored in computers for a long time, organized, shareable and uniformly managed."
In short, a database is a collec ...
Posted by rthconsultants on Tue, 21 Sep 2021 14:56:15 -0700
Introduction to Mybatis and coding process 2021-09-20
Mybatis application
1 Introduction to Mybatis and coding process 2 mapper agent development method 3 global profile 4 input mapping and output mapping 5 Association query 6 delayed loading 7 dynamic SQL 8 Mybatis cache
1, What is Mybatis
Mybatis reference website: http://www.mybatis.org/mybatis-3/zh/index.html Github source address: ht ...
Posted by PHP-Nut on Mon, 20 Sep 2021 23:26:33 -0700
CentOS MySQL installation details
Several common ways to install software on Linux:
Source code compilationDecompress the compressed package (generally tar.gz)Compiled installation packages (RPM, DPKG, etc.)Online installation (YUM, APT, etc.)
The convenience of the above methods increases in turn, but the versatility decreases in turn. For example, downloading compressed pac ...
Posted by zero-one on Mon, 20 Sep 2021 17:57:54 -0700
MySQL: a more complex query - Datawhale's third punch in note
SQL basics tutorial
Statement: the content of this blog is sorted out from Datawhale's punch in learning, and sorted into notes according to the punch in content. For reprint, please contact Datawhale and my authorization, and the reprint source must be indicated.
Chapter 3 more complex queries
The first two punch in notes introduced th ...
Posted by MBK on Mon, 20 Sep 2021 07:02:17 -0700