Database Administrator

Redis master-slave configuration and Sentinel Construction As one of the mainstream nosql database products, redis is widely used. This article describes the master-slave configuration method of redis and how to ensure high availability and

Two MHA switching exceptions (masterha_master_switch line 53) In the process of testing manual failover and online failover, MHA encountered two strange problems, and the test was not successful when calling the IP address, detected dead master xxx

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

MongoDB BASICS (iv) Red Hat Enterprise 6.4x64 install MongDB 3.0 and configure mongodbmongdb Mongodb-org this package is a metadata package. The following four package packages are automatically installed during installation. Mongodb-org-server

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

Mysql Study Notes (single table data record query) and mysql Study NotesQuerying data records refers to obtaining required data records from database objects. Mysql provides various data query methods.1. Simple data record Query Select field1,

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

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',

Redis learning, redisFeatures of Redis master-slave copy After the slave is connected to the master, slave sends a SYNC command to the master. After the master receives the command, whether it is the first connection established during

Database and database LearningData Dependency System Logic Implication definition 6.11 For the relational mode R that satisfies a set of function dependencies F, any of its relational r is true if function dependencies X → Y, (that is, any

Solve and analyze the slow MySQL remote access speed and mysql remote access speedEnvironment Introduction:OS: RHEL5.4MySQL: 5.5.10Exception scenarios:The database has been accessed and used in the Intranet of the data center. A foreign node needs

Materialized View, index view, and function index. DESC is used when an index is created, and desc is materialized. I searched the information for a task assigned by the boss and thought it would be better to summarize it. What if I use it later?

HRegionServer Flush source code analysis, hregionserverflush The Flush operation is the process of saving HBase data to the hard disk. The specific flush flowchart is as follows. This article briefly analyzes the source code of the flush

Mysql imports data to excel, mysqlexcel Create a test data table first Create table users ( Username varchar (40) not null, Password varchar (40) not null) charset = utf8; Insert data Insertinto users values ("admin", "admin "); Insertinto users

PostgreSQL tutorial (12): Role and permission management, postgresql permission management PostgreSQL manages database access permissions through roles. we can regard a role as a database user or a group of database users. Roles can have database

PostgreSQL tutorial (17): client commands (1), postgresql tutorial 0. Password File: Before providing other PostgreSQL client commands, we need to first introduce the password file in PostgreSQL. The reason why this file is described in advance is

Employees Earning More Than Their Managers, employeesearning The Employee table holds all employees including their managers. every employee has an Id, and there is also a column for the manager Id. + ---- + ------- + -------- + ----------- + | Id |