Create a Separate Database and Store Configs (Recommended)

Pre-upgrade

Before proceeding with the upgrade, ensure to execute the following command:

Bash
    
 
create database service_conf_bck;use service_conf_bck;CREATE TABLE IF NOT EXISTS configs_prior_patch ASSELECT    cc.config_id,    cc.type_name,    cc.config_data,    cc.config_attributes,    service_name,    sc.version,    sc.note,    (SELECT MAX(version) FROM ambari.serviceconfig s     WHERE s.service_name = sc.service_name) AS max_versionFROM    ambari.serviceconfig scINNER JOIN    ambari.serviceconfigmapping scmON    sc.service_config_id = scm.service_config_idINNER JOIN    ambari.clusterconfig ccON    cc.config_id = scm.config_idWHERE    sc.service_name IN (<service-name-1>,<service-name-2>,.....);
Copy

Post-upgrade

After completing the upgrade, to restore the configurations for a specific service, execute the following code:

Bash
    
update clusterconfig a set config_data = (select config_data from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM service_conf_bck.configs_prior_patch WHERE service_name = <service-name>) and service_name = <service-name>),    config_attributes = (select config_attributes from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM serviceconfig WHERE service_name = <service-name>) and service_name = <service-name>)    where config_id in (select config_id from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = <service-name> and version =    (select max(version) from serviceconfig where service_name = <service-name>)) );
Copy

For example, in the below code we have taken a backup for configurations of NiFi, Tez, and Spark3:

Bash
    
​x
 
create service_conf_bck;use service_conf_bck;​​CREATE TABLE IF NOT EXISTS configs_prior_patch ASSELECT    cc.config_id,    cc.type_name,    cc.config_data,    cc.config_attributes,    service_name,    sc.version,    sc.note,    (SELECT MAX(version) FROM ambari.serviceconfig s     WHERE s.service_name = sc.service_name) AS max_versionFROM    ambari.serviceconfig scINNER JOIN    ambari.serviceconfigmapping scmON    sc.service_config_id = scm.service_config_idINNER JOIN    ambari.clusterconfig ccON    cc.config_id = scm.config_idWHERE    sc.service_name IN ('NIFI','TEZ','SPARK3');
Copy

After the upgrade, to restore NIFI configurations, the following command was run in mysql:

Bash
    
update clusterconfig a set config_data = (select config_data from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM service_conf_bck.configs_prior_patch WHERE service_name = 'NIFI') and service_name = 'NIFI'),    config_attributes = (select config_attributes from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM serviceconfig WHERE service_name = 'NIFI') and service_name = 'NIFI')    where config_id in (select config_id from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'NIFI' and version =    (select max(version) from serviceconfig where service_name = 'NIFI')) );
Copy

Last updated on Jan 29, 2026

Was this page helpful?