DEV Community

Michael
Michael

Posted on Originally published at gbase.cn

Tuning GBase RTSync for Better Replication Performance

To boost the throughput of GBase RTSync, GBASE's data synchronization tool, focus on these three parameters:

Parameter Recommended Description
cacheMaxSize 2147463480 Maximum in‑memory transaction cache size in bytes (default 100 MB). Transactions exceeding this size are spilled to disk. Raising this value avoids disk I/O and improves sync speed.
transMaxCount 1000000 Large transaction splitting threshold. When a transaction exceeds this row count, it is split into smaller chunks. Default 100 000. Currently supported for Oracle sources.
packetMaxSize 100000 Maximum packet read size in bytes (default 5 MB). If a single row exceeds this size, its integrity is preserved.

Increasing cacheMaxSize and packetMaxSize reduces disk/network overhead, while transMaxCount helps break down heavy transactions into manageable pieces. Together they can significantly improve the replication performance of your gbase database environment.

Top comments (0)