look into binlogs

@MySQL Casual Talks vol.12

Transcript

1. {
   2 TR HT A : 5 X Q B QPX TQ (
   

   View Slide

2. UPN@@CP
   • 6 H X 7SMOS W 2:9 7
   • A : TU W OTS
   • @ A : W @ UQ W 0
   • TWIN X W TW
   •
   • A : D PQ 0
   • N UX0 R X Q PQ N S HQTM ITR
   • A : HQ XO_ X OR TW
   • N UX0 MO N H ITR TR HT HQ XO_ X OR TW
   • X XH SIN R X Q X W0
   • N UX0 MO N H ITR TR HT X XH SIN R X Q TTQ
   O W0 2 TR HT
   MO N H0 TR HT
   N S HQTM O 0 TR HT
   (
   

   View Slide

3. |p
   • n
   • HOSQTM~
   • HOSQTM
   • HOSQTM
   • R HOSQTM
   • R HOSQTM HOSQTM
   •
   )
   

   View Slide

4. f o D
   • WITS :O ( /
   • L I HTTP HOSQTM o p n
   • BA k n k l HOSQTM t“ p n
   k
   • 84 X g kt~o
   • X Q I w k
   • A : T ST A : H X g p kne
   

   View Slide

5. • A :o g l cOSST H QTM D3: ~
   • HOSQTM W UQOI v W Q QTM~w v cW UQOI
   ” R X W~ x y
   +
   a g A : g b U)( +
   

   View Slide

6. e
   • HOSQTM OS
   • w k HOSQTM w k g
   • w k HOSQTM o n k
   • HOSQTM S
   • HOS W QTMo k
   • o,
   • R HOSQTM XO_ o v
   • w o “ rt~ k
   ,
   

   View Slide

7. t dg
   • HOSQTM LTWR
   • X R S 0 w ““ ~w QTM q
   • WT 0 u~ QTM q
   • RO 0 X R S ~WT kk~t
   • HOSQTM WT OR M HOSQTM LTWR 1 WT
   • L QQ 0 y
   • ROSOR Q 0 ~c v
   • STHQTH 0 4:=4 B7EB
   -
   

   View Slide

8. c y i
   • R X QHOSQTM
   • A : v k HOSQTMn y g
   • HOSQTM w A : c ““ A : p
   • 9B@ v
   .
   

   View Slide

9. • R X QHOSQTM ST L Q X H X , T U 1675=67 @=DA HOSQTM /
   /
   

   View Slide

10. • R X QHOSQTM ST L Q X H X , T U 1675=67 @=DA HOSQTM /
    

    View Slide

11. • R X QHOSQTM ST L Q X H X , T U 1675=67 @=DA HOSQTM /
    

    View Slide

12. v }lu
    (
    

    View Slide

13. }lu
    •
    • 9S WS Q R S Q
    • R X Q X W W g
    • X Q X Q HOSQTM II
    • X Q QTM S N
    • IQO S R X QHOSQTM II
    • OSIQ R X Q ITR N
    • OSIQ R X Q N UU
    • OSIQ LO Q U X N
    • I
    • HOSQTM
    • t ~
    • k o “y
    N UX0 R X Q ITR TI OS WS QX S HOS W QTM N RQ
    )
    

    View Slide

14. • HOSQTM LOQ H zc
    L ,( ,/ ,
    “ L bHb aOb bSb
    • H S ~kl
    A : c
    y g o
    v k
    }lu
    HOSQTM WT MN XP IN
    L HOS S
    S (
    S
    S
    S )
    S +
    d
    d
    d
    

    View Slide

15. }lu
    • S N W~ n
    • N W LOQ
    • S
    • WXOTS
    • WXOTS 0 CX OS ) ()
    • WXOTS )0 CX OS (
    • WXOTS 0 CX OS + S U
    S X W I W
    +
    

    View Slide

16. s bw L
    • LTWR XIWOU OTS S
    • HOSQTM
    • HOSQTM g cN W LO U W y
    • WT S
    • HOSQTM
    • HOSQTMo g g v n
    • X TU S
    • HOSQTM
    • A :o v t~ y
    • wkHOSQTM o
    ,
    

    View Slide

17. • HOSQTM WXOTS
    •
    • X W WXOTS
    • IW OR X RU
    • N W Q SM N
    • N W v0 /
    • UTX N W Q SM N
    • S u~ H
    LTWR XIWOU OTS S
    -
    

    View Slide

18. qm e a
    • W QTM S
    • X R S H X QTMMOSM ms
    • OS W S
    • W QTM S T OSIW R S Q X OSX W O
    • HQ R U S
    • g ~
    • WO WT X S U WT X S Q WT X S
    • WT H X QTMMOSM ms
    .
    A4:0 A R S 4 X :TMMOSM
    @4:0 @T H X :TMMOSM
    

    View Slide

19. • WT LTWR 1 X R S
    ~p q
    • W ~w
    “ k
    /
    

    View Slide

20. • W QTM S
    y
    • TU OTS
    • 0 Q o T OSIW R S
    • (0 Q oQ X OSX W O
    (
    

    View Slide

21. • WT H X QTMMOSM ~p c
    HQ
    y y
    • R X W~W UQOI g o
    l l“q g
    p l y wk
    (
    

    View Slide

22. :
    • WT H X QTMMOSM y
    y
    • U H LTW OR M ~
    L W OR M o c
    WO Q L W OR M
    • X OXS QQ y
    HO t~ o
    OR M n QQ HQ n
    y
    ((
    

    View Slide

23. • HOSQTM g c w q g
    • t g o w“y
    ()
    

    View Slide

24. qm _
    (
    

    View Slide

25. t i M
    • MOX
    • N UX0 MOX MO N H ITR TR
    HT ,)+I HH /( ( + IH , ( H
    (+
    

    View Slide

26. L
    • 6 : QT LOQ q
    • W QTM S
    • WO WT X S
    • U WT X S
    • Q WT X S
    • A4: @4: z
    W QTM S bH MOSbn “
    • O S o
    (,
    

    View Slide

27. n D
    • R HOSQTM
    • + v S g
    • H LTW OR M L W OR M s HQ R UUOSM
    • s
    • HOSQTM g g
    • LQ XNH IP fe
    • HOSQTM WT OR M 1 L QQo
    • HOSQTM
    (-
    

    View Slide