The logging and monitoring of the connection can take place with the help of the audit framework which is related to Percona. The query activities can perform on the specific service which can eventually store the information in the XML log files. Additionally, the stored information has a different name and specific record id along with a timestamp.
Cost-effective
It is a misconception that the Percona audit is highly costly as it enables the feature of logging into every connection, admin statement and query. However, it is found that a machine with quad-core Xeon and 32GB RAM can support the audit process. The audit logging in the asynchronous mode can result in the effective impact by activating full logging. Moreover, the audit logging can even be on and off subsequently.
Evaluation
The audit application can be installed to run the system without having to see any interruption. The variable can be included and there might not be certain interruptions observed either. The performance and installation of the plug-in can be effective for all the people that look for the system where they do not need to restart the instance. The light audit process can be included in the log file for tracking access and changing the data without affecting its performance.
There is no doubt that audit run by Percona can be a hit among the users as they are given ample opportunities to maintain security in the database system. Through the framework