Aug 25, 2023 |
Insight for DBAs, MySQL
This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. To know more about the deployments of these topologies, you can refer to the manuals – InnoDB Cluster and Innodb ClusterSet setup. In the below snippet, we have two clusters (cluster1 and cluster2), which are connected via an […]
Aug 17, 2023 |
Insight for DBAs, MySQL
This blog post will cover the basic setup of the InnoDB ClusterSet environment, which provides disaster tolerance for InnoDB Cluster deployments by associating a primary InnoDB Cluster with one or more replicas in alternate locations/different data centers. InnoDB ClusterSet automatically manages replication from the primary cluster to the replica clusters via a specific ClusterSet Async replication […]
May 02, 2023 |
Insight for DBAs, MySQL, Percona Software, Security
Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns. The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other third-party team troubleshoot database-related issues. In this context, pt-secure-collect is a very important utility from Percona, which helps capture the […]
Dec 02, 2022 |
Database Trends, Insight for Developers, MySQL, Open Source
Database-as-code service is a new concept and gaining some popularity in recent years. As we already know, we have deployment solutions for application code. Managing and tracking application changes are quite easy with tools like Git and Jenkins. Now this concept is applied in the database domain as well, assuming SQL as a code to […]
Nov 25, 2022 |
Cloud, Insight for DBAs, MySQL
In this blog post, I will try to cover a few dump and data-loading utilities offered by MySQL Shell. What is MySQL Shell? It is a robust client and code editor for MySQL. In addition to having APIs for dealing with MySQL, MySQL Shell offers scripting capabilities for JavaScript and Python. It provides an AdminAPI […]