Database Administrator

MongoDB Replica Set troubleshooting 1. Check the status of the Replica Set Use db. runCommand ({"replSetGetStatus": 1}); or rs. status (); 2. Check the replication Delay TimeSource: m1.example.net: 30001SyncedTo: Tue Oct 02 2012 11:33:40 GMT-0400

PLSQL Developer cannot connect 64-bit Oracle 11 GB Solution Preface: PLSQL Developer cannot connect to Oracle Server64bit in two cases. The first case is to install PLSQL on the Oracle Server 64bit database Server, and the second case is to install

ORA-22828 input style or replacement parameter exceeds 32 K size limit The following error is reported during program debugging today: ORA-22828: input pattern or replacement parameters exceed 32 K size limit22828. 00000-"input pattern or

MySQL database trigger) MySQL trigger: monitors a situation and triggers an operation I. Four Elements Trigger time: before/after Location: table Monitoring Operation: insert/update/delete Trigger operation: insert/update/delete   Ii. Create a

Index Rebuild and Rebuild Online details In the Oracle O & M field, two concepts around indexes have been discussed on the Internet. One is the necessity of regular Index reconstruction, and the other is the Rebuild and Rebuild Online discussions.

MariaDB10.0 instance deployment and multi-source replication Configuration 1. Deploy MariaDB10.0.17 1. Download and briefly describe MariaDBCurrently, MariaDB supports multi-source replication of version 10.0. The latest stable version is 10.0.17.

Use Django to clear data in the database Clean up data in the database Problem description: in my system, due to history and various reasons, the data recorded in the table in the database is faulty, with duplicate and incomplete data. Solution:

MySQL Chinese insert error Incorrect string value: Preface: failed to input Chinese characters. Error: Incorrect string value: '\ xCC \ xEC \ xB2 \ xC5', as shown below: Mysql> set names utf8;Query OK, 0 rows affected (0.00 sec) Mysql> insert into t

Simple use of merge commands in Oracle Merge command With this merge, You can execute the inserts and updates operations on a table in an SQL statement at the same time. You can use the meger statement to merge two specified tables. The syntax is as

Basic configuration of Redis master-slave Replication It is easy to configure master-slave replication for Redis and easy to understand. Is the master-slave copy structure to be configured: 1. Description Redis master-slave replication one master

Mysqlbackup restores a specific table and mysqlbackup recovers Mysqlbackup uses TTS to restore a specified table. **************************************** * ********************* 4. restore a specific table ************************************* * ***

Immediate and oracleimmediate for oracle stored proceduresCREATE or REPLACE PROCEDURE UPDATEUSERDATAAuthid Current_UserIsDelsql varchar2 (400 );BEGINFor t in (SELECT * from oracleuser) LOOPBEGINDelsql: = 'delete' | T.C _ USERNAME | '.

ORACLE 11G does not have backup file parameter files on the same machine through rman backup recovery was accidentally deleted data, 11 grman Background: Colleagues accidentally deleted online data, so they need to recover data from the backup. Real

Use tab to automatically complete mysql commands and tab to complete mysql1. Use mysql -- help to view mysql Command ParametersNote:-- Auto-rehash Enable automatic rehashing. One doesn' t need to use'Rehash' to get table and field completion, but

Compile and install MySQL 5.6.23 and centos5.6.23 on CentOS 7 1. Download source code wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.23.tar.gz 2. Extract tar zxvf mysql-5.6.23.tar.gz 3. install necessary packages sudo yum install

Mysql in and mysqlin The following describes the usage of MySQL in: They are followed by a table (record set) after the in keyword and a string set after the in keyword. Let's start with a table. First, describe the structure of the three

HSQL introduction, hsqldbPrefaceWhen writing a test class to the dao layer, we need a test database. Generally, we will build a real test database, but with HSQLDB, it becomes easier.QuestionI. Introduction:Hsql database is a free database written

System restart caused by KILL of rac ocssd process-non-root users can also restart OS and racocssdOCSSD is the most critical process of clusterware. If CSSD is abnormal, the system restarts immediately. in the LINUX test environment of 10.2.0.5/11.2.

Kettle _ error caused by deleting the "shared output table" Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally

HBase1.0.0 source code analysis-Client startup connection process, hbase1.0.0clientWe know that in the process of using HBase, the first thing to do is to get a link with the server, so how does the client link, how does it find the master and