0 Comments

MySQL major version upgrade from 5.7 to 8.0.30 5 (1)

MySQL major version upgrade from 5.7 to 8.0.30 In the previous blog, we saw MySQL minor version upgrade from 8.0.22 to 8.0.30  Click here to read more In this blog, we are going to perform Major Version upgrade from 5.7 to 8.0.30 using Yum Repository method. MySQL 8.0 have many important performance and security improvements and […]

Loading

0 Comments

MySQL minor version upgrade from 8.0.22 to 8.0.29 0 (0)

MySQL minor version upgrade from 8.0.22 to 8.0.29 A minor upgrade is easy to perform just install the new version using the package manager like yum of your distribution. Installing the new version of a package requires the MySQL service to be stopped. In a recent blog, we have installed MySQL Server 8.0.22 using Yum […]

Loading

0 Comments

Access MySql database from PostgreSQL using MySQL Foreign Data Wrapper (MYSQL_FDW) 0 (0)

Access MySQL database from PostgreSQL using MySql Foreign Data Wrapper (MYSQL_FDW) The MySQL Foreign Data Wrapper (mysql_fdw) is a Postgres extension that allows you to access data that resides on a MySQL database from Postgres Server. It is a writeable foreign data wrapper that you can use with Postgres functions and utilities, or in conjunction […]

Loading

0 Comments

Perform Mysql Physical Backup using Percona Xtrabackup 0 (0)

Perform Mysql Physical Backup using Percona Xtrabackup The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL. Percona XtraBackup performs online non-blocking, tightly compressed, highly secure full backups on transactional […]

Loading

0 Comments

Steps to Install Percona XtraBackup for MySQL 0 (0)

Steps to Install Percona XtraBackup for MySQL The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL. Percona XtraBackup performs online non-blocking, […]

Loading

2 Comments

Steps to create a Database Link from Oracle to MySQL 0 (0)

Steps to create a Database Link from Oracle to MySQL Nowadays many companies are using a mix of RDBMS system for example, some instances are running on Oracle and other instances are running on MySQL, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow us to query data from non-Oracle databases using SQL. In this blog post we will see How to […]

Loading

0 Comments

How To Bootstrap MySQL Router For InnoDB Cluster 0 (0)

How To Bootstrap MySQL Router For InnoDB Cluster Bootstrap MySQL Router against an InnoDB Cluster to automatically configure the routing of incoming client connections to mysql instances. To bootstrap MySQL Router at the command-line, pass in the –bootstrap option when you start the mysqlrouter command, and it retrieves the topology information from the metadata and configures routing connections to […]

Loading

0 Comments

Changing InnoDB Cluster Topology in MySQL 0 (0)

Changing InnoDB Cluster Topology in MySQL By default, an InnoDB Cluster runs in single-primary mode, where the cluster has one primary server that accepts read and writes queries (R/W), and all of the remaining instances in the cluster accept only read queries (R/O). When you configure a cluster to run in multi-primary mode, all of […]

Loading

0 Comments

How to Setup MySql InnoDB Cluster 0 (0)

How to Setup MySql InnoDB Cluster MySQL InnoDB Cluster provides a complete high availability solution for MySQL. By using the AdminAPI included with MySql Shell, you can easily configure and administer a group of at least three MySQL server instances to function as an InnoDB Cluster. Each MySQL server instance runs MySQL Group Replication, which […]

Loading

0 Comments

Adopting a Group Replication Deployment into InnoDB Cluster 0 (0)

Adopting a Group Replication Deployment into InnoDB Cluster in MySQL   If you have an existing deployment of Group Replication and you want to use it to create a cluster, pass the adoptFromGR option to the dba.createCluster() function. The created InnoDB Cluster matches whether the replication group is running as single-primary or multi-primary. To adopt […]

Loading