Questions related to Percona Telemetry Agent and Audit Log Filter plugin

MySQL & MariaDB
1

Hi,

We noticed that if Percona Telemetric Agent is installed, then we are able to successfully install the new audit log plugin. If we uninstall and remove the telemetry service agent, then not able to install the Audit Log Filter plugin.

Is there any dependency of installing new audit log plugin with Telemetry agent in Percona MySQL 8.4.7?

How do we install 8.4.7 without Telemetry (and its service) and install the new audit log filter?

2

hey @Ramasamy
telemetry has been added as a dependency. so if you don’t want to use it - you just need to disable it permanently

https://docs.percona.com/percona-server/8.4/telemetry.html#locations-of-metrics-files-and-telemetry-history

3

Thank you for your reply. Yes, I tried to disable it but after installing it audit log filter component is not installing properly. Is there any dependency between Telemetry and new audit log filter component?

4

Please share how you tried to install it

5

Yes, we followed the link Telemetry on Percona Server for MySQL - Percona Server for MySQL . Though it is disabled (also updated the parameter percona_telemetry_disable=1 in the configuration file) and no service is enabled/running) but still the package is installed

rpm -qa |grep percona

]$ rpm -qa |grep percona
percona-xtrabackup-84-8.4.0-5.1.el8.x86_64
percona-telemetry-agent-1.0.7-1.el8.x86_64
percona-server-shared-8.4.8-8.1.el8.x86_64
percona-toolkit-3.7.1-2.el8.x86_64
percona-server-server-8.4.8-8.1.el8.x86_64
percona-server-client-8.4.8-8.1.el8.x86_64
percona-server-shared-compat-8.4.8-8.1.el8.x86_64
percona-icu-data-files-8.4.8-8.1.el8.x86_64

$

6

When I installed percona server with the below command, telemetry package was installed.


# sudo PERCONA_TELEMETRY_DISABLE=1 apt install percona-server-server

# dpkg -l |grep -i percona
ii  percona-release                    1.0-32.generic                          all          Package to install Percona gpg key and APT repos
ii  percona-server-client              8.0.45-36-1.noble                       amd64        Percona Server database client binaries
ii  percona-server-common              8.0.45-36-1.noble                       amd64        Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii  percona-server-server              8.0.45-36-1.noble                       amd64        Percona Server database server binaries
ii  percona-telemetry-agent            1.0.10-1.noble                          amd64        Percona Telemetry Agent gathers information and metrics from Percona products installed on the host.

Installed the audit log filter using

# mysql -u root -p -D mysql < /usr/share/mysql/audit_log_filter_linux_install.sql
Enter password: 

mysql> show plugins;
| audit_log_filter                 | ACTIVE   | AUDIT              | audit_log_filter.so | GPL     |

At the moment it is getting installed but not configured to send the data. You can safely stop the percona-telemetry-agent service and continue. You can also disable it in case if you dont want to restart it when the OS starts.

Reported this to our Engineering team to see if we can avoid installing. But at this time it is a dependency package for percona-server-server.

We tried stopping the agent and installed the plugin and it worked fine.

# mysql -u root -p -D mysql < /usr/share/mysql/audit_log_filter_linux_install.sql
Enter password: 
#

Plugin was active and can be used too. Both in 8.0 and 8.4.