Database Administrator

Deploy multiple MySQL instances on a [DELL R720] Server Deploy multiple MySQL instances on a [DELL R720] Server I. Prepare for installing mysql 1.1 download the mysql package Mkdir-p/home/xuekun/mysql Cd/home/xuekun/tools/mysql Wgethttp: //

Quickly deploy an Oracle RAC environment using an Oracle VM Template Oracle VM templates are pre-packaged and pre-configured virtual machines. In the communication between enterprise-level customers, I often use "simple, fast, and error-free" to

(Direct file copy)I recently learned how to start Oracle databases, so I created a database for testing in Windows.After porting to Linux, we successfully transplanted Linux to Windows a few days ago. However, many problems may occur when porting

[Mongo] install and use PyMongo, mongopymongoInstall and use PyMongo Here is a simple installation and usage record. First, you must have an available mongo environment, either win or linux environment. Suppose you have some knowledge about mongo

Recently, I need to write a data migration script to migrate data from a single Oracle database to a MySQL Sharding cluster. I just recently learned python and used it to practice it.I quickly completed MySQL and only needed to install a python

11gR2 RAC exclusive mode replace votedisk encounters PROC-26, restore ocr encounters CRS-4000, PROT-35, proc-26crs-4000 Link: http://blog.itpub.net/23135684/viewspace-748816/ The storage data of the 11gR2 RAC system is completely lost. The software

Hive date functions, Hive date functions1. unix timestamp to Time Function Syntax: from_unixtime (bigint unixtime [, string format]) Return Value: string Description: converts a UNIX timestamp (from 00:00:00 UTC to the specified time in seconds) to

SQL Server quickly generates SQL addition, deletion, modification, and query statements, and SQL addition and DeletionAre you still coding to generate SQL statements? Are you still speechless for SQL statements that are sloppy? Are you still

To connect to a remote Oracle database using Toad on the local machine, follow these steps. Step 1: Install the Oracle database Pay attention to the following points when installing the Oracle database: 1) Click setup.exe, the outmost icon of the

The listener. ora, sqlnet. ora, and tnsnames. ora configuration files are stored in the $ ORACLE_HOME \ network \ admin directory. 1. sqlnet. ora ----- is similar to the nsswitch. conf file of linux or other unix. It is used to determine how to find

How to insert special characters in Oracle: & and '(Multiple Solutions) Category: Oracle How to insert special characters in Oracle: & and '(Multiple Solutions) encountered a problem when importing a batch of data to Oracle today: Toad prompts you

 One-network fund settlement analysis system for Guangdong expressway Based on the Data Warehouse Star Model Magenfeng(Guangdong Union Electronic Service Co., Ltd., Guangzhou 510300, China) SummaryThe star mode is a well-known concept in the Data

Change Password:1. For example, if your root user does not have a password and you want to change the password to 123456, the command is:Mysqladmin-u root password 1234562. If your root account has a password (123456), the command to change the

Technical Architecture Design of the data warehouse system Author: Cheng Xiaoxu   Statement] Because the technical solutions described in this article are derived from online production systems, they will not provide complete and detailed technical

The data pump is a server tool, and the exported files are stored on the server where the database is located. Of course, we know that the files can be controlled through directory objects. The directory object has four levels by default. Of course,

A simple example shows Oracle's "selfless" robustness, and the example oracle is selfless. Oracle's strength lies in its ability to always help you choose the right execution plan, even if you give it wrong instructions. Lab: 1. Create a test table:

Use of sqlite3 triggers and sqlite3 triggers The storage of applications in the osx dock is studied ~ In the/Library/Application Support/Dock/next database file with a long name, I have briefly introduced the deletion of the osx launchpad icon. Here

Three lock variables in DB2: DB2_EVALUNCOMMITTED, DB2_SKIPDELETED, and DB2_SKIPINSERTED This article mainly explains how to use the three lock variables DB2_EVALUNCOMMITTED, DB2_SKIPDELETED, and DB2_SKIPINSERTED in DB2. Lab environment:DB2

[MongoDB] Export Import and Export export of data (1), export db1_import In the software development, we usually are faced with a common question of exporting or importing data from database. So in this blog we will together study the specified DDB

Memory Database In traditional database tables, due to the limitation of the physical structure of disks, the structure of tables and indexes is B-Tree, which makes such indexes very weak in the highly concurrent OLTP environment, although there are