How to setup a Slave DB on a scratch install

Any and all non-support discussions

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

How to setup a Slave DB on a scratch install

Postby carpenox » Sun Apr 24, 2022 12:13 pm

Good afternoon all and happy Sunday,

I have written an article on how to setup a slave DB for ViciDial when you have scratch installed your servers. This particular example should work on CEntOS 7 and 8, Alma and Rocky Linux as well

https://dialer.one/how-to-setup-a-slave ... -vicidial/


This was actually a little bit of a nightmare and I had to try it many times before I got it working, so going back through my steps I may have missed something, so if anyone tries it out please report back here or on my blog your success or non success, thanks guys.

Chris aka carpenox
Last edited by carpenox on Wed May 03, 2023 5:54 pm, edited 1 time in total.
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: How to setup a Slave DB on a scratch install

Postby williamconley » Tue May 03, 2022 2:36 pm

Do you have a "resync the slave" script built yet? We've found that building that while building the initial replication script is quite useful. Once you have all that in your upper memory, the resync process is pretty straightforward. But waiting six months for that "out of sync, binaries too old" moment that can come after a long weekend power outage or some such can be a pain in the @ss. 8-)
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: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: How to setup a Slave DB on a scratch install

Postby carpenox » Tue May 03, 2022 2:56 pm

hmmm good to know, ill have to look into that because as of now I do not, any advice you can give towards doing that properly?
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: How to setup a Slave DB on a scratch install

Postby williamconley » Tue May 03, 2022 2:59 pm

There is a method during "dump" that will store the bookmark of "where do I start syncing" directly in the dump file. Thus making it easy to load the db and start sync without guesswork. We generate resync databases nightly "just in case" so we can resync from that file at any time without interrupting operations on the main db server even in the middle of the workday.
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: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: How to setup a Slave DB on a scratch install

Postby carpenox » Tue May 03, 2022 6:26 pm

ah ok so basically a backup of the slave
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: How to setup a Slave DB on a scratch install

Postby williamconley » Wed May 04, 2022 9:10 am

close:

it's a backup FOR the slave to load from. ie: snapshot
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: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 46 guests