[ilugd] Database Management My Sql
Dear All, I am working on a project which is live for some gaming purpose. My problem is, one of my table size has gone beyond my imagination and it records nearly 1 lack per day which is making database searching very slow. We have allocated a separate server for database. Can anyone suggest me how to get rid of this. One simple solution that comes into my mind is to use hadoop but any experienced help on this? -- Thanks and Regards RAKESH KUMAR http://raakeshkumar.wordpress.com ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] [Commercial] Seriously talented dev-ops engineer to run the whole stack
On 11/07/2012 07:38 AM, Sandeep wrote: Why not YATE, http://yate.null.ro/; Yate is modular, efficiently programmed in C++ from scratch and much more stable even the svn/development version works out from the box. Well, I'll confess that this is the first time that I have heard about Yate. I That makes two of us, having had a look around, it does not appear to have had any sort of code audit. I'd be keen on keeping an eye out for that ( or even instigating one ) -- Karanbir Singh +44-207-0999389 | http://www.karan.org/ | twitter.com/kbsingh ICQ: 2522219| Yahoo IM: z00dax | Gtalk: z00dax GnuPG Key : http://www.karan.org/publickey.asc ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] [Commercial] Seriously talented dev-ops engineer to run the whole stack
On 11/07/2012 03:38 PM, Karanbir Singh wrote: On 11/07/2012 07:38 AM, Sandeep wrote: Why not YATE, http://yate.null.ro/; Yate is modular, efficiently programmed in C++ from scratch and much more stable even the svn/development version works out from the box. Well, I'll confess that this is the first time that I have heard about Yate. I That makes two of us, having had a look around, it does not appear to have had any sort of code audit. I'd be keen on keeping an eye out for that ( or even instigating one ) Please do check: http://comments.gmane.org/gmane.comp.telephony.yate/6082 It is not a fork of Asterisk like the OpenPBX.org which eventually turned into FreeSWICH; whereas the FreeSWITCH again is a completely re-written alternative. I do not intend to initiate a war; but am talking about FLOSS (Free/Libre Open Source) alternatives; forget to mention the FreeSWITCH in my earlier post, indeed. IMHO, All these, the Asterisk, the FreeSWITCH and the Yate fulfill difference design goals, but almost same functionality while one of these might be more suitable for a particular scenario and, or environment. -- Balwinder S bdheeman Dheeman (http://werc.homelinux.net/contact/) ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] [Commercial] Seriously talented dev-ops engineer to run the whole stack
On 11/07/2012 01:08 PM, Sandeep wrote: Balwinder S Dheeman bdheeman@... writes: In addition, you will get the chance (if you want) to build and run a sophisticated call routing system built over Asterisk. Why not YATE, http://yate.null.ro/; Yate is modular, efficiently programmed in C++ from scratch and much more stable even the svn/development version works out from the box. Well, I'll confess that this is the first time that I have heard about Yate. I have only ever interacted with Asterisk or Freeswitch. Perhaps there are advantages or disadvantages to each - that is something to be looked at. Plus there is the question of availability of talent (across all our offices in different cities). Who should I reach out to if we were evaluating this - would you be the right person ? Sorry, I'm busy doing other important projects these days. Anyway, the Null Team, developers of Yate and Yate community is quite active and quick at resolving problems and, or answering questions. -- Balwinder S bdheeman Dheeman (http://werc.homelinux.net/contact/) ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] [Commercial] Seriously talented dev-ops engineer to run the whole stack
On 11/07/2012 04:19 PM, Balwinder S Dheeman wrote: On 11/07/2012 03:38 PM, Karanbir Singh wrote: On 11/07/2012 07:38 AM, Sandeep wrote: Why not YATE, http://yate.null.ro/; Yate is modular, efficiently programmed in C++ from scratch and much more stable even the svn/development version works out from the box. Well, I'll confess that this is the first time that I have heard about Yate. I That makes two of us, having had a look around, it does not appear to have had any sort of code audit. I'd be keen on keeping an eye out for that ( or even instigating one ) Please do check: http://comments.gmane.org/gmane.comp.telephony.yate/6082 It is not a fork of Asterisk like the OpenPBX.org which eventually turned into FreeSWICH; whereas the FreeSWITCH again is a completely re-written alternative. I do not intend to initiate a war; but am talking about FLOSS (Free/Libre Open Source) alternatives; forget to mention the FreeSWITCH in my earlier post, indeed. IMHO, All these, the Asterisk, the FreeSWITCH and the Yate fulfill difference design goals, but almost same functionality while one of these might be more suitable for a particular scenario and, or environment. See also: http://lists.freeswitch.org/pipermail/freeswitch-users/2008-July/004606.html -- Balwinder S bdheeman Dheeman (http://werc.homelinux.net/contact/) ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] Database Management My Sql
On Wed, Nov 7, 2012 at 2:16 PM, Raakesh kumar kumar3...@gmail.com wrote: Dear All, I am working on a project which is live for some gaming purpose. My problem is, one of my table size has gone beyond my imagination and it records nearly 1 lack per day which is making database searching very slow. We have allocated a separate server for database. Can anyone suggest me how to get rid of this. One simple solution that comes into my mind is to use hadoop but any experienced help on this? You can use a MySQL slave dedicated to search if you are using Full Text Search or use Apache Solr for searching instead of using MySQL. This seems like a good starting guide for HiveDB:- http://himanshubaweja.com/post/7529434265/analytics-reached-mysql-limit-lets-hive Ofcourse you need to add more processing power to get results in a reasonable amount of time. -Tarun ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] [Commercial] Seriously talented dev-ops engineer to run the whole stack
On Wednesday 07 Nov 2012, Balwinder S Dheeman wrote: [snip] Please do check: http://comments.gmane.org/gmane.comp.telephony.yate/6082 It is not a fork of Asterisk like the OpenPBX.org which eventually turned into FreeSWICH; whereas the FreeSWITCH again is a completely re-written alternative. I do not intend to initiate a war; but am talking about FLOSS (Free/Libre Open Source) alternatives; forget to mention the FreeSWITCH in my earlier post, indeed. IMHO, All these, the Asterisk, the FreeSWITCH and the Yate fulfill difference design goals, but almost same functionality while one of these might be more suitable for a particular scenario and, or environment. I deploy Asterisk for the same reason that I still use Sendmail as the MTA for those clients who need large mailers: - It's been around for donkey's years -- the technology is tried and tested - Flaws are (mostly) known and workarounds public - Huge developer community - Availability of III-party extensions to do almost anything you need from the system - Vibrant and responsive community so problem-solving, patches, etc. are easily available Sure, there are better (subjectively speaking) alternatives around, but then, If It Ain't Broken, Don't Fix It. Sendmail's been working for me for over 20 years, Asterisk for nearly 10, so I happily stand in the Way of Progress and continue using antediluvian packages. Also, the desire to use something just because it's new and shiny just isn't there anymore... hey, my desktop is Debian! Regards, -- Raj -- Raj Mathur || r...@kandalaya.org || GPG: http://otheronepercent.blogspot.com || http://kandalaya.org || CC68 It is the mind that moves || http://schizoid.in || D17F ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] Database Management My Sql
On Wednesday 07 Nov 2012, Raakesh kumar wrote: Dear All, I am working on a project which is live for some gaming purpose. My problem is, one of my table size has gone beyond my imagination and it records nearly 1 lack per day which is making database searching very slow. We have allocated a separate server for database. Can anyone suggest me how to get rid of this. One simple solution that comes into my mind is to use hadoop but any experienced help on this? If it's an option, switch to an RDBMS that was designed for enterprise- class deployment from day 1, i.e. an RDBMS that doesn't have My in the name. Yeah, I know this is going to start another flame war but WTH, Delhi's getting colder by the day. I'm planning to install a few old computers around slum clusters, at least the heat generated on the list will keep them warm at nights! Regards, -- Raj -- Raj Mathur || r...@kandalaya.org || GPG: http://otheronepercent.blogspot.com || http://kandalaya.org || CC68 It is the mind that moves || http://schizoid.in || D17F ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] Database Management My Sql
On Thu, Nov 8, 2012 at 9:46 AM, Raj Mathur (राज माथुर) r...@linux-delhi.org wrote: If it's an option, switch to an RDBMS that was designed for enterprise- class deployment from day 1, i.e. an RDBMS that doesn't have My in the name. Yeah, I know this is going to start another flame war but WTH, Delhi's getting colder by the day. I'm planning to install a few old computers around slum clusters, at least the heat generated on the list will keep them warm at nights! Regards, Well i have created one more index on the respective table and have created partitions on the table based on date range. This has increased the performance by 50% for now but it's very scary as table is recording approx 1 lack rows per day so i am switching to MongoDB now with sharding. @Tarun, Thanks I will try Apache Solr. BTW just to ask why did Google, Facebook didn't switch to Mongo DB if it's that difficult in MySql? I have seen so many big applications are still running and being developed on My Sql. -- Regards RAKESH KUMAR http://raakeshkumar.wordpress.com ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
Re: [ilugd] [Commercial] Seriously talented dev-ops engineer to run the whole stack
On 11/08/2012 09:41 AM, Raj Mathur (राज माथुर) wrote: I deploy Asterisk for the same reason that I still use Sendmail as the MTA for those clients who need large mailers. [bsd@anu ~]$ aptitude show default-mta No current or candidate version found for default-mta Package: default-mta State: not a real package Provided by: exim4-daemon-light hey, my desktop is Debian! Regards, -- Raj Mine workstation is also powered by Debian since 2003, I re-installed it only once since then, because I wanted try it amd46/x86_64 variant. I started with Slackware (Obtained from a PC-Quest CD), used RedHat for a few years (thanks to PC-Quest again) and also FreeBSD 8.0-CURRENT for a year or so, which even served my web sites quite efficiently and flawlessly; Yes I'm brave enough to build, test, evaluate and, or deploy any FLOSS (Free/Libre Open Source Software) ;) -- Balwinder S bdheeman Dheeman (http://werc.homelinux.net/contact/) ___ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd