question Can one use a single database server for hosting Ambari database for multiple clusters? in Archives of Support Questions (Read Only)

Can one use a single database server for hosting Ambari database for multiple clusters?

aervits — Fri, 22 Apr 2016 01:32:19 GMT

Picture a scenario where you have one MySQL database server and I'd like to run two Ambari managed clusters. Would name collision occur if 2nd cluster tried to create a database on the same server? Can you use a different name for Ambari database?

Re: Can one use a single database server for hosting Ambari database for multiple clusters?

emaxwell — Fri, 22 Apr 2016 01:37:23 GMT

@Artem Ervits

This can definitely be done, but you'll need a different "database" (MySQL parlance) or "schema" (Oracle, DB2 parlance) for each Ambari cluster. For example, you might create an "ambari-Prod1" database or schema for the Prod1 HDP cluster and an "ambari-Test2" database/schema for the Test2 HDP cluster.

Re: Can one use a single database server for hosting Ambari database for multiple clusters?

aervits — Fri, 22 Apr 2016 01:47:39 GMT

thanks, I'm going to test this right now. Stay tuned for your 10 points :).

Re: Can one use a single database server for hosting Ambari database for multiple clusters?

nsomasundaram — Fri, 22 Apr 2016 02:45:05 GMT

+1. You need a different database for each Ambari server. These databases can be on the same SQL server. All that Ambari requires is a connection string.

Re: Can one use a single database server for hosting Ambari database for multiple clusters?

aervits — Fri, 22 Apr 2016 08:45:05 GMT

It's turning out more time consuming than I thought. Two things I noticed is first, you cannot have upper case letters in database name and second, after you run setup, it asks you to run a SQL file with schema DDL, in case of Postgres, it always asks to run EMBEDDED DDL SQL which doesn't work. Still struggling with this use case. @emaxwell @Nahappan Somasundaram

Re: Can one use a single database server for hosting Ambari database for multiple clusters?

bcobb — Fri, 08 Jul 2016 23:27:01 GMT

@Artem Ervits This is a long standing bug in Ambari setup. For an external Postgres database the script is:

Ambari-DDL-Postgres-CREATE.sql