MySQL Continuous Log Real-time Protection (CLRP), achieving a sub-second RPO is not a dream!
Traditional MySQL database backup methods suffer from serious data loss. When a production host fails, users can only restore to the most recent backup point, which may result in several hours or even days of data loss. In today’s data-driven era, data has become a critical element of production. Therefore, more advanced technology is needed to ensure data security.
To address the shortcomings of traditional backup methods, Aurreum has independently developed the Continuous Log Real-time Protection (CLRP) technology. Based on MySQL’s source-replica (master-slave) replication protocol, This technology continuously captures binlog data changes to ensure real-time consistency between backup data and business data.
Backup Principle
-
When there is a transactional change in the database, it is first recorded in the Redo Log. After the transaction is successfully committed, the changes are recorded in the binary log (binlog).
-
Aurreum’s CLRP technology leverages MySQL’s source-replica (master-slave) replication protocol to immediately and accurately identify valid new records in binlog files once a new transaction is committed.
-
The technology continuously monitors and captures changes in log data through binlog dump, and synchronizes the data to the storage server to ensure consistency between backup storage and business system data.
Through CLRP technology, it is possible to achieve near-zero Recovery Point Objective (RPO). In the event of a failure, data can be restored to a state very close to the time of failure, greatly enhancing business continuity and data security.
Technical Features
Since CLRP only captures changes in log files, the amount of data involved is very small, and the resource consumption on the business side can be negligible.
With Aurreum’s CLRP technology for MySQL, users can achieve real-time data backup, reducing the risk of data loss and improving data security.
Technical Advantages
Sub-second response, sub-second RPO! The technology reduces the RPO to a sub-second level, with an average of only 0.2 seconds. Even under normal load, real-time data protection can be achieved.
Precision backup, finer granularity! Unlike traditional volume-level synchronization methods, the technology only backs up changed binlog data blocks, greatly saving system resources, bandwidth, and storage space.
Low cost, high efficiency! The technology does not rely on expensive hardware, which can save costs, increase efficiency, and make your data protection more cost-effective.
No fear of anomalies! The backup program does not introduce any software/hardware drivers. Even if the backup program is abnormal or crashes, it will not affect the stability of your business system!