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
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
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,
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
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.
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
-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
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
: [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