Database Administrator

After MySQL 5.7 is installed in rpm mode in CentOS 7, root login cannot be used. Recently, the latest mysql-server 5.7 (mysql57-community-release-el7-7.noarch.rpm) version was installed in CentOS 7 using rpm, and root login was not available after

MySQL Master/Slave Failure Recovery using bin-log When MySQL Master/slave fails, first view the slave database show slave status \ G Remember the pos and binlog files of the bin-log (usually select the last point of the last pos for recovery) or

MySQL batch insert data script MySQL batch insert data script #! /Bin/bashI = 1;MAX_INSERT_ROW_COUNT = $1;While [$ I-le $ MAX_INSERT_ROW_COUNT]DoMysql-uroot-proot dbname-e "insert into tablename (name, age, createTime) values ('Hello $ I ', $ I % 9

Why does HBase need to build an SQL engine layer? The existing SQL solutions are generally not horizontally scalable, so when the data volume changes, it will encounter obstacles. However, with the emergence of NoSQL, it has been greatly mitigated,

MongoDB sharding simple instanceParts Another type of cluster exists in Mongodb, that is, the sharding technology, which can meet the needs of a large increase in MongoDB data volume. When MongoDB stores massive amounts of data, one machine may not

MySQL Tutorial: Build a MySQL Cluster in Linux Install fuse for mysql-cluster-gpl-7.4.6-linux-glibc2.5-i686.tar.gz (http://pan.baidu.com/s/1c1bjxVa) The system is a Linux virtual machine. 2 virtual machines (ensure that the firewall is disabled,

MySQL SQL _mode Mode Modification my. cnf 1. SQL _mode ModeThe mysql database has an environment variable SQL _mode, which defines the SQL syntax and data verification that mysql should support! You can view the SQL _mode used by the current

Win remote ASM instance in Linux I. Windows ASM instances in remote Linux1. Listener files in Linux[Grid @ myrac1 admin] $ cat listener. ora# Listener. ora Network Configuration File:/g01/app/grid/product/11.2.0/grid/network/admin/listener. ora#

Page processing of Neo4j graph data First, we will briefly introduce Neo4j. Neo4j is a high-performance NOSQL graphic database that stores structured data on the network rather than in tables, it is an embedded, disk-based, Java persistence engine

About the field-based fuzzy query method of MongoDB About the field-based fuzzy query method of mongodb Fuzzy query: tname contains a keyword Test' Cd/opt/soft/mongodb/bin ./Mongo -- host 192.168.0.1 -- port 17017 test Db. test_info.find

Oracle 11g system-level trigger to track drop misoperations Preface:The data in a table in the db is always disordered. I guess I 've experienced data synchronization operations such as drop and create, but no one knows where to operate it now,

Set Oracle 11gR2 to start automatically under CentOS6.5 Set Oracle 11gR2 to start automatically under CentOS6.5 1. Modify ORATAB as the root user (set N to Y ): [Root @ ora11gr2 ~] # Vim/etc/oratabMytest:/oracle/product/11.2.0/db_1: Y 2. oracle

Imp/exp Oracle Database Import and Export command Oracle Data Import and Export: imp/expFunction: Oracle Data Import/Export imp/exp is equivalent to oracle data restoration and backup. In most cases, you can use Oracle data import and export to back

MySQL storage engine features and selection suggestions Common storage engines of MySQL official storage engines include Innodb, MyISAM, Memory, Archive, NDB, and BDB. The most famous third parties are TokuDB, Infobright, InnfiniDB, and

MySQL configuration file my. cnf added log parameter file Error MySQL configuration file my. cnf added log parameter file Error Add a line after [mysqld]Log =/tmp/mysql. logThen restart mysql,Shell> service mysql restartThen an error is

MySQL 5.7 cannot be logged on First, MySQL version 5.7 was released. The manager asked me to build LNMP with the latest version. Many problems were encountered during the setup process. Today, I will briefly discuss a problem with MySQL: After the

MySQL5.7.10 installation documentation 1. Install the dependency package Yum-y install gcc-c ++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison 2. Install the boost Library: First, check whether boost has been

Build an environment for Python3.3 accessing Oracle 11gR2 on CentOS6.3 Build an environment for Python3.3 accessing Oracle 11gR2 on CentOS6.3 View the built-in python path and version of CentOS[Root @ oracle11g ~] # Which python/Usr/bin/python[Root @

Upgrade Oracle 11.2.0.1 to 11.2.0.3 [Note] Generally, production databases do not use similar version 1 or R1 such as Oracle 11.2.0.1. 11.2.0.1 is the basic version, this version has more feature updates than the previous version, and feature

Oracle 12c R2 new feature dbca command can create standby Database Since version 12c R2, the dbca command provides the syntax for creating the standby slave database: Syntax: Dbca-silent-plain-gdbName BOS.domain.com-sid BOS1-sysPassword