Collecting and Comparing OceanBase Parameters Using Shell Scripts and Excel VLOOKUP
This article explains how to use Shell scripts together with Excel VLOOKUP to extract OceanBase cluster Parameters, Variables, and ProxyConfig values, compare them against default or DBA‑tuned settings, and generate a report that highlights unexpected configurations for manual verification.
Background: The client needed to record current OceanBase cluster Parameters, Variables, and ProxyConfig values before go‑live, compare them with default or DBA‑tuned values, and generate a report highlighting unexpected settings for manual verification.
Implementation: A Shell script extracts the default Parameters, Variables, and ProxyConfig from both primary and standby clusters and saves them as CSV files, which are then imported into Excel as “default value templates”. The three scripts are available on GitHub.
Extraction: DBA‑tuned parameters are also exported and placed into a separate Excel sheet named “刷参数默认值模板”.
Comparison: In production, the script is run again, the results are loaded into Excel, and VLOOKUP formulas are used to compare each parameter against the templates; mismatches are highlighted with red shading. Example formula used:
=IFERROR(IF(B2=VLOOKUP(A2,variables模板!A:B,2,FALSE),"一致","不一致"),"不存在")Manual Confirmation: Parameters that do not match expectations are reviewed with the client for possible remediation.
Conclusion: OceanBase currently lacks built‑in tracking of parameter changes; this method provides a practical way to archive and compare parameters, requiring updates to the Excel templates when parameters change, and enabling traceability after deployment.
Aikesheng Open Source Community
The Aikesheng Open Source Community provides stable, enterprise‑grade MySQL open‑source tools and services, releases a premium open‑source component each year (1024), and continuously operates and maintains them.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.