[MDEV-20390] Parse command/tool for galera.cache ring buffer Created: 2019-08-19  Updated: 2023-12-22

Status: Open
Project: MariaDB Server
Component/s: Galera
Fix Version/s: None

Type: New Feature Priority: Minor
Reporter: Vinicius Malvestio Grippa Assignee: Seppo Jaakola
Resolution: Unresolved Votes: 0
Labels: None


 Description   

When we are talking about gcache, I have questions like:
- What is the lower seqnumber stored on gcache
- Which query/event belongs to seqnumber X

I would like to be able to somehow parse the gcache to be able to answer some of those questions. I believe this follows the InnoDB standard, where each information is stored in a specific offset. Like the first 100 bytes are the header of the file, where we store from 1st - 4th byte the version of the file, from 5th - 10th the cluster uuid, ... so on. Can you please point out what is the layout of the file or direct me to the source files where this mapping is defined?

I tried strings but it does not work:

# strings -t d -a -e s galera.cache |  more
      0 Version: 2
     11 GID: 4974e99f-c27a-11e9-842b-e7d05d4d0202
     53 synced: 0
   1434 lK\_
   1442 a?T/
   1506 test

Note: People pointed me to check the binary logs, but for Galera, it is not frequent to have binary logs enabled, so I want a way to extract this information from Galera ring buffer file (aka gcache).



 Comments   
Comment by John Stratoulis [ 2019-11-27 ]

Hello, any solution regarding this?

Comment by Ralf Gebhardt [ 2023-12-22 ]

Hi seppo, I am assigning this community request for you that you can discuss if you think that the request makes sense

Generated at Thu Feb 08 08:59:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.