best disaster recovery software

Directory1. Introduction of test environment2. Backup strategy3. Backup4. Disaster recovery5. Summary1. Introduction of Test ringMysql>selectversion (); +------------+|version () |+------------+|5.5.36- log|+------------+mysql>showdatabases;+--------------------+|database |+--------------------+|information_schema| | mydb1| | mysql| | performance_schema| | test|+-------- ------------+mysql>select*frommydb1.tb1;+----+------+------+|id| name|age|+----+-

description: the Article In the disaster recovery series is composed of Robert Davis , released in sqlsoldier, I personally think it is quite good, so according to my own understanding, testing and sorting are not directly translated. If there is any inaccuracy, please correct me. This article is the fifth article on Database disaster

After the database server is set up, the first thing we need to do is not to consider which MySQL-carrying programs should be run on this database-supporting server, but when the database is damaged. After the database server is set up, the first thing we need to do is not to consider which MySQL-carrying programs should be run on this database-supporting server, but when the database is damaged. After the database server is set up, the first thing we need to do is not to consider which MyS

After the database server is set up, the first thing we need to do is not to consider which MySQL-initiated programs should be run on the server that supports the database, but when the database is damaged, how to safely restore to the last normal state, minimizing data loss. In other words, just the establishment of a database server can only describe what it can do, and it does not mean what it can do stably. Disaster

information of the certificate4, prompt us to set up the corresponding firewall, start 443 port5, we will configure a copy, the same we select the corresponding guest system win2012r2-test03, and then click "Copy" into the Copy wizard, click "Next"6, specify the replica server, click "Next"7, here we also need to select the corresponding certificate, click "Select Certificate"8, select the corresponding certificate, click "OK"9, this time we can see the corresponding certificate details, click

library)Next, restore to an empty directory based on the InodeCd/root/testEXT3GREP/DEV/SDB1--restore-inode 48961MV test/restore-files/inode.48691 Test/restore-files/t2. MYDMV test/restore-files/inode.48692 Test/restore-files/t2. MYIMV test/restore-files/inode.48693 TEST/RESTORE-FILES/T2.FRMMount/dev/sdb2/var/lib/mysqlCP t2.*/USR/LOCAL/MYSQL/DATA/DB1Chow-r Mysql.mysql. * (pwd =/VAR/LIB/MYSQL/DB1)/etc/mysqld startFinally, check that the data is complete,This article is from the "Crazy_sir" blog,

Disaster logAll DDL (Create, DROP, and alter) and DML (INSERT, UPDATE, DELETE_ statements, but not query statements) are loggedOpen Mysql.ini Find binary LoggingRevision changed toBinary Logging. Log - = "ABC"Restart MySQLFind E:\AppServ\MySQL\dataTwo more files belowabc.000001Abc.indexOpen Mysql.ini, find [client] revision to[Client]#no-beepTo create a new test environment:1. New Test table2. Create a new ID and name two fields3. Inserting data (opti

Tags: disaster recovery, mirage In (MirageSeries 8)MirageData Update and restoration in classic cases We have introduced Mirage The Management Terminal can restore data from the terminal. Download to describe how to use Mirage Disaster recovery. Disaster

second, disaster recovery simulation Since persistent data is used for data recovery after a reboot, it is very necessary to perform such a disaster recovery simulation. It is said that if the data is to be persisted and stability is to be ensured, half of the physical memor

KBMMW provides a good mechanism for balancing load and disaster recovery, supports multiple implementations, and now looks at the simplest, client-controlled disaster recovery and simple load balancing.Now, we deploy Kbmmwserver to different servers, or deploy multiple instances on the same server, so we have a service

restoration process of the Oracle database is divided into two steps. First, all the retries stored in the redo log file are applied to the data file, and then all uncommitted transactions in the Redo are rolled back, in this way, all the data will be restored to the time of the disaster. Database recovery can only be used to redo data files before a fault occurs, restoring them to the time of failure, rat

has its own infrastructure master. The default five kinds of FSMO exist on the first DC of the root domain in the forest, while the relative representation host, PDCE, infrastructure master in the child domain exists on the first DC in the child domain. After the construction of the previous domain, we will perform a disaster recovery for the primary domain controller. Step three: The transfer of FSMO r

Brief introduction The role of the log is to ensure persistence and data consistency, through the log can achieve data undo and redo, so through the log, SQL Server can not only achieve disaster recovery, but also through the redo of the log to achieve high availability. This article focuses on the role of logging in several high-availability scenarios provided in SQL Server and in

Note:Disaster recovery SeriesOfArticleYesby Robert Davis Written in sqlsoldier,I personally think it is quite good, so according to my own understanding, testing and sorting are not directly translated. If there is any inaccuracy, please correct me. This article introduces the second article on Database disaster recovery. It mainly discusses the protection me