Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I've bought 2 hp G3 servers with Smart Array 5I Storage Controller, how can I install the MYSQL on the array storage so that the linux on both server can read the DB, I'm kinda lost here.

This is what I need exactly, install linux on both G3 servers, and both of them need to be able to reach a shared DB, how can I do that?

share|improve this question

migrated from stackoverflow.com Mar 27 '12 at 8:26

This question came from our site for professional and enthusiast programmers.

    
is this for HA, or do you just need to connect to the database from both servers? –  Jack Douglas Mar 27 '12 at 9:43

1 Answer 1

While doing this is very easy I really have to suggest that you don't do it, unless you are talking about read-only databases. Having multiple instances of any database server working on the same set of files is a sure road to disaster. The sensible way is to create a master/slave or even master/master replication pair.

However, if you absolutely feel the urge to do this anyway just install the two instances as usual, then alter the configuration of one or both to point to the desired data directory.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.