List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:February 16 2011 11:41am
Subject:Re: Limit of Mysql
View as plain text  
Mostly correct - save for pointer sizes and such, but it's pretty hard to
reach those.

SQL vs NoSQL is not a matter of data size - plenty of fud is being spread
about NoSQL, for some reason - but a matter of access patterns.

Without knowing what you need and how you design, that question can't be
answered.


On Wed, Feb 16, 2011 at 8:48 AM, Reindl Harald <h.reindl@stripped>wrote:

> there are no hard limits as long your hardware ist fast enough
>
> * memory, memory and agin: memory
> * disk-speed
> * cpu
>
> Am 16.02.2011 06:04, schrieb Adarsh Sharma:
> > Dear all,
> >
> > I want to know the upper limit of mysql after which Mysql-5.*  fails to
> handle large amount of data ( 100's of GB
> > or 100's of TB's ) . After which we have to move to some NoSQL databases
> ( Hadoop, Hive , Hbase).
> >
> > Currently we have 100 of GB's  data in Mysql -5.1 RDBMS.
> >
> > Is anyone has some experience of moving from these open -source databses
> ( Mysql, Postgresql ) to some mechanism of
> > handling data in file systems.
> >
> > Please share the views.
> >
> >
> >
> > Thanks & best regards,
> >
> > Adarsh Sharma
> >
> >
> >
>
> --
>
> Mit besten Grüßen, Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofmühlgasse 17
> CTO / software-development / cms-solutions
> p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
> icq: 154546673, http://www.thelounge.net/
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
Limit of MysqlAdarsh Sharma16 Feb
  • Re: Limit of MysqlReindl Harald16 Feb
    • Re: Limit of MysqlJohan De Meersman16 Feb