NAV: SLTechnology News&Howtos > Database >

• 

  DATAGUARD for Oracle Learning (1) DG Architecture

  The operation principle of DataGuard is very simple: transfer log, application log. The following figure shows that DG's basic architecture log transfer service transfers log data generated by the master library to the slave database. The application service (Apply Service) validates the log data and updates the data files from the library. Master

  2022-06-01 14:34:37 Views: 281
• 

  Mycat simply realizes the separation of reading and writing and the separation of libraries and tables.

  Mycat database read-write separation environment: client 1.13 ↓ mycat middleware 1.11 ↙

  2022-06-01 14:34:37 Views: 280
• 

  Build nodejs, mongodb and Subversion environments

  Nodejs environment 1. Install nodejs to C:\ nodejs https://nodejs.org/dist/v4.4.5/node-v4.4.5-x64.msi2, install plug-ins for nodejs, command line D:\ ol

  2022-06-01 14:34:36 Views: 220
• 

  Centos 7 lamp environment

  1. Install Apacheyum install httpd # according to the prompts, type Y to install systemctl start httpd.service # successfully to start apachesystemctl stop h

  2022-06-01 14:34:36 Views: 251
• 

  Oracle user status query

  # switch to Oracle user su-oracle# login sqlplussqlplus / as sysdba# set display format set pagesize 300 set linesize 300 candidate # query user list

  2022-06-01 14:34:36 Views: 205
• 

  Mysql adds daily table partitions

  1. Create tables and table partitions DROP TABLE zy.time_partition;CREATE TABLE zy.time_partition (TIME DATETIME NOT NULL) ENGINE=

  2022-06-01 14:34:35 Views: 275
• 

  Oracle database cloning

  When installing multiple servers in oracle on linux, you can install multiple clones at a time, which is simple and fast. *

  2022-06-01 14:34:35 Views: 251
• 

  Oracle user creation and permission setting

  Permissions: create sessioncreate tableunlimited tablespaceconnectresourcedba example: # sqlplus / nologSQL > conn / as s

  2022-06-01 14:34:35 Views: 276
• 

  Oracle snake_trian

  DECLARETYPE arr1_tt IS TABLE OF INT INDEX BY PLS_INTEGER;TYPE arr2_tt IS TABLE OF arr1_tt INDEX BY P

  2022-06-01 14:34:35 Views: 226
• 

  Docker mysql data is persisted locally, and the table name is large without distinction.

  Docker MySQL stores the data in the local directory, which is very simple. You only need to map the local directory to the container. 1, plus the-v parameter $docker run-d-e MYSQL_ROOT_PASSWORD=admin-- nam.

  2022-06-01 14:34:34 Views: 242
• 

  Learn about SQL server

  The necessity of using database 1. Structured storage of a large number of data information, convenient for users to effectively retrieve and access. two。 Maintain data consistency, integrity and reduce data redundancy. 3. Meet the requirements of sharing and complete aspects of the application. The basic concept of database 1. A symbolic record of data that describes things.

  2022-06-01 14:34:34 Views: 292
• 

  Optimize it through case study-- dynamic view (v$bh and x$bh)

  Through case study tuning-dynamic views (v$bh and x$bh) v$bh and x$bhv$bh: the usage of data blocks in the data buffer is recorded in great detail, and a record corresponds to a detailed record of a block. V$bh comes from base tables x$bh and x$le

  2022-06-01 14:34:34 Views: 234
• 

  Percona PMM Query Analytics newspaper "No query classes for selected instance and time range" error

  The complete error message is as follows: There is no data for the selected MySQL instance, time range or search query.QAN API error:

  2022-06-01 14:34:34 Views: 278
• 

  Details of mysql backup and recovery

  Why does the preface need to back up data? The type of data backup MySQL backup data backup needs to be considered designing appropriate backup strategy practical exercise using cp for backup using mysqldump+ replication BINARY LOG backup using lvm2 snapshot backup data to make

  2022-06-01 14:34:33 Views: 205
• 

  Activiti awareness and database and plug-in configuration

  Workflow introduction Workflow (Workflow) is to automate the management of business processes through computers. It mainly addresses the process of automating the transmission of documents, information, or tasks among multiple participants in accordance with some predefined rules, in order to achieve an expected business goal, or

  2022-06-01 14:34:32 Views: 265
• 

  UNDO Segment in-depth analysis

  Undo Segment in-depth parsing when undo automatic management, after setting undo_retention, there are four states of undo block. Active: indicates that the transaction that is using the undo has not been committed or rolled back. Inactive: tabl

  2022-06-01 14:34:31 Views: 237
• 

  Single database and multiple instances of mysql master-slave replication practice

  1. Master-slave replication database actual combat environment preparation MySQL master-slave replication practice the requirements for the environment are relatively simple, it can be a single single database multi-instance environment, or it can be between two servers, each server deploys an independent database environment. This paper is based on the environment of stand-alone database and multi-instance.

  2022-06-01 14:34:31 Views: 229
• 

  Unable to start after oracle 11g EM is stopped

  After checking the log and testing, the reason is that emagent cannot be restarted and emctl start dbconsole starts normally, but http://localhost:1158/em/ cannot be accessed. Close oem,emctl stop first.

  2022-06-01 14:34:31 Views: 242
• 

  One-click installation of GitLab and uploading code using Git tools

  First, the introduction of the installation environment Centos 6.7 x8634 2.6.32-573.el6.x86_64 IP:192.168.159.129 # internal test server GitLab version: 9.1.2 package download address:

  2022-06-01 14:34:01 Views: 210
• 

  Installation of MongoDB in window and linux

  1. First of all, go to the official website (http://www.mongodb.org/downloads) to download the appropriate installation package. The latest version is 2.6. The installation package is in zip and msi format. It is recommended to download the zip format. Msi actually enters

  2022-06-01 14:34:00 Views: 219