Oracle GoldenGate MySQL to MySQL Configuration part 1

Step1 :- Download and add MySQL Yum Repository to Linux Repository.

# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

Step 2:- Install the downloaded package by using below command.

# yum local install mysql80-community-release-el7–3.noarch.rpm

Step 3:- Verify that the MySQL Yum repository has been added successfully.

# yum repolist enabled | grep “mysql.*-community.*”

Step 4:- Install latest MySQL using below command.

# yum install mysql-community-server

Step 5:- Start MySQL Server and enable it, using below commands.

# systemctl start mysqld

# systemctl enable mysqld

Step 6:- When MySQL 8.0 version is installed, temporary password for root is stored in mysqld.log file. Run below command to list the password.

# cat /var/log/mysqld.log | grep ‘temporary password’

Step7:- Get the password and then run below command. To create new password and other things(check screen-shot)

# mysql_secure_installation

Step8:- Login to MySQL database. (below command can be run from other OS user also)

# mysql -u root -p

Create MySQL Source and Target database

Step1:- Create Two Mysql database one for source one for Target

[opc@pocgg OGG19c]$ mysql -u root -p

mysql> show databases;
+ — — — — — — — — — — +
| Database |
+ — — — — — — — — — — +
| ggtest |
| information_schema |
| mysql |
| performance_schema |
| sys |
+ — — — — — — — — — — +
5 rows in set (0.00 sec)

mysql> CREATE DATABASE sourcegg DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
Query OK, 1 row affected, 2 warnings (0.01 sec)

mysql> CREATE DATABASE targetgg DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
Query OK, 1 row affected, 2 warnings (0.01 sec)

mysql> show databases;
+ — — — — — — — — — — +
| Database |
+ — — — — — — — — — — +
| ggtest |
| information_schema |
| mysql |
| performance_schema |
| sourcegg |
| sys |
| targetgg |
+ — — — — — — — — — — +
7 rows in set (0.00 sec)

Note:- Source Database for GoldenGate will be sourcegg and target database for GoldenGate will be targetgg.

Step 2:- Create GoldenGate user for sourcegg and targetgg databases and grant then required privilege's.

mysql> CREATE USER ‘ggsuser_S’@’%’ IDENTIFIED BY ‘Ggsuser$1234’;
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON sourcegg.* TO ‘ggsuser_S’@’%’ WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE USER ‘ggsuser_T’@’%’ IDENTIFIED BY ‘Ggsuser$1234’;
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL PRIVILEGES ON targetgg.* TO ‘ggsuser_T’@’%’ WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

Step 3:- Check to login to sourcegg and targetgg database from ggsuer_S and ggsuer_T respectively.

--

--

--

Oracle database and GoldenGate consultant

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Let’s get started with Azure Function for Dynamics 365 CRM: Part 2 [Cloud Deployment]

Top Tips to Become a Senior Engineer

What startups should know about observability

Running your local tiny “Big Data Cluster”

Unique Paths

Test Automation Framework (Selenium with Java) — Alchemy or Translating JIRA with Selenide (with…

Null Byte Injection- Part-1

My Programming journey

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Abhii

Abhii

Oracle database and GoldenGate consultant

More from Medium

MySQL spacial indexing example

How to Creat ASP.NET Core Web Application?. The Complete ASP.NET Core Developer Course 2022 Videos.

Embedded Systems Project 7: Web Server

Rest Services | Rest-API