[asterisk-users] Trigger Asterisk after data inserted in MySQL

[Ahmed Munir]

Thanks Bryant and David for sharing.






> From: "Bryant Zimmerman" <BryantZ at zktech.com>
> Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in
>         mysql
> To: "Asterisk Users Mailing List - Non-Commercial Discussion"
>         <asterisk-users at lists.digium.com>
> Message-ID: <4d5734ed$7d50d85e$77bd1cd6$@zktech.com>
> Content-Type: text/plain; charset="us-ascii"
>
> David
>
> The way we do this is to have a trigger insert into a batch table. This
> table can be polled from a secondary process. That process/service is
> responsible for monitoring, working and cleanup. This allows for you to
> poll a highly optimized table without taking the db performance hit from
> larger tables that will grow over time. We process millions of cdr and
> process records a day this way. It also allows you balanced process loads
> across multiple servers. This can be extremely important on systems that
> are more heavily loaded. It also allows you to remove process load and
> latencies from the database servers.
>
> Thanks
>
> Bryant Zimmerman (ZK Tech Inc.)
> 616-855-1030 Ext. 2003
>
> ----------------------------------------
>  From: "David Cook" <dbc_asterisk at advan.ca>
> Sent: Wednesday, September 19, 2012 2:04 PM
> To: asterisk-users at lists.digium.com
> Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in
> mysql
>
> It looks like the answer is yes.
>
>
> http://crazytechthoughts.blogspot.ca/2011/12/call-external-program-from-mysq
> l.html
>
> >From the page, here is code to execute a UDF library and call a shell.
> Clearly there would be a heavy penalty to launching a shell so you would
> want to carefully evaluate the frequency this is executed on your system.
>
> DELIMITER @@   CREATE TRIGGER Test_Trigger  AFTER INSERT ON MyTable  FOR
> EACH ROW  BEGIN  DECLARE cmd CHAR(255);  DECLARE result int(10);  SET
> cmd=CONCAT('sudo /home/sarbac/hello_world ','Sarbajit');  SET result =
> sys_exec(cmd); END; @@ DELIMITER ;
>
>   -dbc
>
>  Message: 1 Date: Tue, 18 Sep 2012 15:41:46 -0400 From: Ahmed Munir
> <ahmedmunir007 at gmail.com> Subject: [asterisk-users] Trigger Asterisk after
> data inserted in        mysql To: asterisk-users at lists.digium.comMessage-ID:
>         <CAGMN=JdbE5FdDSQXxZ9OrWXu3Pvgc-hj-EnPxUrG=
> RJHGSD-eg at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"  Hi all,   I would like to
> know, is there a way to trigger Asterisk after data inserted into mysql DB?
> Like here what I'm trying to do, when the new data inserted into MySQL DB,
> it sends the request to Asterisk along with the new data (that is inserted
> in DB) for making outbound call i.e. Realtime.  Currently I've set a cron
> job that execute my script every 30 seconds and checks for a new data in
> DB. If new data is inserted in 30 seconds that script will run and sends
> the data to Asterisk for making calls. (This is the case which I'm thinking
> to avoid)  Please advise.
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.digium.com/pipermail/asterisk-users/attachments/20120919/b8c396a7/attachment.htm
> >
>
> ------------------------------
>


-- 
Regards,

Ahmed Munir Chohan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120921/cd0772dc/attachment.htm>