Hi all, I'm trying to setup Openser with two Mysql server configured as Master-Master. Is it possible to configure Openser to read data from the first Mysql server (192.168.1.4) and if that fails to read data from the second Mysql server (192.168.1.5)? If not, which alternatives I have to instruct Openser to use the second Mysql server when the first is down? Thanks in advance.
Hi Antonio,
OpenSER uses only one database per module, so no mean of setting two and do failover. If I were you, I would rather try another approach, with failover on the database side.
EG: Use Linux-HA to provide a virtual ip address for your database and detect active/pasive mode for your database servers. If you are not running linux, there are some other similar applications for other OS-es around.
Hope that helps, DanB
On 11/5/07, Antonio Reale ant.reale@gmail.com wrote:
Hi all, I'm trying to setup Openser with two Mysql server configured as Master-Master. Is it possible to configure Openser to read data from the first Mysql server (192.168.1.4) and if that fails to read data from the second Mysql server (192.168.1.5)? If not, which alternatives I have to instruct Openser to use the second Mysql server when the first is down? Thanks in advance.
-- Antonio
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
Take a look at http://www.linux-ha.org/Heartbeat
I do not think you can do what you want directly from openser.
On 11/5/07, Antonio Reale ant.reale@gmail.com wrote:
Hi all, I'm trying to setup Openser with two Mysql server configured as Master-Master. Is it possible to configure Openser to read data from the first Mysql server (192.168.1.4) and if that fails to read data from the second Mysql server (192.168.1.5)? If not, which alternatives I have to instruct Openser to use the second Mysql server when the first is down? Thanks in advance.
-- Antonio
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
On 11/05/07 13:17, Morten Isaksen wrote:
Take a look at http://www.linux-ha.org/Heartbeat
I do not think you can do what you want directly from openser.
no, it is not possible now. I started some work in this direction, but it is no release time line yet, perhaps will be in 1.4
Daniel
On 11/5/07, Antonio Reale ant.reale@gmail.com wrote:
Hi all, I'm trying to setup Openser with two Mysql server configured as Master-Master. Is it possible to configure Openser to read data from the first Mysql server (192.168.1.4) and if that fails to read data from the second Mysql server (192.168.1.5)? If not, which alternatives I have to instruct Openser to use the second Mysql server when the first is down? Thanks in advance.
-- Antonio
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
2007/11/6, Daniel-Constantin Mierla daniel@voice-system.ro:
no, it is not possible now. I started some work in this direction, but it is no release time line yet, perhaps will be in 1.4
Ok thanks, for now I'll try an alternative solution.
Thank a lot also to other guys in the ML that suggested me the heartbeat solution. Regards, Antonio.
-
Antonio Reale -
Dan-Cristian Bogos -
Daniel-Constantin Mierla -
Morten Isaksen