Created 03-16-2018 04:24 PM
i have already de Ranger database with postgres, and i want to migrate to mysql, so please how can do that?
Created 03-16-2018 05:04 PM
There are couple of tools out there bt some come at a price. There is an interesting on found at the Git repository
Introduced the new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. It also provides for generic migrations, i.e. migrations from other RDBMSes that are not explicitly supported, provided that they have a well behaved ODBC driver.
This converter (PostgreSQL to MySQL Converter) The pg2mysql converter is an online tool to convert/migrate existing PostgreSQL databases into MySQL. http://www.lightbox.ca/pg2mysql.php
Hope that helps !!!
Created 03-17-2018 07:15 AM
After the data conversion was successful, there were many error messages that could not be added to the primary foreign key when importing Mysql. I don't know if this has any effect.Thanks.
Created 03-16-2018 06:08 PM
Hi @ay mu,
If you are on the newer releases of ranger you could just create a new ranger database in mysql and import the policies over using the import/export policy feature. https://cwiki.apache.org/confluence/display/RANGER/User+Guide+For+Import-Export
Created 03-17-2018 07:13 AM
Thank you very much.I am now using the 0.5 version of Ranger, ready to upgrade 0.7, while the database is changed from PostgreSQL to MySQL.
I checked the document, Ranger0.5 does not support export import,I will further study.
Created 03-17-2018 09:48 AM
Created 03-17-2018 10:10 AM
Thanks for your reply, it is impossible to reproduce the problem now.
I saw 41 tables in the database ranger0.5 postgresql, but there are 53 tables in the Ranger0.7 mysql database. Is it feasible to migrate from postgres to mysql?
Created 03-17-2018 11:50 AM
If you read the release note for Ranger 0.7 you will realize a lot of enhancements that could explain the difference in the numbers of tables between the 2 versions.
Concerning the migration are you planning to run a complete stack (HDP.2.5 to HDP 2.6) or component (like Ranger 0.5 to Ranger 0.7) migration?
In case it's a complete stack migration then you could try migrating the Ranger 07 database from Postgres to Mysql later. Remember to always run a back before so you can use the dump I am sure the Mysql workbench could do that and in parallel have 2 databases Postgres and MySQL and just change the config files to point to the new Mysql and do some validation tests and once you are satisfied you do the cutover else try to resolve the errors.
All in all I think its doable !