とあるサービスにSchemaPolicyCheckを導入した話
by
HiroakiEitoku
Link
Embed
Share
Beginning
This slide
Copy link URL
Copy link URL
Copy iframe embed code
Copy iframe embed code
Copy javascript embed code
Copy javascript embed code
Share
Tweet
Share
Tweet
Slide 1
Slide 1 text
SchemaPolicyCheck () 2018/12/02
Slide 2
Slide 2 text
• %1: "/ -2 ( ) • : ATK → !,4 • )+203 • .( (SRE) '* • DBFlute &$#
Slide 3
Slide 3 text
LT 1 Before/After 2 SchemaPolicy Tips 3
Slide 4
Slide 4 text
Slide 5
Slide 5 text
• DBA () • DB
Slide 6
Slide 6 text
9 MTG
Slide 7
Slide 7 text
< DB'# &" ' ($ %…) > DBA, !
Slide 8
Slide 8 text
< DB/#+"&.* / (%, -…) > < DB/# '!( $DBA, )
Slide 9
Slide 9 text
< DB1%-$(0, 1 ('." / …) > < DB1%)#* > &DBA, !+
Slide 10
Slide 10 text
• DB0& • !/*', Alter-check. DDL% • 2+32$3. • #-()(8"1)
Slide 11
Slide 11 text
SchemaPolicyCheck
Slide 12
Slide 12 text
Before/After
Slide 13
Slide 13 text
• : 500 • DB: 2~3 •
Slide 14
Slide 14 text
• "# $5DB 3*%: • SchemaPolicyMap & • -/7 140+. • 2:8%4 • 98%4 • '6) • !(2 • … 0,
Slide 15
Slide 15 text
schemaPolicyMap
Slide 16
Slide 16 text
Before → After • • "DDLalter-check • DBA$→% • • "DDLalter-check → SchemaPolicyCheck • DBA#! &
Slide 17
Slide 17 text
After Good(From DBA) • DB%!→30 • DB" • ($'#&) SchemaPolicyCheck
Slide 18
Slide 18 text
After Good • “/ *1%”$0 .2-) • + !4&,( • '3 #( 1%"
Slide 19
Slide 19 text
DB
Slide 20
Slide 20 text
After Bad • $ SchemaPolicyMap% #' • & ! " #'
Slide 21
Slide 21 text
SchemaPolicyTips
Slide 22
Slide 22 text
SchemaPolicyTips •
Slide 23
Slide 23 text
SchemaPolicyTips • • 1. 2. firstDate 3. 1 > 2 > 3 2 : 3
Slide 24
Slide 24 text
SchemaPolicyTips • ! • "
Slide 25
Slide 25 text
SchemaPolicyTips • : XXX_TM DATETIME • XXX_TM • DATETIME
Slide 26
Slide 26 text
SchemaPolicy() • • uniqueTableAlias • • sameColumnNameIfSameColumnAlias
Slide 27
Slide 27 text
SchemaPolicy() • PK # • +*' # • ' !& • $() • %" (')
Slide 28
Slide 28 text
SchemaPolicy() • ,+-AUTO_INCREMENT * • (%) • #/!&DATETIME • '$".BIGINT
Slide 29
Slide 29 text
SchemaPolicy() •