[jira] [Resolved] (AMBARI-23009) Refactor Repository/Desired FK for All Tables

["Jonathan Hurley (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/AMBARI-23009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Hurley resolved AMBARI-23009.
--------------------------------------
    Resolution: Fixed

> Refactor Repository/Desired FK for All Tables
> ---------------------------------------------
>
>                 Key: AMBARI-23009
>                 URL: https://issues.apache.org/jira/browse/AMBARI-23009
>             Project: Ambari
>          Issue Type: Epic
>            Reporter: Jonathan Hurley
>            Assignee: Jonathan Hurley
>            Priority: Blocker
>         Attachments: ERD.png
>
>
> We need to remove/refactor the {{repo_version}} table.  This means the relationships tied to {{repo_version}} will also need to be replaced. Some of the high-level work items are:
> - Associate MPack's with Repositories
> - Remove {{host_version}} and add new relationships for mpack installations on hosts
> - Change Upgrades to track Mpacks not repos
>  !ERD.png! 
> \\
> - Removed repo_version table as it no longer serves a purpose (multiple mpacks of different versions can now come from the same repo)
> - Replaced the {{host_version}} table with {{mpack_host_state}} to represent whether an mpack was correct installed on appropriate hosts
> - Changed upgrade history to track the differences between 2 mpacks for a service group. This links back to an upgrade as well so we can have 2 SG's with 2 mpack source/targets in a single upgrade (think HDPCore and EDW in 1 upgrade plan)
> The entity associations would look like:
> {code}
> /*
> Each Mpack has a collection of OS's, each OS with different URLs
> Redhat6, Redhat7, Ubuntu12
> */
> MPackEntity.getRepos() -> List<RepoOSEntity>
> /* 
> The OS can have any number of URLs
> HDP: http://repo.ambari.apache.org/hdp
> HDP-UTILS: http://repo.ambari.apache.org/hdp-utils
> HDP-GPL: http://repo.ambari.apache.org/hdp-gpl
> */
> RepoOsEntity.getRepoDefinitions() -> List<RepoDefinitionEntity>
> /*
> HDP-Core-Default
>   Mpack 3.0.0.0 -> 3.0.0.1
>   MPack 3.0.0.1 -> 3.1.0.0
> */
> ServiceGroupEntity.getUpgradeHistory() -> List<UpgradeHistory>
> UpgradeHistoryEntity.getSourceMPack() -> MPackEntity
> UpgradeHistoryEntity.getTargetMPack() -> MPackEntity
> /*
> Mpack HDP Core 3.0.0.0 -> Hosts 1, 2, and 3 are OK
> Mpack HDP Core 3.1.0.0 -> Hosts 1 and 2 are OK, Host 3 is INSTALL_FAILED
> */
> MPackEntity.getHostInstallState() -> List<MPackInstallState>
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)