Database Administrator

This article details how to implement dual-machine hot backup for MySQL databases. 1. There is no Incremental backup mechanism for MySQL databases. Backup is a big problem when the data volume is too large. Fortunately, the MySQL database provides a

1. Several simple concepts to be understoodAdaptive Server:A relational database Server generally includes Adaptive Server, Backup Server, Monitor Server, XP Server, Adaptive Server utility, scripts, and configuration files.Backup Server:Backup

How to run Oracle commands in SUSE Linux:Suid/guid:Non-Oracle users are required to run oracle commands such as sqlplus. Solution:If you want to set s u I d, set the one before the corresponding permission bit to 4; if you want to set g u I d, set

In MySQL, the default Character Set utf8 is used. The sorting order of Chinese characters by Pinyin is messy, not the result we want. The solution is as follows: 1. If you do not want to change the table definition and default encoding, convert

Recently, MySql was installed and run on the server. Due to the aging of the computer's keyboard, I always press the wrong key. The error message is not interrupted, so it is annoying. No way, I disabled it. Open the installation directory of MySql.

Use FreeTDS in Linux to access the Microsoft SQL Server database Download freetds http://www.freetds.org/ With PHP's support for MSSQL: ./Configure -- with-mssql =/usr/local/freetds If: Configure: error: Directory/usr/local/freetds is not a

In Oracle, the CHAR field value is automatically filled with spaces. Therefore, when it is used as a condition, you may not be able to find the desired data.If you cannot change the database design, use RTRIM. Example:DB: Code highlighting produced

Taking part in Oracle's open-source technology day, I have no contact with Oracle db and open-source. I have always been a fan of ms products and cisco, but I am free of charge to learn more, it is also good to broaden your knowledge. In Oracle's

MySQL released the latest stable version 5.1.34 of the 5.1 series this morning. This is the fourth version after the official GA version of The November 26 last year series was released in 5.1. The previous version is 5.1.33 of. We recommend that

1. Required Software The command line email tool in mutt Linux, which can be used to receive and send emails. Sendmail/postfix on the mail server in Linux, all emails are sent from the Local Machine MySQL database backup program 2. mutt parameter

In Ubuntu 12.04, you can use the apt-get method to install MySQL. It is too troublesome to install and change the configurations by yourself, the following two articles are worth your reference: I just want to save time. In fact, it is best to

Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and alarm log monitoring, and database backup, AWR report automatic mail, etc. This article describes how

Instance recovery is used to recover failed instances or failed instances in the parallel server environment, therefore, instance recovery can refer to both crash recovery and instance recovery in the parallel server environment (one or more failed

Introduction to Oracle Trading Community Architecture (Oracle chloroform)Introduction Oracle Trading Community Architecture (chloroform) is a data model used to manage complex Party or customer information in a business environment, including

1. twemproxy release E When we have a large number of Redis or Memcached instances, we can only use some data distribution algorithms (such as consistent hashing) on the client side to implement Cluster Storage features. Redis Cluster has been

-Add a temporary Column Alter table tablename add filedname_temp number (2 ); -Leave the value of the temporary column empty. Update zyt set id_temp = null; ----- # alter table tablename modify filedname null; -The field value to be updated is

1. Prepare files1. Copy the linux.x64_11gR2_database_1of2.zip file.Linux.x64_11gr2_database204 f2.zip to the/Oracle directory; 2. decompress the package (you can right-click to decompress the package, or use the password, cd/oracle)[Root @ jyrac1/] #

Tip For the principle and implementation of master-slave replication, see MySQL master-slave replication. I. Questions about Replication 1. asynchronous replication solves those problems The basic problem solved by replication is that data on one

After the project was completed, we found the tragedy. By default, sqoop was used to list data tables from Oracle databases. If the data accuracy is greater than 15 digits, some fields in the imported table are of the double type by default. As a

Conclusion: -- two single-instance databases are used as DG and the database version is 10.2.0.1.0.1. Configure the master database as arch async, And the slave database does not have a standby log.The log contains: RFS [4]: No standby redo logfiles