Hi Cyrille, First of all, if you use a MySQL server it's typically better and faster to connect via DBD::mysql rather than via ODBC.
Second, you'll want to use MySQL-proxy or a similar solution as a 'load balancer' for your MySQL cluster. https://launchpad.net/mysql-proxy http://www.slideshare.net/KrisBuytaert/mysql-ha-alternatives-2010 That way from OTRS you connect to only one 'virtual' server. If you'd define two data backends all queries typically hit all cluster database nodes which seems very inefficient to me. With the LDAP example you gave the 'failover' happens at connection time. Within mod_perl typically the connection is not set up for each query but only once and then is kept open by Apache::DBI. Michiel Beijen Senior Developer OTRS BV Schipholweg 103 2316 XC Leiden The Netherlands T: +31 71 8200 255 I: http://www.otrs.com OTRS 3.2 - More than a Help Desk System – Process and Customer Management – Be an early bird with our special offer - http://j.mp/11TFPSr On Wed, Apr 24, 2013 at 4:56 PM, Cyrille Bollu <cyrille.bo...@belnet.be>wrote: > Hi list, > > I'm trying to find out how I could setup OTRS to use a redundant ODBC > backend for CustomerUser objects. > > I initially thought I could setup 2 backends pointing to 2 mirrored mysql > servers. But, it seems that OTRS' code dies with a nice HTTP 500 error when > a backend isn't available. > > Has anyone already worked on such a setup? > > I remember doing such a setup for agents authentication with an LDAP > backend using the following in config.pm: > > # LDAP agent backend > my @ldaphosts = ('ldap2','ldap1'); > $Self->{'AuthModule'} = 'Kernel::System::Auth::LDAP'; > $Self->{'AuthModule::LDAP::**Host'} = \@ldaphosts; > ... > > And it seem to work fine at that time. > > Now, is there an easy solution for ODBC backends? > > Best regards, > > Cyrille > ------------------------------**------------------------------**--------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: > http://lists.otrs.org/**pipermail/otrs<http://lists.otrs.org/pipermail/otrs> > To unsubscribe: > http://lists.otrs.org/cgi-bin/**listinfo/otrs<http://lists.otrs.org/cgi-bin/listinfo/otrs> >
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
