Hello Everyone,
I am using Kamailio sqlops module to write to a remote database which is not the database of Kamailio. It is working fine. But for redundancy purpose, if this database goes down, I want the Kamailio to detect the failure at runtime and write the data to another database (standby database). Is it possible? Can anybody please guide me on this asap?
Regards, Vicky
i would recommend solution with sql proxy in front of database. something like HAproxy or similar
Marek
Dne 05/12/2022 v 13:49 Waqar 40 napsal(a):
Hello Everyone,
I am using Kamailio sqlops module to write to a remote database which is not the database of Kamailio. It is working fine. But for redundancy purpose, if this database goes down, I want the Kamailio to detect the failure at runtime and write the data to another database (standby database). Is it possible? Can anybody please guide me on this asap?
Regards, Vicky
Kamailio - Users Mailing List - Non Commercial Discussions sr-users@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
DB_CLUSTER module, perhaps?
Kaufman
From: sr-users sr-users-bounces@lists.kamailio.org On Behalf Of Waqar 40 Sent: Monday, December 5, 2022 6:49 AM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Subject: [SR-Users] Database Failure Detection at runtime
Hello Everyone,
I am using Kamailio sqlops module to write to a remote database which is not the database of Kamailio. It is working fine. But for redundancy purpose, if this database goes down, I want the Kamailio to detect the failure at runtime and write the data to another database (standby database). Is it possible? Can anybody please guide me on this asap?
Regards, Vicky
This module only provides redundancy. I want to check at runtime if the database connection is failed. I want to add different kind of data into the remote database if the connection of the main database is failed.
On Mon, Dec 5, 2022 at 9:22 PM Kaufman bkaufman@bcmone.com wrote:
DB_CLUSTER module, perhaps?
*Kaufman*
*From:* sr-users sr-users-bounces@lists.kamailio.org * On Behalf Of *Waqar 40 *Sent:* Monday, December 5, 2022 6:49 AM *To:* Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org *Subject:* [SR-Users] Database Failure Detection at runtime
Hello Everyone,
I am using Kamailio sqlops module to write to a remote database which is not the database of Kamailio. It is working fine. But for redundancy purpose, if this database goes down, I want the Kamailio to detect the failure at runtime and write the data to another database (standby database). Is it possible? Can anybody please guide me on this asap?
Regards,
Vicky __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions sr-users@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe: https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-
Kaufman -
marek -
Waqar 40