Database Administrator

MySQL MHA configuration FAQ MHA is widely used in MySQL databases. It is compact, easy to use, and powerful. It enables manual master-slave failover Based on the MySQL replication architecture, redirects from the database to the master database, and

An error occurred when connecting to the Oracle database with Navicat: connection to server failed, probable Oracle Net admin error, failedwitherror1 The following error occurs when you use Navicat to connect to the Oracle database: The version of

Mysql study notes 5 (triggers) and mysql Study NotesTrigger is one of mysql database objects. This object is very similar to functions in programming languages and must be declared and executed. However, trigger execution is not called by a program,

Data structure, data structure and AlgorithmBasic concepts of strings String: Used in non-numeric processing, transaction processing, and other fields.Computer hardware: mainly reflects the requirements of numerical calculation.Processing strings is

Percona xtradb cluster installation procedure, perconaxtradb The previous blog compares various mysql cluster solutions. This blog will explain the installation steps of percona xtradb cluster, which is excellent in synchronous replication. First,

Data structure, data structure and AlgorithmProgram = Algorithm + Data Structure Professor Niklaus Wirth proposed:Program = Algorithm + Data StructureThe above formula illustrates the following two problems:(1) algorithms determine how to construct

Data structure, data structure and AlgorithmCyclic linked list Circular Linked List (Circular Linked List): A chain table connected to the beginning and end. Its feature is that the pointer field of the last node points to the head node of the

[IDC reconstruction]-the storage process is a matchmaker, and the reconstruction of the storage process matchmaker The following is what I have seen with my own eyes: Data Center reconstruction handsome guy (Reconstruction for short). I will share

Aerospike C client manual --- query-secondary index management, aerospike ClientSecondary index management The Aerospike C client provides the ability to create and delete secondary indexes in the database. Currently, secondary indexes can be

SQL inserts data from two databases with different ip addresses, and sqlip Simple Example:// Create a linkServerExec sp_addmediaserver 'srv _ lnk ', '', 'sqloledb', 'server name'// Log on to the linkServerExec sp_add1_srvlogin 'srv _ lnk ', 'false',

[LeetCode] Nth Highest Salary, solution report, leetcodenth Question Write a SQL query to get the nth highest salary from the Employee table. Id Salary 1 100 2 200 3 300

Oracle Development Series (iii) exists & not exists usage and comparison with in & not in (10g), oracleexists Note: The following content is suitable for beginners of oracle development, java, and other developers. One exists & in The following

How to thoroughly uninstall mysql in linux1. Check whether mysql is installed before. Run the: yum remove mysql * command to uninstall mysql and related components. Command: rpm-qa | grep-I mysqlAs shown in:

EXtremeDB HA synchronization procedure, extremedb Here is the description of synchronization procedure:1. Masterand replica databases have a ha_sequencer-64bit integer which is initializedby zero at startup. 2. Masterincrements the sequencer at

Summary of Small and Medium-sized ORACLE production tools, oracle practice In daily production, data sources are often diverse. Let's talk about the amount of data in excel today, because many development languages now support exporting data to

Lelead and Lag implementation, sqlserverleadlag We will not talk about version 2012 here, because the version seems to have the lead and lag functions, but I have never tried it. Here we will focus on how to implement it by yourself. 1. Table A

Java: Getting started to mastering-Database: Mongo DB GridFS file system, mongogridfs I. Overview GridFS is a storage mechanism of MongoDB used to store large binary files. Advantages: 1. Using GridFS can

Dell Pcserver with Windows OS, Oracle db error: ORA-8103, pcserverora-8103 Windows operating system Dell Pcserver, Oracle db error: ORA-8103 ORA-8103 using Windows platform and DELL servers (Doc ID 1921533.1) Applies: Oracle Database-Personal

Aerospike C client manual --- user-defined functions-apply UDF to records, aerospikeudfApply UDF to record The API of the Aerospike C client provides aerospike_key_apply () to apply a user-defined function to a record in the database. Before using

Oracle-1-installation, oracle11g installation tutorialI. Environment preparation1.1. DescriptionWorking path/data/hdfs/data1/jianxin/1.2. Software VersionOracle-xe-11.2.0-1.0.x86_64.rpm.zip1.3 modify tmpfs1.3.1. oracle XE provides the minimum