Database Administrator

How to install and deploy Cassandra distributed NoSQL Database Apache Cassandra is an open-source Distributed Key-Value storage system. It was initially developed by Facebook to store particularly large data. Cassandra is suitable for real-time

Install mirror E 11g on Solaris 10 iSCSI 64 bit I went to a client yesterday to install the 11g database, and made a record of the entire installation process and encountered problems. Because the customer cannot remotely connect to the server using

Use XtraBackup to perform Online Incremental backup and database restoration for MySQL 1. Introduction to Percona Xtrabackup 1. Xtrabackup bin directory file Introduction 1) innobackupex Innobackupex is a symbolic link of xtrabackup. innobackupex

Etl tool, kettle implementation loop, etl Tool kettle implementation Kettle is an open-source ETL Tool written in java. It can be run on Windows, Linux, and Unix. It does not need to be installed green, and data extraction is efficient and stable.  

IT Ninja Turtles oracle connect by usage review, Ninja Turtles oracle First use the emp table of scott.The emp table has one field: empno (employee ID) and mgr (Superior manager ID)Below are all the data in the table 1 select *from emp

[Architecture, 13] oracle Character Set details, oracle Character Set1. A simple understanding of character sets: tables corresponding to characters and encodings. When the software has a character set, it uses its own character set. If the software

Mysql Performance Check script-mysql Performance Check script #! /Bin/sh# Ocpyang@126.com Export black = '\ 033 [0m'Export boldblack = '\ 033 [1; 0m'Export red = '\ 033 [31m'Export boldred = '\ 033 [1; 31m'Export green = '\ 033 [32m'Export boldgreen

Data room charging system VB (1)-system analysis, charging system vb First, let's answer two questions: 1. What is the charging system for the IDC room "? 2. What should I do with the data room charging system "? My answer: 1. As the name suggests,

[Translated from mos] Does oracle Support Symbolic Links Under rdbms home ?, Does oracle Support Symbolic Links Under rdbms home? Reference Original:Does Oracle support Symbolic Links in the RDBMS home? (Docid 813116.1) Applicable:Oracle

Access to Create a Table SQL statement Create Table to set AUTOINCREMENT for Automatically increasing columns, SQL statement createtable Access Table creation SQL statement Create Table setting AUTOINCREMENT for Automatically increasing Columns SQL

How to Use kettle's official website to find out how to set the carte service, kettlecarte Original Works are from the "Deep Blue blog" blog. Be sure to indicate the source when reprinting. Otherwise, you have the right to pursue legal liability for

Database review 5-security and database review securityDatabase review CH7 Security 7.1 database security Introduction If integrity is a database protection measure for authorized users, security is a database protection measure for unauthorized

When the database needs to recover the media, in order to ensure that the database can smoothly perform the recovery process, restore the database to the current state. All we need to do is verify! What is verification? Of course, it is to verify

SQLite tutorial (III): Introduction to data tables and views, sqlite View 1. Create a data table: The syntax rules and usage of this command are basically the same as those of most relational databases. Therefore, we use examples to demonstrate the

 Note: 1 The experiment environment is the same platform, in the same byte order, in the same version. The directory structure of the source and target machines is the same. 2. You only need to install the oracle database software on the target

I. Relational databases are facing the pressure of data access. Generally, the solution steps take MySQL as an example)1. Master-slave replication for read/write splitting or distributed read; 2. There are many read requests. You can add cache

The issue of unzip when installing oracle database software under hp-ux is hp-uxunzip. When you first install the oracle database under hp-ux, you will encounter the Oracle database software medium (*. zip Format) cannot be decompressed, because

Oracle Core Technology notes (this book is not carefully read, so you need to read it later ~~), Oracle Core TechnologyOracle Core Technology jump to: navigation, search Directory Start 1 2redo and undo 3. Transactions

Install Oracle12cR1 on Oracle Linux 6.5 in VirtualBox, oraclevirtualbox My Oralce Linux 6.5 is running on VirtualBox. Basic settings is 4G memory, 50G hard-disk, auto partition when install OL6.5.   ** Following series of operations need root

1. does the ms SQL Server and SQL Server agent service start and run as domain users. \ administrator users are also allowed) If you log on to the local account, the network function is not available and the following error occurs: the process