RE: [Asterisk-Users] howto write CDRs on two mysql servers

2005-06-11 Thread Max W Blackmer Jr
Original Message Subject: Re: [Asterisk-Users] howto write CDRs on two mysql servers From: Matthew Boehm [EMAIL PROTECTED] Date: Thu, June 09, 2005 1:47 pm To: Mark Musone [EMAIL PROTECTED], Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users

Re: [Asterisk-Users] howto write CDRs on two mysql servers

2005-06-11 Thread Ronald Wiplinger
Rosario Pingaro wrote: For redundancy I would like to write the CDRs on tow mysql servers. cdr_mysql.conf accept only one configuration [global], how to add a second host? I think that is the wrong end you are looking. Try to use MySQL cluster and you can add servers as you wish on the

Re: [Asterisk-Users] howto write CDRs on two mysql servers

2005-06-09 Thread Matthew Boehm
Rosario Pingaro wrote: For redundancy I would like to write the CDRs on tow mysql servers. cdr_mysql.conf accept only one configuration [global], how to add a second host? Thanks Rosario The quickest way would be to make a copy of cdr_addon_mysql and rename the app and conf file,

Re: [Asterisk-Users] howto write CDRs on two mysql servers

2005-06-09 Thread Mark Musone
why not just use mysql replication to the second one? On 6/9/05, Rosario Pingaro [EMAIL PROTECTED] wrote: For redundancy I would like to write the CDRs on tow mysql servers. cdr_mysql.conf accept only one configuration [global], how to add a second host? Thanks Rosario

Re: [Asterisk-Users] howto write CDRs on two mysql servers

2005-06-09 Thread Robert Goodyear
On Jun 9, 2005, at 8:51 AM, Rosario Pingaro wrote: For redundancy I would like to write the CDRs on tow mysql servers.   cdr_mysql.conf accept only one configuration [global],   how to add a second host? Might be easier to add a second host as a replica server with the mySQL Administrator.

Re: [Asterisk-Users] howto write CDRs on two mysql servers

2005-06-09 Thread Andrew Latham
Use SQL to duplicate or CRON... On 6/9/05, Rosario Pingaro [EMAIL PROTECTED] wrote: For redundancy I would like to write the CDRs on tow mysql servers. cdr_mysql.conf accept only one configuration [global], how to add a second host? Thanks Rosario

RE: [Asterisk-Users] howto write CDRs on two mysql servers

2005-06-09 Thread Rusty Shackleford
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Musone Sent: Thursday, June 09, 2005 10:20 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] howto write CDRs on two mysql servers why not just

Re: [Asterisk-Users] howto write CDRs on two mysql servers

2005-06-09 Thread Matthew Boehm
Mark Musone wrote: why not just use mysql replication to the second one? Replication does not solve the issue of redundancy. If the master goes down, so do the updates to the slave. -Matthew ___ Asterisk-Users mailing list

RE: [Asterisk-Users] howto write CDRs on two mysql servers

2005-06-09 Thread Huddleston, Robert
: [Asterisk-Users] howto write CDRs on two mysql servers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Musone Sent: Thursday, June 09, 2005 10:20 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] howto