<p>I have a 3 node cluster. What I am going to do is create a persistence volume with <strong>ReadWriteMany</strong> access mode for MySQL Deployment. Also, Mount Option is GCEPersistentDisk.
My question is if I could use ReadWriteMany access mode for MySQL deployment, Will it be an issue? Because the volume can be mounted by many nodes. if I am wrong please correct me.</p>

YMA
<p>GCE persistent disks do not support ReadWriteMany. You can see this here in the documentation:   `
<a href="https://cloud.google.com/kubernetes-engine/docs/concepts/persistent-volumes#access_modes" rel="nofollow noreferrer">https://cloud.google.com/kubernetes-engine/docs/concepts/persistent-volumes#access_modes</a></p>
<p>However, there is a workaround to achieve the same with a NFS server:<br />
<a href="https://medium.com/@Sushil_Kumar/readwritemany-persistent-volumes-in-google-kubernetes-engine-a0b93e203180" rel="nofollow noreferrer">https://medium.com/@Sushil_Kumar/readwritemany-persistent-volumes-in-google-kubernetes-engine-a0b93e203180</a></p>
<p>I wouldn't recommend this as the MySQL performance will be suboptimal, though. Consider using a <a href="https://cloud.google.com/sql" rel="nofollow noreferrer">Cloud SQL</a> instance instead, and connecting from multiple nodes nodes to that using MySQL protocol instead of accessing the disk.</p>
