mySQL db from both Windows and UNIX

Customer Support H-Sphere Reseller Hosting
1

Hi

Can someone please tell me (before I waste lots of time) whether a mySQL database can be accessed by several domains - some hosted on a Windows Server Account and some hosted on a UNIX Server Account?

This would be ideal I have a mySQL database that is/will be accessed by 2 domains hosted on UNIX but I want to rewrite one of the domains utilising asp.net so need it to access mySQL from a Windows Server

Thanks

Kevin

2

Should be fine as long as you don’t get select/insert conflicts on the same tables. :slight_smile:

if you are using different tables or table prefixes, I don’t see any issue unless you forget to close connections, but that could be a problem with a single domain/server accessing it as well.

3

Hi Stephen

Thanks for that

4

I have done this quite successfully. However, I’m doing reads so I don’t have to worry about the insert/update conflicts Stephen wisely warns about.

Tim