Database Administrator

Use Case of MySQL quick backup tool XtraBackup in production environment There are many ways to back up MySQL. The most common method is MySQLdump. Export the database to an SQL file. When restoring, source db. SQL is executed happily. Our friends

Cacti Monitors multiple MySQL instances The Cacti official website provides templates for monitoring MySQL. Only the default port 3306 can be monitored, but the current port is not 3306. How can we monitor it? 1. upload ss_get_mysql_stats.php to

High Availability of MariaDB dual-master N slave replication-Implementation of MMM Architecture 1. MMM OverviewMMM (Master-Master replication manager for Mysql) is a flexible script program for monitoring and failover, manage the configuration of

Unreasonable setting of MAXPIECESIZE and FORMAT causes RMAN backup failure Today, I went to the customer to build the DG. When I created the RMAN backup set, I encountered a problem, causing the backup set to never be generated. Because the customer'

Innobackupex-Based Incremental backup and recovery MySQL Hot Backup (physical backup) can be used with full backup and Incremental backup to reduce the I/O pressure on the database and the occupation of system resources. Incremental backup is based

Database Cluster (1) MySQLCluster entry, cluster mysqlcluster Recently, the company is planning to do ITOO products, so preliminary technical research is essential. This article briefly introduces MySQL Cluster: (1) Overview MySQL cluster is a

Relationship between locks and isolation levels One. net project, occasionally some strange problems, recently made up effort to troubleshoot and found that it is caused by a deadlock, the following is a deadlock situation map tracked using SQL

[ORACLE] processing of oracle string objects, oracle string objects 2.1 char field, varchar2 Field (1) Defining the field length char (10) indicates that the field can contain 10 English characters (regardless of the encoding method, do English

5. Basic Redis commands --- unordered set, redis command --- set1. Each element in the set is unique and has no order.2. Comparison between set and list Set List Storage content Up to 2 ^ 32-1 strings Up to 2 ^ 32-1

Comparison of the two types of SQL statements and comparison of the two types of SQL statementsSUM (p. payable-p. single_price) AS profitCount,M. order_id AS orderId,M. create_time,M. dept_airport_code,M. arrv_airport_code,M. payable AS

Master-slave synchronization for Redis and master-slave for redis Synchronization Why does Redis implement master-slave synchronization? Master-slave synchronization has the following benefits: Partial re-synchronization Redis introduced

ALERT. LOG for ASM Shows "WARNING: failed to online diskgroup resource ora. GI. dg (unable to communica, asmdiskgroup Applies: OracleDatabase-Enterprise Edition-Version 11.2.0.1 to 12.1.0.1 [Release 11.2 to12.1] Informationin this document applies

Formula for calculating the average transaction response time in the Oracle database, and the oracle Response Time Calculation Formula of average transaction response time in Oracle Database   Note: This formula is taken from: eel , p316   Top 5

Nodejs uses the mysql tutorial in xampp, nodejsxampp The following describes how to connect to the mysql database of the local machine through node. js: Var mysql = require ('mysql'); var connection = mysql. createConnection ({host: 'localhost',

Update all mnemonic codes and mnemonic codes Two functions are required: USE [oa erp]GO/***** Object: UserDefinedFunction [dbo]. [f_ch2py] Script Date: 12/31/2014 17:12:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER function [dbo].

Thinking about orcle 11g select count (*) from v $ lock, orcle11g recently, we found that the query by orcle 11g select count (*) from v $ lock is very slow, and I think it is necessary to perform a detailed analysis: select count(*) from v$lock;--

[Oracle] Wide ledba28 open a connection to the RMAN recovery catalog, which contains the RMAN metada, metada You executed the following command in Recovery Manager (RMAN ): RMAN> restore controlfile; Which operation must you perform before this

Innobackupex-Based Incremental backup and recovery MySQL Hot Backup (physical backup) can be used with full backup and Incremental backup to reduce the I/O pressure on the database and the occupation of system resources. Incremental backup is based

Export the database structure in toad to pdm and toadpdm I. SQL statement for using toad to export the database structure: Menu [DataBase] --- [Export] ---- [Generate Schema Script], 2. In the displayed window, the frame is checked by default.

Database mode: database mode Three-Level mode structure: external mode, mode, and internal mode I. Schema) Definition: Also known as the logical mode. It is the logical structure and feature description of all data in the database and is the public