Gcache.page file location

1

Can the gcache.page files save to a different location. Currently they are in the datadir but i would like to store them in another mount.

1 Like
2

wsrep_provider_options="gcache.dir=/path/to/dir"

1 Like
3

Thanks. How to auto purge those files? My datadir filled up with the files and my cluster failed. I am moving the gcache.page to another directory. The 5 node cluster was in sync.

1 Like
4

Shutdown MySQL, delete them, change the variable, start mysql. They are just cache files and transactions will be fetched if the local node does not have them.

1 Like
5

I am getting the following error

2022-07-12T16:34:01.211301Z 0 [ERROR] [MY-000000] [Galera] deque::_M_new_elements_at_back
2022-07-12T16:34:01.211442Z 0 [ERROR] [MY-000000] [Galera] Failed to create a new provider '/usr/lib/galera4/libgalera_smm.so' with options 'gcache.size = 5G; gcache.dir = /db2/cache;socket.ssl_key=/etc/mysql/percona-cert/server-key.pem;socket.ssl_ca=/etc/mysql/percona-cert/ca.pem;socket.ssl_cert=/etc/mysql/percona-cert/server-cert.pem': Failed to initialize wsrep provider
2022-07-12T16:34:01.211477Z 0 [ERROR] [MY-000000] [WSREP] Failed to load provider
2022-07-12T16:34:01.211505Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-07-12T16:34:01.211748Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.26-16.1)  Percona XtraDB Cluster (GPL), Release rel16, Revision b141904, WSREP version 26.4.3.
1 Like
6

Can the mysqld user access the new directory?

1 Like
7

Yes the mysql user can access the new directory.

1 Like
8

I deleted the galera.cache file which allowed the nodes to join the cluster.

1 Like
9

Is there a way to have them auto purge or limit how many I keep? They are filling up HD space fast, which will lock up my system again.

1 Like