Database Administrator

Compile and install the PostgreSQL 6.5 database on CentOS 9.3 PrefacePostgreSQL is a free object-relational database server (Database Management System), which is issued under a flexible BSD-style license. It provides an alternative to other

Yii2-Redis using note-Cache I learned about Redis a few days ago, and now I am going to use it on the project. We are currently using the Yii2 framework, in the official website to search for Redis, we found the yii2-redis this extension. After

Use Redis extension in Yii2 Redis is a good Nosql database. Its advantage over Memcached is that it can persist data. To use Redis in Yii2, you must first expand Redis. You can add redis in composer. json. "require": { "php": ">=5.4.0",

Preparations before Datapump data migration In fact, for Datapump migration, if you have participated in XTTS, OGG, Veritas SF, External table increments, and other migration methods, you will find that Datapump is simple and clear. one advantage is

ORA-12545: connection failed because the target host or object does not exist! ORA-12545: connection failed because the target host or object does not exist! The error occurs because the host name is incorrectly configured. Solution: 1. Search

Oralce database Optimization1. Select the most efficient table name sequence (only valid in the rule-based Optimizer ): The Oracle parser processes the table names in the FROM clause in the order FROM right to left. The table written in the FROM

Using simple functions in Oracle This chapter describes the built-in functions of Oracle databases. The function can accept zero or multiple parameters and return an output parameter. Two main types of parameters can be used in Oracle databases:

Adjust the interval between snapshots generated by AWR I. DescriptionThe test environment often performs stress tests on the database. During the test process, the database is stable and burstable, because I am not very professional in the test, so

Oracle Database object_view A view is a very important database object. It is similar to a common table. We can query data from a view. In fact, it is a virtual table built on a table. It does not store real data in the view, but only saves a SELECT

Master-slave Redis configuration in Linux 1. Download redis-2.8.24.tar.gz at http://redis.io/download. 2.decompress redis-2.8.24.tar.gz and install Tar xvf redis-2.8.24.tar.gzMv redis-2.8.24/usr/local/cd/usr/local/redis-2.8.24makeMake install #

Install Hbase database in Ubuntu Server 14.04 I. Environment preparation 1. Ubuntu14.04-server 2. ssh 3. jdk1.6 4、hbase-0.98.19-Hadoop2-bin.tar.gz (http://www.apache.org/dyn/closer.cgi/hbase) Ii. Installation Steps 1. Decompress hbase

Oracle Database object_sequence A sequence is a database object used to automatically generate a unique sequence number. A sequence is a shared object. Multiple users can use the sequence number together.Generally, the sequence is applied to the

Oracle _ transaction control statement A transaction is a logical unit for database operations. A transaction can contain one or more DML (data manipulation language), DDL (Data Definition Language), and DCL (Data Control Language) statement, which

Oracle Database object_synonym A synonym is a database object. It is an alias defined for a database object. The main purpose of synonyms is to simplify the writing of SQL statements. Concepts and types of synonyms Synonyms can be used to define an

Import Oracle Data Using Solr5.3.0 1. Modify solr-data-config. Xml file with the following content: (PS: This article creates an index based on the siteinfo table of the yqfx database in the Oracle database. The site table contains three fields: id,

TABLE_EXISTS_ACTION parameter option of impdp Impdp has a parameter option TABLE_EXISTS_ACTION. The help = y is interpreted: Action to take if imported object already exists.Valid keywords are: APPEND, REPLACE, [SKIP] and TRUNCATE. There is a

Oracle Database object_index Query is the most frequently accessed table. When querying data, few users are willing to query all the data in the table unless they want to process the entire table.In general, you always query a part of the data in

How to remotely back up MySQL binlog Previously, binlogs were backed up and compressed locally, and then sent to a remote server. However, there are still some risks, because log backup is cyclical. If the server goes down and the hard disk is

MongoDB Master/Slave Configuration 1. Create the file mongodb. repo in the/etc/yum. repos. d/directory on the Master/Slave server, which contains the configuration information of the MongoDB repository. The content is as follows: [mongodb]

Measure the test taker's knowledge about Oracle Database Bad blocks. How to check Bad blocks of Oracle databases: 1. Use the DBV (DB File Verify) tool; 2. Use the RMAN (Recovery Manager) tool; DBV (DB File Verify) tool: External commands, physical