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

Popular posts from this blog

To install .NET Framework 3.5

-
  Sent by Copilot: To install .NET Framework 3.5 using the Registry Editor (regedit), you can follow these steps: Open Registry Editor : Press  Win + R , type  regedit , and press Enter. Navigate to the Windows Update Settings : Go to  HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU . Modify the UseWUServer Value : Find the  UseWUServer  entry. Double-click it and change its value from  1  to  0 . Restart Your Computer : This change will take effect after a reboot. Install .NET Framework 3.5 : After restarting, you can install .NET Framework 3.5 through the Control Panel or using the following command in an elevated Command Prompt: DISM /Online /Enable-Feature /FeatureName:NetFx3 /All Revert the Registry Change : After the installation, go back to the Registry Editor and change the  UseWUServer  value back to  1 . Restart Your Computer Again : Restart your computer to apply the changes. This process shou...
Read more

How to Format your USB drive with CMD

-
Image
How to Format your USB drive with CMD 1. Open CMD (run as admin) 2. Type DISKPART and press Enter 3. Type list disk and press Enter 4. Type select disk n and Press Enter (n is the number that you want to use) 5. Type clean and Press Enter 7. Type create partition primary and press Enter 8. Type select partition 1 and Press Enter 9. Type format fs=ntfs quick and Press Enter 10. Type assign letter F and Press Enter
Read more

Local Server - 2 of 3 services running wamp server

-
Solution go to wamp icon==>apache==>httpd.conf(open)==>find and replace #listen 12.34.56.78:80 listen 0.0.0.0:80 listen[::0]:80    replace the above 3 listen by below #listen 12.34.56.78:8080 listen 0.0.0.0:8080 listen[::0]:8080 save and go back to wamp icon go to wamp icon==>apache==>httpd-vhosts.conf(open)==>find and replace Virtual Hosts *:80      by  Virtual Hosts *:8080 save and go back to wamp icon restart all service  wait for 10-20 seconds     if wamp ask you user name and password in wamp 3.... default username is root and don't use password 2. and if the problem is not resolved goto task manager==>processes==>mysqlid==>endtask goto wamp icon back and restart all services.
Read more