InnoDB physical files on MySQL 8.0

Introduction -               MySQL 8.0.10 GPL came out with more changes and advanced features. We have changes on InnoDB physical file layout ( MySQL data directory ) too. This blog will provide the information about the MySQL 8 InnoDB physical files. MySQL system tables are completely InnoDB now ?               Yes, Previously, we don't have too many … Continue reading InnoDB physical files on MySQL 8.0

Advertisements

Descending index in MySQL 8.0

MySQL 8.0 has come with a list of new features for DBA's ,we will discuss the new feature in MySQL 8.0 which supports Descending index.Prior to MySQL 8.0 (i.e MySQL 5.6 and 5.7) creating desc index syntax was supported but desc keyword was ignored, Now in MySQL 8.0 release descending index is extended are supported. … Continue reading Descending index in MySQL 8.0

Presentation : Customer Experience on InnoDB Cluster

  As Mydbops we have consulted  many large scale MySQL deployments. This presentation is about one of our customer who is one of the largest retailer in North America. This is about their data migration to InnoDB Cluster ( MySQL ) from an enterprise database.

Back to basics: Isolation Levels In MySQL

In this blog, we will see the very basic thing "I" of "ACID" and an important property of Transaction ie., "ISOLATION" The isolation defines the way in which the MySQL server (InnoDB) separates each transaction from other concurrent running transaction in the server and also ensures that the transactions are processed in a reliable way. If transactions … Continue reading Back to basics: Isolation Levels In MySQL

Ensure better defaults with InnoDB Dedicated server.

We have seen with most of the consulting projects where the customer might be having a dedicated DB (MySQL) server ,but running with a default configuration, without any optimisation for underlying hardware, "An idle hardware is similar to idle money will give you no returns". Well again if you are from a non-DBA background and you … Continue reading Ensure better defaults with InnoDB Dedicated server.

Presentation : MySQL Timeout Variables Explained

MySQL has multiple timeout variables these slides helps to give an overview of the different  timeout variables and their purposes briefly.

Handling long duration SST(timeout) in PXC with systemd

In this blog post, We will be explaining about the timeouts in SST on systemd implementation which we faced recently in Percona XtraDB Cluster  during our Consulting with a client. State Snapshot Transfers (SST) refers to complete data sync from one of the nodes from the cluster to the joining node. SST will happen for one or … Continue reading Handling long duration SST(timeout) in PXC with systemd

Online Schema Change for Tables with Triggers.

In this post, We will learn how to handle online schema change if the table has triggers. In PXC, an alter can be made directly ( TOI ) on tables with less than a 1G ( by default) , but on a 20GB or 200GB table we need some downtime to do ( RSU ). … Continue reading Online Schema Change for Tables with Triggers.

Presentation: Highly efficient backup with Xtrabackup

  Xtrabackup is the most widely open source hot backup tool for MySQL. Xtrabackup support InnoDB and MyISAM engines.It supports both MySQL Server , Percona Server and MariaDB. This presentation covers some of the important features in Xtrabackup. Pic Courtesy : https://www.flickr.com/photos/robbiewendt/8108744459/

Aurora – The MySQL to be explored

“The MySQL to be explored ” this is what i felt when i worked with it, and just going to share my experience with Aurora . Recently we had an call for MySQL Consulting from one of the famous fantasy gaming site in India, stating that “Database (MySQL) is our bottleneck”, they want it to be … Continue reading Aurora – The MySQL to be explored