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.

For details, refer to sybase Installation Guide (Chinese version) Adaptive Server Enterprise12.5 Linux/Intel.I have referenced several documents on the Internet. Thank you!(1) Log On As root:Create sybase users and user groups (useradd, groupadd or

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

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

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

In daily DB2 O & M, we often encounter slow execution of Several SQL statements, but the cpu and memory usage of the database server is not high, similar problems are basically caused by locks, sorting, and other reasons. Next we will analyze how to

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.

When using SQL Server, many beginners will encounter the problem that SQL Server Management Studio cannot connect to a remote database instance. The error is described as follows: An error has occurred while establishing a connection to the server. (