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)
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
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
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
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:: 4
===============================================================================
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
===============================================================================
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
===============================================================================
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):
===============================================================================
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:
===============================================================================
[==================|==================|==================|==================]
[—————————|—————————|—————————|—————————]
===============================================================================
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
[H[JWelcome 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…
[H[JInitializing. Please wait…
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:
Select an encryption profile:1
Enter your selection:1
Enter an encryption profile name: mysqlprod
Engine-to-engine encryption enablement:
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:
Select the trust store type [JKS (Java)]: 1
Enter your selection:4
Encryption profile:
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:
Select a JDBC Driver containing a driver class: 1
Show all classes (y/n) [n]:n
JDBC driver class:
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
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
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 条评论