Database Administrator

Undotbs01.dbf file too large solution Reduce the size of the UNDOTBS01.DBF file in the Oracle directory Log on to Oracle using the sys userMethod 1: reset the tablespace size Run Alter database datafile '/opt/oracle/oradata/res/undotbs01.dbf' RESIZE

Description of synchronization parameters for different databases and tables in MySQL master-slave Replication Description of synchronization parameters for different databases and tables in MySQL master-slave Replication In replication, the

MySQL master database High Availability-Dual-master single-active failover Solution Preface: (PS: Preface was added later when this article was modified.) Some bloggers raised some questions and opinions about this article and paid attention to it,

Configure MySQL Master-Slave replication (Master-Slave) on CentOS) The previous article introduced the installation of MySQL without compiling, which is really convenient. Now let's take a look at how to configure MySQL master-slave replication. For

RMAN backup reports RMAN-06059 Error RMAN backup reported RMAN-06059 error: RMAN-03002: backup plus archivelog command (on 00:08:52) failedRMAN-06059: failed to find the expected archive log, loss of archive log will affect recoverabilityORA-19625:

Solr 5.3 import SQL Server Data I have explained the solr configuration in the previous article. As you can see, I will not talk about it here. The following configuration is done on the premise that solr has been successfully integrated into tomcat.

Introduction to Kingshard MySQL Middleware Functions: MySQL table sharding and a series of MySQL operations such as adding, deleting, modifying, and querying tables. The master-slave architecture of MySQL can be expanded to facilitate distributed

Installing MySQL 5.6.10 package conflict in Linux By default, the Liunx operating system will install lib files such as mysql-libs-5.1.73-5.el6_6.x86_64, which will conflict with the installation file of MySQL5.6.10, the first installation is as

MongoDB backup and recovery (mongorerstore)MongoDB Data Backup In Mongodb, we use the mongodump command to back up MongoDB data. This command can export all data to a specified directory. The mongodump command can be used to specify the exported

Configure MySQL GTID master-slave Replication GTID is a global transaction ID generated based on the original mysql server that has been successfully executed. It is composed of the server ID and transaction ID. This global transaction ID is not

MongoDB Delete document The MongoDB remove () function is used to remove data from the set. You can use the update () function to update MongoDB data. It is a good habit to execute the find () command before executing the remove () function to

IEE Database Installation Wizard RHEL 5 uses an rpm package to directly install the package and configure the data and cache directory. RHEL 6 uses the tar package + configuration file. This article is a wizard for installing IEE on RHEL 6.Upload

Migrate the collection data in MongoDB to the MySQL database 1. Export data on mongodb and write expmongo. sh. The shell script is as follows: #! /Bin/shDatestr = 'date' + % Y-% m-% d''/Usr/local/mongodb/mongodb-linux-x86_64-2.4.4/bin/export-im_user-

Zabbix uses the Orabbix plug-in to monitor Oracle databases (enhanced version) According to some information on the Internet, the installation finally found many problems, so I fixed some problems and recorded them. 1. Install jdk (Orabbix Server) 1.

Use pgpool to achieve high availability of PostgreSQL Pgpool-ii is used to achieve high availability of PG. Based on the stream replication method, two nodes are automatically switched: 1. Single pgpool A. Environment: Pgpool: 192.168.238.129Data1: 1

Oracle Reports ORA-01691 error, single data file size limit problem 1. Problem: an error occurs when the Oracle database synchronizes a large table from another database. ERROR at line 3: ORA-24801: illegal parameter value in OCI lob function ORA-020

TPCC-MySQL Benchmark Test 1. Brief IntroductionThe output result of TPCC-MySQL includes five business logics, which constitute the entire transaction processing process of TPCC-MySQL testing. The details are as follows: New-Order: New Order Payment:

Mongodb installation and basic search operations: Learning and organizing (1), mongodb search **Install and configure MongoDB in windows: **Installation references: http://www.cnblogs.com/jiaxuekai/p/7204716.htmlHttps://jingyan.baidu.com/article/ed1

Comparison of three common Mysql database engines: mysql Database Engine (Click the blue icon on the top to quickly follow it) ISAM: ISAM is a well-defined and time-tested data table management method. It is designed to take into account that the

Processing Method for PostgreSQL database transactions in unknown state, postgresql Processing Method Background Database transactions are atomic operations, either successful or failed. However, from the client perspective, there may be a third