luckman_2008
作者luckman_20082022-06-14 15:54
系统运维工程师, 人寿保险

IBM cdc Mysql源端安装和配置

字数 10413阅读 2276评论 0赞 0

赋权并进入mysql用户

root[@6icustomerproddb01 /]# chown -R mysql. /cdcdata
root[@6icustomerproddb01 /]# su - mysql
Last login: Tue Jun 7 16:12:37 CST 2022 on pts/1
-bash-4.2$ cd /cdcdata/soft/
-bash-4.2$ ls
mysql-connector-java-5.1.49.jar setup-iidr-11.4.0.4-5625-linux-x86.bin
-bash-4.2$ chmod +x setup-iidr-11.4.0.4-5625-linux-x86.bin
说明:mysql-connector-java-5.1.49.jar该文件是mysql的驱动包,需要自行下载,下载地址为https://downloads.mysql.com/archives/c-j/

执行安装程序

-bash-4.2$ ./setup-iidr-11.4.0.4-5625-linux-x86.bin
Preparing to install
Extracting the JRE from the installer archive…
Unpacking the JRE…
Extracting the installation resources from the installer archive…
Configuring the installer for this system’s environment…

Launching installer…

===============================================================================
Choose Locale…
1- Deutsch
->2- English
3- Espaol
4- Italiano
5- Portugus (Brasil)

使用2语言进行安装

CHOOSE LOCALE BY NUMBER: 2
IBM InfoSphere Data Replication (created with InstallAnywhere)

Preparing CONSOLE Mode Installation…

===============================================================================

Introduction
InstallAnywhere will guide you through the installation of IBM InfoSphere Data
Replication 11.4.0.4

Respond to each prompt to proceed to the next step in the installation. If
you want to change something on a previous step, type ‘back’.

You may cancel this installation at any time by typing ‘quit’.
->1- Install new product
2- Upgrade existing product

选择1,新安装

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: 1

===============================================================================

Select Datastore Type
->1- IBM Db2 for z/OS
2- Kafka
3- IBM DB2
4- IBM InfoSphere DataStage (including Apache Hadoop, WebHDFS, Cloudant)
5- FlexRep
6- IBM Informix Dynamic Server
7- IBM Netezza
8- Oracle
9- Oracle XStream
10- Oracle Trigger
11- Teradata
12- PostgreSQL
13- MySQL
14- MariaDB

选择13,安装Mysql agent

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: 13

===============================================================================

Select Offering

Contact your sales representative if you require assistance determining what
offering you are entitled to.

->1- IBM Data Replication
2- IBM Data Replication Targets for z/OS Sources
3- IBM InfoSphere Data Replication Non-RDBMS Targets
4- IBM InfoSphere Data Replication
5- IBM InfoSphere Change Data Delivery ——适用于影子表复制的产品
6- IBM InfoSphere Change Data Delivery for PureData System for Analytics
7- IBM Data Replication Db2 for z/OS Remote Source

选择4,安装IBM InfoSphere Data Replication

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: 4

===============================================================================

Choose Install Folder

Where would you like to install?

Default Install Folder: /opt/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL

输入安装路径

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT
: /cdcdata//ibm/InfoSphereDataReplication/ReplicationEngineforMySQL

INSTALL FOLDER IS:
/cdcdata/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL
IS THIS CORRECT? (Y/N): y

===============================================================================

  1. LICENSE INFORMATION
  2. The Programs listed below are licensed under the following License
  3. Information terms and conditions in addition to the Program license
  4. terms previously agreed to by Client and IBM. If Client does not have
  5. previously agreed to license terms in effect for the Program, the
  6. International Program License Agreement (Z125-3301-14) applies.
  7. Program Name (Program Number):
  8. IBM InfoSphere Data Replication V11.4.0.4 (5725-E30)
  9. IBM InfoSphere Data Replication for Non-Production Environments V11.
  10. 4.0.4 (5725-E30)
  11. The following standard terms apply to Licensee's use of the Program.
  12. Limited use right
  13. With the exception of Bundled Programs, all IBM software provided to
  14. Licensee with the Program can only be used to support Licensee's use

Press Enter to continue viewing the license agreement, or enter “1” to
accept the agreement, “2” to decline it, “3” to print it, or “99” to go back
to the previous screen.: 1

===============================================================================

Choose Instance Folder

Where would you like your instances and product logs created?

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT

Instance Folder: (Default:
/cdcdata/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL):

===============================================================================

Pre-Installation Summary

Please Review the Following Before Continuing:

Product Name:
IBM InfoSphere Data Replication

Install Folder:
/cdcdata/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL

Instance Folder:
“/cdcdata/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL”

Datastore type:
MySQL

Offering:
IBM InfoSphere Data Replication

Disk Space Information (for Installation Target):
Required: 533,322,867 Bytes
Available: 299,370,409,984 Bytes

PRESS TO CONTINUE:

===============================================================================

Installing…

[==================|==================|==================|==================]
[—————————|—————————|—————————|—————————]

===============================================================================

Install Complete

Congratulations. IBM InfoSphere Data Replication has been successfully
installed to:
/cdcdata/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL

You can launch the Configuration Tool at any time by running
/cdcdata/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL/bin/dmconf
igurets

Launch Configuration Tool? (1=Yes, 2=No) (Default: 1): 1

Welcome to the configuration tool for IBM InfoSphere Data Replication (MySQL). Use this tool to create instances of IBM InfoSphere Data Replication (MySQL).

Press ENTER to continue…
Initializing. Please wait…

CONFIGURATION TOOL - CREATING A NEW INSTANCE

Enter the name of the new instance:mysqltp6i
Enter the server port number [12001]:

Staging Store Disk Quota is used to limit the disk space used by IBM InfoSphere Data Replication staging Store. If this space is exhausted, this instance may run at a lower speed. The minimum value allowed is 1 GB.

Enter the Staging Store Disk Quota for this instance (GB) [100]: 200
Enter the Maximum Memory Allowed for this instance (MB) [1024]: 8192
Encryption profile:

  1. Manage encryption profiles

Select an encryption profile:1

MANAGE ENCRYPTION PROFILES

  1. Add encryption profile
  2. Edit encryption profile
  3. Delete encryption profile
  4. Completed management of encryption profiles

Enter your selection:1
Enter an encryption profile name: mysqlprod
Engine-to-engine encryption enablement:

  1. Enabled
  2. Disabled
  3. Required
  4. Always

Select the engine-to-engine encryption enablement [Enabled]: 2
Enter the path to the private key store or press ENTER for no private key store :
Enter the path to the trust store [/cdcdata/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL/jre64/jre/lib/security/cacerts]:
Enter the password that was used to encrypt the trust store or press ENTER to keep the same password:
Trust store type:

  1. JKS (Java)
  2. JCEKS (Java Cryptography Extension)
  3. PKCS12 (Public-Key Cryptography Standards)

Select the trust store type [JKS (Java)]: 1

MANAGE ENCRYPTION PROFILES

  1. Add encryption profile
  2. Edit encryption profile
  3. Delete encryption profile
  4. Completed management of encryption profiles

Enter your selection:4
Encryption profile:

  1. mysqlpro
  2. Manage encryption profiles

Select an encryption profile: 1
Select y to use JMS or TCP/IP engine communication connection, select n to use TCP only engine communication connection (y/n) [n]:n
Are you configuring with Community Edition? [n]: y
Enter the location of the JDBC driver file: /cdcdata/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL/lib/mysql-connector-java-5.1.49.jar
JDBC Driver:

  1. /cdcdata/ibm/InfoSphereDataReplication/ReplicationEngineforMySQL/lib/mysql-connector-java-5.1.49.jar

Select a JDBC Driver containing a driver class: 1
Show all classes (y/n) [n]:n
JDBC driver class:

  1. com.mysql.fabric.jdbc.FabricMySQLDriver
  2. com.mysql.jdbc.Driver
  3. com.mysql.jdbc.NonRegisteringDriver
  4. com.mysql.jdbc.NonRegisteringReplicationDriver
  5. com.mysql.jdbc.ReplicationDriver
  6. org.gjt.mm.mysql.Driver

Select a Class:2
Enter JDBC Connection URL: jdbc:mysql://10.146.35.50:3306/6icustomer?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false&useSSL=false
Enter Binary log name pattern: mysql-bin
Would you like to configure advanced parameters (y/n) [n]:
Enter the username: root
Enter the password:
Enter the path for Binary Log directory: /data/mysql

Creating a new instance. Please wait…

You are about to overwrite metadata for a previous installation of IBM InfoSphere Data Replication. If you choose to overwrite the metadata, you will not be able to use the previous installation of IBM InfoSphere Data Replication. If you choose not to overwrite the metadata, you can select an alternative schema. Are you sure you want to overwrite the metadata (y/n)?y

Instance mysqlp6i was successfully created.

Would you like to START instance mysqlp6i now (y/n)?y

Starting instance mysqlp6i. Please wait…

Instance mysqlp6i started successfully. Press ENTER to go to the Main menu…
MAIN MENU

  1. List Current Instances
  2. Add an Instance
  3. Edit an Instance
  4. Delete an Instance
  5. Manage encryption profiles
  6. Exit

Enter your selection:1
LIST OF CURRENT INSTANCES

Name Server Port Database Status

    • -

mysqlp6i 12001 6icustomer running

Press ENTER to return to the Main menu…
MAIN MENU

  1. List Current Instances
  2. Add an Instance
  3. Edit an Instance
  4. Delete an Instance
  5. Manage encryption profiles
  6. Exit

Enter your selection:6

Exiting…

至此CDC for mysql安装并配置完成。

-bash-4.2$ netstat -nlpt
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:44839 0.0.0.0:_LISTEN -
tcp 0 0 0.0.0.0:8400 0.0.0.0:_ LISTEN -
tcp 0 0 0.0.0.0:22 0.0.0.0:_LISTEN -
tcp 0 0 0.0.0.0:48926 0.0.0.0:_ LISTEN -
tcp 0 0 0.0.0.0:54660 0.0.0.0:_LISTEN -
tcp 0 0 127.0.0.1:49861 0.0.0.0:_ LISTEN -
tcp6 0 0 :::3306 :::_LISTEN -
tcp6 0 0 :::22 :::_ LISTEN -
tcp6 0 0 :::4189 :::_LISTEN 115816/dmts64-java
tcp6 0 0 :::35549 :::_ LISTEN 115816/dmts64-java
tcp6 0 0 :::12001 :::* LISTEN 115816/dmts64-java

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

相关文章

相关问题

相关资料

X社区推广