NAV: SLTechnology News&Howtos > Database >

• 

  Redis has several ways to persist data

  Today, I will talk to you about the data persistence methods of redis, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article. Redis provides two ways to persist data, one is RDB

  2022-06-01 15:40:21 Views: 285
• 

  Steps for linux system to connect to redis

  This article will explain in detail the steps of connecting linux system to redis. The content of the article is of high quality, so I hope you can get something after reading this article. Because there are so many linux distributions. Redis provides the source of c development

  2022-06-01 15:40:18 Views: 255
• 

  ORACLE index invalidation, update statistics

  Sometimes when building an index, we do not go to the index, excluding the problems of field data and sql writing, and the problem of index failure, we have to consider that the statistical information is too old and has to be collected again. Check the statistics of the table and see the last_analyze of user_index.

  2022-06-01 15:40:18 Views: 258
• 

  Highly available keepalived instance

  The data from the master-slave database server will eventually be consistent (because mysql replication is asynchronous and there will always be delays), which seems to solve the single point problem, but the solution is not perfect. Because once the master server goes down, the read-write connection must be manually switched to the original slave server, and this process takes time.

  2022-06-01 15:39:47 Views: 284
• 

  How to realize Master-Slave synchronization in redis

  How does redis achieve master-slave synchronization? In response to this problem, the editor summed up this article today, hoping to help more friends who want to solve this problem to find a more simple and feasible way. Redis master-slave replication can be divided into full synchronization and incremental synchronization according to whether it is full or not. 1 full synchronous Re

  2022-06-01 15:39:44 Views: 229
• 

  The role of key

  Not null and defaultcreate table T1 (id int primary key auto_increment, set the primary key id, if you search through id, there will be a large number of

  2022-06-01 15:39:26 Views: 237
• 

  The most common interview questions and answers for Redis

  This article will explain in detail the most common interview questions and answers about Redis. The content of the article is of high quality, so I hope you can get something after reading this article. 1. What is Redis? Redis is essentially a Key-Value.

  2022-06-01 15:39:26 Views: 212
• 

  Types of resources that SQL Server can lock

  Types of resources that SQL Server can lock SQL Server can lock different types of resources. These resource types that can be locked include: RIDs or key (keys) (row level), page (pages), object (objects) (for example, table)

  2022-06-01 15:39:25 Views: 209
• 

  Building configuration of Redis High availability Cluster

  This article will explain in detail the construction and configuration of Redis high-availability clusters. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article. Redis's cluster master-slave model is a highly available cluster architecture. The main content of this chapter

  2022-06-01 15:39:22 Views: 254
• 

  The highest state of database disaster recovery

  The client of the highest level of database disaster recovery is not affected, the database connection is continuous, and there is no need to log in again.

  2022-06-01 15:39:22 Views: 262
• 

  Linux week 11 Learning Notes (1) Advanced SMTP Service

  SMTP service deployment-the advanced article follows last week's content. One. Remote login restrictions as all virtual machines can connect remotely to send mail services, it is obvious that this is step-by-step security. How to implement login restrictions: 1.cd / etc/ on my client (desktop)

  2022-06-01 15:38:52 Views: 265
• 

  Construction steps of redis master-slave replication

  This article will explain in detail the building steps of redis master-slave replication. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article. The principle of master-slave replication in a Redis cluster allows several Redis servers to reply.

  2022-06-01 15:38:43 Views: 262
• 

  Mysql study notes (7-DCL commands user account and rights management)

  User account and rights management: user account: 'username'@'host'host: which hosts are allowed to remotely create connections when this user accesses the current mysql server; representation: IP, network address, hostname, wildcard (% and _); check prohibited

  2022-06-01 15:38:42 Views: 261
• 

  Open the audit of a table in Oracle

  Oracle uses the audit_trail parameter to control whether audit is enabled or not. The following parameters are used: NONE: do not enable audit OS: indicate that the audit information is put in the system summary. If it is Linux, then audit_file_des

  2022-06-01 15:38:42 Views: 299
• 

  Basic Operation of Mysql based on linux operating system (3)

  Based on linux operating system Mysql basic operation (3) knowledge point 1: view all user commands in MYSQL database: select distinct concat ('User:''',user,'''@''',host

  2022-06-01 15:38:34 Views: 220
• 

  MySQL audit plug-in use

  Download the MySQL audit plug-in https://github.com/mcafee/mysql-audit/releasesor this article uses the mcafee official website to download the linked software: https://dl.bintray.co

  2022-06-01 15:38:33 Views: 258
• 

  Deployment and installation of zabbix server

  Based on centos6.5 + zabbix-2.4.6 and most of the commands are in the zabbix installation path! For example, / usr/local/zabbix/yum-y install gcc gcc-c++ auto

  2022-06-01 15:38:33 Views: 259
• 

  ORA-07445: [kghsrch () + 128] [SIGSEGV] [Address not mapped to object] Cold treatment

  Customer site, telecom-related 24-hour business, a province database two-node alert constantly generate ORA-7445 errors, and throw out Trace dump files, Trc files. There are no 7445 related errors in one-node alert, only core files are generated. Cr

  2022-06-01 15:38:18 Views: 293
• 

  Mysql forgot password handling method

  Launch mysqld_safe in safe mode-- skip-grant-tables & mysql-u rootuse mysqlupdate user set password=PASSWORD ('new password'

  2022-06-01 15:38:18 Views: 264
• 

  SQLServer2008 backup and recovery

  Goal: 1. Understand the backup mode (full, differential, log backup) and recovery model of SQLServer2008R2; 2. Able to perform full backup, differential backup operation, transaction log backup, and restore operation; 3. Use the maintenance plan to realize the daily database backup operation

  2022-06-01 15:38:17 Views: 211