Otdfbt

Substring join or additional table, which is faster?

Did galley captains put corks in the mouths of slave rowers to keep them quiet?

Can my Serbian girlfriend apply for a UK Standard Visitor visa and stay for the whole 6 months?

Unexpected Netflix account registered to my Gmail address - any way it could be a hack attempt?

Help understanding this line - usage of くれる

Why is it harder to turn a motor/generator with shorted terminals?

Why can't I share a one use code with anyone else?

Do we have C++20 ranges library in GCC 9?

Why are solar panels kept tilted?

Single word that parallels "Recent" when discussing the near future

How does this Martian habitat 3D printer built for NASA work?

Holding rent money for my friend which amounts to over $10k?

Use of さ as a filler

How to disable Two-factor authentication for Apple ID?

Is it wrong to omit object pronouns in these sentences?

Re-testing of regression test bug fixes or re-run regression tests?

Problem in downloading videos using youtube-dl from unsupported sites

Offered a new position but unknown about salary?

Can only the master initiate communication in SPI whereas in I2C the slave can also initiate the communication?

Show solution to recurrence is never a square

Was the dragon prowess intentionally downplayed in S08E04?

Under what charges was this character executed in Game of Thrones, The Bells?

Why does SSL Labs now consider CBC suites weak?

Why was my Canon Speedlite 600EX triggering other flashes?

Minimizing the write-outage time of the database deployed on AWS EC2 [closed]

EBS with RAID0 (striping) and restoring snapshotsUbuntu Software RAID 0 on AWS Does Not Survive RebootHow different is an Amazon EC2 RDS DB Instance different from the normal EC2 Instance?What's the easiest way to auto-backup an EC2 instance?Amazon EC2 terminology - AMI vs. EBS vs. Snapshot vs. VolumeAmazon EC2 and EBSSolutions for a growing Postgresql database on Amazon EC2?How do I back up AWS S3 and EBS to a non-Amazon provider?AWS EC2 what is a reservation ID exactly and what does it represent?How to determine AWS EC2 network performance?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

-1

1

Say we have a relational database on EC2 instance. It has a set of EBS volumes in RAID mode. We perform a procedure of backing-up this instance. How to minimize the time during which we cannot write to the database while this backup is performed?

amazon-web-services amazon-ec2 backup raid

share|improve this question

edited May 4 at 6:56

Andremoniy

asked May 3 at 14:10

AndremoniyAndremoniy

1236

closed as off-topic by Iain, womble♦ May 5 at 0:59

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "Questions on Server Fault must be about managing information technology systems in a business environment. Home and end-user computing questions may be asked on Super User, and questions about development, testing and development tools may be asked on Stack Overflow." – Iain, womble

If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You probably need to supply the answers so we can try to figure out what the person creating the quiz was thinking.
  
  – Michael - sqlbot
  May 3 at 21:36
  

  
  
  
  

add a comment | 

-1

1

Say we have a relational database on EC2 instance. It has a set of EBS volumes in RAID mode. We perform a procedure of backing-up this instance. How to minimize the time during which we cannot write to the database while this backup is performed?

amazon-web-services amazon-ec2 backup raid

share|improve this question

edited May 4 at 6:56

Andremoniy

asked May 3 at 14:10

AndremoniyAndremoniy

1236

closed as off-topic by Iain, womble♦ May 5 at 0:59

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "Questions on Server Fault must be about managing information technology systems in a business environment. Home and end-user computing questions may be asked on Super User, and questions about development, testing and development tools may be asked on Stack Overflow." – Iain, womble

If this question can be reworded to fit the rules in the help center, please edit the question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You probably need to supply the answers so we can try to figure out what the person creating the quiz was thinking.
  
  – Michael - sqlbot
  May 3 at 21:36
  

  
  
  
  

add a comment | 

Say we have a relational database on EC2 instance. It has a set of EBS volumes in RAID mode. We perform a procedure of backing-up this instance. How to minimize the time during which we cannot write to the database while this backup is performed?

amazon-web-services amazon-ec2 backup raid

share|improve this question

edited May 4 at 6:56

Andremoniy

asked May 3 at 14:10

AndremoniyAndremoniy

1236

share|improve this question

edited May 4 at 6:56

Andremoniy

asked May 3 at 14:10

AndremoniyAndremoniy

1236

share|improve this question

edited May 4 at 6:56

Andremoniy

asked May 3 at 14:10

AndremoniyAndremoniy

1236

asked May 3 at 14:10

AndremoniyAndremoniy

1236

asked May 3 at 14:10

AndremoniyAndremoniy

1236

1 Answer
1

active

oldest

votes

1

If your key concern is not taking the database down then you can take snapshots. If you take the snapshots while the instance is quiesced the snapshots will be consistent, but you can shut the instance down for 10 seconds you can be 100% sure of consistent snapshots. The key here is once a snapshot is started you can continue to modify the volume but the snapshot will be taken as of the time you requested the snapshot. You can then mount the snapshots to a new instance and take a backup. That's the hard way, but probably the least downtime, and maybe it can be automated.

You could also simply export the database using the vendor tools to another volume or S3, which typically does not interrupt database use.

There are no doubt other ways, probably some better, which others will answer. The question will probably be closed sooner or later as SF is for real world business problems rather than helping with exams.

share|improve this answer

answered May 3 at 18:58

TimTim

18.4k41951

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I just want to clarify out of curiosity: why is "once a snapshot is started you can continue to modify the volume"? What the technical nuance behind the scene?
  
  – Andremoniy
  May 4 at 6:58
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  We don't know what the behind the scene technology is, we just know that AWS says once you start a snapshot it's taken as at the time the snapshot is started, even if the volume is modified while the snapshot is being taken. I guess it's something like volume shadow copy
  
  – Tim
  May 4 at 8:01
  

  
  
  
  

add a comment | 

1

If your key concern is not taking the database down then you can take snapshots. If you take the snapshots while the instance is quiesced the snapshots will be consistent, but you can shut the instance down for 10 seconds you can be 100% sure of consistent snapshots. The key here is once a snapshot is started you can continue to modify the volume but the snapshot will be taken as of the time you requested the snapshot. You can then mount the snapshots to a new instance and take a backup. That's the hard way, but probably the least downtime, and maybe it can be automated.

You could also simply export the database using the vendor tools to another volume or S3, which typically does not interrupt database use.

There are no doubt other ways, probably some better, which others will answer. The question will probably be closed sooner or later as SF is for real world business problems rather than helping with exams.

share|improve this answer

answered May 3 at 18:58

TimTim

18.4k41951

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I just want to clarify out of curiosity: why is "once a snapshot is started you can continue to modify the volume"? What the technical nuance behind the scene?
  
  – Andremoniy
  May 4 at 6:58
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  We don't know what the behind the scene technology is, we just know that AWS says once you start a snapshot it's taken as at the time the snapshot is started, even if the volume is modified while the snapshot is being taken. I guess it's something like volume shadow copy
  
  – Tim
  May 4 at 8:01
  

  
  
  
  

add a comment | 

1

If your key concern is not taking the database down then you can take snapshots. If you take the snapshots while the instance is quiesced the snapshots will be consistent, but you can shut the instance down for 10 seconds you can be 100% sure of consistent snapshots. The key here is once a snapshot is started you can continue to modify the volume but the snapshot will be taken as of the time you requested the snapshot. You can then mount the snapshots to a new instance and take a backup. That's the hard way, but probably the least downtime, and maybe it can be automated.

You could also simply export the database using the vendor tools to another volume or S3, which typically does not interrupt database use.

There are no doubt other ways, probably some better, which others will answer. The question will probably be closed sooner or later as SF is for real world business problems rather than helping with exams.

share|improve this answer

answered May 3 at 18:58

TimTim

18.4k41951

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I just want to clarify out of curiosity: why is "once a snapshot is started you can continue to modify the volume"? What the technical nuance behind the scene?
  
  – Andremoniy
  May 4 at 6:58
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  We don't know what the behind the scene technology is, we just know that AWS says once you start a snapshot it's taken as at the time the snapshot is started, even if the volume is modified while the snapshot is being taken. I guess it's something like volume shadow copy
  
  – Tim
  May 4 at 8:01
  

  
  
  
  

add a comment | 

If your key concern is not taking the database down then you can take snapshots. If you take the snapshots while the instance is quiesced the snapshots will be consistent, but you can shut the instance down for 10 seconds you can be 100% sure of consistent snapshots. The key here is once a snapshot is started you can continue to modify the volume but the snapshot will be taken as of the time you requested the snapshot. You can then mount the snapshots to a new instance and take a backup. That's the hard way, but probably the least downtime, and maybe it can be automated.

You could also simply export the database using the vendor tools to another volume or S3, which typically does not interrupt database use.

There are no doubt other ways, probably some better, which others will answer. The question will probably be closed sooner or later as SF is for real world business problems rather than helping with exams.

share|improve this answer

answered May 3 at 18:58

TimTim

18.4k41951

share|improve this answer

answered May 3 at 18:58

TimTim

18.4k41951

answered May 3 at 18:58

TimTim

18.4k41951

answered May 3 at 18:58

TimTim

18.4k41951