Database operation and Maintenance protection

Database operation and Maintenance protection

National Day holiday could have been happy to play, but due to some unexpected situation, such as the disaster caused by the database failure situation is likely to appear

If this situation not only destroys the good mood of the national Day holiday fun, after-work may also be due to the lack of preventive measures to encounter leadership criticized.

In order to avoid this situation, for the company's business system of the relevant operations and maintenance personnel can not be taken lightly, must do a good job of preventive measures.

The following is a summary of some of the emergency prevention measures

1, do a good job in the monitoring of business system alarm, the key moment to start the emergency plan

2, the server select dual power server, to avoid a single power failure caused by server downtime

3, select high-quality room, the engine room must have a generator, encountered a typhoon this kind of natural disaster can not go to the computer room normal shutdown or treatment situation, the generator is very important

4, the server configuration ups, dual power server, one power access to the mains, another power access to the UPS, to avoid the situation of power off immediately the server is not normal shutdown

5, the database to do disaster tolerance scheme, to ensure the availability of the system, SQL Server usually choose the strategy is: failover cluster, mirroring, log shipping, AlwaysOn, etc., according to their own needs to choose the appropriate disaster recovery plan

6, off-site disaster preparedness, in case the computer room export network interruption can switch to other computer room, important business system consider the three centers of the two Places disaster preparedness plan

7, arrange the operation and maintenance personnel on duty, in similar to the National Day, the Spring Festival these long holiday holiday inside, may consider lets some operation dimension personnel 24 hours in the machine room duty

Tips Instructions

For the first four measures, is the basic requirements, because I have seen some of the older computer room, the generator is not, the mains power supply is not particularly stable, if not equipped with dual power supply and UPS, then the server outage probability will be higher

If the room facilities are not too good, often power outages, network export instability, then we should not choose such a room, the room is not stable, the company's business will be implicated.

For SQL Server disaster preparedness scenarios, you can purchase storage if the funds permit, and failover the cluster with SQL Server, and the database is placed in the shared storage.

If the funds are not allowed and data is not lost, you can consider using SQL Server mirroring and AlwaysOn, configuring the mirror to High security mode or configuring AlwaysOn as synchronous mode, so that the data is not lost when failover.

But the money is not allowed, but can allow the minute level of data loss, can consider log shipping.

And some very very important business needs to consider remote disaster preparedness, such as the city power outages, operators of network export problems, this time need to consider switching room.

For the last point, the arrangement of the relevant operations personnel on duty I think is the most effective, because no one can say which day may encounter earthquakes or floods, this time the relevant personnel may not go to the computer room or the company for emergency treatment

At this time can only rely on duty personnel to deal with.

Database operation and Maintenance protection