Database Administrator

Slave have equal MySQL Server UUIDs Recently, When I deployed The MySQL master-slave replication architecture, I encountered "Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs

Oracle Database version on RHEL 7 RHEL 7 was available for download in 2014. The following information can be found in the "authentication" section of MOS:12.1.0.2 has passed the authentication on rhel7.12.1.0.1 has not passed the authentication on

After Oracle is upgraded to 11.2.0.4, The NUMA warning is displayed in the alert Log. Note: the articles related to this article are: After upgrading to 11.2.0.4, The NUMA warning is displayed in the alert Log. Translated from mos: NUMA warning

Oracle column commands The Oracle column command can be used to format the column title and data. The syntax of this command is as follows:COL [UMN] [{column | expr} [option...]Column nameOptions specifies one or more options used to format columns

Oracle get command Oracle can use the get command to read file content to the buffer zone,The get command syntax is as follows:Get [file] file_name {list | nolist]File_name indicates an external file, which is included in the SQL * plus buffer.List

Use Innobackupex to quickly build (fix) the MySQL Master/Slave Architecture There are many ways to build MySQL Master/Slave databases. The traditional mysqldump mode is one of the choices of many people. However, this method is not ideal for large

MySQL MHA configuration details MySQL environment: Master: 192.168.202.129: 3306 Slave: 192.168.202.129: 3307,192.168 .202.129: 3307,192.168 .202.130: 3306,192.168 .202.130: 3307,192.168 .202.130: 3308 MariaDB-10.0.13 MHA environment: Manager: 192.16

MySQL and Oracle Database concat () Functions I. Different Function Parameters MySQL supports concatenation of multiple strings: CONCAT (str1, str2 ,...) Oralce only supports concatenation of two strings. To splice multiple strings, you can use

MongoDB achieves regular currentOp capture Problem description: When analyzing performance problems in the production environment, it is often impossible to get started because there is no real-time basis. The author captures db. currentOp () to the

Xinxing analyzes the ordered collection in Redis, and Xinxing analyzes redis The sorted-set in Redis is similar to the set. It is a string set and duplicate members are not allowed to appear in a set. The main difference between an ordered set and a

Rman multisection backup Test 2, rmanmultisection Use section size in the two channels for backup. [Oracle @ rhel63single ~] $ Rman target/Recovery Manager: Release 11.2.0.4.0-Production on Thu Feb 19 01:07:28 2015 Copyright (c) 1982,201 1, Oracle

[Translated from mos] explanation of the MISSING keyword in datafile name, mosdatafile Source:Explanation of MISSING keyword in datafile name (Document ID 1050268.1)Applicable:Oracle Server-Enterprise Edition-Version 7.3.4.0 to 11.2.0.1.0 [Release 7

PL/SQL summary, plsql SummaryI. Basic syntaxThe structure blocks of PL/SQL are as follows:Declare-- Declare variables, types, and cursorsBegin-- The execution part of the program, similar to the main methodException-- Provides a mechanism for

Oracle linesize command, oraclelinesizeYou can use the linesize command to set the number of characters that a row can accommodate. The default value is 80. If the linesize value is small,A row of data in the table may be displayed in multiple rows

Real-Time Report (T + 0) solution using the rundry set computing report, real-time report In report projects, the customer is paying more and more attention to the real-time nature of source data, and hopes to see the latest data in the report.

Perform an experiment where initial is larger than uniform size multiplied by minextents, and summarize the distribution rule of initial extent, minextentsinitial This article is the original article, reproduced please indicate the source:

Reconstruction-multiple methods are used to remove students and reconstruct students When designing the function of discontinuing students, I have read many blogs and think it is appropriate to use the responsibility chain model, we know that when a

SQL Optimization-logical Optimization-non-SPJ optimization, sqlspj 1) group by group Conversion(Not supported by MySQL) ① Move group operations down The GROUPBY operation may greatly reduce the number of relational tuples. If you can group a

Oracle 11g how to clear the execution plan of an SQL statement in the share pool, 11 gpool In the past, if the execution plan was slow due to binding snoop on a 10 Gb database, you wanted to clear the execution plan of an SQL statement and make it

Apsaradb for Redis pipeline and Redispipeline Redis is a typical TCP Service Based on the C/S model. During the communication between the client and the server, the client usually initiates a request first, and the server executes the corresponding