• New here? Register here now for access to all the forums, download game torrents, private messages, polls, Sportsbook, etc. Plus, stay connected and follow BP on Instagram @buckeyeplanet and Facebook.

Downtime this afternoon (Monday, April 27)

JCOSU86;1457783; said:
What did you do?

Mysql's bin logs were turned on. They're still on (and building 1gb files every day and a half or so), but we're going to turn them off. We do a fresh mysqlhotcopy nightly anyway, so I'm not terribly concerned about having those files. As a quick remedy, I just moved a dozen of them over to another array and restarted mysql.
 
Upvote 0
OK, the bin(ary) log allows for point-in-time recovery. In other words, if you don't back it up, and the site crashes at 1:19 PM, then you can only recover up to the last full backup. Backing up the bin logs allows for recovery to 1:19 PM.

I'm not advocating either, it depends on what you feel you can lose.
 
Upvote 0
JCOSU86;1458252; said:
OK, the bin(ary) log allows for point-in-time recovery. In other words, if you don't back it up, and the site crashes at 1:19 PM, then you can only recover up to the last full backup. Backing up the bin logs allows for recovery to 1:19 PM.

I'm not advocating either, it depends on what you feel you can lose.

Is there a good way to make it keep binary logs only for the last 24 hours?

We have them going back a month and a half. At 1g every 36 hours or so, it adds up.
 
Upvote 0
Clarity;1458386; said:
Is there a good way to make it keep binary logs only for the last 24 hours?

We have them going back a month and a half. At 1g every 36 hours or so, it adds up.

I'm not a SQL expert by any stretch, but I'm guessing there has to be a way to truncate the bin logs so that it isn't eating up your disk space as much.

I found this link which seems to indicate there is a way within SQL to get the logs to expire automatically (and it's configurable too)

Patterns ? Blog Archive ? MySQL: Purge binary logs

Hope that helps you C-dawg.
 
Upvote 0
Back
Top