Database Administrator

Solve the socket error when XtraBackup is backed up When XtraBackup is used for the uat database created by the company today, an error is reported. Sort the solution and make a note: Server

Restoration of corrupted Oracle database file blocks Data Recovery Fault Description: When Oracle database is enabled, the error "system01.dbf requires more recovery to maintain consistency and the database cannot be opened" is reported ".

Use the FILTER, COMPUTE, and sqlexec commands in GoldenGate. This article mainly introduces the usage of some filtering or computing functions in OGG and the basic usage of sqlexec. SQLPREDICATE When initializing with OGG, you can add this parameter

MySQL semi-synchronous replication practices Semi-synchronous ReplicationMySQL master-slave replication only supports asynchronous replication before MySQL 5.5. That is to say, after the master database executes some transactions, no matter the

Oracle password expired the password has expired Solution Oracle encountered the password has expired problem. Today, it suddenly found that the project could not be accessed. If it could not be used, it could not be accessed. This problem was

MongoDB replica set: installation and deployment PreparationsSoftware Environment OS: Oracle Linux 6.5 MongoDB: mongodb3.2.3   Deployment Architecture Three servers are simulated. 10.1.5.123: 28001 master node From node 10.1.5.123: 28002 10.1.5.123:

MongoDB Delete document The MongoDB remove () function is used to remove data from the set. You can use the update () function to update MongoDB data. It is a good habit to execute the find () command before executing the remove () function to

The MySQL database of Ubuntu 15.04 allows remote connection to Toad. I installed Ubuntu 15.04 IN THE vmwarevm. mysql service can be enabled. However, when Toad is used for remote connection, the connection fails and an error message is displayed.

MySQL new features-mysql_config_editor encryption algorithm and Decryption Implementation Mysql_config_editor adopts aes ecb encryption. The ECB encryption of AES is usually block encryption. to encrypt data that exceeds the block size, the padding

Install MySQL 5.6.26 source code MySQL 5.6.26 source code installation package and cmake installation package link: http://pan.baidu.com/s/1eRsF4noOperating system version: CentOS release 6.3 (Final)Installation Process: (remember to mount the image

MySQL Tutorial: About the checkpoint Mechanism I. Introduction Think about this scenario: If the redo log can be infinitely increased and the buffer pool is large enough, you do not need to refresh the new version of the page in the buffer pool to

MongoDB 3.2 WiredTiger storage engine performance test MongoDB 3.2 was recently released. It uses WiredTiger as its default storage engine. Over the past five years, MongoDB has developed rapidly from its birth to its popularity. MongoDB 3.0 began

MySQL multi-instance Configuration Lab environment: RHEL6.4 for minimal installation, mysql installation package for general binary installation package, version for mysql-5.6.26 1. Create a mysql user # Useradd-M-s/sbin/nologin mysql # Yum-y

Covering indexes of MySQL SQL optimization and optimizing indexes of mysqlsql Content Overview Using the primary index to improve SQL query efficiency is a frequently used technique, but sometimes the execution plan provided by MySQL is completely

Python basics 6: formatting characters, colors, and python Basics Character formatting: 1.% placeholder, % s, % d, % 2. Use format. The format is easy to use. It can be centered, %, binary, and character-filling; 1. Use Case of % Tp1 = "I am % s" %

Detailed explanation of adding keywords in PostgreSQL syntax, detailed explanation of postgresql Add keywords in PostgreSQL syntax When PostgreSQL's background process Postgres receives the query statement, it first passes it to the query analysis

Processing Method for PostgreSQL database transactions in unknown state, postgresql Processing Method Background Database transactions are atomic operations, either successful or failed. However, from the client perspective, there may be a third

What are the types and features of database indexes? It effectively optimizes the VPS performance and increases the running speed of the VPS server. In addition to configuring the WEB Server properly, we need to be able to optimize our website

Lesson 5 MongoDB Data Query (II): mongodb Data Query1. Course outlineThis course continues to explain MongoDB Data Query related content, including MongoDB cursor, fuzzy query, and use of findAndModify functions. 1. MongoDB cursor 2. fuzzy query 3.

Beckham _ redis hash type learning, Beckham _ redishash type Redis Hash type 1. View hash commands Ii. Detailed description of operating hash commands   1. View hash commands 1. Enter help @ hash 127.0.0.1: 6379> help @ hash HDEL key field [field...]