master slave database setup

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

master slave database setup

Postby pratikvicidial » Tue Aug 20, 2024 3:04 am

Hello All

Just want to know the Slave Database server setup for my vici cluster what is the best way to achieve this.

Is this what we need to take care all the time of installation of all server or we can add Slave Database server later on after the installation?

And how this slave database works and it's use cases.

Thanks
pratikvicidial
 
Posts: 33
Joined: Tue Mar 30, 2021 5:56 am

Re: master slave database setup

Postby carpenox » Wed Aug 21, 2024 2:03 am

Alma Linux 9.4 | SVN Version: 3884 | DB Schema Version: 1720 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2400
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: master slave database setup

Postby williamconley » Wed Sep 04, 2024 6:54 pm

1) Slave database is NOT required at all.

2) Slave database CAN be added at any time in the future.

3) Slave database is actually best referred to as the "Reporting Server". It's purpose is to remove the database queries needed to run reports from the LIVE database server. Since some of those reports can be heavy and disruptive during production hours, the slave database running those queries instead can make it possible to run reports with no impact to the call system.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20226
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: master slave database setup

Postby carpenox » Sat Sep 07, 2024 10:48 am

True, great additions Bill. Happy Saturday!
Alma Linux 9.4 | SVN Version: 3884 | DB Schema Version: 1720 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2400
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 9 guests