Database Administrator

Compiling and installing Redis in Linux Introduction Redis is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set, and zset) and hash (hash type ). These data types support

CentOS6.5 install MariaDB10.0.15 compilation and installation and multi-instance Management Configuration CentOS6.5 x86_64 System [Root @ e3 ~] # Wget https://downloads.mariadb.org/interstitial/mariadb-10.0.15/source/mariadb-10.0.15.tar.gz/from/http%

Use of Oracle exp/imp Export Import tool-2, expimp Iii. Problems with import tool imp (1) The database object already exists. Generally, tables, sequences, functions/processes, and triggers under the target data should be completely deleted

MySQL connection query and MySQL connectionConnection query 1. Internal link query Inner join uses a comparison operator to compare data in certain columns between tables, and lists the data rows matching the connection conditions in these tables to

Install and configure Mongodb in win7 to start at random.Mongodb in win7 only needs to decompress the package to the corresponding folder, and then add it to the win7 path. Opening it under the CMD command may cause the server to reject it actively,

Win7_32-bit PLSQL connects to the remote database (Oracle is not installed locally), win7_32plsql 1. Tool: Download Oracle Client address: Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html such Select the

Back up Oracle with Netback reports ora-27206 error handling, netbackora-27206 Today, my colleague encountered a problem with database backup. The error message is as follows: channel ch01: starting piece 1 at 2015-01-12:22:06:56RMAN-03009: failure

MySQL backup script based on Innobackupex, innobackupexmysql Innobackupex is part of Xtrabackup, and its essence is to call xtrabackup. The main difference is that Xtrabackup not only supports the innodb engine, but also supports the xtradb engine.

The jdbc encoding is set when java connects to the database. I found that there are a lot of pitfalls on the Internet, and many meanings are incomplete. For example, when jdbc is connected to the mysql database, set the character set encoding.

MongoDB-installation and configuration, MongoDB-installation ConfigurationZookeeper Recently, we formed a team to welcome a new BS project, campus video management, and many people thought about MongodDB when we talked about videos. At that time,

Oracle Partition summary, oraclepartition Table partition http://www.cnblogs.com/ggjucheng/archive/2013/01/03/2843393.html Http://wenku.baidu.com/link? Url =

. Net operations on mssql (backup, restore, get table data, get table field information), mssql Field # Region database management // // restore and restore the database // // Save path /// public bool DataRestore (string FilePath) {string []

9. mysql (linux) read/write splitting, mysqllinux After Mysql master-slave mutual backup, in order to make full use of the two (or more) machines, the necessity of read/write splitting is highlighted. Advantages and disadvantages this is not the

Sort Redis data and redis data Redis-related materials, including the Redis Getting Started Guide, Redis design and implementation, Redis In Action, others' blog posts, etc, I think it is necessary to sort it out. As for how to use commands, I

ALERT. LOG for ASM Shows "WARNING: failed to online diskgroup resource ora. GI. dg (unable to communica, asmdiskgroup Applies: OracleDatabase-Enterprise Edition-Version 11.2.0.1 to 12.1.0.1 [Release 11.2 to12.1] Informationin this document applies

Analysis of h2database source code and h2database Recently I want to take a good look at the principles of the database, download the source code of h2database, and have a good look. Some ideas in this process can be written down for the time being.

Mysql usage summary, mysql SummaryDatabase Management System (DBMS) DBMS, Database Management System Database Management, Simply put: is to manage a dataLarge software. DBMS manages and maintains data, or processes data security and

In Oracle DB 11.2.0.4, SYS. ALL_CONSTRAINTS and SYS. ALL_CONS_COLUMNS are defined, SYS. ALL_CONSTRAINTS is defined as follows: CREATE OR REPLACE VIEW ALL_CONSTRAINTS(owner, constraint_name, constraint_type, table_name, search_condition, r_owner,

[Oracle] export ledba25 a list of files that have not been backed up for three days, export ledba25backed You executed the following command in Recovery Manager (RMAN) aga Inst your Oracle 10g database: RMAN> report need backup days 3; What wocould

Mysql selects the previous and next data records, sorts the data to move up, move down, and top, and mysql next1. The list sorting function needs to be completed! Shows the effect:2 setting ideas Set a rank as the timestamp. By selecting "Move Up",