Thanks, it's works. ... View more

I have database replica and physical replication slot. When replica was down, postgers began to save wal journal and them was save all month! When i drop replication slot and clear old wal journal the cpu utilisation return to normal. ... View more

@Jay Kumar SenSharma I already cleaned ambari database --from-date 2019-01-01 now it size is 1200mb, but i have databases "oozie, ranger, hive, airflow" on the same postgres cluster. Should i clean historical data from those databases? HDP cluster is two years old. The most big base now is oozie 12GB ... View more

@Jay Kumar SenSharma Thank you for your answer. I have this "time requests" time curl -i -u admin:* -H 'X-Requested-By: ambari' -X GET http://localhost:8080/api/v1/clusters/DataLake real 0m36.270s user 0m0.020s sys 0m0.184s time curl -i -u admin:* -H 'X-Requested-By: ambari' -X GET http://localhost:8080/api/v1/clusters/DataLake?fields=Clusters/desired_configs real 0m0.190s user 0m0.003s sys 0m0.013s time curl -i -u admin:* -H 'X-Requested-By: ambari' -X GET http://localhost:8080/api/v1/clusters/DataLake?fields=Clusters/health_report,Clusters/total_hosts,alerts_summary_hosts real 0m30.498s user 0m0.002s sys 0m0.011s I think something with database time response, isn't it? ... View more

Thank you for the very helpful article. ... View more

@Geoffrey Shelton Okot Thank you, you are right, the problem was really in zookeeper's acl. I copied everything in "ZooKeeper directory" from Test cluster to Dev cluster and that was help. But i don't know what exactly permission affected it. Is something way to get list all acl permission by Zookeeper? I would like to compare it with all acl from both cluster. ... View more

@Geoffrey Shelton Okot Yes i have ls /config/topics [test1] NiFiClient { com.sun.security.auth.module.Krb5LoginModule required useKeyTab=true keyTab="/etc/security/keytabs/nifi.service.keytab" storeKey=true useTicketCache=false principal="nifi/host@RAIFFEISEN.RU"; }; RegistryClient { com.sun.security.auth.module.Krb5LoginModule required useKeyTab=true keyTab="/etc/security/keytabs/nifi.service.keytab" storeKey=true useTicketCache=false principal="nifi/host@RAIFFEISEN.RU"; ... View more

@Geoffrey Shelton Okot Can i remove zookeeper's trees? Will they be recreate after deleting with right permission? ... View more