what is Binarylog?
Binary log is writing events such like database changes, table create operations or changes to table data like delete, insert, update. Binary log also contains info about how long each statement took to the above listed kind of updated data. The main purpose of binary data is two. 1. for replication to the second server which helps to write immediately when the change occurs to the replica server 2. for data recovery, in case of data recovery it requires binary data which helps for example we take a backup today at 2pm and system failure occur immediately after backup completed and restored after one hour from the backup, at this time binary log helps to fill the lost data between backup taken time and restore time. Binary log not used for select or show scripts because it will not have a change to the table.
Comments
Post a Comment