Coming from an Oracle background, there some learning steps for me to pick up Mysql.
We are using Mysql very 5.148, the latest on Ubuntu. One important feature is to enabled log_bin=on in /etc/my.cnf file. This is equivalent to archive logs feature.
Next we need to take care on how to archive these bin logs before it fills up. I have a cron script that runs and remove binary logs that are a couple of days old. Alternatively, there is a parameter 'expired%' that can specify the validity of binaries log before removed by system.
No comments:
Post a Comment