Database Administrator

How to install MariaDB 10 on CentOS 7 and related configurations How to install MariaDB 10 on CentOS 7 and related configurations Step 1: Add MariaDB yum Repository Add the MariaDB yum configuration file MariaDB. repo in the/etc/YUM. repos.

Install Percona Server in rpm package Percona XtraDBIt is an enhanced version of the InnoDB Storage engine and is designed to better use and update the performance of computer hardware systems. It also contains some new features in high-performance

Install MongoDB and PHP MongoDB Driver in Ubuntu 14.04 Description MongoDB is a very famous NOSQL database. The following is the installation of MongoDB in Ubuntu 14.04, as well as the configuration for PHP (driver Installation, etc.). This method

Install the oracle client in linux and the linuxoracle Client 1. Prepare the required installation

Db2 database commands This article summarizes commonly used DB2 operation commands and shares them with you. For friends who use db2, refer. The DB2 database management Client no longer has a control center since v9.7, but uses the Data Studio

How to obtain mysql help information and mysql help information When a mysql-related fault occurs in the development or test environment, most of my friends may post on the Forum and discuss the problem with the QQ group. This method is one of the

Starting MySQL... The server quit without updating PID file [failed] lib/mysql/localhost. localdomain. pid)., localhost After restarting the server, the following error is reported: Starting MySQL... The server quit without updating PID file [failed]

To put it a little bit, pl/SQL developer needs to install the local Oracle client to connect to remote oracle before using the client configuration. Due to the bloated client, oracle now provides green and small solutions. The following is a

PL/SQL single-row functions and group functions A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided

When the SQL database is restored, the structure of the media cluster is incorrect, and SQL Server cannot process one of the solutions for this media cluster ., Sqlserver Problem: SQL Server cannot process the media cluster because the structure of

Key-Value Pair design in Redis and Redis key-Value Design The rich data structure makes redis design very interesting. Unlike relational databases, DEV and DBA need to communicate in depth, and review does not require DBA participation for each row

Kaggle Data Mining -- Take Titanic as an example to introduce the general steps of data processing, kaggletitanic Titanic is a just for fun question on kaggle, there is no bonus, but the data is neat, it is best to practice it. This article uses

The AWR import failed today and damaged the awr of the database. It can only be rebuilt. After reconstruction, an error is reported in awr. SYS @ hcndb> beginDbms_workload_repository.modify_snapshot_settings (3 interval => 30,4 retention => 14*24*605

Oracle rman backup and RestorationRMAN supports Incremental Backup: databases, tablespaces, and data files.Only used blocks can be backed up as backup setIng between tablespaces and data files: dba_data_files/v $ datafile_headerIn noarchivelog mode,

Then I went to the Internet to search for "How to Write website SEO optimization solutions, online seoThis time is part of the Website planning stage, website positioning, website layout, and keyword selection.First, you need to determine what kind

Expdp when encountering ORA-31693 & ORA-00922, expdpora-31693Expdp ORA-31693 & ORA-00922The following error is reported when executing expdp:ORA-31693: Table data object "HQ_X1". "B3901_P" failed to load/unload and is being skipped due to error:ORA-0

Environment:Source Server:VM7.14 rhel5.5-32 Oracle 11.2.0.0g172.16.3.202Target ServerVM7.14 rhel5.5-32 oracle 11.2.0.0g172.16.3.204 Source Server 1. Add verification tables and data to the database: [Oracle @ ebs01 ~] $ Sqlplus "/as sysdba" SQL *

MongoDB has been widely used as a NoSQL Database in recent years. More and more enterprises are trying to use MongoDB instead of the original Database. MongoDB also performs well in clusters, sharding, and replication. I will introduce various

PostgreSQL tutorial (6): Functions and operators (2), postgresql Operators 6. Pattern Matching: PostgreSQL provides three methods for implementing pattern matching: SQL LIKE operator, closer SIMILAR TO operator, and POSIX-style regular expression.1.

BKJIA exclusive Article: First of all, this article is not a detailed list of new features of DB2 9.7. I only list a list that is very important to DBAs or developers. Online solution Modification Please refer to Burt's article on online solution