As the title suggests, I need to set up MySQL database which can be accessed by two (or more) different sites. The only snag with this is that we need to run a windows service alongside it (this is a 3rd party app and can't be rewritten).
We have some ambitions to move more of our internal services into the cloud over time, so we're taking this as an opportunity to take some first steps, but I'm unsure as to what options are available or feasible.
From what I've read of each, given that we need to be running MySQL, we'll end up having to run a full VM, even on Azure/EC2.
Is there another way to do this? Have I massively misunderstood what's possible or even necessary? If not, what benefits would Azure/EC2 offer over a VM host (or even a co-located box)? (and vice-versa?)