Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the definitions of Cold, Warm and Hot backup?

April 26, 2017backup cold hot Warm

0

Posted

What are the definitions of Cold, Warm and Hot backup?

1 Answer

0

Posted

• Cold a.k.a. off-line backup means that during backup the MySQL server is shut down and not available to users. • Warm a.k.a. near-line backup means that MySQL server is running but tables are locked for writes during backup. • Hot a.k.a. on-line or live backup means that MySQL server is fully available to users for both reads and writes.