NAV: SLTechnology News&Howtos > Database >

• 

  Introduction to Zabbix installation and configuration

  Zabbix server installation preparation server Ip for 192.168.1.190 username root password yicha.123 prepare the running environment and the corresponding software list: software version Apache httpd-2.2.3My

  2022-06-01 14:32:48 Views: 284
• 

  Detailed steps to create a Postgres-XL cluster

  Recently, the company's business needs, the need to use Postgres-XL cluster, about this part of the knowledge, the network information is not much. After a period of inquiry and various detours, the installation is finally completed. The detailed steps will be fully recorded for reference. And I hope I can help those in need. Let's get started.

  2022-06-01 14:32:47 Views: 275
• 

  PGSQL Master / Slave + keepalived High availability configuration

  Environment description: host and IP:192.168.11.177 master library 192.168.11.180 standby library 192.168.11.210 VIP system: centos7.2PGSQL9.6 master and slave installed configuration completed (refer to my previous blog

  2022-06-01 14:32:47 Views: 203
• 

  Oracle 11g rac enables archive logging and flashback

  1. Check whether archiving is enabled in the database (check whether archiving logs are enabled on the two nodes rac1 and rac2) SQL > archiveloglistSP2-0734: unknown command beginning "archive

  2022-06-01 14:32:17 Views: 290
• 

  Functions commonly used in mysql

  1. IF (expr1,expr2,expr3) function: if expr1 is TRUE, the return value of IF () is expr2;, otherwise the return value is expr3. The return value of IF () is either a numeric value or a string value, depending on where

  2022-06-01 14:32:17 Views: 244
• 

  MySQL5.7 query performance improvement

  1. Subquery 1.1 MySQL5.5mysql > explain extended select id,k,c,pad from sbtest1 where id in (select id from

  2022-06-01 14:32:11 Views: 230
• 

  Optimize it through case study-- SQL Profile

  Tuning it through case study-SQL Profile 1. What is SQL Profile (summary) SQL Profile occupies an important position in performance optimization. This is how SQL Profile:SQL Profile is described in MOS

  2022-06-01 14:32:11 Views: 261
• 

  MongoDB delete data

  1. View the collection show collections2. Add data db.runoob.insertMany ([{'title':'data1','url':' https://blog.51cto.com] to the collection

  2022-06-01 14:31:56 Views: 250
• 

  Solutions to ORA-01157 errors

  The following error occurred during data migration of Oracle 11g database: ORA-01157: cannot identify/lock data file 1-see DBWR trace fileORA-011

  2022-06-01 14:31:55 Views: 225
• 

  Summary of RAC-DG installation

  Configure the main library parameter file: add: * .log _ archive_config='DG_CONFIG= (CWFOL,CWFOLB)'* .log _ archive_dest_1='LOCATION=USE_DB_RE

  2022-06-01 14:31:46 Views: 267
• 

  Using pt-online-schema-change to add an index to a ten million level table online to report an error

  Add index ALTER TABLE `RECORD`add INDEX `IDX_PAY_THIRD_ ID` (`THIRD_ ID`) USING BTREE; statistical table size 5

  2022-06-01 14:31:46 Views: 209
• 

  Three methods of Mysql backup

  The main function of Mysql backup is to solve problems quickly, efficiently and safely in the event of hardware failure, software failure, natural disaster, *, or human misoperation, so as to avoid unnecessary losses. What do you need to back up when Mysql backup? 1. Data to be used 2. Binary log

  2022-06-01 14:31:46 Views: 245
• 

  "Linux Rookie getting started 2" mariadb Service

  Learn to use mariadb database 1.yum search mariadb to query the package you want to install 2.yum install mariadb-server.x86_64-y installation service 3.netstat-ant

  2022-06-01 14:31:46 Views: 234
• 

  Build dataguard by oracle 11gR2

  1. Build environment master library oracle11gR2 backup library oracle11gR2db_name orcl orcldb_unique_name orcl standby239 configuration host file master library: primary

  2022-06-01 14:31:45 Views: 233
• 

  Oracle all tables under this user

  Dropuser DW cascade

  2022-06-01 14:31:31 Views: 219
• 

  Transformation functions and conditional expressions on the basis of SQL (8)

  Data type conversion is divided into: implicit data type conversion display data type conversion implicit data type conversion: in expressions, the Oracle server automatically completes the following conversion FromToVARCHAR2 or CHARNUMBERVARCHAR2 or CHA

  2022-06-01 14:31:31 Views: 230
• 

  Delete / modify nodes in Redis cluster (master, slave) (lab)

  Delete a slave node: # redis-trib.rb del-node 192.168.2.202 e4dc23dc67418bf66c6c63655110612cb9516aff// d

  2022-06-01 14:31:31 Views: 207
• 

  Opening and closing of Oracle Archive

  -- 1. Open archiving [step] a. Consistency shuts down database (shutdown [immediate | transactional | normal]) b. Start to the mount phase (startup mount) c. Switch to

  2022-06-01 14:31:31 Views: 282
• 

  How to realize redis current limit

  How to realize redis current limit? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. There are three ways to realize redis current limit, which are: the first one is based on Redis.

  2022-06-01 14:31:29 Views: 220
• 

  The use of triggers in Database

  What this article shares with you is about the use of triggers in the database. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. Let's take a look at it. The syntax for creating a database trigger is: [CREATE

  2022-06-01 14:31:29 Views: 289