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
