Database Administrator

MariaDB master-slave Replication MySQL Replication: NySQL Replication. MySQL Replication adopts asynchronous working mode by default. The replication function of mysql is built in mysql. After it is installed, mysql replication is a basic tool for

Oracle PL/SQL Block PL/SQL block Description: PL/SQL is the abbreviation of Procedure Language & Structured Query Language. It is an extension of standard database languages by Oracle. PL/SQL block Syntax: DeclareBeginExceptionWhen other thenEnd; PL/

11gR2 and 11gR2Minimum version of the database that can be directly upgraded to Oracle 11g Release 2 (11.2) --- direct upgrade Source Database Target Database 9.2.0.8 or higher 11.2.x 10.1.0.5 or higher 11.2.x

Mysql decimal and numeric data types, decimalnumericDECIMAL (M, D) Example: salary DECIMAL (5, 2)In this example, 5 (precision) represents the number of important decimal digits, and 2 (data range (scale) represents the number of digits after the

Xinxing analyzes key-related commands in Redis, and Xinxing analyzes rediskey In Redis, we can also directly operate on keys. The following are common commands: (1) keypattern: It indicates getting all the keys matching pattern. Note that we should

Xinxing analyzes the configuration file in Redis, and Xinxing analyzes redis The main configuration items in Redis are as follows: (1) daemonize yes indicates whether to run in the background. If it is written as yes, it runs in the background. If

In oracle database, a datafile can be dropped, databasedatafile Refer to the mos article:Unable to Drop a Datafile From the Tablespace Using Alter Tablespace Command (Document ID 1050261.1) This datafile cannot be dropped because of any of the

Call the Oracle stored procedure in java, and the javaoracle Stored ProcedureCalling the Oracle stored procedure in java This article describes how to call the stored procedure of Oracle through java. 1. Write the Stored Procedure Create or replace

SQL Optimization-logical Optimization-database constraint rules and semantics optimization, SQL Semantics 1) database integrity ① Entity Integrity (Entity Integrity): yourself A) a link corresponds to an entity set in the real world. -- ER

MySQL Distributed Database Service middleware-Cobar Research 2, mysql middleware-cobar In this article, we will learn how to use the Cobar configuration.Scenario: The database name provided by the system is UserCenter, and there is a table

The. frm. myd. myi file in mysql,. frm. myi When I saw a program in the library management system yesterday, I found that the database files are MYI, frm, and myi files, which are not commonly used. SQL files, which have never been used before,

Poor memory: 22-JAVA database connection pool C3P0, 22-javac3p0 C3P0 is an open-source JDBC connection pool that implements data source and JNDI binding and supports JDBC3 specifications and standard extensions of JDBC2. Currently, open-source

SQL Server extracts data at intervals for Data Sampling. SQL Server Select Ana1, RdDate, RdTime, cast (convert (varchar, RdDate, 112) + ''+ convert (varchar, RdTime, 108) as datetime) as time, t. interval FROM (SELECT Ana1, RdDate, RdTime, datediff

Oracle uses triggers to implement auto-increment columns, and oracle uses triggers Oracle uses triggers to implement auto-increment Columns   Oracle does not have the auto-increment function. mysql and sqlserver use auto_increment and identity () to

Database Concurrent transaction control 1: Summary, Database Concurrent transactions OverviewConcurrency control is a key technology of DBMS.Database operations are performed in transactions.A transaction is a group of mutually dependent operations.

ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated, logarchivedest1Standby down, so restart error, ORA-16032: parameter LOG_ARCHIVE_DEST_3 destination string cannot be translated:1. Reboot error messageSQL> startupORA-160

Ogg _ cascade replication ', ogg ReplicationCascade replication: node1-> node2-> node 3[Oracle @ dominic dump_dir] $ cat/etc/hosts 127.0.0.1 localhost. localdomain localhost4 localhost4.localdomain4: 1 localhost. localdomain localhost6

Install MySQL Enterprise Monitor and mysqlenterprise MySQL Enterprise Monitor is an Enterprise-level monitoring designed specifically for MySQL databases. It can be well integrated with various MySQL features, including: mySQL's key performance

Installation and configuration of MySQL green decompress version, mysql green decompress version The MySQL version used in this example is the MySQL-5.6.17-winx64. [For more information, see http://blog.csdn.net/mahoking] Procedure: 1. Install the

[Shell Command] MySQL cluster global list, mysql Cluster Author: skateTime: 2015/01/19 Global list of MySQL Clusters       Usage:# Monrep-hUsage: monrep [-d dbname]-D Database Cluster name-H Display basic help# For example, if a cluster named