2 nodes on GKE. Persistent Disk on GCE (outside of cluster) being used as PV. Want to create a StatefulSet of SQL Server following the Microsoft documentation. This will generate 1 SQL Server container in one pod per node. So total 1 instance spread over 2 nodes in 2 pods in 2 containers. Concerned that a PV can only be listed as RWO (ReadWriteOnce) and can only attach to one node at a time. I have seen that GKE only allows RWX (ReadWriteMany) on something called a Filestore, not on a PV in GCE. Filestore may be an option but I have not explored it.
Questions follow: If I have a request coming in to the SQL Server on the second node, how does it write to the PV? If the "2nd" SQL Server does not write to the PV, do I need to generate another PV for it to write to? If so, how does it stay in sync with the first? No HA groups.
Have not yet deployed my yaml to K8s