migrate postgres database ambari to mysql

[#1]

hi:

i have already de ambari database with postgress, and i want to migrate to mysql, so please how can do that???

thanks

[#2]

For moving data between Postgres and some target database, we leave that to the customer to handle the migration (using whatever utility they have available / preference for). Once the data is moved from db1 -> db2, then the we should perform an "ambari-server setup" again and choose to change the advanced database configuration to point to your new database.

[#3 · Accepted solution]

@Roberto Sancho

Following two articles will give little more detailed steps to accomplish the same task.

[1] MySQL setup for Ambari

https://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.0/bk_ambari_reference_guide/content/_using_am...

[2] How do I change an existing Ambari DB Postgres to MySQL?

http://www.hadoopadmin.co.in/bigdata/how-do-i-change-an-existing-ambari-db-postgres-to-mysql/