question Re: Migrating ambari database from one host to other in Archives of Support Questions (Read Only)

Migrating ambari database from one host to other

arunpoy — Fri, 06 Jan 2017 19:55:02 GMT

We are running our ambari database with mysql on a dedicated host. Now we need to move the DB to a different host. what are the steps that needs to be done to make this migration smooth and retain all the data in the new database on the new host.

Re: Migrating ambari database from one host to other

apathan — Fri, 06 Jan 2017 19:59:18 GMT

@ARUN Please refer to the below documentation for moving ambari database to the new host.

http://docs.hortonworks.com/HDPDocuments/Ambari-2.4.1.0/bk_ambari-reference/content/ch_amb_ref_moving_the_ambari_server.html

Re: Migrating ambari database from one host to other

jsensharma — Fri, 06 Jan 2017 20:01:44 GMT

@ARUN

1. Stop ambari server

2. Take your Ambari DB dump.

Example:

pg_dump -U ambari ambari > /tmp/ambari_bk.psql
mysqldump -u ambari ambari > /tmp/ambari_bk.mysql

3. Now on the other Host import the mentioned DB dump. And moke sure that the new DB host is accessible from ambari server.

4. Now edit the ambari.properties " /etc/ambari-server/conf/ambari.properties" and add the correct JDBC URL to point to the new host:

Example:

server.jdbc.url=jdbc:oracle:thin:@oracle.database.hostname:1521/ambaridb

5. Now try restarting ambari server.

Re: Migrating ambari database from one host to other

jsensharma — Fri, 06 Jan 2017 20:07:06 GMT

@ARUN

Also please check the ambari.properties and change the persistence type to remote when the DB is moved

server.persistence.type=local
to
server.persistence.type=remote

You can import the mysql dump as following on the remote Mysql host:

mysql -u ambari -pbigdata ambari < ambari_mydb_current.sql

Also please refer to the following link for preparing the mysql on the new host. (before importing the dump) http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.0/bk_ambari_reference_guide/content/_using_ambari_with_mysql.html

Before importing the dump you might want to create the DB users and grand desired permissions as mentioned in the above link

Re: Migrating ambari database from one host to other

arunpoy — Fri, 06 Jan 2017 20:39:11 GMT

Thanks @Jay SenSharma. it really helps