How to Limit MySQL Enterprise Backup's Impact on Active DB
(Doc ID 2494959.1)
Last updated on JULY 23, 2023
Applies to:
MySQL Enterprise Backup - Version 3.11 and laterMySQL Server - Version 5.7 to 5.7 [Release 5.7]
Information in this document applies to any platform.
Goal
On any suitably large or active database , it can be the case where an MEB backup could impact the performance of the users.
There are many reasons for this, eg an application uses an especially "hot" table , or the DB is used 24.7 with no designated "quiet time" to take a backup.
Limiting the impact of an MEB backup may be desirable.
Example problem scenario
During a normal backup process, there are lag spikes being reported from the application side.
The current backup script may be:
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Example problem scenario |
| Solution |