Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

migrate postgres database ambari to mysql

Solved Go to solution

migrate postgres database ambari to mysql

Super Collaborator

hi:

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

thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: migrate postgres database ambari to mysql

@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/

2 REPLIES 2

Re: migrate postgres database ambari to mysql

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.

Highlighted

Re: migrate postgres database ambari to mysql

@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/

Don't have an account?
Coming from Hortonworks? Activate your account here