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)