Skip to main content

Search

Welcome to Tibero GTS!

Service Delay After DB Migration When Changing Cloud Region

Document Type | Issue Resolution

Category | Interface/Integration

Applicable Product Version | 6FS07

Document Number | TIITS002

 

Issue

In the previous environment, the DB connection time was 100~200ms, but after migrating the DB in the environment where the cloud region was changed, it increased to 20s, causing service delays.

[Analysis of Phenomenon Environment]

  • DB migration was performed using Cold Backup with no changes, so infrastructure verification is necessary
  • When running test queries with tbsql in the DB local environment, there were no significant differences in query execution times or plans between the original and migrated DB
  • Both the original and migrated environments use the same DB and JDBC Driver versions, and the original DB environment operated without issues, so it is unlikely that DB or Driver versions affect processing speed
  • No anomalies found in sys.log

 

 

Cause

Due to delays in internal DNS calls within the cloud region, DB connection time increases, resulting in service delays. 
 
 
 
 

Solutions

Maintain the DNS settings of the CSP or create and configure a private DNS within the CSP to resolve the issue.
Note
You can perform network tests using commands such as traceroute and ping.
 
 
 
 
 
 
 

Related to