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

Asked By Devan 0 points N/A Posted 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.
 

• Status: Open
• Question Views: 741
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Mahesh Babu 20 points N/A #105989

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

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

 

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/23/2011
• Question Category: Misc Databases