During our testing process, we observed the following phenomenon when Vertica interfaced with our S3 storage system using DNS resolution for the "tpc-ds deptoff user=3" test:
When the storage system had 3 nodes, each node achieved load balancing. However, with configurations of 2, 4, 5, or 6 nodes, only one node experienced exceptionally high workload while other nodes maintained very low utilization rates throughout the entire testing period.
We would like to consult your team regarding Vertica's DNS resolution implementation to verify whether this aligns with our test results. For reference, we have already enabled database load balancing using the following SQL statement:
`SELECT SET_LOAD_BALANCE_POLICY('ROUNDROBIN');`
Question
TPC-DS Performance Test When Vertica Uses S3 as External Storage
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.