Others :Database Maintenance
- Rajeev Rai
Table Of Content
Prerequisite:
Take the downtime from the client.
Pause the scheduler
Scale down the webrunner pod.
Run the below query to identify the free space in the Database.
SELECT table_schema "DataBase Name",
sum( data_length + index_length ) / 1024 / 1024 "Database Size in MB",
sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES GROUP BY table_schema;
Refer the below link for the table for which we have to perform cleanup
https://support.adeptia.com/hc/en-us/articles/207881923-Truncate-Log-Tables-Manually
Run the optimize query “OPTIMIZE TABLE tablename;” This query will create a lock on the table and then create a new table with the same name and same data.
Post maintenance:
Run the above query (point4) to verify the free space
Scale up the webrunner pod
Resume the scheduler
Drop confirmation email to client.
Monitoring CPU and Memory Utilization Trend:
Login into the Client grafana.
Navigate to the dashboard and select kubernetes-compute-resources-namespace-pods dashboard.
Verify the CPU trend.
Monitoring Disk Utilization Trend:
Login into the Client grafana.
Navigate to the dashboard and select kubernetes-persistent-volumes dashboard.
Verify the Disk utilization trend.
Log and Archival Cleanup Review:
Login into environment of each customer
Navigate to the system console page and verify the cleanup
Certificate Expiry:
Take the backup of the cacert file.from below location
Place the new cert in the same location
Run the below command to add the new certificate in the cacert
keytool -import -trustcacerts -alias BOSAPIProdCert -file "D:\BOS\certs\16_may_2023\apim.sfs.operations.dynamics.com_prod.crt" -keystore "D:\BOS\certs\16_may_2023\cacerts"
Restart the webrunner and runtime microservices.
License Expiry:
We receive mail notification 1 month prior to license expiration.
Get the latest license from Gaurav Gautam.
Place the latest license into the /shared/license location
Restart the license pod.
Regency patch upgrade:
Login into the regency environment using a remote desktop.
Scale down the webrunner and kernel
Navigate to windows update.
Click on update and restart the windows
Verify again if any other updates are pending
Once Windows is uptodate.
Restart the kernel and webrunner.