[JDEV] xdb_sql connection with two host

[Dillip Kumar Swain]

Hi Benoit.   I want to just clarify  my points..actually I  have two database(mysql) on different server like abc.com & xyz.com..I want to fetch data from both server....database setting is like this...From A--M users details are in one database and N-Z users details are in other ....   Please help me how will i configure it..? so that each user request can communicate its coressponding database...   awaiting your reply Thanx dillip   Message: 3 From: Benoit Orihuela <[EMAIL PROTECTED]> Date: Fri, 27 Apr 2001 12:34:39 +0200 To: [EMAIL PROTECTED] Subject: Re: [JDEV] xdb_sql connection with two hast <000901c0cdd3$95ce6960$1b01a8c0@dsf> Reply-To: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED]   > Let me know..whether can I use connection with two different host(differnet > database server) on mysql module...how? you can use different database servers according to namespaces. for instance, I use a configuration like that :     <xdb id="xdb_auth">     <host/>     <ns>jabber:iq:auth</ns>     <ns>jabber:iq:profile</ns>     <ns>yahootrans:data</ns>     <load><xdb_sql>/home/jabber/lib/jabber/xdb_sql.so</xdb_sql></load>   </xdb>     <xdb id="xdb_roster">     <host/>     <ns>jabber:iq:roster</ns>     <ns>jabber:iq:filter</ns>     <load><xdb_sql>/home/jabber/lib/jabber/xdb_sql.so</xdb_sql></load>   </xdb>   and so on ...   Regards,   Benoit.   -- Benoit Orihuela         IDEALX S.A.S.   --__--__--