Re: Two MySQL Server sharing one database (ibdata1) on SAN storage (GFS)

[Phillip Ward]

I would not [ab]use MySQL is this manner.
I would not expect sharing InnoDB data files across multiple instances to work at all.

If all you're doing is pulling the data and displaying it, why not use the original database? MySQL is quite good at supporting that.

If you must have a second database, set up Replication between the two (although that means you will have two complete copies of your data - which isn't exactly a Bad Thing).

Quote

Although data is written into storage (ensured by COMMIT)

Really? I think not.

Going back to the MySQL Administration training course I did many years ago ...

Even if you could run MySQl in this fashion (and you can't), a commit does not flush the dirty [buffer cache] blocks to disk (MySQL uses "adaptive flushing" to optimise the required disk traffic) and so your change won't be visible to the "other" MySQL instance.

Regards, Phill W.