Multiple MySQL servers using same mounted data?
I'm in a situation where I have a web interface which relies on a database backend. It would be easier for me if the interface just pointed to 127.0.0.1 for the database which means every server needs to have an instance of mysql running. The catch is they all need to run with exactly the same data in real time, and they will be changing different rows/etc of the same tables sometimes at the same time.
So if I was to mount the physical database files (stored on a single main server) in the same place on every mysql server, would there be any locking issues between the mysql nodes arguing for control, or does mysql handle this type of scenario well? Anyone have any experience in this? Any ideas would be greatly appreciated as it would take some considerable time to set a test environment up.
Thanks for any info.