Project

General

Profile

Actions

개선(improvement) #317

open

[New] Setup Elastic search database for read data

Added by Joseph Vo 10 months ago. Updated 6 months ago.

Status:
진행(Doing)
Priority:
보통(Normal)
Assignee:
Start date:
07/18/2025
Due date:
09/18/2025 (about 6 months late)
% Done:

100%

Estimated time:
(Total: 110.00 h)
Spent time:
(Total: 72.00 h)
Part:
Build env.:

Description

Request :
a/ Setup Elastic search server manually on Amazon
b/ Synchronize process between Write Database and Read Database (Elastic search)
c/ Solution to compare and resolve differentiate between Write Database and Read Database (backup solution)


Subtasks 11 (0 open11 closed)

개선(improvement) #877: Implement push calendar rate-allotment to ElasticSearch완료(Done)Dan Hoang07/18/202507/21/2025

Actions
개선(improvement) #923: Implement push calendar sales stop to ElasticSearch완료(Done)Dan Hoang07/22/202507/23/2025

Actions
개선(improvement) #942: Migrate room allotment from main database to ES완료(Done)calvin dev07/28/202507/29/2025

Actions
개선(improvement) #943: Migrate plan prices from main database to ES완료(Done)calvin dev07/28/202507/29/2025

Actions
개선(improvement) #947: Implement search availability use elastichsearch완료(Done)Dan Hoang07/23/202507/29/2025

Actions
개선(improvement) #967: Migrate promotion status from main database to ES완료(Done)calvin dev07/29/202507/29/2025

Actions
개선(improvement) #978: Implement feature to switch a specific channel to search availability use elastichsearch완료(Done)Dan Hoang07/29/202507/29/2025

Actions
개선(improvement) #1014: Implement new search availability for Ctrip use Elasticsearch완료(Done)Dan Hoang07/30/202507/31/2025

Actions
개선(improvement) #1112: [ES] Test data read use Elasticsearch on dev완료(Done)Dan Hoang08/04/202508/08/2025

Actions
개선(improvement) #1296: [Elasticsearch] Implement sync allotment in booking, cancel process완료(Done)Dan Hoang08/28/202509/05/2025

Actions
개선(improvement) #1429: [ElasticSearch] Implement sync any allotments and rates changes when run Pentaho campare data to ES완료(Done)Dan Hoang09/04/202509/18/2025

Actions

Related issues

Related to Ellis improvement - 기능(Feature) #528: Implement push CMS data to ElasticSearch완료(Done)Dan Hoang06/04/202506/23/2025

Actions
Related to Ellis improvement - 개선(improvement) #949: [Elastic search] Check all trigger change status data for Elastic search완료(Done)Tan Jang07/24/202507/25/2025

Actions
Related to Ellis improvement - 개선(improvement) #950: [Elastic search] Create process compare date between Elastic search and DB완료(Done)Dan Hoang09/04/202509/18/2025

Actions
Related to Ellis improvement - 개선(improvement) #951: [Elastic search] Setup ES server on Dev완료성공(Resolve)Joseph Vo12/30/202512/30/2025

Actions
Actions #1

Updated by Dan Hoang 10 months ago

  • Status changed from 신규(New) to 진행(Doing)
  • Start date set to 05/29/2025
Actions #2

Updated by Dan Hoang 9 months ago

Actions #3

Updated by Joseph Vo 8 months ago

Actions #4

Updated by Joseph Vo 8 months ago

Actions #5

Updated by Joseph Vo 8 months ago

Actions #6

Updated by ziniy Kang 8 months ago

Issue:
기존 구조에서는 데이터 조회(Read)를 메인 데이터베이스(DB)에서 직접 수행하고 있었음
→ 성능 문제나 부하 발생 가능성이 있으므로,ElasticSearch를 활용한 별도 읽기 전용 데이터베이스(Read DB) 를 구축할 예정

Request:
1. Amazon 환경에 수동으로 ElasticSearch 서버를 세팅
2. Write DB ↔ Read DB 간의 동기화 처리 로직 구성
3. Write DB와 Read DB 간 데이터 불일치 시 비교 및 복구 솔루션 마련

Sub tasks:
  1. 예약 캘린더 allotment / 판매 종료 정보를 ElasticSearch로 전송
  2. 객실 정보, 요금 정보를 메인 DB에서 ES로 이전
  3. 검색 기능에서 ElasticSearch를 사용하도록 적용
Related issues:
  1. CMS 데이터 Push
  2. 상태 변경 시 트리거 처리 확인
  3. DB와 ElasticSearch 간 데이터 비교 처리
  4. Dev 환경에 ES 서버 설치 등
Actions

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 50 MB)