Tibero MYSQL DATA ÀÌ°ü ¹æ¹ý
Tibero MYSQL DATA ÀÌ°ü ¹æ¹ý
º» ¹®¼¿¡¼´Â Tibero¿¡¼ Á¦°øÇÏ´Â Table Migrator ToolÀ» ÀÌ¿ëÇÏ¿© MysqlÀ» Tibero·Î DATAÀÌ°ü¿¡ ´ëÇؼ¸¸ ¼Ò°³ÇÑ´Ù.
1. °³¿ä
Table Migrator ´Â Tibero¿¡¼ Á¦°øÇÏ´Â ÀÌ°üÀ» À§ÇÑ ToolÀÌ´Ù.
À̶§ Table ´ÜÀ§·Î ÀÌ°üÀ» ÇÏ´Â Table Migrator¸¦ Àû??ÇÏ°Ô »ç¿ëÇϸé ÀÛ¾÷ÀÇ È¿À²¼ºÀÌ ³ô¾ÆÁø´Ù
MYSQL DATAÀÌ°üÀº Tibero¿¡¼ Á¦°øÇÏ´Â Tool·Î Table migrator¸¦ ÀÌ¿ëÇÑ ¹æ¹ýÀÌ ÀÖ´Ù.
2. ȯ°æ ±¸¼º
¡Ü MYSQL
- OS :Linux 2.6.39-200.24.1.el6uek.x86_64
- IP/PORT : 192.168.70.1:3306
- version :mysql-5.1.71
- sample data :
URL :https://launchpad.net/test-db/employees-db-1/1.0.6/+download/employees_db-full-1.0.6.tar.bz2
¡Ü TIBERO
- OS :Linux 2.6.39-200.24.1.el6uek.x86_64
- IP/PORT : 192.168.70.2:8629
-version :Tibero 5 (DB 5.0 S1343)
¡Ü Table migrator (table_migrator_140117.zip)
log4j-1.2.16.jar migrator.sh migrator.bat mlogger.jar
readme.txt toolcom.jar migrator_cli.jar migrator.properties
MLogger.log mysql-connector-java-5.1.27-bin.jar tibero5-jdbc.jar
mysql-connector-java-5.1.27-bin.jar´Â tibero¿¡¼ Á¦°øÇÏÁö ¾ÊÀ½
3. TABLE »ý¼º
3.1. Table ½ºÅ©¸³Æ® ÃßÃâ
MYSQL¿¡¼ Table ½ºÅ©¸³Æ®¸¦ ÃßÃâÇÏ´Â ¹æ¹ýÀ¸·Î ¿©·¯ °¡Áö Áß MYSQL DUMP±â´ÉÀ» ÀÌ¿ëÇÑ ¹æ¹ýÀ» Á¦½ÃÇÏ¿´´Ù.
mysqldump -u root -p RFC3 API_NURSERY --compatible=oracle --compact > i.txt
--compatible : ±¸ºÐÀÚ°¡ "TEST"·Î ¶³¾îÁö¸ç oracle, db2, mssql µî ´Ù¸¥ µ¥ÀÌÅͺ£À̽º¿¡ ¿ÉƼ¸¶ÀÌÁîµÊ.
-- compact : »ó¼¼ ¼³¸íÀ» Á¦¿ÜÇÏ°í ´ýÇÁ.( --skip-add-drop-table --no-set-names --skip-disable-keys --skip-add-locks)
* Âü°í »çÇ× - mysqldump¸¦ ÀÌ¿ëÇÑ ¿¹
Export Import
* µ¥ÀÌÅͺ£À̽º ??ü¸¦ ÃßÃâÇÏ´Â °æ¿ì
mysqldump guestdb > guestdb.txt
mysqldump [µ¥ÀÌÅͺ£À̽º¸í] > [ÆÄÀϸí]
* ƯÁ¤ Å×ÀÌºí¸¸ ÃßÃâÇÏ´Â °æ¿ì
mysql guestdb guestTbl > guestdb.txt
mysqldump [µ¥ÀÌÅͺ£À̽º¸í] [Å×À̺í¸í] > [ÆÄÀϸí]
* µ¥ÀÌÅͺ£À̽º ??ü¸¦ ÃßÃâÇÑ °æ¿ì
mysql -u root -p < guestdb.txt
mysql -u [À¯Àú¸í] -p < [ÆÄÀϸí]
* ƯÁ¤µ¥ÀÌÅͺ£À̽ºÀÇ Å×ÀÌºí¸¸ ÃßÃâÇÑ °æ¿ì
mysql -u username -p --database=guestdb < guestTbl.txt
mysql -u [À¯Àú¸í] -p --database=[µ¥ÀÌÅͺ£À̽º¸í] < [ÆÄÀϸí]
3.2. Table »ý¼º
- AS-IS table (MYSQL)
- TO-BE table (TIBERO)
create table tibero.dept_emp(
"emp_no" number(11),
"dept_no" char(4),
"from_date" date,
"to_date" date
À©¹é ¹× ¾÷±×·¹À̵å
Better Technology, Better Tomorrow
5
);
4. ÀÌ°ü ¼öÇà
¡Ü Table migrator ¼¼ÆÃ
- Migrator.sh ¿¾îº¸¸é ¾Æ·¡¿Í °°ÀÌ mysql. jar¸¦ Ãß°¡ÇÑ´Ù..
Java-classpathmysql-connector-java-5.1.27-bin.jar:migrator_cli.jar:log4j1.2.16.jar:mlogger.jar:toolcom.jar:tibero5-jdbc.jar com.m.migrator.TableMigrator "$@"
¡Ü Source/Target DB ¼³Á¤
- Sourceȯ°æ¼³Á¤Àº ¾Æ·¡ ³»¿ëÀ» Âü°íÇÏ¿© ȯ°æ¿¡ ¸Â°Ô ¼³Á¤ÇÑ´Ù.
cp migrator.properties migrator_mysql.properties
vi migrator_mysql.properties
#######################
# Source DB Connection
#######################
# Source DB type (Optional, generic | default | ORACLE)
# ORACLE option needs SOURCE_LOGIN_AS property
# GENERIC option needs SOURCE_DRIVER property
SOURCE_TYPE=GENERIC
# Source DB JDBC driver class name
# Use with SOURCE_TYPE=GENERIC option
SOURCE_DRIVER=org.gjt.mm.mysql.Drive
# Source DB JDBC connection URL (Optional, Default=jdbc:oracle:thin:@localhost:1521:orcl)
SOURCE_URL=jdbc:mysql://192.168.71.1:3306/employees?sessionVariables=sql_mode='ANSI_QUOTES¡¯
# Source DB login ID (Optional, Default=sys)
SOURCE_USER=root
# Source DB login password (Optional, Default=oracle)
SOURCE_PASSWORD=root
# Oracle source DB login option (Optional, Default=sysdba)
# Use with SOURCE_TYPE=ORACLE option
SOURCE_LOGIN_AS=normal
# Source table schema (Optional)
# Default value is the same with SOURCE_USER
SOURCE_SCHEMA=employees
# Source table name (Mandatory)
SOURCE_TABLE=dept_emp
#######################
# Target DB Connection
#######################
# Target DB type (Optional, generic | DEFAULT)
# GENERIC option needs TARGET_DRIVER property
#TARGET_TYPE=DEFAULT
# Target DB JDBC driver class name
# Use with TARGET_TYPE=GENERIC option
#TARGET_DRIVER=com.tmax.tibero.jdbc.TbDriver
# Target DB JDBC connection URL (Optional, Default=jdbc:tibero:thin:@localhost:8629:tibero)
TARGET_URL=jdbc:tibero:thin:@l192.168.70.2:8629:tibero
# Target DB login ID (Optional, Default=sys)
TARGET_USER=tibero
À©¹é ¹× ¾÷±×·¹À̵å
Better Technology, Better Tomorrow
6
# Target DB login password (Optional, Default=tibero)
TARGET_PASSWORD=tmax
# Target table schema (Optional)
# Default value is the same with TARGET_USER
TARGET_SCHEMA=tibero
# Target table name (Optional)
# Default value is the same with SOURCE_TABLE
TARGET_TABLE=dept_emp
#################
# Data Extractor
#################
# Use TSN(or SCN) option (Optional)
#SELECT_TSN=
# Where conditions (Optional)
# ex. column1 > 10 AND column2 = 'abc'
#SELECT_CONDITION=
# Fetch size of source table cursor (Optional, Default=1024)
# Some DB is not supported this feature.
#SELECT_FETCH_SIZE=1024
# Source table partition name (Optional)
#SELECT_PARTITION=
# Ignore source/target DB character set (Optional, y | N )
#SELECT_AS_BYTE=N
##############
# Data Loader
##############
# Use direct path loading (Optional, cpl | DPL)
# CPL means conventional path loading
# DPL means direct path loading
INSERT_METHOD=CPL
# Use batch insert (Optional, Y | n)
# Use with INSERT_METHOD=CPL option
#INSERT_BATCH=N
# Use parallel loading (Optional, Y | n)
#INSERT_PARALLEL=Y
# Number of data loader thread (Optional, Default=4)
# Use with INSERT_PARALLEL=Y option
#INSERT_THREAD_COUNT=4
# Target table partition name (Optional)
#INSERT_PARTITION=
¡Ü Table migrator¼öÇà
$ migrator.shPROPERTY_FILE=migrator_mysql.properties
*
*
*
Loader finished
Loading is ended.
Elapsed Time (milliseconds) : 65985
ADD BATCH : 1012
EXECUTE BATCH : 258297
À©¹é ¹× ¾÷±×·¹À̵å
Better Technology, Better Tomorrow
7
5. DATA È®ÀÎ
¡Ø DATAÀÌ°ü ½Ã Tibero¿¡ TABLESPACE, USER, TABLE±îÁö »ý¼º ÈÄ¿¡ Table Migrator¸¦ ¼öÇàÇÑ´Ù