Database Administrator

Percona Xtrabackup for database backup and disaster recovery Directory1. Tool Introduction2. Tool Installation3. Backup policies and prepare test data4. Full backup of data5. Incremental Backup Data6. Disaster Recovery7. Summary 1. Tool

MongoDB Tutorial: MongoDB cluster and replica set Concepts For MongoDB Data Disaster Tolerance, the recommended mode is the replica set mode. It has an external Primary server Primary and N replica servers Secondary (N> = 1, when N = 1, an

When installing PostgreSQL9.3.5 on CentOS 6.5, the following error occurs: jade: Command not found. When installing PostgreSQL9.3.5 on CentOS 6.5, the following error occurs: jade: Command not found. 1[Root @ pghost1 postgresql-9.3.5] #. /configure -

ORA-12034: The materialized view log on SCOTT. "USER_TABLE" is newer than the last refresh Recently, when I handed over my work, I found that several schedule jobs were not successfully executed. I have shown that one of them is due to database

Install MongoDB 3.4 on yum in CentOS 7 Install MongoDB 3.4 on yum in CentOS 7. Step 1 check whether the yum source is configured for Mongodb Switch to the yum directory cd/etc/yum. repos. d/ View File ls The second part does not add the yum

Compile and install MariaDB-10.0.20 under CentOS 6.6 System Environment: CentOS6.6 (Final)MariaDB port: 3309 (because MySQL is already installed on the local machine and you do not want to delete MySQL) # Wget http://mariadb.nethub.com.hk//mariadb-10

Summary of SQL Injection bypass techniques, SQL Injection Bypass Preface SQL Injection was a common vulnerability long ago. Later, with the improvement of security, SQL injection was rarely seen. However, today, many websites are running with SQL

MySQL foreign key details, MySQL key details Recently, when I was studying Hibernate, I was always confused by foreign keys. Moreover, my MySQL foreign key learning is not very solid, so in order to better master Hibernate and MySQL, therefore, I

C ++ Class Library: OTL connects to the MySQL ODBC database (insert, update, select) and otlodbc I. Introduction OTL is a pure C ++ universal database connection template library, can support a variety of popular databases, such as Oracle, Sybase,

Replay eygle's example in the speech at the Oracle conference to see what is the master's starting point and face, replay eygle In his speech at the just-concluded Oracle conference, the company demonstrated the optimization of vertices and surfaces

Similarities and differences between Oracle Enterprise Edition, Standard Edition, and other versions, oracle Enterprise Edition For different development and deployment environments, Oracle divides the same series of Oracle databases into four

How to back up Oracle batch processing on Windows (with scheduled tasks or third-party timing software, you can achieve automatic backup), oracle Batch Processing@ Echo start to back up oracle Data@ Echo offSetSet curdir = "D: \ backup"Echo % curdir

Install Oracle 12C and linux7centos7 on LINUX7 (CentOS7) Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for

Advanced applications of Redis-transaction processing, persistence, message publishing and subscription, virtual memory usage, and redis Transaction Processing Iii. Transaction Processing Redis transaction processing is relatively simple. You can

Insert statement plus/* + APPEND */impact analysis on the system of a single commit in a loop, insertappend1./* + APPEND */usage of the prompt /* + APPEND */indicates that an INSERT statement exclusive hint is used to increase the insert speed and

Database Programming -- Use of translate, -- translate1. translate syntaxTranslate (string, from_str, to_str)2. explanation: replace each character in the string from_str from left to right with each character corresponding to the string to_str, if

SQL server database Type insert statement usage insert into emproyee (e_name, e_sex) values ('tang Jia San Shao ', 0); insert into emproyee, Summary when SQL server inserts multiple data records into the insert statement Insert a single data entry:

Oracle copy table, temporary table, and view, oracle copy table ViewCreate a new_table table with the same structure as the old_table Table (no old_table Records) Create table new_table as select * from old_table where 1 = 0;   Create a new_table

Oracle technology _ 5 minutes will use stored procedure _ simple example of stored procedure (including loop, condition, add and modify query, parameter input, variable assignment, java call, etc.), oracle_5 Example business functions: 1. query the

ORA-12520 error solved one, ORA-12520 error solved Problem description: An error was reported when I suddenly found a connection to the database today. When I use pl/SQL dev to connect to data, sometimes I can connect to the database. Sometimes I