Thanks Bryant and David for sharing.
> From: "Bryant Zimmerman" <[email protected]> > Subject: Re: [asterisk-users] Trigger Asterisk after data inserted in > mysql > To: "Asterisk Users Mailing List - Non-Commercial Discussion" > <[email protected]> > Message-ID: <[email protected]> > 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" <[email protected]> > Sent: Wednesday, September 19, 2012 2:04 PM > To: [email protected] > 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 > <[email protected]> Subject: [asterisk-users] Trigger Asterisk after > data inserted in mysql To: [email protected]: > <CAGMN=JdbE5FdDSQXxZ9OrWXu3Pvgc-hj-EnPxUrG= > [email protected]> > 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
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
