Prerequisites for Installing Oracle GoldenGate for MySQL

Installing MySQL Client Libraries

Learn the prerequisites for installing Oracle GoldenGate for a MySQL database.

Oracle GoldenGate 23ai (or higher) for MySQL is packaged with MySQL Client libraries 8.0.35 and requires OpenSSL 1.1 (libssl.so.1.1 and libcrypto.1.1) be installed on the Oracle GoldenGate server.

• If Oracle GoldenGate is installed on a MySQL 8.0 (versions greater than 8.0.26+) database server, then add the MySQL installation’s home\bin directory to the LD_LIBRARY_PATH environment variable as follows:

  For Linux:

  export LD_LIBRARY_PATH=mysql_home/bin:$LD_LIBRARY_PATH

• If Oracle GoldenGate is installed on a MySQL version lower than or equal to 8.0.26, MySQL 8.4, MySQL 9.0 or MariaDB database server, or installed on a hub server, then install OpenSSL 1.1 and add its installation location to the LD_LIBRARY_PATH environment variable.

  Note:

  The OpenSSL library (libssl.so.1.1 and libcrypto.so.1.1) is part of the core OS package on OEL 8 and RHEL8 but its not part of the OS package on OEL 9 and RHEL9. On OEL 9 and RHEL9, you need to manually install a compatible SSL (libssl.so.1.1, libcrypto.so.1.1) library.

  This is required for Linux and the environment variable must include the directory containing the libssl.so.1.1 and libcrypto.so.1.1 libraries for Linux systems.

OpenSSL 1.1 binaries are available through OpenSSL development package or by installing a MySQL or by installing a MySQL 8.0 product that includes the OpenSSL 1.1 libraries, such as Connector/ODBC 8.0 version 8.0.26.