Database Administrator

OS X compilation and installation of MariaDB The MariaDB database management system is a branch of MySQL and is mainly maintained by the open-source community. The purpose of using GPL to authorize MariaDB is to be fully compatible with MySQL,

Asp.net mvc implements distributed cluster sharing Session with Redis 1. During the past two days, we have studied the distributed session issue in Redis. All the information we are looking for online is ServiceStack. redis, but when performing a

Oracle TDE transparent data encryption technology From ORALE 10GR2, Transparent Data Encryption technology (TDE) emerged ). TDE is used to encrypt data. Generally, the application logic executed by SQL statements does not need to be changed and can

Replication_Error: Relay log write failure: cocould not queue event from master, eventqueue Mysql Version: 5.6.16 OS Version: CentOS release 6.4 (Final) Replication: Master-Master Just now I suddenly found that the DB Master1 (currently read/

HBase compact analysis and HBasecompact Analysis HBase is a distributed NoSQL database based on the LSM tree storage model. Compared with the common B + tree, LSM trees can achieve high random write performance while maintaining reliable random read

In oracle, how does one obtain the local IP address and the domain name based on the IP address ?, Oracleip----- Resolve the ip addressSQL> select utl_inaddr.get_host_address ('Google. com') from dual;UTL_INADDR.GET_HOST_ADDRESS ('Google. com ')-----

MySQL-5.6.25 database installation-free configuration, mysql-5.6.25 installation-free Recently, when I was in contact with the MySql database and started the installation, I was always prompted that the configuration file could not be written during

Beckham _ mysql database backup and recovery, _ mysql Database BackupMysql database backup and recoveryBrief:I. Database Backup2. database recoveryI. Database Backup 1. Simple backup Description: Incremental backup and overall backup during system

Differences between sedna xquery in windows and Linux, sedna xquery The source uses the example of yesterday to load book. xml into the collection named novel in the books database. The Call Of WildJack London32.5$2015-7-6Wuthering HeightsEmily

New Feature of oracle11g-Adaptive Cursor Sharing (ACS) and oracle11gadaptive 1. ACS Overview Oracle Database 11g provides the Adaptive Cursor Sharing (ACS) function to overcome the possibility of Sharing a Cursor that should not be shared in the

MySQL transaction traps and art, mysql transaction traps In the previous article "MySQL transactions and why cannot I imitate transactions in PHP", the author elaborated on the advantages of transactions and introduced some simple SQL commands to

One of the Solaris 10 ip address change references, solarisip How to Change hostname and/or IP Address Without Running sys-unconfig-Solaris 10 and below [Video] (Doc ID 1005908.1) This article is not translated. The full text is reprinted:Applies to:

Solaris 10 ip Address Change reference document 2, solarisipRefer to: Cannot change IP address of Solaris [TM] 10 host (Doc ID 1007942.1). This article will not be translated.SymptomsChanging the IP address in/etc/hosts (linked to/etc/inet/hosts)

Is not null and! in SQL! = NULL difference, sqlnull These two methods are often used: is not null and! = NULL. We often encounter database conditions! = NULL, but the returned result is a NULL set. In fact, the difference is not fully understood. By

SQL Script for read information from a csv file in FTP Server, scriptcsv DECLARE w_file_path VARCHAR2(4000) := 'XXIF_INPUT'; --all_directories.directory_name w_file_name VARCHAR2(4000) := 'lcytest001.csv'; --The file name w_file_exists

Connect to the MySQL database using JDBC-Typical Case Analysis (7)-insert employee information in batches, jdbcmysql Reprinted Please note:Zhang Qi's CSDN blog-blog channel-CSDN. NET Problem: Insert 100 pieces of data into the Emp table in batches.

SQL statements Delete duplicate records and retain only one record. Copy codeThe Code is as follows:Delete WeiBoTopics where Id in (select max (Id) from WeiBoTopics group by WeiBoId, Title having COUNT (*)> 1 ); SQL: delete duplicate data. Only one

The ORA-00354 caused by a read-only rhel5.8 File System: upt redo log block header, An rhel5.8 file system read-only caused by ORA-00354: upt redo log block header Wed Jun 03 03:31:24 CST 2015 Thread 1 advanced to log sequence 396 (LGWR switch)

Tinkerpop (1) graph Database console survey, tinkerpopconsole The original Article connection: http://blog.csdn.net/freewebsys/article/details/46348975 reproduced please indicate the source!1. About graph database Tinkerpop is a project under the

Install and use mongodb 1. Install and start MongoDB Widndows and linux are basically the same 1. Download the database, Mongodb-linux-x86_64-ubuntu1404-3.0.3.tgz: linux 2. decompress the file and place it in a proper location. Tar-vxf mongodb-linux-