Using MYSQLBINLOG to do real-time log backups The objective is to ship in real-time the BINARY LOGS from MYSQL_SERVER to BACKUP_SERVER so in the event of losing MYSQL_SERVER you can recover to the ...

Extracts mysql general logs for long term storage which can be used for audit purposes. Mysql removes logs to keep exhausting storage and this can be dictated by the storage policy of the logs. For an ...

Hello everyone, I am Jun Ge. Today, we will delve into the two logging mechanisms in MySQL: Redo Log and Binlog, which play a crucial role in transaction management and data security in databases. To ...

In this project, we will emphasize on looking at how to interface the ESP12 NodeMCU development board with a local copy of MySQL DB using PHP, and log temperature and humidity sensor data into ...