asterisk users - Jun 2007 - Write to multiple databases as redundancy scheme

Hi,

Can Asterisk write to multiple MySQL databases in different machines,  
at the same time, as a backup scheme?
If it does, where can that be configured? In res_mysql.conf file?

Does anyone ever made it?

Regards,
Ricardo.


-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20070608/c6a9b40c/attachment.htm

It would be better to let MySQL handle that - use the built-in 
replication facilities. It's easy to setup.

-- 
Chris Mason
(264) 497-5670 Fax: (264) 497-8463
Int:  (305) 704-7249 Fax: (815)301-9759 UK 44.207.183.0271
Cell: 264-235-5670
Yahoo IM: netconcepts_anguilla@yahoo.com 


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

MySQL has its own ways of doing this kind of thing.  Take a look at the
documentation <http://dev.mysql.com/doc/refman/5.0/en/replication.html> 
on
MySQL's website related to replication.

 

Bobby

 

  _____  

From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of
rjcarvalho@reit.up.pt
Sent: Friday, June 08, 2007 11:45 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: [asterisk-users] Write to multiple databases as redundancy scheme

 

Hi,

Can Asterisk write to multiple MySQL databases in different machines, at the
same time, as a backup scheme?
If it does, where can that be configured? In res_mysql.conf file?

Does anyone ever made it?

Regards,
Ricardo. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20070608/270ac3d1/attachment.htm

Why would you do this???? why put the overhead inside asterisk when  
mysql has perfectly good replication mechanisms built in?


On Jun 8, 2007, at 12:44 PM, rjcarvalho@reit.up.pt wrote:
> Hi,
>
> Can Asterisk write to multiple MySQL databases in different  
> machines, at the same time, as a backup scheme?
> If it does, where can that be configured? In res_mysql.conf file?
>
> Does anyone ever made it?
>
> Regards,
> Ricardo.
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Bryan Laird, Sr. Manager CM Operations
                        -+-
Cablemodems are the gateway to the Internet.
The Internet is a gateway to some things that are  better left un-seen.


-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20070608/30498b4c/attachment.htm

rjcarvalho@reit.up.pt wrote:
> Hi,
>
> Can Asterisk write to multiple MySQL databases in different machines, 
> at the same time, as a backup scheme?
> If it does, where can that be configured? In res_mysql.conf file?
Not that I'm aware of, but you can setup MySQL to mirror the data to a 
slave database.

Doug


-- 
 
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."

> Can Asterisk write to multiple MySQL databases in different machines,
> at the same time, as a backup scheme?
> If it does, where can that be configured? In res_mysql.conf file?
No, you cannot write to 2 different mysql servers with res_mysql.
Just use MySQL replication as an alternative.  Easy to setup.
Asterisk writes to the Master database and the Master replicates
changes to slave databases for backup.

JR

-- 
JR Richardson
Engineering for the Masses