Problem with MySQL 8.0.x and NetApp snapshot folder

[VitoMacDoc01]

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.

[Sergey_Osipov]

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...

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

[VitoMacDoc01]

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 !!!!

[Sergey_Osipov · Accepted solution]

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

[VitoMacDoc01]

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.