mySQL db from both Windows and UNIX

K

kjedwards

Guppy
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
 
Should be fine as long as you don't get select/insert conflicts on the same tables. :)

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.
 
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
 
You must log in or register to reply here.
Back
Top