topic Re: Problem with MySQL 8.0.x and NetApp snapshot folder in General Discussion

Problem with MySQL 8.0.x and NetApp snapshot folder

VitoMacDoc01 — Wed, 07 May 2025 23:52:27 GMT

I am migrating old CentOS VMs running MySQL 5.x to MySQL 8.0.x that will run on Rocky 8 or 9.

I am installing mysql 8.0.x on the CentOS first, so I can verify all database files are updated and working.

Mysql 8 keeps reading the NetApp .snapshot folder as databases and throwing errors and stopping.

For some reason, this was not an issue in Mysql 5.x.

I did some research and I believe mysql 8 does not have the ignore directory setting anynore

Has anyone had and solved this issue ?

Thank you.

Re: Problem with MySQL 8.0.x and NetApp snapshot folder

Sergey_Osipov — Tue, 10 Jun 2025 11:07:12 GMT

https://kb.netapp.com/on-prem/ontap/da/NAS/NAS-KBs/A_Linux_system_running_kernel_2.6x_creates_a_mount_point_when_accessing_the_.snapshot_directory_via_Network_File_System

Modern Linux clients identifies the .snapshot directory as a different filesystem, and thus as a different mount point

Re: Problem with MySQL 8.0.x and NetApp snapshot folder

VitoMacDoc01 — Tue, 10 Jun 2025 13:38:34 GMT

Thank you for this information, it is very helpful. I did not know 9.5 had this option.

Another solution I read from an AI site is to put all data into a sub directory that does not have the .snapshot folder. Seems like a very simple solution. Data should still get snap saved.

Thank you !!!!! Very much appreciated !!!!

Re: Problem with MySQL 8.0.x and NetApp snapshot folder

Sergey_Osipov — Tue, 10 Jun 2025 13:45:01 GMT

Please bear in mind that

Explicit access to .snapshot directory is still allowed
Clients that explicitly access the .snapshot directory will still show the multiple .snapshot mounts

Meaning volume needs to be remounted after a change

Another option is simply disabling snapdir-access at all

Additionally not even sure what AI suggested to you - feels like not a real advise

Re: Problem with MySQL 8.0.x and NetApp snapshot folder

VitoMacDoc01 — Tue, 10 Jun 2025 14:32:09 GMT

Actually, the AI suggestion was most helpful.

Instead of putting mysql data into the root level of the share which has .snapshot, create a sub directory

instead of /mysql/database, move to /mysql/database/data or something similar

I understand about remounting after change and browsing if needed.

Thank you again, very helpful.