asterisk users - Jun 2005 - howto write CDRs on two mysql servers

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20050609/9eacbae2/attachment.htm

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, recompile, then load that module. You would 
basically be running 2 instances of that module.

Long term solution would be to rewrite cdr_addon_mysql to support 
multiple databases.

-Matthew

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. Might lessen the load on Asterisk by not waiting on a 
second, remote connection.

/rg


Robert Goodyear
Brand Up LLC
http://www.brand-up.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 658 bytes
Desc: not available
Url :
http://lists.digium.com/pipermail/asterisk-users/attachments/20050609/a1ccfddf/attachment.bin

why not just use mysql replication to the second one?



On 6/9/05, Rosario Pingaro <rpingar@nesec.it>
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 
>   
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   
> http://lists.digium.com/mailman/listinfo/asterisk-users
> 
>

Use SQL to duplicate or CRON...

On 6/9/05, Rosario Pingaro <rpingar@nesec.it>
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 
>   
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>   
> http://lists.digium.com/mailman/listinfo/asterisk-users
> 
> 

-- 
<sig>
Andrew Latham - AKA: LATHAMA (lay-th-ham-eh)
WWW: http://lathama.com
Email: lathama@lathama.com - lathama@yahoo.com - lathama@gmail.com
If any of the above are down we have bigger problems than my email!
</sig>

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

What about mysql cluster... I think it's open source... 

-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Rusty
Shackleford
Sent: Thursday, June 09, 2005 2:29 PM
To: 'Mark Musone'; 'Asterisk Users Mailing List - Non-Commercial
Discussion'
Subject: RE: [Asterisk-Users] howto write CDRs on two mysql servers
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com
> [mailto:asterisk-users-bounces@lists.digium.com] 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 use mysql replication to the second one?
> 
> 
> 
> On 6/9/05, Rosario Pingaro <rpingar@nesec.it> wrote:
> >  
> > For redundancy I would like to write the CDRs on tow mysql servers.
I thought of that, briefly, but "redundancy" would rather dictate that
if
"MySQL Server 1" went down, records could still be created on
"MySQL Server
2". Not possible in the replication scenario.

This would be a nice feature to have, either a second live database
connection, or the option of configuring a failover server, to be used in
the event that * can't connect to the primary.

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 06/08/2005
 

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

> -------- Original Message --------
> Subject: Re: [Asterisk-Users] howto write CDRs on two mysql servers
> From: Matthew Boehm <mboehm@cytelcom.com>
> Date: Thu, June 09, 2005 1:47 pm
> To: Mark Musone <mmusone@gmail.com>, Asterisk Users Mailing List -
> Non-Commercial Discussion <asterisk-users@lists.digium.com>
>
> 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
>
Replication can be set up to go bothways in a 2 server scenario for
MySQL. This would solve your replication issue for 2 servers. More
servers can be set up in a loop configuration for 3 or more servers.
There is one problem with this method if one MySQL goes down updates
are not passed around the loop. but as soon as the loop is
reestablished the updates are passed around the loop to bring the other
servers up to date.

You might also consider DNS round robin to distribute initial
connections to MySQL.  A better solution is to use a load balancer that
tracks to see if the servers are alive and balance against the load on
each server.

Cheers

Max W. Blackmer, Jr.

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 fly. However, you need a lot 
of memory for each of these machines.

My road map of growing system is:
1. Two (more) Asterisk servers use the same mysql database (done) and 
share the same config files and temp area (e.g., wakeup) (planned via 
NFS as a quick solution, later to contribute that back to MySQL)
2. Add one (two) SER servers with round robinson DNS settings
3. Add multiple Mysql cluster to the existing Mysql machine
4. relocate a set of machines to another place


End will be, that the MySQL cluster becomes the heart of all!!! SER and 
Asterisk will become "slaves" of MySQL.


bye

Ronald