Dmitriy Ivolgin
Dmitriy Ivolgin
1. Install kots with kURL 2. Use Snapshots page to change setting from Internal to S3 3. Take snapshot before restic pods restart. The snapshot will fail. Once Restic pods...
`kubectl schemahero get migrations` command can output a long list of migrations, with potentially repeating names. To find the right migration with a tool like grep, we need to look...
Only show migrations that are pending. Add `--include-applied` flag to include all migrations.
When reconciling a table, always delete the pending migration. If new DDL is empty, then no migration is needed. If new DDL is not empty, it should supersede previous DDL...
The [reconcileMysqlDatabaseSchema](https://github.com/schemahero/schemahero/blob/364934050e5d6b9e5d8fb0b595f8bbcdf2cd3af1/pkg/controller/database/database_schema_controller.go#L85) function is called on startup (or when Database spec changes) and immediately applies changes. It should instead create a Migration called `-database`. The migration should only be applied...
``` apiVersion: schemas.schemahero.io/v1alpha4 kind: Table metadata: name: test spec: database: test name: test schema: mysql: primaryKey: - not_a_column columns: - name: test_id type: varchar (255) constraints: notNull: true ``` The...
Describe output has this ``` To recalculate this migration against the current schema: kubectl schemahero recalculate migration 7173d4a ``` However ``` $ kubectl schemahero recalculate migration 7173d4a Error: unknown command...
``` $ time kubectl schemahero get migrations | wc -l 83 real 0m16.952s user 0m1.501s sys 0m0.446s ```
Schemahero can drop and create an index with the same columns and the same name. It's not clear how to reproduce this condition. ``` Generated DDL Statement (generated at 2021-03-19T09:13:07-07:00):...
#### What type of PR is this? #### What this PR does / why we need it: #### Which issue(s) this PR fixes: Fixes # #### Special notes for your...