GTIDs Explained

50 %
50 %
Information about GTIDs Explained

Published on March 11, 2014

Author: izoratti



I presented these slides at the London MySQL Meetup on Thursday 6 March 2014

Ivan  Zoratti   GTIDs  Explained MySQL 5.6, MariaDB 10, Galera 3 V1403.01

MySQL  5.6  Replication 2 M1 S1 S2 S3

GTID  in  MySQL  5.6 3 3E11FA47-71CA-11E1-9E33-C80AA9429562:23 Transaction  ID   Sequence  number  determined  by  the  order  in  which   the  transaction  was  committed  on  this  server   ! Transaction  ID  =  =  Sequence Source  ID
 Identifies  the  originating  server
 ! Source  ID  =  =  Server  UUID

GTID  in  MySQL  5.6 •Used  to  identify  a  transaction  in  a  MySQL  5.6  Cluster   •Sets  are  also  allowed  to  identify  an  interval  of  transactions   •Preserved  between  masters  and  slaves,  i.e.  they  identify  the  source  (origin)  of  a  transaction   •Transactions  with  the  same  GTID  cannot  be  applied  more  than  once   •Benefits   •Simplified  failover  (with  CHANGE  MASTER  TO  and  MASTER_AUTO_POSITION=1)   •Guarantees  slave  consistency  by  checking  Executed_Gtid_Set 4

Galera  Cluster • Read  &  Write  access  to  any  node   • Client  can  connect  to  any  node   • There  can  be  several  nodes   • Automatic  node  provisioning   • Replication  is  synchronous 5

GTID  in  Galera  3 •Used  to  identify  a  state  change   •i.e.  to  identify  write  operations  to  the  database   •Used  to  identify  the  state  itself   •i.e.  the  last  state  change 6

GTID  in  Galera  3 7 ! 45eec521-2f34-11e0-0800-2a36050b826b:94530586304 An  ordinal  sequence  number  (seqno,  64-­‐bit  signed   integer)  to  denote  the  position  of  the  change  in  the   sequence   ! Sequence  =  =  Change  in  the  Cluster State  UUID
 I  uniquely  identifies  the  state  and  the  sequence  of  changes  it   undergoes   ! UUID  =  =  Cluster  ID

GTID  in  Galera  3 •A  Galera  Cluster  acts  as  a  single  node   •No  holes  in  the  sequence   •Stored  in  grastate.dat   •5ee99582-­‐bb8d-­‐11e2-­‐b8e3-­‐23de375c1d30:8204503945773  <<<  Typical  sequence   •5ee99582-­‐bb8d-­‐11e2-­‐b8e3-­‐23de375c1d30:-­‐1  <<<  The  node  has  crashed   •00000000-­‐0000-­‐0000-­‐0000-­‐000000000000:-­‐1  <<<  The  node  has  crashed  during  the   execution  of  a  non  transactional  operations  (e.g.  a  DDL  op)  or  the  op  has  been  aborted 8

MariaDB  10  Replication 9

GTID  in  MariaDB  10 10 ! #131109 14:59:59 server id 1 end_log_pos 4151 GTID XXX-YYY-ZZZ /*!100001 SET @@session.gtid_seq_no=ZZZ*//*!*/; Sequence  Number   64bit  unsigned   It  increases  monotonically  at  each  commit   It  is  applied  for  each  Event  Group,  i.e.,  for  each  BEGIN/COMMIT  or   for  groups  that  have  no  BEGIN/COMMIT
 (for  example  DDL  commands,  TRUNCATE  and  others) Server  ID   32bit  unsigned   The  server_id  value  for  the   MariaDB  instance Domain  ID   32bit  unsigned   The  domain_id  value  for  the   Replication  stream

GTID  in  MariaDB  10 •1  GTID  for  each  event  group   •Groups  can  be  executed  in  parallel   •Transaction  safe  (stored  in  an  InnoDB  table,
 not  in  a  file)   •MASTER_USE_GTID=gtid_slave_pos  -­‐  great  to  position/reposition  slave  nodes   •Domain  ID  is  used  to  guarantee  that  this  works  with  multi-­‐source  replication 11

Add a comment

Related pages

Grid Trading explained - YouTube

In this video I will explain the basics of a grid trading system: 1. How it works 2. When to use it Enjoy and thumbs up if you like it! Leave a ...
Read more

The Smart Grid Explained - An Understanding for Everyone ...

EPCE, the Energy Providers Coalition for Education ( with Common Craft present this video intended to provide a simple ...
Read more

Solar Explained | Microgrid Solar

Solar Explained Like a lot of good things, solar is simple. Solar Panels. Solar panels are installed on your roof or a nearby structure. These panels are ...
Read more

Smart Grid Explained by Common Craft (VIDEO)

This video focuses on the basic ideas that make up the smart grid, which is the next generation of the network that delivers electricity to our homes.
Read more

Triads explained - Works Management

As the National Grid prepares to make its annual triad announcement this month, Ian Preston, head of direct & technical sales at npower, demystifies energy ...
Read more

The Smart Grid Explained - Renewable Energy World

The Smart Grid is an intriguing but elusive concept. What exactly do we mean when we talk about the intelligent grid? And where does renewable energy fit ...
Read more

Bootstrap 3 Grids Explained | Jetstrap Blog

Update: on August 19th this post was updated to reflect the big changes made to Grids in Bootstrap 3 Final. Over the last week, I’ve spent a lot of time ...
Read more

In-Memory Data Grids Explained - DZone Big Data

In-memory processing has been a pretty hot topic lately. Many companies that historically would not have considered using in-memory technology because it ...
Read more

In-Memory Data Grids… Explained. - DZone Cloud

Many companies that would not have considered using in-memory technology in the past due to its cost are now changing their core systems’ architectures to...
Read more