Dear Ravi, That was really informative. Although i have not started the thread. But i was unaware of these facts. Thanks for the kind info.
Cheers! On Fri, Nov 9, 2012 at 1:30 AM, <ilugd-requ...@lists.linux-delhi.org> wrote: > Send Ilugd mailing list submissions to > ilugd@lists.linux-delhi.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://frodo.hserus.net/mailman/listinfo/ilugd > or, via email, send a message with subject or body 'help' to > ilugd-requ...@lists.linux-delhi.org > > You can reach the person managing the list at > ilugd-ow...@lists.linux-delhi.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Ilugd digest..." > > > Today's Topics: > > 1. [NCR-PYTHON]Mail Server Creation in Python (Raakesh kumar) > 2. Re: Database Management My Sql (Ravi Kumar) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 8 Nov 2012 15:47:25 +0530 > From: Raakesh kumar <kumar3...@gmail.com> > To: NCR Python Users Group India <ncr-python...@python.org>, > Ilugd@lists.linux-delhi.org > Subject: [ilugd] [NCR-PYTHON]Mail Server Creation in Python > Message-ID: > < > caeid6wfhpjz7iicue3rb+b5xgqgxo3y2epr8dwju9dx8dlx...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Dear All, > I have to start a project for our internal purpose and that is we have to > create a MTA which will take data from our database(like from, to, message > etc.) and will transfer/receive it to/from other ISPs (e.g. google mail, > yahoo mails). The problem which i think could arise is, our peak time value > for sending/receiving mails would be 5K mails/sec. I can develop normal > server and can use python for this purpose but not sure whether it will be > able to handle 5K mails/sec so thought to ask first. > > -- > Regards > RAKESH KUMAR > http://raakeshkumar.wordpress.com > > > ------------------------------ > > Message: 2 > Date: Thu, 8 Nov 2012 21:32:34 +0530 > From: Ravi Kumar <ra2...@gmail.com> > To: Raakesh kumar <kumar3...@gmail.com> > Cc: Ilugd@lists.linux-delhi.org > Subject: Re: [ilugd] Database Management My Sql > Message-ID: > < > capqpr+_e3gbpc1ae7dqkoaqeydvxfhuc1sfonfuzq0ymd6r...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Managing Big data on MySql is challenging. Many companies do that their own > way, like some partition their users based alphabetically on different > database servers with replications and load balancing for each, resulting > in 100 DB servers. > Google uses their own home baked nosql DB, BigTable. Facebook uses multi > Mysql. > > Ravi Kumar > On 08-Nov-2012 11:50 AM, "Raakesh kumar" <kumar3...@gmail.com> wrote: > > > 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 > > > > > ------------------------------ > > _______________________________________________ > Ilugd mailing list > Ilugd@lists.linux-delhi.org > http://frodo.hserus.net/mailman/listinfo/ilugd > > > End of Ilugd Digest, Vol 36, Issue 5 > ************************************ > _______________________________________________ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
