Otdfbt

How do I identify the partitions of my hard drive in order to then shred them all?

"The van's really booking"

How to not get blinded by an attack at dawn

Can multiple outlets be directly attached to a single breaker?

Will the volt, ampere, ohm or other electrical units change on May 20th, 2019?

Was the dragon prowess intentionally downplayed in S08E04?

Given 0s on Assignments with suspected and dismissed cheating?

Were any toxic metals used in the International Space Station?

How about space ziplines

Generate ladder of integers using the least number of unique characters (in C++)

How to redirect stdout to a file, and stdout+stderr to another one?

Will casting a card from the graveyard with Flashback add a quest counter on Pyromancer Ascension?

Acronyms in HDD specification

Show solution to recurrence is never a square

Formal Definition of Dot Product

is it correct to say "When it started to rain, I was in the open air."

Why are BJTs common in output stages of power amplifiers?

Were any of the books mentioned in this scene from the movie Hackers real?

Why are solar panels kept tilted?

Should I communicate in my applications that I'm unemployed out of choice rather than because nobody will have me?

Why weren't the bells paid heed to in S8E5?

Mark command as obsolete

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

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

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