Database Administrator

Redis cluster deployment document under Ubuntu 15.10 Linux: Ubuntu15.10. (To make the cluster work normally, at least three master nodes are required. here we need to create six redis nodes, three of which are master nodes and three are slave nodes,

Recovery of RMAN data from different machines is incomplete Source database: Red Hat Enterprise Linux Server release 5.5 (Tikanga) 64bit + Oracle V11.2.0.4.0 + DG + RAC Target Database: Red Hat Enterprise Linux Server release 5.8 (Catthage) 64bit +

Preparations before Datapump data migration In fact, for Datapump migration, if you have participated in XTTS, OGG, Veritas SF, External table increments, and other migration methods, you will find that Datapump is simple and clear. one advantage is

Oralce database Optimization1. Select the most efficient table name sequence (only valid in the rule-based Optimizer ): The Oracle parser processes the table names in the FROM clause in the order FROM right to left. The table written in the FROM

Install Hbase database in Ubuntu Server 14.04 I. Environment preparation 1. Ubuntu14.04-server 2. ssh 3. jdk1.6 4、hbase-0.98.19-Hadoop2-bin.tar.gz (http://www.apache.org/dyn/closer.cgi/hbase) Ii. Installation Steps 1. Decompress hbase

Compile and install MySQL 5.6.16 in CentOS 6.5 Check: uninstall the original MySQL Because MySQL databases are too popular on Linux, the mainstream Linux system versions currently downloaded are basically integrated with MySQL databases, run the

Measure the test taker's knowledge about Oracle Database Bad blocks. How to check Bad blocks of Oracle databases: 1. Use the DBV (DB File Verify) tool; 2. Use the RMAN (Recovery Manager) tool; DBV (DB File Verify) tool: External commands, physical

MySQL master-slave replication interrupt error code = 1217 error resolved MySQL master-slave replication is interrupted and the Error "error on master: message (format) = 'could not delete or update a parent row: a foreign key constraint fails

How to view the content in the Oracle11g Control File A Control File is one of Oracle physical files. It records the database name, data File location, and other information. The importance of the control file is that the database will go down once

DataGuard how to transmit Redo to Standby DataGuard transfers redo to standby and then applies the redo on standby to ensure data consistency between the two.The lgwr process is used to transmit redo logs. In the lgwr transfer mode, the lgwr process

MySQL 5.6 quickly locates unreasonable Indexes # If CARDINALITY/TABLE_ROWS is less than 10% (experience value), it indicates a high data repetition rate. Generally, you need to consider whether it is necessary to create this index.###################

Python scripts for migrating MySQL Data to MongoDB MongoDB is a document database with a natural advantage in storing small files. As the business requirements change, you need to import the Row Records in the online MySQL database to the document

How to efficiently write large amounts of data to Redis Recently, a buddy asked in the Group how to quickly import these IP addresses to Redis when there is a log containing IP addresses (one row per row. I initially recommended the Shell + redis

How to configure MySQL5.6 Master-Slave in Linux The installation of MySQL is very simple compared with that of Oracle. I personally think it is closer to the installation configuration of TimesTen, and the configuration of the Master-Slave or Master-

Oracle Database hang instance analysis Symptom: Neither common users nor sysdba can log on, resulting in service interruption. Analysis process: 1. Do hanganalyze and systemstate dump first $ Sqlplus-prelim "/as sysdba" SQL> oradebug setmypid

[PL/SQL series] use dynamic SQL for Oracle stored procedures I believe everyone knows about the Oracle stored procedure. The following describes how to use dynamic SQL in the Oracle stored procedure. I hope this will help you. Create or replace

MySQL cross-platform (Windows, Linux, Mac) use and Installation MySQL is actually a cross-platform lightweight database, which is usually used for development. Writing programs may require cross-platform development. Next I will introduce how to use

MySQL5.5.32 compilation and Installation MySQL IntroductionMySQL is a relational database management system developed by MySQL AB in Sweden. It is currently a subsidiary of Oracle. MySQL is the most popular Relational Database Management System. In

ORA-00392 ORA-00312 log clearing fault Recently encountered a ORA-00392 after restoring the Oracle database open: log 3 of thread 1 is being cleared, operation not allowed, its literal meaning is that the log file is being cleared, operation is not

CentOS 6.5 installation of Redis and startup script I. Download and install Redis in CentOS 6.5 1. Download the source code, decompress it, and compile the source code. # Wget http://download.redis.io/releases/redis-2.8.3.tar.gz# Tar xzf redis-2.8.3.