N/APosted on - 11/06/2011
Hello! I like to know whether it is possible to store a database e.g. MySQL/Oracle/MSSQL in three different servers which could be used simultaneously. Your suggestion would be highly appreciated. Looking forward for your response. Thank you.
Storing a database e.g. MySQL/Oracle/MSSQL in three different servers
I am not so sure if that is entirely possible, because what I know as the ideal way is whereby you will store the SQL database in a single directory on your computer, and that means on the same server. But I guess it might be possible if you have all the servers running on the same network and you can access them on the computer that you are using to create the databases, but you will have to alter the SQL statements in that the databases will be stored on the three servers you have.
But if you are creating different SQL databases and you have different servers on the same network, then that will be easy since you will have to define the storage location for each database separately and therefore you can store it on whichever server on the network.