Docs Menu

RHEL ์„œ๋ฒ„์— ์„ค์น˜

RHEL/CentOS ์„œ๋ฒ„์— Relational Migrator๋ฅผ ์„ค์น˜ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ด ์„ค์น˜ ๋ฐฉ๋ฒ•์„ ์‚ฌ์šฉํ•˜๋ฉด ์ž๋™ ์„œ๋ฒ„์—์„œ Relational Migrator๋ฅผ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ž๋™ ์„œ๋ฒ„์—์„œ ์‹คํ–‰๋˜๋Š” Relational Migrator๋Š” ์„œ๋ฒ„์˜ ๋ชจ๋“  IP ๋ฐ ํฌํŠธ์— ๋ฐ”์ธ๋”ฉํ•˜์—ฌ ์ด๋ฅผ ์›น ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์œผ๋กœ ๋…ธ์ถœํ•ฉ๋‹ˆ๋‹ค.

  1. ์ถœ์‹œํ•˜๋‹ค ํŽ˜์ด์ง€์—์„œ ์ตœ์‹  .rpm ๋ฐ”์ด๋„ˆ๋ฆฌ๋ฅผ ๋‹ค์šด๋กœ๋“œํ•ฉ๋‹ˆ๋‹ค.

  2. Relational Migrator๋ฅผ ์„ค์น˜ํ•ฉ๋‹ˆ๋‹ค.

    sudo yum install mongodb-relational-migrator-X.X.X-1.x86_64.rpm
  3. (์„ ํƒ ์‚ฌํ•ญ) Oracle ๋˜๋Š” MySQL ๋“œ๋ผ์ด๋ฒ„์— ์—ฐ๊ฒฐํ•˜๋ ค๋ฉด ๋“œ๋ผ์ด๋ฒ„๋ฅผ ๋‹ค์šด๋กœ๋“œํ•˜์—ฌ Relational Migrator ๋””๋ ‰ํ† ๋ฆฌ์— ๋ฐฐ์น˜ํ•ฉ๋‹ˆ๋‹ค.

    1. MySQL ๋˜๋Š” Oracle ๋“œ๋ผ์ด๋ฒ„๋ฅผ ๋‹ค์šด๋กœ๋“œํ•˜์—ฌ ์„ค์น˜ํ•˜๋ ค๋ฉด ๋‹ค์Œ์„ ์ฐธ์กฐํ•˜์„ธ์š”.

    2. ๋“œ๋ผ์ด๋ฒ„ ํŒŒ์ผ์„ /opt/mongodb-relational-migrator/lib/app/lib ์— ๋ณต์‚ฌํ•ฉ๋‹ˆ๋‹ค.

      ๋“œ๋ผ์ด๋ฒ„๋ฅผ ๋ณต์‚ฌํ•˜๋ ค๋ฉด ๋‹ค์Œ ์˜ˆ์ œ๋ฅผ ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค.

      curl https://download.oracle.com/otn-pub/otn_software/jdbc/216/ojdbc11.jar -O -L -b -o

    ์ž์„ธํ•œ ๋‚ด์šฉ์€ ๋กœ์ปฌ ๋จธ์‹ ์— ์„ค์น˜๋ฅผ ์ฐธ์กฐํ•˜์„ธ์š”.

  4. ๋””๋ ‰ํ† ๋ฆฌ๋ฅผ Relational Migrator /bin ์œ„์น˜๋กœ ๋ณ€๊ฒฝํ•˜๊ณ  ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์„ ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค.

    cd /opt/mongodb-relational-migrator/bin
    ./mongodb-relational-migrator
  5. Relational Migrator๋ฅผ ์ž๋™ ๋…๋ฆฝํ˜• ์„œ๋ฒ„๋กœ ์‹คํ–‰ํ•˜๋ ค๋ฉด ํ™œ์„ฑํ™”ํ•ฉ๋‹ˆ๋‹ค.

    user.properties ํŒŒ์ผ์—์„œ spring.profiles.active: unattended ์˜ ์ฃผ์„ ์ฒ˜๋ฆฌ๋ฅผ ์ œ๊ฑฐํ•ฉ๋‹ˆ๋‹ค.

  6. (์„ ํƒ ์‚ฌํ•ญ) TLS/SSL ๊ตฌ์„ฑ ์†์„ฑ์„ ์—…๋ฐ์ดํŠธํ•ฉ๋‹ˆ๋‹ค.

    user.properties ํŒŒ์ผ์—์„œ TLS/SSL ๊ตฌ์„ฑ ์†์„ฑ์˜ ์ฃผ์„์„ ์ œ๊ฑฐํ•˜๊ณ  ์—…๋ฐ์ดํŠธํ•ฉ๋‹ˆ๋‹ค.

    Relational Migrator๋Š” ์„œ๋ฒ„์˜ ๋ชจ๋“  IP ๋ฐ ํฌํŠธ์— ๋ฐ”์ธ๋”ฉ๋  ์ˆ˜ ์žˆ์œผ๋ฏ€๋กœ TLS/SSL ๊ตฌ์„ฑ์œผ๋กœ ์ž๋™ ์„œ๋ฒ„ ์„ค์น˜๋ฅผ ๋ณด์™„ํ•˜๋Š” ๊ฒƒ์ด ์ข‹์Šต๋‹ˆ๋‹ค. ์ž์„ธํ•œ ๋‚ด์šฉ์€ SSL ๊ตฌ์„ฑ ์†์„ฑ์„ ์ฐธ์กฐํ•˜์„ธ์š”.

  7. (์„ ํƒ ์‚ฌํ•ญ) Relational Migrator๊ฐ€ ์‹คํ–‰๋˜๋Š” ํฌํŠธ๋ฅผ ์—…๋ฐ์ดํŠธํ•ฉ๋‹ˆ๋‹ค.

    ๊ธฐ๋ณธ์ ์œผ๋กœ Relational Migrator๋Š” ํฌํŠธ 8278์—์„œ ์‹คํ–‰๋˜๋„๋ก ๊ตฌ์„ฑ๋ฉ๋‹ˆ๋‹ค. Relational Migrator๊ฐ€ ์‹คํ–‰๋˜๋Š” ํฌํŠธ๋ฅผ ๋ณ€๊ฒฝํ•˜๋ ค๋ฉด user.properties ํŒŒ์ผ์˜ server.port ์ค„์„ ์—…๋ฐ์ดํŠธํ•˜์—ฌ ์›ํ•˜๋Š” ํฌํŠธ๋ฅผ ์ง€์ •ํ•ฉ๋‹ˆ๋‹ค.

  8. ๋ฐ”์ด๋„ˆ๋ฆฌ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ Relational Migrator๋ฅผ ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.

    bin ๋””๋ ‰ํ† ๋ฆฌ๋Š” ์ผ๋ฐ˜์ ์œผ๋กœ /opt/mongodb-relational-migrator/bin ์—์„œ ์ฐพ์„ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

    ๋ฐ”์ด๋„ˆ๋ฆฌ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ Relational Migrator๋ฅผ ์‹คํ–‰ํ•˜๋ ค๋ฉด ๋‹ค์Œ์„ ์‹คํ–‰ํ•˜์„ธ์š”.

    cd /opt/mongodb-relational-migrator/bin
    ./mongodb-relational-migrator
  9. (์„ ํƒ ์‚ฌํ•ญ) ๋กœ๊ทธ์—์„œ ์˜ค๋ฅ˜๋‚˜ ๊ธฐํƒ€ ์ •๋ณด๋ฅผ ํ™•์ธํ•ฉ๋‹ˆ๋‹ค.

    • ๋กœ๊ทธ๋Š” ~/Migrator/Logs/migrator.log ์— ์žˆ์Šต๋‹ˆ๋‹ค.

    • Relational Migrator๋ฅผ ์‹œ์Šคํ…œ ์„œ๋น„์Šค๋กœ ์‹คํ–‰ํ•˜๋Š” ๊ฒฝ์šฐ ๊ฒฝ๋กœ๋Š” ์„œ๋น„์Šค ์‚ฌ์šฉ์ž์˜ ํ™ˆ ๋””๋ ‰ํ† ๋ฆฌ ์•„๋ž˜์— ์žˆ์Šต๋‹ˆ๋‹ค.