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

Oracle 11.2.0.2 solve INS-35354 when RAC is installed When installing an Oracle 11.2.0.2 RAC database today, the INS-35354 problem occurs: Because the GI of 11.2.0.2 has been successfully installed, and all the status of the Cluster is normal, this

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

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

SQL statement optimization: optimization of JOIN, LEFT JOIN and RIGHT JOIN statements; sqljoin In database applications, we often need to perform multi-table queries on the database. However, when the data volume is large, multi-table queries have a

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

Full process of installing MySQL 11.04 through apt in Ubuntu 5.1: Read: MySQL 5.5.11 compiling and Installation notes in Linux (complete installation tutorial) compile and install MySQL dual-instance in Ubuntu and configure master-slave replication

Problem description In the production database, the data of one table is 1 billion level, and that of the other table is 10 billion level. The data of other tables is also quite large. I didn't know that these tables had such a large amount of data

Redhat 6.2 installation of the Oracle 11g client and Analysis of problems encountered, oracle11gOracle 11.2.0.1.0 client (32 bit) was installed on Redhat6.2 (64 bit) yesterday. The following are some problems encountered during installation and the

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

 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

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