4 ms·
How easy is it to verify that the configuration of your database matches a checked-in configuration or source file these days? My beef with a lot of installed p
by joeblubaugh 4y ago
How easy is it to verify that the configuration of your database matches a checked-in configuration or source file these days? My beef with a lot of installed procedures in a SQL database comes down to deployment and rollback difficulty.
- mh- 4y agoDepends on the DBMS, but pt-config-diff works well for MySQL. edit: This will only help for configuration, not procedures. https://docs.percona.com/percona-toolkit/pt-config-diff.html https://docs.percona.com/percona-toolkit/pt-config-diff.html
- Wicher 4y agoFor Postgres views, materialized views, functions and triggers I've made a tool that can do that, DBSamizdat: https://sr.ht/~nullenenenen/DBSamizdat https://sr.ht/~nullenenenen/DBSamizdat