Database Administrator

Silent Installation of Oracle databases on Oracle Linux 7.0 Silent Installation is rarely used, and basically does not require Silent Installation. Xmanager is used to redirect graphics even for text-installed systems. But there is always an

Oracle 10 Gb Standby Database real-time application of redo data ------- Physical standby database: Standby redo log needs to be configured for real-time apply; When real-time applications are enabled, log application service directly receives

Analysis on Redis implementing lock mutex Resource Access Redis is a popular open-source key-value database. At present, ruisi's background architecture adopts a combination of Redis and MySQL on the database layer. Redis is mainly used to store

Make HAProxy 1.5 aware of the delay of MySQL Replication In the MySQL world, HAProxy is usually used as a software Load balancer. Peter BOLOs explained in his past emails how to use the percona xtradb cluster (pxc) to set it. Therefore, it only

Redis database (Elementary) Redis is an open-source non-relational database. It is written in C language and is a key-value storage system. It stores many value types, including string, list ), set, zset, and hash ). For example, we insert a data

Description of deployment uard configurations between heterogeneous platforms and deployment uard configurationsWhen deploying a replicuard, the simplest case is that the configurations of the master and slave nodes are identical. However, it may

Mysql SQL statement (1), mysqlexplain Reference: http://www.2cto.com/database/201307/230048.html Http://blog.csdn.net/zhuxineli/article/details/14455029 Explain is used to analyze how mysql uses indexes to process select statements and connect

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,

Restrictions in Oracle and OracleConstraint type CONSTRAINT_TYPE in Table ALL_CONSTRAINTS:C (check constraint on a table) -- constraints, such as not null, checkP (primary key) -- primary keyU (unique key) -- unique key constraintR (referential

Install MySQL5.6.22 in CentOS-7, centos install mysql5.6 Install MySQL5.6.22 in CentOS7 (Latest Version) Reprinted please indicate the source:Jiq • Chin's technical Blog1. installation environment (1) CentOS version: CentOS-7 View method: [Root @

Max_prepared_stmt_count, maxparametercount An error occurred while migrating data from SqlServer to MySQL. The ole db access interface "MSDASQL" of the link server "192.168.66.53 (ewallet_lxl)" returns the message "[MySQL] [ODBC 5.2 (w) driver]

Plsql developer inserts Chinese garbled characters, plsqldeveloper Address: http://yanwushu.sinaapp.com/plsql-developer-chinese-charactereset/ Solution 1 The oracle character set cannot store Chinese characters. The following statement queries

11. Create and authorize mysql users. 11. mysql 1. Create a user. // Log on to MYSQL@> Mysql-u root-p@> Password// Create a userMysql> insert into mysql. user (Host, User, Password) values ("localhost", "abc", password ("1234 "));// Refresh the

Oracle connection query and oracle connection I have learned inner join and outer join in SQL Server. outer join is divided into left outer join andRight outer join ). In Oracle, the external connection between two or more tables is represented by (+

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.

Mysql optimization practice (explain & Index) and mysql practiceLab environment: 1. SQL tool: Navicat2 and SQL database. Use openstack database as an example. I. mysql index Query Show index from instances Result field

Good habits of database design and use, good habits of Database Design Good habits need to be constantly cultivated and strengthened until they become a habit and then part of their thoughts. Before or after work, I want to read "three character

MySQL self-study (10) -- date functions and mysql self-study date functionsDate and Time Functions (1) functions for obtaining the current date and time CURDATE () and CURRENT_DATE () functions to obtain the current date Select current_date (),

Simple oracle query, simple oracle Data Query uses the SELECT command to extract information from the database table. Syntax structure: simple query SELECT * | column name | expression FROM table name WHERE condition order by column name Syntax

Configure the authentication password for redis and the authentication password for redisRedis Password Configuration1. Configure through the configuration fileThe redis configuration file installed in yum mode is usually in/etc/redis. conf. Open