I am using AWS Aurora MySQL with Writer and reader instances in replication. Both instance are used by two separate applications.
I want to clear the performance schema on the read replica server but getting below error.
An error occurred truncating performance_schema event tables. (‘The
MySQL server is running with the –read-only option so it cannot
execute this statement’, 1290)
Is there any option that can be done specifically for this AWS deployment?
Here is the version info: