Category: ADMINISTRATION
For ADMINISTRATION articles under category MySql.
MySQL major version upgrade from 5.7 to 8.0.30
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 […]
153 Total Views, 3 Views Today
MySQL minor version upgrade from 8.0.22 to 8.0.29
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 […]
190 Total Views, 1 Views Today
Steps to create a Database Link from Oracle to MySQL
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 […]
1,493 Total Views, 8 Views Today
Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle
Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle Here we are going to demonstrate multiplexing of Control Files in Oracle using available options SPFILE, PFILE & RMAN. Before moving ahead first we will have a basic understanding of Control Files in Oracle. Control File is a physical file on OS level and […]
2,599 Total Views
Create MySQL Instance Replica using Clone Command
Create MySQL Instance Replica using Clone Command MySQL 8 has recently released clone plugin which makes cloning process very easy and handy to perform. In this blog we will see How to install and perform clone of mysql instance. I will clone complete mysql instance server_id 3 into server_id 4, Please note in server_id 4 […]
1,139 Total Views, 1 Views Today
How to Download and Create Sample database in MySql
How to Download and Create Sample Database in MySql In this article, we are going to demonstrate How to Download & Create Sample Database in MySql. You can download a sample database for MySql directly inside mysql server or download it first from GitHub and then transfer it to mysql server. Click here to download […]
1,922 Total Views, 2 Views Today
Configure another instance of MySql and administer using systemctl
Configure another instance of MySql and administer using systemctl In this article, we will be performing Configure another instance of MySql and administer using systemctl. To fulfill the purpose of this demonstration, We have already configured mysql instance using yum repository method which is running on mysql default port 3306. Click here to read more. […]
1,511 Total Views
How to enable automatic restart of the MySQL server using systemctl
How to enable automatic restart of the MySQL server using systemctl In the previous blog, we saw How to Install Mysql 8 manually using Binaries Tar Click here to read more. Though this method provides full control over the installation process it doesn’t register mysqld in systemctl. So we need to start mysql service manually […]
2,911 Total Views, 3 Views Today
Step by Step Database MySql 8 Installation using Binaries
Step by Step Database MySql 8 Installation using Binaries In the previous blog, we have performed MySql 8 installation using YUM Repository click here to read more. In this blog, we are going to perform step by step MySql 8 installation using binaries in OEL 7.9 (Oracle Linux Enterprise). Download MySql 8 tar binary using […]
1,990 Total Views
Database MySql 8 Installation using Yum Repository Method
Database MySql 8 Installation using Yum Repository Method Database MySql can be installed using the below 3 different methods. 1) Yum Installation – The easiest and fastest method to install MySql but provide no control over the installation. 2) RPM Bundle – Need to download RPM Bundle and install MySql rpm manually. 3) Using Binaries […]
2,199 Total Views, 3 Views Today
Recent Comments