Sharding configuration [Документация VAS Experts]

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
en:dpi:dpi_components:qoestor:configuration:sharding:start [2023/04/03 13:01] arusnaken:dpi:dpi_components:qoestor:configuration:sharding:start [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
Line 1: Line 1:
-====== Sharding configuration ====== 
-{{indexmenu_n>7}} 
- 
-QoE Stor can work in sharding mode: horizontal cluster scaling, in which parts of the same database are placed on different shards (nodes). 
-Through sharding, you can: 
-1. Distribute the load on the IPFIX inserts from several DPIs, spreading it over the nodes. 
-2. At times speed up the construction of reports by increasing the machine resources-nodes: the construction of reports is performed in parallel and glued into the final report. 
- 
-===== 1 Create a cluster ===== 
- 
-To create a QoE Stor cluster, you must specify the cluster node settings on each node in the file /etc/clickhouse-server/config.d/qoestor-cluster-config.xml 
- 
-Edit file on 1st node 
- 
-{{ :dpi:dpi_components:qoestor:configuration:sharding:sharding-xml.png?direct&400 |}} 
- 
-For each shard, you must specify the host IP or its name. Save your changes. 
- 
-Copy the file to the rest of the cluster nodes. 
- 
-Restart the database with the <code>fastor-db-restart</code> command on each node. The cluster is ready to run. 
- 
-<note important>Port 9000 must be open on all firewall cluster nodes in the internal network between the cluster nodes.</note> 
- 
- 
-===== 2 Adding a cluster to the GUI ===== 
- 
-==== 1 Master node connection ==== 
- 
-Choose which node you will use as the master. Enable it in the GUI settings. Enable cluster mode. See screenshot below. 
- 
-{{ :dpi:dpi_components:qoestor:configuration:sharding:sharding-master-node.png?direct&400 |}} 
- 
-<note important>Port 8123 must be open on all cluster nodes.</note> 
- 
-==== 2 Управление через SSH ==== 
- 
-В разделе GUI Адимнистратор / Оборудование добавить все узлы для управления по SSH.  
- 
-{{ :dpi:dpi_components:qoestor:configuration:sharding:sharding-ssh.png?direct&400 |}} 
- 
- 
-==== 3 Настройка IPFIX ресиверов ==== 
- 
- 
-В конфигурации QoE Stor настроить ресиверы для каждого узла.  
- 
-{{ :dpi:dpi_components:qoestor:configuration:sharding:sharding-receivers.png?direct&400 |}} 
- 
-Перенастроить DPI для отправки IPFIX на соответствующие узлы кластера QoE. 
- 
-<note important>Распределяйте нагрузку равномерно. Один или несколько DPI  должны отправлять IPFIX на один узел QoE Stor.</note>   
- 
-<note warning>Не отправляйте IPFIX от одного DPI на несколько узлов QoE Stor.</note> 
-