test: add integration test for compaction offload

[LeslieKid]

Rationale

Close #1571

Detailed Changes

• Impl compact as pre-command for sqlness, with http compaction service.
• update integration tests to test compaction offload.

Test Plan

[LeslieKid]

This pr should be merged after #1563 , it involves testing compaction offload.

[Rachelint]

For simplificity, I think we can just setup a standalone horaedb in test which acts as both remote compaction caller and remote compaction server?