Database Administrator

Implement ACFS replication on Oracle 12C Environment: qc550705 & qc550707, AIX6.1 + 12c RAC Primary FS: qc550705:/acfs3 Standby FS: qc550707:/acfsstd1 Prerequisites: the available space of primary FS must be equal to the space in use. Follow these

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

DB2 tablespace redirection recovery database practice DB2's backup recovery is a bit pitfall. When the path settings of the source and target systems are different, manual redirection recovery is required. This article is a summary process after my

Kettle variables and examples of custom java code, kettlejava1 kettle. properties parameter configuration data source connection and FTP connection The configuration of the database connection FTP in the test environment and production environment

Hive programming guide-employees table data definition and programming guide-employees There is an employees table in the hive programming guide. The default Delimiter is complicated and cannot be edited easily (the control character ^ A edited by

Database review 8 -- concurrency, database review 8Database review CH15 concurrency 15.1 concurrency issues The I (Isolation, independent) of the ACID nature of the transaction, and the concurrent transactions are transparent. The interspersed

Navicat premium usage-navicat connects to the MySQL database, navicatmysql Recently, I was studying navicat premium, a third-party database management software. During my internship, I used this software to call the database on the server. However,

SQL Application and Development: (9) Improving efficiency indexes and SQL Indexes In a database, an index is a special object. It is a database structure that can accelerate data retrieval. It can quickly find the desired content from a large amount

Mysql workbench table creation PK, NN, UQ, BIN, UN, ZF, AI, workbenchuq[Intrinsic column flags] (basic field type identifier)-PK: primary key (column is part of a pk) primary key-NN: not null (column is nullable) non-null-UQ: unique (column is part

MySQL statistics for the past 12 months (including this month), mysql this month1. Problems We need to collect statistics for the past 12 months. For example, we need to collect statistics from. In the past 12 months, if there is no data for this

MySQL learning notes _ overview of MySQL database management system, learning notes _ learn MySQLZookeeper 1. MySQL Architecture C/S: client/server Architecture MySQL DBMS (Data Bank Management System): Database Management System Client server --->

The Excel file at the end of the SSIS export date, And the excel file at the end of the ssis Export When you use the ETL Tool to regularly export data documents in Excel format, it is sometimes required that the exported file name end with the date

(15) mysql triggers and 15mysql triggers Overview A trigger, as its name implies, executes a program when something (event) occurs. Triggers have four main elements:Monitored location (table_name),Monitoring event (insert/update/delete),Trigger time

Greenplum + Hadoop learning notes-11-distributed database storage and query processing, hadoop-11- 3. 1. Distributed Storage Greenplum is a distributed database system. Therefore, all its business data is physically stored in the database of all

A simple database design example and a simple database design example An example of database design in a simple management system, including design tables, ergraphs, modeling, and scripts. ++ ++ ++ Project information Project Name:Book

Introduction to basic concepts and terms of data structures and algorithms, and introduction to data structures and algorithms In order to get a "common language" with everyone, some concepts and terms are given definite meanings. 1. data: a

Path to mathematics-sas memo (6), path to mathematics-sas memo Connect external data Connect to database type options  All content of this blog is original, if reproduced please indicate the source http://blog.csdn.net/myhaspl/ Connection

Install the MongoDB driver in PHP and the phpmongodb driver. Reference: http://docs.mongodb.org/ecosystem/drivers/php/ Method 1: Install with PECL # Pecl install mongo Enter "no" in the displayed dialog box" After installation, the system prompts

SysBase FAQ [set character set] And sysbase FAQ 1) character encoding problems:(2402) Error converting characters into server's character set, Some character9s) cocould not be conver[Mainly causes insert and drop exceptions] Perform encoding

How to completely uninstall the oracle 11g Client 1. Disable oracle service: Go to computer management. In the service, find all services starting with oracle, right-click and choose stop. 2. In the Start Menu, find the Universal Installer, run