Database Administrator

Install Redis and MongoDB in CentOS 7 The previous article recorded Node. js. This time we talked about installing Redis and MongoDB in CentOS 7, so we basically installed the entire development environment of Node. js.Redis Installing apsaradb for

ORA-28000: the account is locked to check which specific IP address causes Check the default system policy and the account will be locked after 10 consecutive verification errors. SQL> select resource_name, limit from dba_profiles where profile =

Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19)Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19) I. Preparations 1. database environment Operating system version: RedHat 5.8x64Database Version: Oracle 10.2.0.5 x64 RACCluterware: 10.2.0.5Oracle

Compile and install the latest version of Redis Stable Currently, REDIS has been upgraded to 3.0.5 as the most stable version, but many system sources are not updated. Therefore, compile and install REDIS here. Suitable for all systems # Wget# Tar

Install adventure and northwind Sample Database, adventurenorthwind There are a lot of information on AdventureWorks database installation for help on the Internet. You can also find many answers to this question in baidu and google, but some of the

Easy-to-use PL/SQL Developer settings, pldeveloperSome time before the easy-to-use PL/SQL Developer settings, the company trained pl/SQL related knowledge internally. Here I will share my settings that I think are very convenient. 1. When PL/SQL

[Translated from mos] Enable encryption for Redo Transport OF DataGuard, and enable dataguardredo Enable encryption for mongouard's Redo Transport Source:Enabling Encryption for Data Guard Redo Transport (Document ID 749947.1) Applicable:Oracle

Fault case: slave latency is high, and slave latency is Case 1: lvm model. After the slave database is created, the qps of the master database is 2 w and the slave database is more than 6 K. The latency increases slowly from a certain point in time

Mysql error: MySQL server version for the right syntax to use near 'Type = innodb', syntaxinnodb When using SQL statements to create a table at work, mysql reports the following error: You have an error in your SQL syntax; check the manual that

Null and SQLnull in SQL A summary of null in Oracle SQL is as follows:1.1 null The null value is still null. Null is an unallocated, unknown, or not applicable value. Ø null is neither 0 nor a space.  1.1.1 null Value Calculation The result of the

Optimization of SQL massive data query and non-use like processing solutions, data query like 1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.2. Try to avoid

Operation 3: Enable slow query logs for mongodb and mysql, start mongodb from the configuration file, and enable mongodbmysql 1. Start mongodb from the configuration file Create a configuration file:/usr/local/mongodb/etc/mongodb. conf The

MySQL Study-MySQL architecture in-depth analysis, mysql-mysqlMySQL Study-in-depth analysis of MySQL Architecture MySQL Architecture   It consists of connection pool components, Management Service and logging tool components, SQL interface components,

Payment Card Industry Data Security Standard pci dss and oracle database, dssoracle Payment Card Industry Data Security Standard pci dss and oracle database Recently I checked several Oracle database Security options, so I came into use with the

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE, 1175 tried 1 error description 19: 15: 34 call sp_store_insert (90) Error Code: 1175. you are using safe update mode and you tried to update a

Redis configuration details, redis details Web programmer blog: http://blog.csdn.net/thinkercode If it is a professional DBA, many parameters will be added when the instance is started to make the system run very stably, so that a parameter may

SQL query beginner's Guide Reading Notes (4) where clause, beginner's Guide where CHAPTER6 Filtering Your Data This chapter introduces the WHERE clause.   Predicates Comparison, BETWEEN, IN, LIKE, and is null. We'll cover theother two-Quantified

Data structure, data structure and AlgorithmChain Storage Chain storage: stores data elements in a linear table with any group of storage units. Linear table stored in this method is short for Linear Linked List. Any group of storage units of nodes

(17) SQL injection and SQL mode, and 17sql injection mode Overview   SQL injection is used to insert user data into the actual database operating language by using some external interfaces of the database, so as to intrude into the database and even

Oracle job creation example, oracle job example-- 1. Learning jobs in plsql-- Learning job-- Create a tableCreate table test_job (para_date date );Commit;Insert into test_job values (sysdate );Commit; Select * from test_job;-- Establish the storage