Storing a database e.g. MySQL/Oracle/MSSQL in three different servers

Asked By 0 points N/A Posted on -
qa-featured

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.
 

SHARE
Answered By 0 points N/A #105989

Storing a database e.g. MySQL/Oracle/MSSQL in three different servers

qa-featured

Hello Devan,

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.

__
Regards
Mahesh Babu

 

Login/Register to Answer

Related Questions