Database Administrator

Configure auto-start for Oracle Database startup Every time the database server is restarted, it is necessary to restart the database listening and instances, especially when the server is powered off and restarted and routinely maintained. Can I

Data Types in MySQL I. char and varchar types The char and varchar types are similar. They are used to store strings, but they are stored differently from the string retrieval method. Char is a fixed-length character type, and varchar is a

Use mysqldump to export a database (table) Mysqldump is used to back up databases or migrate data between different databases. The backup content of mydqldump includes SQL statements used to create and load tables.I. How to Use mysqldump (1) Back up

Oracle-ASM installation tutorial The steps for installing the ASM database are a lot different from those for installing RAC. Therefore, we have successfully installed the database based on the ASM management by modifying the installation document

Two solutions to ORA-30078 errors Recently encountered a ORA-30078 error while trying to create a partition table, prompting "ORA-30078: partition limit must be TIME/timestamp with time zone text", why is it difficult. First, I create a test table

MySQL 5.6.26 restores data through frm & ibd Create A database bkjia on serverRoot (yoon)> show create table bkjia \ G* *************************** 1. row ***************************Table: bkjiaCreate Table: create table 'bkjia '('Id' int (11)

Install MySQL on Ubuntu Server 16.04 and set Remote Access I. Install MySQL on Ubuntu Server 16.04 1. Use the root account Sudo apt-get install mysql-serverApt-get isntall mysql-clientApt-get install libmysqlclient-dev If there is a problem in the

MySQL mysqlpump parallel backup Preface: MySQL 5.7 is a new Database Export method. The official calligraphy is to replace mysqldump with mysqlpump; Mysqldump: the export process is very slow, but it is a single thread. [However, you can also use

Install and configure PostgreSQL in UbuntuI. installation 1. Installation Use the following command to automatically install the latest version. Here, PostgreSQL is 9.5. sudo apt-get install postgresql After the installation is complete, the default

MySQL 5.6 -- dump-slave parameter usage In MySQL 5.5 and later versions, a parameter "dump-slave" is added. With this parameter, we can export data on the slave node to create a new slave to avoid pressure on the master database. The method is as

Oracle graphical and command line installationOracle Installation version description Different Versions of Oracle must be installed on a specific system version.For example, 11.2.0.1.0 of Oracle 11gR2 needs to be installed in CentOS 5.X and RHLE

Install MySQL5.7.13 in CentOS 6.8 using a common binary method Installation environment: CentOS 6.8Objective: To install MySQL5.7.13 using the Generic Binary (Generic Binary) MethodRequired Software: mysql-5.7.13-linux-glibc2.5-x86_64.tar (Please

Steps for upgrading to MySQL 5.6.19 Steps for upgrading to MySQL 5.6.19 Pre-upgrade version check + test table Creation [Root @ localhost ~] # Mysql-uroot-p123456 -- socket =/var/lib/mysql/mysql3307.sock -- port = 3307-e "create database lottery;

CentOS 6.8 compiling and installing MySQL 5.6.23 Installation environment: CentOS 6.8, MySQL 5.6.23I. Preparations before compiling and installing MySQL Install the tools and libraries required for compiling source codeYum-y install gcc-c ++ ncurses-

A small example of how PL/SQL implements the split () method in Java As we all know, Java provides the split () String segmentation method for the String class, so it is easy to split the String into a String array using the specified symbol.

MySQL semi-synchronous replication implementationI. Why do I need semi-synchronous replication? MySQL replication is asynchronous by default. After the Mysql Master Server transfers its Binary Log through the replication thread, the Mysql Master

Install MySQL 5.7 On CentOS 1. Download mysql57-community-release-el6-8.noarch.rpm from mysql Official Website 2. Install the rpm downloaded in step 1 rpm -ivh mysql57-community-release-el6-8.noarch.rpm 3. After the installation is complete, we

Redis cluster deployment document under Ubuntu 15.10 Linux: Ubuntu15.10. (To make the cluster work normally, at least three master nodes are required. here we need to create six redis nodes, three of which are master nodes and three are slave nodes,

Use of MySQL Log and mysqlbinlog Tool View log-related global variables:Mysql> show global variables like '% log %' Modify related variables:1. For a function, use set global xxx = xxx.2. For file operations, you can only modify the configuration

Recovery of RMAN data from different machines is incomplete Source database: Red Hat Enterprise Linux Server release 5.5 (Tikanga) 64bit + Oracle V11.2.0.4.0 + DG + RAC Target Database: Red Hat Enterprise Linux Server release 5.8 (Catthage) 64bit +