Database Scalation / dimensioning
Posted: Tue Mar 23, 2021 3:41 pm
Guys, sorry to post this since it is already a F.A.Q. but i can not find specific answer for my question. Also sorry because this will be a long post
The Vicibox Installation manual says this:
Can I Scale this up to 1,000 agents ?
I mean can I assume this?
So following that specs, my current setup will only handle 300 Agents
2x Intel® Xeon® Processor E5-2620 v4 ( 8 real cores each - 16 cores in total for the Dual CPU Setup )
128 ECC RAM
LSI 3108 MegaRAID w RAID 1+0 8 x 256 Gb SSD
I build this for less of $4,000 USD ( The whole server including case, disks, controller, etc etc )
If i want to get up to 600 Agents, i need to double the cores, so I would require Dual Xeon® E5-2683 v4 which costs about $2,000 USD each CPU, so for the costs of the CPU I can build a second server for 300 agents.
If I want to get up to 1,000 things start to get ridiculous. That would require Dual Xeon® E5-2699 v4 which cost $4,200(ish) each, so $8,400 only on CPUs, also at this point I will need a more expensive Motherboard and power supply in order to handle the wattage and heat. This build easily can be $15,000 USD price tag, 4 x times the cost of the 300 agent build.
Is it worth to spent that much on Single BD Server ?
Is there any strategy to use 4 x Servers with specs 300 Agents each ?
Did I misunderstood the dimensioning of the database ?
Please note that this will be running with daily archive and nightly optimize tables;
The Vicibox Installation manual says this:
Recommended Database specification :
Approximately 150 agents, or 300 agents with double the amount of RAM and CPU cores•Eight core CPU 2.0+ Ghz•16+ GB RAM (More RAM generally gives better DB performance)•500+ GB RAID1 drive configuration for the OS•250+ GB SSD RAID10 drive configuration mounted under /srv/mysql for MySQL
Can I Scale this up to 1,000 agents ?
I mean can I assume this?
150 Agents
Eight core CPU 2.0+ Ghz•16+ GB RAM
300 Agents
16 core CPU 2.0+ Ghz•
32+ GB RAM
450 Agents
24 core CPU 2.0+ Ghz•
64+ GB RAM
600 Agents
32 core CPU 2.0+ Ghz•
128+ GB RAM
750 Agents
40 core CPU 2.0+ Ghz•
256+ GB RAM
1000 Agents
48 core CPU 2.0+ Ghz•
512+ GB RAM
So following that specs, my current setup will only handle 300 Agents
2x Intel® Xeon® Processor E5-2620 v4 ( 8 real cores each - 16 cores in total for the Dual CPU Setup )
128 ECC RAM
LSI 3108 MegaRAID w RAID 1+0 8 x 256 Gb SSD
I build this for less of $4,000 USD ( The whole server including case, disks, controller, etc etc )
If i want to get up to 600 Agents, i need to double the cores, so I would require Dual Xeon® E5-2683 v4 which costs about $2,000 USD each CPU, so for the costs of the CPU I can build a second server for 300 agents.
If I want to get up to 1,000 things start to get ridiculous. That would require Dual Xeon® E5-2699 v4 which cost $4,200(ish) each, so $8,400 only on CPUs, also at this point I will need a more expensive Motherboard and power supply in order to handle the wattage and heat. This build easily can be $15,000 USD price tag, 4 x times the cost of the 300 agent build.
Is it worth to spent that much on Single BD Server ?
Is there any strategy to use 4 x Servers with specs 300 Agents each ?
Did I misunderstood the dimensioning of the database ?
Please note that this will be running with daily archive and nightly optimize tables;