Author - Sveta Smirnova

Replication Between Two Percona XtraDB Clusters, GTIDs and Schema Changes

Replication Between Two Percona XtraDB Clusters

I got this question on the “How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster (PXC)” webinar and wanted to answer it in a separate post.
Will RSU have an effect on GTID consistency if replication PXC cluster to another cluster?
Answer for this: yes and no.
Galera assigns its own GTID for the operations, […]

Read more

Q & A on Webinar “How Safe is Asynchronous Master-Master Setup in MySQL?”

Q&A Followup

First I want to thank everyone who attended my May 21, 2020 webinar “How Safe is Asynchronous Master-Master Setup in MySQL?“. Recording and slides are available on the webinar page.
Here are answers to the questions from participants which I was not able to provide during the webinar.
Q: What do you generally think of hosting […]

Read more

Daylight Saving Time and System Time Zone in MySQL

daylight savings time in MySQL

March is not only the month when a pandemic closed all borders and people had to stay home on the quarantine; it’s also the month when daylight saving time change happens. For some regions, this is not only a time change but also a switch to a different timezone. For example, New York uses […]

Read more

Q & A on Webinar “Introduction to MySQL Query Tuning for DevOps”

QA Followup

First I want to thank everyone who attended my December 5, 2019 webinar “Introduction to MySQL Query Tuning for DevOps“. Recording and slides are available on the webinar page.
Here are answers to the questions from participants which I was not able to provide during the webinar.
Q: How to find stored execution plans and optimizer […]

Read more