DataBase Server Specs (Advise really appreciated)

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

DataBase Server Specs (Advise really appreciated)

Postby gequiros » Thu Jan 11, 2018 12:55 pm

I need worst case scenario for this Database server, i know a lot of factors come in to place... but, how many agents can i move with this toy:

Motherboard: 1x X9DRi-LN4F+
- Onboard NIC: Integrated Dual Intel 1000BASE-T Ports
- Management: Integrated IPMI 2.0 Management
- PCIe: 1x Full Height PCI-e x8 slot
CPU: 2x Intel Xeon E5-2660 V1 Octa (8) Core 2.2Ghz
Memory: 128GB DDR3 (8 x 16GB DDR3 -REG 12800R HP )
Drive: 512GB SSD

What do i need to improve ? and how many agents as it is can handle with a dialing ratio of 15 ( Let's assume worlds crappiest leads )

I will use 20 Dialing Servers and 3 Web Servers ( 1 to do load balancing and 2 real web servers )

I need advise before i purchase and take decisions...
Vicibox 7.0.4

VERSION: 2.14-585a / BUILD: 170114-1356 / No VoIP hardware

1 x DataBase ( 32gb Ram - 24 Cores - 1 SSD 240gb )
1 x Web ( 16gb Ram - 16 Cores - 1 TB SATA )
4 x Dialers ( 8gb Ram - 16 Cores - 1 SSD 120gb

www.Come2VoIP-USA.com
gequiros
 
Posts: 90
Joined: Sat Oct 22, 2016 1:22 am
Location: Costa Rica

Re: DataBase Server Specs (Advise really appreciated)

Postby williamconley » Thu Jan 11, 2018 1:15 pm

I'd love to give you a number. But the reality of the situation is that every room is different and hardware specs ALL matter (front side bus, HD speed, RAID level and hardware speed and number of drives, 3rd party apps loading leads or viewing "wall" data on a screen for the agents, replication ... literally everything matters).

So while you may get an answer from someone, they'll be guessing (educated or otherwise) and they'll be wrong. You'll find that out when you load it up and the number differs. Keep an eye on it as you load it up, and see if you can find out what could be offloaded to another server or altered to reduce load (indexing, replication for reports ...). Eventually you'll find the absolute top, but you may never get there. You may also be paying enough attention to see the levels rising and take action to split your cluster.

Then you'll tell people who purchase similar hardware how many agents you managed before overload and wonder why theirs is so different from yours. Because everything matters.

That being said: Even at 15:1 dialing you ought to be able to exceed 150 agents. Perhaps 200. But don't quote me. I'm wrong, too. 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 16727
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DataBase Server Specs (Advise really appreciated)

Postby gequiros » Sat Jan 13, 2018 4:02 pm

What Config would you suggest me to reach 400 agents ? and how many dialers as well Web servers ?

Thanks, and sorry for hijacking your time... as always, really appreciate the help of any of you guys...
Vicibox 7.0.4

VERSION: 2.14-585a / BUILD: 170114-1356 / No VoIP hardware

1 x DataBase ( 32gb Ram - 24 Cores - 1 SSD 240gb )
1 x Web ( 16gb Ram - 16 Cores - 1 TB SATA )
4 x Dialers ( 8gb Ram - 16 Cores - 1 SSD 120gb

www.Come2VoIP-USA.com
gequiros
 
Posts: 90
Joined: Sat Oct 22, 2016 1:22 am
Location: Costa Rica

Re: DataBase Server Specs (Advise really appreciated)

Postby williamconley » Sat Jan 13, 2018 4:48 pm

Honestly: If you're planning to put down a system with 400 agents on it, you need to Contact The Vicidial Group. They are the hands-down most qualified to make sure your system works at launch and beyond.

I'd personally consider it irresponsible to not at least have a Professional Vicidial Consultant directly involved in the system buildout (if not actually being the ones building it out for you ...) for a system that size with that many paychecks and families riding on it.

Remember what I said: Your experience WILL differ from any advice you get here based on a wide array of criteria. If you have the ability to build it out slowly as you grow, you'll have a much better experience. I hope you have a whole lot of bandwidth, too. Seriously. :)

That being said: You'll want to start with Four Powerful Dedicated webs (100 agents per web) 1 Seriously Powerful DB (with a six drive RAID10 on 15kSAS drives with 6G RAID and 6G RAID cables) backed by a dedicated replication server for reporting. 1 Archive server to offload all recordings and backups. Good archiving and pruning rules for all log tables and recordings. And at least four (also Seriously Powerful) Dedicated Dialers or six (Not Quite as Powerful as the dB) Dedicated dialers. You can then load one of each of your server types until they overload and use that experience to determine if you have enough before adding on.

Be sure each Dialer has a dedicated public IP with a minimum of 10M up & down bandwidth (preferably 20). Be sure all dialers have 1G direct access to each other (all on the same local network on the same 1G switch for internal communciations). Be sure you configure their Vicidial IPs with the Internal IP address. Agents can access via public or private IPs, but they must communicate with each other privately on 1G speed network preferably without any iptables or other firewall interference (I don't even like managed switches in this network, as that's just one more link to fail!).

But seriously: Get someone who knows Vicidial involved in your buildout. It's been known to cost jobs. Like: IT jobs. Possibly YOURS. 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 16727
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DataBase Server Specs (Advise really appreciated)

Postby gequiros » Sat Jan 13, 2018 5:09 pm

I hear ya !!!

you are the expert... i am just planning it on the go

What's your definition for powerful DataBase Server in terms of CPU and Memory ( I guess DDR4 ), i've been reading everywhere, some suggest dual XEON some suggest SINGLE processor, i am getting clueless..

As well, what's your definition of Powerful dedicated Dialers, i heard they need around 8gb DDR

At this point, it is all about planning and doing the major figures on hardware and cost, if not, i will lease servers on a data center, and postone this for 6 months while i grow and increase cash flow...

Thanks so much... i mean it...
Vicibox 7.0.4

VERSION: 2.14-585a / BUILD: 170114-1356 / No VoIP hardware

1 x DataBase ( 32gb Ram - 24 Cores - 1 SSD 240gb )
1 x Web ( 16gb Ram - 16 Cores - 1 TB SATA )
4 x Dialers ( 8gb Ram - 16 Cores - 1 SSD 120gb

www.Come2VoIP-USA.com
gequiros
 
Posts: 90
Joined: Sat Oct 22, 2016 1:22 am
Location: Costa Rica

Re: DataBase Server Specs (Advise really appreciated)

Postby williamconley » Sat Jan 13, 2018 5:45 pm

More cores = more power. The number of CPUs used to get more cores is relevant only insofar as more CPUs tends to be more cores. (1 CPU with 4 cores is the same as 2 CPUs with 2 cores ... it's the core count that matters)

Faster cores = more power.

More memory is more power.

Faster memory is more power.

Faster front side bus is more power.

Faster (NOT bigger) hard drives is more power. This speed is not just a factor of the HD speed itself, the drive controller and front side bus are also involved. And the drive controller speed can be limited by the drive cable. 6G RAID 6G Cable and 6G HD all are needed to achieve 6G. And then HD itself should be able to sustain fast throughput for lenghty periods of time (thus 15K SAS is a reliable source ... some SSDs are also capable).

Total HD space should be over 100G (preferably 300G) to be sure that in the long term your DB and logs never exceed 75% of the drive space. Nothing else actually needs to reside on the DB server, but the dialers will need at least temporary storage for each day's recordings (if you're recording calls, that is).

If you can get a 16 or 20 core (not "virtual" cores, but physical) server at 3.0 Ghz with 32G of RAM and six 600G 15k SAS drives in RAID 10, you'll be doing good. You can start much lower and switch out the DB server as you grow, of course. Most start with 8 cores and less memory and add/change as their system grows. Monster servers are expensive.

Do not get the "bleeding edge" best newest servers. Linux drivers are often not available for them. Be sure they have linux drivers available (which is only possible by performing an install in many cases ... so buy one and install the OS instead of buying 10 at your first hit).
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 16727
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DataBase Server Specs (Advise really appreciated)

Postby gequiros » Sat Jan 13, 2018 7:50 pm

Abusing of you a bit, lol.. i've look around for:

Database:
Processor - 2 x AMD Opteron 6386 SE 16-Core 2.8GHz Processors ( Would be 32 cores )
Memory - 192GB Ram DDR3

Or:

2 x E5-2690V4 2.6GHZ ( 28 Cores )
Memory - 128GB DDR4-2133

i guess by that i "would be safe"... Which one would be your pick ?

Intel XEON or AMD Opteron ? ( I guess you would call for XEON )

Or do you suggest me a better one, i am open to suggestions

Which Raid Card should i go, as well, Hard Drives...
i thought you would suggest me going for: M.2 NVMe
I've been thinking going for 2 x 512gb Samsung 960 PRO or going for 2 x 480gb Intel Optane 900P in raid 10 ( would that be better than SAS or it would be a waste ? )

On my actual DB server the DataCenter put a KINGSTON SV300S3 ( max read / write speed 500 /260 MB/s ), that's regular SSD, and i don't think right now that's causing any hog or bottlenecks... i guess, lol...

For dialers and voice recording, would normal 7200 rpm drives work fine ( this would be temporary), or should i go with at least 10K or 15k would be a must ?

What would be the ideal CPU for a Dialer server ?

I guess file server does not need to be powerful, any 8 core with decent 8gb memory would do the trick and all it matters is storage reliability, correct ?

i am expecting to crank it up in 2 - 3 months this OP... need to build cash flow...

Thanks my man for your help !!!
Vicibox 7.0.4

VERSION: 2.14-585a / BUILD: 170114-1356 / No VoIP hardware

1 x DataBase ( 32gb Ram - 24 Cores - 1 SSD 240gb )
1 x Web ( 16gb Ram - 16 Cores - 1 TB SATA )
4 x Dialers ( 8gb Ram - 16 Cores - 1 SSD 120gb

www.Come2VoIP-USA.com
gequiros
 
Posts: 90
Joined: Sat Oct 22, 2016 1:22 am
Location: Costa Rica

Re: DataBase Server Specs (Advise really appreciated)

Postby williamconley » Sun Jan 14, 2018 12:12 am

You're on your own there. We only decipher to that level for clients. There's no way to know which will have superior performance beyond the basic specs. Drivers are for the motherboard (chipset), and not for the CPU itself. Compatibility (safety) is about the chipset, but performance is about the whole enchilada. Get the best price break for the Speed and core count (and all other speed factors) that you can. But remember that while there's no gurantee Vicibox will install smoothly, older systems have better odds at having OpenSUSE drivers available.

Matt has specified the RAID on this forum many times. There are a lot of RAID systems out there, and he doesn't recommend any of them except the one that he knows works because that's the backbone of the DB and many RAID fail under consistent load (there have been a lot of posts for people with RAID failing to maintain).

I'm not going to quote Matt's recommendation, you can search the forum for it in Matt's own words. When we use RAID it's built in (stock) PERC RAID in our Dell servers (we ONLY use Dell for our Rack servers, and don't support RAID in our starter-level non rack Standard servers). The PERC raid servers behave marvelously for us, and we've no reason to look further.

We've had several clients send us other servers with other RAID controllers in them, but those "NonPoundTeam hardware" servers and clusters are usually not heavily loaded, thus not a good comparison. We have configured them for the clients in question (even when the configuration is ... arcane, lol), but we don't generally recommend them until we know they will handle "full bore every day all day", which is just not something we can say we've observed with client servers we did not provide the hardware for. For many of those, we're merely the Host (no babysitting :) )
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 16727
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DataBase Server Specs (Advise really appreciated)

Postby mflorell » Sun Jan 14, 2018 9:36 am

Just a note about Dell PERC RAID cards, they are NOT built for high load Linux use. We have had to replace several high-volume system Database RAID cards for clients with LSI Logic MegaRAID caching RAID controllers in order to fix overheating or throughput limitations that happen when Dell PERC RAID cards are run past their designed specifications.
mflorell
Site Admin
 
Posts: 16402
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: DataBase Server Specs (Advise really appreciated)

Postby gequiros » Mon Jan 15, 2018 11:31 am

Thanks so much for such a great advises...

Will we gain too much performance using: M.2 NVMe 4 x 480gb Intel Optane 900P in raid 10 or regular SSD by Samsung will do the trick, or i should remain loyal to SAS 15k ?
Vicibox 7.0.4

VERSION: 2.14-585a / BUILD: 170114-1356 / No VoIP hardware

1 x DataBase ( 32gb Ram - 24 Cores - 1 SSD 240gb )
1 x Web ( 16gb Ram - 16 Cores - 1 TB SATA )
4 x Dialers ( 8gb Ram - 16 Cores - 1 SSD 120gb

www.Come2VoIP-USA.com
gequiros
 
Posts: 90
Joined: Sat Oct 22, 2016 1:22 am
Location: Costa Rica


Return to Support

Who is online

Users browsing this forum: uncapped_shady and 14 guests