0

We have a MariaDB Database (10.3 v) on a virtual Redhat server. I should create a LVM-Snapshot script to secure our data. We use a kind of technolgy that it secures our storage. It means if the hard disk fails, there will be no problem with the data. The data will be saved almost simultaneously on several other disks.

But for a failure or crash and fast restore we need a LVM-Snapshot (running every night).

My main question is: Should I secure (snapshot) our binlogs too or not? and Why?

As far as I know, even if the database crashes for any reason, the binlogs will not be lost or corrupted.

Thanks in advance.

Improve this question
4
  • 2
    Presumably, if you have binary logs enabled, you find some value in them, so it would make sense to protect them. Commented Aug 22, 2022 at 13:49
  • What failure(s) do you want to protect against? Flood destroying all your computers? Single disk failure? MySQL server aborting? Accidental "DROP DATABASE"? Disgruntled employee? Commented Aug 23, 2022 at 4:15
  • Not physical. It's more about data like server aborting, server crash, disgruntled employee and etc. Commented Aug 23, 2022 at 6:00
  • Does this answer your question? Can it be safe to disable binary logging in MySQL? Commented Aug 23, 2022 at 7:06

1 Answer 1

Reset to default
1

It is a good practice to keep a backup (including binlog as well).

As per the part even if the database crashes for any reason, the binlogs will not be lost or corrupted there is still an open ticket MariaDB binlog corruption when "No space left on device" and stuck session killed by client which isn't solved yet.

Another part which I recommend is protecting the binlog (even if it isn't directly related to the question)

Overview of the Binary Log

It is important to protect the binary log, as it may contain sensitive information, including passwords.

You can encrypt it by using Encrypting Binary Logs.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.