Skip to content

yumaeda/sakaba-migration

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

80 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

sakaba-migration

Preparation

brew install golang-migrate

brew install mysql

 

Create migration files

migrate create -ext sql -dir db/migration -seq <Migration Name>

 

TiDB

Preparation

export DB_ADMIN=xxxx
export DB_PWD=xxxx
export DB_HOST=gateway01.ap-northeast-1.prod.aws.tidbcloud.com
export DB_PORT=4000
export DB_NAME=test

Run migration

migrate -path db/migration -verbose -database "mysql:https://$DB_ADMIN:$DB_PWD@tcp($DB_HOST:$DB_PORT)/$DB_NAME?tls=true&charset=utf8&parseTime=True&loc=Local" up
  • schema_migrations table stores the migration version and the status of the last migration.

Connect

mysql --comments -u $DB_ADMIN -h $DB_HOST -P $DB_PORT -D $DB_NAME --ssl-mode=VERIFY_IDENTITY --ssl-ca=/etc/ssl/cert.pem -p$DB_PWD

SET GLOBAL tidb_skip_isolation_level_check=1;

About

Repository for Sakaba Link Database Migration

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published