Re: [asterisk-users] MYSQL problem
However, if you're going to be doing massive joins for reporting, you're better off using something else (or running individual MySQL slaves, whose purpose is to run those complex queries and doing nothing else). In a past life, our MySQL database ran circles around Oracle, Informix, and DB2... until someone ran a massive join on the same server, which caused MySQL to crawl. Good distinction to make. I should have been more clear. I believe mysql has read only slave capabilities within a clustered environment, so your point about the slaves isn't out of the question. However I don't believe in database engines doing really anything other than transaction processing. That's why IMHO there should always be a distinction between the database backend and whatever software you're using to generate OLAP data (this software should NOT be the database engine). I know this is not a common opinion, but if we keep the database engine doing what it's good at and leave any report processing to external software, we're generally able to get better performance out of each individual piece... -Dave -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
On Wednesday 27 January 2010 12:55:18 David Gibbons wrote: > > many people around think mysql is not a good option for database, they > think mysql > > is only suit for small business. but i want to have a try. i need to > convince them to use this. > > > This statement is absolute BS. Give me some factual, backed statements by > trained database professionals who don't work for Microsoft or Oracle (OK, > Sun) and we can talk. > > > I guarantee that mysql can be made at least as fast as Oracle with a > relational database that's designed, indexed and implemented properly. The > problem with the backend is NEARLY ALWAYS a problem with the DBA. I hate to > hear crap DBAs blame their problems on the backend. MySQL is top-notch and > production ready if you are logical about your DB design. For OLTP, I'd agree with you, and in fact, I'd go one step further. Nothing can touch MySQL for speed with OLTP. However, if you're going to be doing massive joins for reporting, you're better off using something else (or running individual MySQL slaves, whose purpose is to run those complex queries and doing nothing else). In a past life, our MySQL database ran circles around Oracle, Informix, and DB2... until someone ran a massive join on the same server, which caused MySQL to crawl. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
many people around think mysql is not a good option for database, they think mysql is only suit for small business. but i want to have a try. i need to convince them to use this. This statement is absolute BS. Give me some factual, backed statements by trained database professionals who don't work for Microsoft or Oracle (OK, Sun) and we can talk. I guarantee that mysql can be made at least as fast as Oracle with a relational database that's designed, indexed and implemented properly. The problem with the backend is NEARLY ALWAYS a problem with the DBA. I hate to hear crap DBAs blame their problems on the backend. MySQL is top-notch and production ready if you are logical about your DB design. -Dave -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
> 2010/1/27 Steve Edwards : >> So don't use ODBC, use Pro*C... On Wed, 27 Jan 2010, Zhang Shukun wrote: > you said" Personally, I'd vote for an AGI using whatever C API your DB > provides" what do you think about phpagi and cagi, if i choose the agi > method. while phpagi seems used more popular than cagi. I write my AGIs in C because that's my sharpest tool and because I'm "old-school" enough to care about shaving milliseconds. You can execute xxx AGIs written in C in the time it will take to load the PHP interpreter and parse your script. If you expect to process a lot of calls, all those milliseconds add up -- at least in my mind. I wrote my own AGI library because I started before cagi was available so I have no experience with it. On Wed, 27 Jan 2010, Zhang Shukun wrote: > i cant quantify my requirement now. but the business has not be start. > and the user will increase as time going. If you don't know where you are going how will you know what road to take? If you and your peers don't know how big your database will be or how many queries per second how can you say MySQL is not up to the job? -- Thanks in advance, - Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
This is WAY OT but I had no idea what fnal.gov was, so I checked it out: http://computing.fnal.gov/xms/Services/Getting_Services/Web_at_Fermilab/Professional_Home_Pages_at_Fermilab And I quote "...professional information about themself..." About themself? Really? Really? That is all. Cheers Dave -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Tilghman Lesher Sent: Wednesday, January 27, 2010 10:25 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] MYSQL problem On Wednesday 27 January 2010 01:34:57 Zhang Shukun wrote: > 2010/1/23 Steve Edwards : > > On Fri, 22 Jan 2010, Zhang Shukun wrote: > >> as you know, we can use MYSQL command to visit mysql database > >> > >> but if i use other database like Oracke,sybase,etc, Could i use MYSQL > >> command ? > > > > ODBC will do what you want. > > Thanks, while i think because oracle has no offical ODBC for linux system. I've used this driver with Oracle before with good results. Just make sure that you use the full Oracle libraries, not the Instant Client. The Instant Client has a severe resource leak that makes it inappropriate for long-running processes. http://home.fnal.gov/~dbox/oracle/odbc/ -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
On Wednesday 27 January 2010 01:34:57 Zhang Shukun wrote: > 2010/1/23 Steve Edwards : > > On Fri, 22 Jan 2010, Zhang Shukun wrote: > >> as you know, we can use MYSQL command to visit mysql database > >> > >> but if i use other database like Oracke,sybase,etc, Could i use MYSQL > >> command ? > > > > ODBC will do what you want. > > Thanks, while i think because oracle has no offical ODBC for linux system. I've used this driver with Oracle before with good results. Just make sure that you use the full Oracle libraries, not the Instant Client. The Instant Client has a severe resource leak that makes it inappropriate for long-running processes. http://home.fnal.gov/~dbox/oracle/odbc/ -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
2010/1/27 Steve Edwards : > Un-mid-posting... > >>> On Fri, 22 Jan 2010, Zhang Shukun wrote: >>> as you know, we can use MYSQL command to visit mysql database but if i use other database like Oracke,sybase,etc, Could i use MYSQL command ? >>> >> 2010/1/23 Steve Edwards : > >>> ODBC will do what you want. >>> >>> Personally, I'd vote for an AGI using whatever C API your DB provides >>> -- like Pro*C to access Oracle. >>> >>> You will have access to all of the features of your DB and your >>> dialplan will be a lot cleaner and easier to maintain. > > On Wed, 27 Jan 2010, Zhang Shukun wrote: > >> Thanks, while i think because oracle has no offical ODBC for linux >> system. is that better use mysql than oracle. considering the >> perfoermace and speed. many people around think mysql is not a good >> option for database, they think mysql is only suit for small business. >> but i want to have a try. i need to convince them to use this. > > So don't use ODBC, use Pro*C... you said" Personally, I'd vote for an AGI using whatever C API your DB provides" what do you think about phpagi and cagi, if i choose the agi method. while phpagi seems used more popular than cagi. > > Back when Yahoo was relevant, they ran on MySQL. > > Can you quantify your requirements (number of rows, queries per second, > simultaneous connections) and test it on hardware similar to your > production environment? i cant quantify my requirement now. but the business has not be start. and the user will increase as time going. > > While I'm sure Yahoo spent a lot of time and money designing and tuning > their system, sometimes "explain plan" can point you to small changes that > yield significant results. > > If your shop is committed to Oracle, can finance the licenses, and has the > in-house talent -- use it. Nobody ever lost their job by buying IBM... > > -- > Thanks in advance, > - > Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST > Newline Fax: +1-760-731-3000 > > -- > _ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > -- Best regards, Sucan -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
Un-mid-posting... >> On Fri, 22 Jan 2010, Zhang Shukun wrote: >> >>> as you know, we can use MYSQL command to visit mysql database but if i >>> use other database like Oracke,sybase,etc, Could i use MYSQL command ? >> > 2010/1/23 Steve Edwards : >> ODBC will do what you want. >> >> Personally, I'd vote for an AGI using whatever C API your DB provides >> -- like Pro*C to access Oracle. >> >> You will have access to all of the features of your DB and your >> dialplan will be a lot cleaner and easier to maintain. On Wed, 27 Jan 2010, Zhang Shukun wrote: > Thanks, while i think because oracle has no offical ODBC for linux > system. is that better use mysql than oracle. considering the > perfoermace and speed. many people around think mysql is not a good > option for database, they think mysql is only suit for small business. > but i want to have a try. i need to convince them to use this. So don't use ODBC, use Pro*C... Back when Yahoo was relevant, they ran on MySQL. Can you quantify your requirements (number of rows, queries per second, simultaneous connections) and test it on hardware similar to your production environment? While I'm sure Yahoo spent a lot of time and money designing and tuning their system, sometimes "explain plan" can point you to small changes that yield significant results. If your shop is committed to Oracle, can finance the licenses, and has the in-house talent -- use it. Nobody ever lost their job by buying IBM... -- Thanks in advance, - Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
2010/1/23 Steve Edwards : > On Fri, 22 Jan 2010, Zhang Shukun wrote: > >> as you know, we can use MYSQL command to visit mysql database >> >> but if i use other database like Oracke,sybase,etc, Could i use MYSQL >> command ? > > ODBC will do what you want. Thanks, while i think because oracle has no offical ODBC for linux system. is that better use mysql than oracle. considering the perfoermace and speed. many people around think mysql is not a good option for database, they think mysql is only suit for small business. but i want to have a try. i need to convince them to use this. > > Personally, I'd vote for an AGI using whatever C API your DB provides > -- like Pro*C to access Oracle. > > You will have access to all of the features of your DB and your dialplan > will be a lot cleaner and easier to maintain. > > -- > Thanks in advance, > - > Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST > Newline Fax: +1-760-731-3000 > > -- > _ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > -- Best regards, Sucan -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
On Fri, 22 Jan 2010, Zhang Shukun wrote: > as you know, we can use MYSQL command to visit mysql database > > but if i use other database like Oracke,sybase,etc, Could i use MYSQL > command ? ODBC will do what you want. Personally, I'd vote for an AGI using whatever C API your DB provides -- like Pro*C to access Oracle. You will have access to all of the features of your DB and your dialplan will be a lot cleaner and easier to maintain. -- Thanks in advance, - Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem
On Friday 22 January 2010 02:06:08 Zhang Shukun wrote: > as you know, we can use MYSQL command to visit mysql database > > but if i use other database like Oracke,sybase,etc, Could i use MYSQL > command ? > > if not, is there any other alternative could do the same > function(visit database in dailplan)? func_odbc will do what you want. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] MYSQL problem and configuration
Hello,I am new to asterisk but i have vbeen scriptinh PHP SQL and webLanguages
for a long time.I can Give you a solution but using php
AGI:extensions.con-> AGI(connect.agi);/var/lib/asterisk/agi-bin/connect.agi
:#!/usr/bin/php
-q12");while($entry = mysql_fetch_array($result))
{fwrite(STERR, "Name : $entry['name'], Age: $entry['age']
\n");fflush(STDOUT);$result =
trim(fgets(STDIN,4096));checkresult($result);}?>It will return things on the
asterisk CLI You can adapt this example for youI don't know if it help but
it shows a way to do...Kheraud> From: [EMAIL PROTECTED]> To:
asterisk-users@lists.digium.com> Date: Fri, 24 Aug 2007 12:56:55 +0300>
Subject: [asterisk-users] MYSQL problem and configuration> > Greetings
everyone> > I've set up a call recording system on debian 4.0 with asterisk and
mysql db> for handling user information (accessible over the net for users).
My> asterisk is running on one machine and the mysql on another. The
connection> is over lan. Now I have a problem and a question.> > My problem
is:> When mysql_real_connect doesn't get connection to the mysql server
asterisk> pretty much freezes and doesn't let any info go in or out, even the
CLI> freezes. I've seen a bug report on this but no solution(?)> Although this
might be a bug with asterisk when I have the connection set to> a hosted mysql
server (company that hosts our website during the testing> period) the
connection works fine so I've come to conclusion that the> problem might be the
mysql and/or debian configuration I have. SO...> > My question is:> How should
I configure mysql (and debian box) for asterisk connections?> > Best regards>
Jari-Pekka Lehtinen> > > ___>
--Bandwidth and Colocation Provided by http://www.api-digital.com--> >
asterisk-users mailing list> To UNSUBSCRIBE or update options visit:>
http://lists.digium.com/mailman/listinfo/asterisk-users
_
Le blog Messenger de Michel, candidat de la Nouvelle Star : analyse, news,
coulisses… A découvrir !
http://michel-nouvelle-star2007.spaces.live.com/___
--Bandwidth and Colocation Provided by http://www.api-digital.com--
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
