Oracle 10 Gb Standby Database real-time application of redo data

Oracle 10 Gb Standby Database real-time application of redo data ------- Physical standby database: Standby redo log needs to be configured for real-time apply; When real-time applications are enabled, log application service directly receives

Innobackupex-based full Backup Recovery

Innobackupex-based full Backup Recovery For Hot Standby MySQL databases, xtrabackup is the choice of most DBA friends. Xtrabackup is embedded with an innobackupex for Hot Standby MySQL database. This article describes the full backup recovery based

Buffer sort in Oracle execution plan

Buffer sort in Oracle execution plan The buffer sort in the Oracle execution plan is not actually sorted. It only loads data to the memory and does not scan tables multiple times. -- Manufacturing data Drop table test purge;Drop table test1

Getting started with Linux: Installing phpMyAdmin on CentOS

Getting started with Linux: Installing phpMyAdmin on CentOS Problem: I am running a MySQL/MariaDB service on CentOS, and I want to use phpMyAdmin to manage databases through network interfaces. What is the best method for installing phpMyAdmin on

MongoDB log Rotation

MongoDB log Rotation MongoDB can use a standard method to rotate logs, that is, to obtain the current log and enable a new one. To achieve this, the mongod instance renames the current log file by adding a UTC (GMT) timestamp at the end of the file

Redis database (list type)

Redis database (list type) List is a linked list structure. The main function is to push, pop, get all values in a range, etc. In the operation, the key can be understood as the name of the linked list. In Redis, the list type is actually a

MariaDB single-host dual-instance master-slave Replication

MariaDB single-host dual-instance master-slave Replication MariaDB single-host dual-instance master-slave Replication MariaDB is actually the same as MySQL, but its name is different. Start ~ In the previous experiment, we installed MariaDB on a

CentOS6.5 install MariaDB10.0.15 compilation and installation and multi-instance Management Configuration

CentOS6.5 install MariaDB10.0.15 compilation and installation and multi-instance Management Configuration CentOS6.5 x86_64 System [Root @ e3 ~] # Wget https://downloads.mariadb.org/interstitial/mariadb-10.0.15/source/mariadb-10.0.15.tar.gz/from/http%

How to Use RMAN Incremental backup to restore data guard log gap)

How to Use RMAN Incremental backup to restore data guard log gap) The minimum scn information of the master database:SQL> col current_scn for 999999999999999SQL> SELECT CURRENT_SCN FROM V $ DATABASE; Select min (fhscn) from x $ kcvfh; Select min (f.

Node where RAC Archive log is written incorrectly

Node where RAC Archive log is written incorrectly Multiple customers have asked several times that archive logs of node2 In the RAC environment are written to the archive path of node1. This problem causes some customers to be unable to read logs

Binary installation of MariaDB5.5.36

Binary installation of MariaDB5.5.36 Binary installation of MariaDB5.5.36 1. Obtain the source code package and decompress it. Make sure mysql-server and mysql of the rpm package are not installed. [Root @ http1 mysql] # rpm-qa mysql [Root @ http1

Redis database (set type and zset type)

Redis database (set type and zset type) 1. set Type Set is a collection of unordered string types. set is implemented through hash table. the time complexity of adding, deleting, and searching is O (1 ), for a set, we can take the Union,

Install Redis in CentOS 6.5

Install Redis in CentOS 6.5 Install Redis in CentOS 6.5 Version: redis-2.8.19.tar.gz Check whether the following dependencies are installed. If not, install them first. Otherwise, an exception occurs. Yum installgcc-c ++ Yum install-y tcl. 1. Obtain

Make HAProxy 1.5 aware of the delay of MySQL Replication

Make HAProxy 1.5 aware of the delay of MySQL Replication In the MySQL world, HAProxy is usually used as a software Load balancer. Peter BOLOs explained in his past emails how to use the percona xtradb cluster (pxc) to set it. Therefore, it only

Error logs recorded during DML Process

Error logs recorded during DML Process When you insert millions of data records, the insertion fails due to several dirty data records. Oracle 10g R2 has a new feature that inserts records that failed to be inserted into another table. SQL> drop

CentOS 6.3 Environment Oracle 11gR2 Database Installation

CentOS 6.3 Environment Oracle 11gR2 Database Installation CentOS 6.3 Environment Oracle 11gR2 Database Installation 1. install necessary OS installation packages We recommend that you install the operating system to the maximum extent, because the

Oracle continuous data processing example

Oracle continuous data processing example The function described in the following section is to have a table in the Oracle database, which stores continuous time records and a tag bit. Now you need to obtain a result set: when the flag bit is 0, the

Monitoring MySQL monitoring transaction hanging (RUNNING) alarm notification in Nagios

Monitoring MySQL monitoring transaction hanging (RUNNING) alarm notification in Nagios Preface:An error occurred while submitting the business alarm order. The page was not responded. After troubleshooting, the transaction was not committed or

Redis database (string and hash type)

Redis database (string and hash type) I. string type String is the simplest type in Redis. A key corresponds to a value. redis string can contain any data object, such as JPG images or serialized objects. The operations on the string type are as

Redis database (Elementary)

Redis database (Elementary) Redis is an open-source non-relational database. It is written in C language and is a key-value storage system. It stores many value types, including string, list ), set, zset, and hash ). For example, we insert a data

Total Pages: 1013 1 .... 307 308 309 310 311 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.