Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

where do people place their multi user meta store? I'm going to use mysql but I don't know were I should stick it. on the name node or on its own server?

share|improve this question

Hadoop can really trash the page buffers on a datanode so you probably will do well to keep mySQL off of any of them.

The recommendation to run Hive outside the cluster is a very good one, if only because you will have serious balance problems if you run it inside the cluster.

share|improve this answer

It can be on any machine really.

We installed hive on a node that is not a cluster member (but is only used for staging data to load into hive) and setup the metastore mysql instance there.

share|improve this answer

Your Answer

 
discard

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