Views: 513
Last Modified: 01.07.2024

Starting from the main module version 24.0.0 the query balancing system in cluster has been improved significantly The previous balancing system system version had any query update interrupting the conveyor process and all queries were submitted to the main (master) database. , optimizing load between servers.

  Main updates

  1. The system functions in a standard mode before the first query for data update.
  2. In case of an update query, list of modified tables is registered.
  3. Upon subsequent retrieving queries, the updated tables are checked. If no tables were modified, queries will continue to be processed via slave servers.

Tests demonstrate significant increase of queries, processed by slave servers and minimized errors when handling cluster configuration. This allows for better distribution of queries between servers and reduced load on master server.

  Load balancing

  1. Legacy (standard) variant: Master 30 la, Slave 3 la.

  2. New variant: Master 1 la, Slave 50 la.

Now cluster settings allow to redirect 100% of load to slave servers, which significantly increases system performance and effectiveness.




Courses developed by Bitrix24