Database Administrator

MongoDB Data Replication shard I. MongoDB introduction: MongoDB is a high-performance, open-source, and non-pattern document-based database. It is a popular NoSql database. It can be used in many scenarios to replace traditional relational databases

MySQL Slow Query Log) Like most relational databases, log files are an important part of MySQL databases. MySQL has several different log files, such as error log files, binary logs, common logs, and slow query logs. These logs help us locate the

MySQL and MariaDB traditional master-slave cluster configuration The most basic cluster mode for MySQL and MariaDB is the master-slave mode, which is also the most widely used cluster mode for many small and medium-sized enterprises. This cluster is

[Code implementation] prevents SQL injection solution and SQL Injection Source: PHP development learning portal Address: http://www.phpthinking.com/archives/494 SQL injection is a common issue during program development. It is a security

The project team needs to install Oracle on a remote HP minicomputer. The hardware information of the system is as follows: The software information is as follows: 1. Download the correct Oracle Installation version HP-UX can run on HP's own

A big and comprehensive choice between SQL and functions: Who is a more effective SQL ?, More effective SQL Reprinted please indicate the source: jiq •'s technical Blog Note that the Oracle11g database is discussed here. It is not applicable to SQL

Oracle 10g 10.2.0.1 in Oracle Linux 5.4 32Bit RAC installation manual (a touch of Xiangyang), 10.2.0.1 installation manual Oracle 10g 10.2.0.1 installation manual in Oracle Linux 5.4 32Bit rackets (step by step) Http://download.csdn.net/detail/rlhua/

Database Installation Package and upgrade package script tool RedGate usage introduction, installation package redgate This log records the design of the database installation package I learned at the company. I have encountered some problems in my

I. Mark data Log On with the scott user and set the tag data SQL> select table_name from user_tables; TABLE_NAME ------------------------------ DEPT EMP BONUS SALGRADE EMP_BAK Creates a backup table emp_bak for the emp table. Ii. Back up the

MySQL entry, mysql entry classic This chapter describes the Relational Database Management System (RDBMS) of MySQL and the Structured Query Language (SQL) used by MySQL ). The basic terms and concepts that should be mastered are listed, and the

Case statements and case expressions are an important part of plsql Process Control. Although they are easy to use, they are easy to confuse. This article describes the case statement and case expression, and provides a demonstration to better

Postgresql database import and export, postgresql Import and ExportExport a remote database 1. Export the threshold table structure and data to the file threshold. SQL from the database monitor on the remote database IP Address: pg_dump -t threshold

SQLite tutorial (10): Memory Database and temporary database, sqlite tutorial I. Memory Database: In SQLite, databases are usually stored in disk files. However, in some cases, we can keep the database in the memory. The most common method is to

When a blocking txn id for DDL wait event occurs on Oracle 11gR2, 11gr2txn This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/44726875   In a recent case (oracle db of version 1

When mysql is installed in windows and linux, the following error occurs: mysql 1045. In the past, mysql was not installed in windows, but some problems occurred during installation in linux. The 1045 error also occurred during windows Installation

Windows 11gR2 installation error: "PRKN-1019: Failed to create directory", 11gr2prkn-1019 Source:11gR2 Installation on Windows fails with "PRKN-1019: Failed to create directory" (Document ID 1669683.1) Applicable:Oracle Database-Enterprise

Database System check before holidays and database check before holidays This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/43761361 1. If the Operating System Log reports an

Terminating the instance due to error 481 causes the ASM to fail to start. terminatingasm1. symptom description When a RAC database is accidentally shut DOWN, the first node starts normally, but the second node cannot start ASM and CRS resources.2.

Install and configure the hadoop plug-in myeclipse and eclipse in windows/Linux, and myeclipsehadoop I recently want to write a test program MaxMapperTemper on windows, and there is no server around, so I want to configure it on windows 7. Succeeded.

T-SQL time operations (dateadd, datediff, datepart, datename), datepartdatename -- 1. current System Date and Time select getdate () -- 09:27:27. 277--2. the Time Operation dateadd returns the new datetime value dateadd (datepart, number, date)