Dual-machine hot backup solution for Servers
The dual-machine Hot Standby software can detect computer operating systems, network systems, and databases in a timely manner. When any system has problems, the dual-machine software can automatically run on the backup server, let the slave server take over the work of the host so that the computer will never stop an
In the first two articles, we described the backup and recovery solutions for Small and Medium databases using RMAN catalog, all related scripts are provided to simulate Oracle Data Guard to a certain extent in a car to reduce database losses on the Prod Server caused by hardware faults. This article mainly describes how to restore the changes of the Prod database on the Bak server.
Small and Medium databases rman catalog
backup model file.2.2: RecoveryClick Restore on the interfaceSelect Back up the backup of the Open DJ directory, note that the server side of the backup file must be placed in the backup machine backup directory is: /bakIf you are not up-to-date, verify that the server-side
Mysql automated backup solution bitsCN.com
Mysql automatic backup solution 1. configure the database server 1. write the mysql automatic backup script mysql backup mainly includes hot backup
SQL Server backup solution
In order to reduce data loss caused by database server problems, the database is generally backed up, depending on the importance of data and performance compromise using different backup solutions.The general backup solution is:Global
The following articles mainly describe the actual operation solution of DB2 Online backup. This article describes how to modify Database parameters and modify the relevant parameters of database online backup, the following describes the main content of the text.
Online, solution Online,
Simple remote backup solution for Linux server databases (MySQL and ORACLE) bitsCN.com
Simple remote backup solution for Linux server databases (MySQL and ORACLE)
Simple remote backup solution for MySQL databases on Linux server
"! -name "DB"! -name "rtx*" ' ">>/shell/bAckup.logElseecho "' Date +%y%m%d ' Delete unsuccessful" >>/shell/backup.logFi# from Email adminMail-s "DataBackup" [email protected] If [$WEEK-ne 0];thenif [!-d/hddf/database/' Date +%y%m%d '];thenMkdir-p/hddf/database/' Date +%y%m%d 'mv/hddf/database/{*.bak,*. BAK}/hddf/database/' Date +%y%m%d '/FiElseecho "Today is Sunday no data backup" >>/shell/mvdata.txtFiThis article is from the "Zhongliang Linux Technol
log-based replication mechanism, therefore, the master server must support Log changes. Set the database to which logs are to be written or the database to which logs are not to be written. In this way, only changes to the database you are interested in are written into the database log.
Server-id = 1 // Database id. The default value is 1. You do not need to change the name of log-bin = log_name // log file, // you can specify the log to another directory
Mysql automatic backup solution 1. Configure the database server 1. Write the mysql automatic backup script mysql backup mainly includes hot backup and cold backup. Hot Backup is used h
Simple remote backup solution for Linux Server databases (MySQL and Oracle)
Simple remote backup solution for Linux Server databases (MySQL and Oracle)
Simple remote backup solution for MySQL Databases on Linux servers
First,
Article Title: Nginx + PHP + MySQL dual-host mutual backup and automatic switch solution. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
In production applications, a data server with the "Nginx + PHP + MySQL" interface plays a very important role. If the server hardwar
Oracle elastic uard is a database-level HA solution. Its primary functions include redundancy, data protection, and fault recovery.
When the "transaction consistency" of the production database is used, the physical full backup (or physical COPY) of the production database is used to create the standby database, the slave database automatically maintains the slave database through the archive logs (or redo
For DB2 "SQL2421N does not allow tablespace-level backup because rollback and recovery are not enabled ." When backing up the tablespace in DB2, if the error "SQL2421N does not allow tablespace-level backup because rollback and recovery are not enabled" is reported, the cause and solution are as follows: the command --------------------------------
In Linux, the dual-host (multi-host) automatic mutual backup solution-Linux Enterprise Application-Linux server application information. The following is a detailed description. Question: Our company has two LINUX servers, each of which has only one hard disk. Therefore, the backup issue is particularly important. We have a mysql database installed. Of course, we
Question: two LINUX servers each have only one hard disk. Therefore, the backup issue is particularly important. We have a mysql database installed. Of course, we also need to solve the problem of mysql backup.
Project: host Machine (all backups are stored on it) ship Machine (save host Machine backup)
Method: use shell scripts to package the files to be backed
Windows System Backup can be completed using the ghost tool. Linux systems cannot rely entirely on the ghost tool. First, ghost itself is copyrighted, second, ghost only supports Linux partitions of ext2 and ext3 file systems. It does not support reiserfs, XFS, and other advanced file systems. Ghost itself does not back up MBR, therefore, grub Errors often occur after recovery. Linux itself comes with excellent ba
The following shell script is used to restore the database automatically. After the restoration is successful, the database is disabled. Because we do not need the bak slave database in the case of no exception in the Prod database.
The following shell script is used to restore the database automatically. After the restoration is successful, the database is disabled. Because we do not need the bak slave database in the case of no exception in the Prod database.
Small and Medium databases ar
With the popularization of computer networks, computer viruses have the opportunity to spread quickly, and the damage to data files is becoming increasingly serious. Users often need to back up important personal data in different regions. Based on the consideration of multiple users and data privacy, a personal data backup system solution is proposed. It uses the large capacity, high reliability, and high
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.