Database Administrator

In Linux, the configuration of MySQL remote access settings is described a lot on the Internet, but the actual operation is still a lot of trouble, record it (Attention should be paid to the red area.). The first step is the same as configuring

The master-slave synchronization of mysql fails. the following error is reported in the log:120309 18:39:23 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004 'at position 2207467, relay log'./mysqld-relay-bin.000011'

Stored Procedures and functions A subroutine stored in a database for calls by all user programs is called a stored procedure and a stored function. Create a stored procedure: UseCREATE PROCEDURECommand to create a stored procedure and a stored

To count which users are logging on to the database and other purposes, you need to record the information about the database logon and the information about failed attempts to log on to the database, which of the following triggers can be

The configuration of ASM in Oracle RAC can be implemented in two ways: raw and asmlib. Raw is recommended for actual maintenance. There are two ways to use raw: multipath and UDEV. On the RedHat platform, refer: Redhat 5.4 + ASM + RAW + Oracle 10g

Mysql recursive sorting Query Note: producttype sorting table, producttype. Ptype parent node, producttype. Id Primary Key, showTreeNodes (IN rootid INT) function. The parameter is of the starting type. Drop procedure if exists showTreeNodes;

1. Install SQLite3 Sudo apt-get install sqlite3 2. Install the Toolkit required for Sqlite3 Compilation Install the Toolkit if necessary. It is just for the sake of experience. You can skip the installation. This item is optional. Apt-get

In Linux, allow external ip addresses to access your MySQL database: 1: Set the mysql configuration file /Etc/mysql/my. cnf Find bind-address = 127.0.0.1 and comment it out; // This will no longer allow local access only; Restart mysql:/etc/init.

Oracle SQL Developer 3.1.07.42 is installed in Linux Mint 12 (see). It feels good to connect Oracle, Mysql, and SqlServer ......., but there has always been a problem, that is, when the mouse is clicked, the mouse will be offset. Specifically, the

Study mysql master-slave replication. During the Database Import and Export process, it is okay to export the master data, but the error mysqldump 1449 is returned when importing the master data from the database, then I searched for the solution on

1. Oracle data export: (1) completely export data from the database bkjia. The database username bkjia and password bkjia are exported to the local E: \ data. dmp. Exp bkjia/bkjia @ bkjia file = E: \ data. dmp full = y (2) export the tables of

MySQL is a widely used relational database. When the data size expands and the importance increases, the reliability and performance of a single database are severely challenged, so there will be a master-slave database, read/write splitting and

1. Start and close server processes:The following are the usage and common options of the pg_ctl command. It should be noted that this command is the encapsulation body of the S command, so it is more convenient to use than using postgres

The script for MySQL database flushing contains Chinese characters. After logging on with the MySQL command, it is flushed into the database and garbled during reading. The possible causes are as follows: After MySQL is installed, the client

For example, there is a shortage of hard disk space in a development library recently. A new disk is added to prepare to move all the data files to the new disk.First, list the data files to be moved. The data files belong to the tablespace. The

I. Applicable background There is a database named test, whose data is in the device test, and the log is in the device test_log; The test database has a table tab1 with 5 Records (1-5 ); Complete database backup: dump database test to

Since Oracle 10 Gb has not yet come out of the red-flag Linux Asianux 3.0, it is better to install the rpm package according to the requirements of Asianux 2.0. We must have the following RPMs installed:Red Hat Enterprise Linux 4.0 and Asianux

Migrate a user from an Oracle database to another database. The migrated data volume is about 120 GB. If you use expdp to export data, it will take a long time. In addition, the exported DMP file copy and impdp import time cannot meet the

Through the Partition Table analysis, we found that the original table structure was renamed without indexing, and a new table was created. After the analysis, we found that the index was used! Is it a partition storage parameter? Or the number of

For RAC, when an Oracle Instance fails, the application has several high-availability technologies to ensure availability. These technologies are transparent to the client, and the client may not be able to perceive the instance failure.1.