ranger-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pradeep Agrawal <pradeep.agra...@freestoneinfotech.com>
Subject Re: Review Request 64869: RANGER-1930 : Add consolidated db schema script for all supported DB flavor
Date Tue, 16 Jan 2018 09:42:31 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/64869/#review195443
-----------------------------------------------------------


Ship it!




Ship It!

- Pradeep Agrawal


On Dec. 29, 2017, 9:51 a.m., bhavik patel wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/64869/
> -----------------------------------------------------------
> 
> (Updated Dec. 29, 2017, 9:51 a.m.)
> 
> 
> Review request for ranger, Ankita Sinha, Don Bosco Durai, Gautam Borad, Abhay Kulkarni,
Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Selvamohan Neethiraj, Sailaja Polavarapu, and
Velmurugan Periasamy.
> 
> 
> Bugs: RANGER-1930
>     https://issues.apache.org/jira/browse/RANGER-1930
> 
> 
> Repository: ranger
> 
> 
> Description
> -------
> 
> Currently Ranger installation with different DB Flavors are taking lot of time in some
environment due to execution of many db and java patches or due to latency issues.
> 
> To avoid this issue before installing Ranger, User can separately run this script to
reduce db setup and installation time.
> 1) Execute DBA setup and ensure that ranger-admin user & database are created.
> 2) From a Client tool execute ranger_core_db_<DB FLAVOR>.sql file on the database
created in previous step.
> For Exampele : 
> For mysql DB, run following command: 
> mysql -u username -p database_name < /file_path/file.sql
> 
> 
> Diffs
> -----
> 
>   security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql PRE-CREATION 
>   security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql PRE-CREATION 
>   security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql PRE-CREATION

>   security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql PRE-CREATION

>   security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql d5af82b

> 
> 
> Diff: https://reviews.apache.org/r/64869/diff/1/
> 
> 
> Testing
> -------
> 
> After manually importing Ranger Schema from given patch: 
> 1) DB schema creation and java patch execution was skipped during Ranger installation
and patches were marked executed in x_db_version_h table (manual installation).
> 2) For Ambari based installs  of Ranger - start time for Ranger service reduces,as schema
was imported using given patch. 
> 3) Ranger Admin, Ranger KMS started successfully.
> 4) Also verified CRUD operations related to users/groups and policies/services.
> 
> 
> Thanks,
> 
> bhavik patel
> 
>


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message