NAV: SLTechnology News&Howtos > Database >

• 

  Centos7 maiadb Master-Slave replication Building

  Requirements: due to the use of saltstack, deployment environment, first manually built the next master-slave environment, found that the original word information can not be found, so quickly record to the blog this time! Environment: two devices, the ip address is: node1:192.168.56

  2022-06-01 15:44:21 Views: 265
• 

  Introduction and use of transaction commands in redis

  This article will explain in detail the introduction and use of transaction commands in redis. The content of the article is of high quality, so I share it for your reference. I hope you can get something after reading this article. 1. Overview: the essence of a Redis transaction is a collection of commands. Transaction support

  2022-06-01 15:44:21 Views: 203
• 

  How to migrate from BasicFile to SecureFile Storage (1)

  The new SecureFile storage feature of Oracle 11g extends the flexibility and capacity of large objects (LOB). This paper studies how to effectively migrate from BasicFile to SecureFile storage and how to measure SecureFile vs Ba.

  2022-06-01 15:44:18 Views: 237
• 

  Learning suggestions of mysql

  This article will explain in detail the learning suggestions about mysql for you. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article. Learning steps: 1. Download and install. Familiar with mysql configuration files and directory structure. 2.mys

  2022-06-01 15:44:02 Views: 277
• 

  Oracle's OFA (Optimal Flexible Architecture)

  The highest directory where the Oracle Base Directory:oracle software is installed. Oracle Inventory Directory: location: $ORACLE_BASE/../oraInvenory if not found

  2022-06-01 15:44:02 Views: 225
• 

  MONGODB SHARDING

  Sharding IntroductionSharding is a method for storing data across multiple machines. MongoDB uses sh

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

  Redis- slow query analysis

  one。 Slow query log helps developers and operators to locate the slow operation of the system. Slow log means that the system calculates the execution time of each command before and after the command is executed. When the preset threshold is exceeded, the relevant information of the command (slow query ID, occurrence timestamp, time-consuming, and the details of the command) is calculated.

  2022-06-01 15:44:01 Views: 245
• 

  InnoDB change buffer

  InnoDB change buffer, an important data change log, the main purpose of Change buffer is to cache the data operations on the secondary index, so as to reduce the random IO of the secondary index and achieve the effect of merging operations. In MySQL5.

  2022-06-01 15:44:01 Views: 228
• 

  Install Oracle in Linux (installation summary)

  1. Check hardware memory # grep MemTotal / proc/meminfo swap space # grep SwapTotal / proc/meminfo disk space # df-ah2, download software Oracle Data

  2022-06-01 15:44:01 Views: 220
• 

  Informix database selection and system planning

  1. Informix business scenario selection 1, financial industry, such as Construction Bank, PICC, Pudong Development Bank, etc. 2, communications industry, such as China Mobile, China Unicom, China Telecom 3, retail industry, such as Wal-Mart, Carrefour, Huarun Wanjia, etc. 4, e-commerce industry, such as Amazon

  2022-06-01 15:43:58 Views: 290
• 

  Talking about PostgreSQL Database

  Recent work has been focused on database design, taking advantage of this opportunity to sort out some of my understanding of PostgreSQL database, but also a summary of recent learning. For many of you, you may not have heard of this database, but we usually have O in our ears.

  2022-06-01 15:43:58 Views: 214
• 

  Frequently generate archived log processing reports

  Frequent generation of archived log processing reports on October 27th, 2017, the customer database suddenly generated a large number of archived logs frequently, resulting in database hang living, affecting on-site production! Since oracle archive logs are generally generated by dml statements, increasing too fast should be because dml is too frequent.

  2022-06-01 15:43:57 Views: 274
• 

  Guidance on Security reinforcement of Redis Cache Database (1)

  Background among many open source cache technologies, Redis is undoubtedly one of the most powerful and widely used cache technologies. Referring to the 2018 foreign database technology authority website DB-Engines on the popularity ranking of key-value databases, Redis temporarily ranked first.

  2022-06-01 15:43:45 Views: 252
• 

  Configure mongodb replica set

  Host information: [root@my2 db] # cat / etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.lo

  2022-06-01 15:43:44 Views: 207
• 

  [oracle performance Optimization]-use AWR to locate oracle performance bottlenecks

  About 1 AWR AWR (full name Automatic Workload Repository) is a new feature of Oracle 10g version, which is a performance collection and analysis tool installed with the database. AWR can collect all aspects of the scene during operation.

  2022-06-01 15:43:36 Views: 284
• 

  The problem of redis master-slave replication synchronous data endless cycle

  Redis master-slave replication synchronization data endless cycle problem found phenomenon: recently, there is a question and answer codis a slave library port 6504 has been from time to time, the master-slave delay and slave library can not connect to the alarm, began to suspect that redis backup caused, did not go deep to find the cause, later found that the alarm during the day

  2022-06-01 15:43:35 Views: 201
• 

  Migrating and restoring database in Oracle Database 12.1 [actual combat]

  Platform environment: source OS:Oracle Linux 7.3 source DB:Oracle Database 12.1.0.2 destination OS:Oracle Linux 7.3 destination DB:Oracle Database 12.1.

  2022-06-01 15:43:35 Views: 231
• 

  BBED usage

  BBED is a tool for internal use in oracle. 9iPermy 10g comes with it by default and can be used as long as it is compiled. Let me compile BBED and use it to modify the data: [oracle@Srv02 ~] $cd $ORACLE_HO

  2022-06-01 15:43:35 Views: 285
• 

  Mysql flow control function

  If function: the effect of if else SELECT IF (10 < 5); # if the first expression is true, the second parameter is returned; otherwise, the third # case: SELECT last_name, commi

  2022-06-01 15:43:34 Views: 217
• 

  What if the mysql database can't connect to localhost?

  What if the mysql database cannot connect to localhost? 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. 1. Check whether port 3306 is released by the firewall, and then click Management tools-

  2022-06-01 15:43:20 Views: 256