Oracle GoldenGate MySQL to MySQL Configuration part 1
Part 1 contain Installation and Configguration of MySQL database in Rhel 7 server. Source and target MySQl database for GoldenGate will be on same server.
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.
