[dba-Tech] NOSQL goes SQL?

Peter Brawley peter.brawley at earthlink.net
Wed Feb 27 13:26:58 CST 2013


On 2013-02-26 10:49 PM, Jim Lawrence wrote:
> Hi Peter:
>
> I find database deployment always a very interesting subject. Do you find
> clustered MySQL databases perform data manipulation at a reasonable speed
> even retrievals from your data warehouse?

Cluster expert I ain't, but what I read says it performs OK. The latest 
improvement combines MySQL cluster architecture with (nosql) Memcached. 
I just wanted to clarify that MySQL is fine with billions of rows.

PB

-----

>
> Facebook for a long time has been depended on a distributive system like you
> are describing. Thousands MySQL DBs clusters hold all the data but inorder
> to make all the data available in real-time it requires a NoSQL HBase which
> monitors and is the controller that managed all the data retrieval and
> deposits. Since then, because of performance requirements, more and more
> data is being moved into the Cassandra database.
>
> I can not say more I am not an expert in MySQL but I believe Hans is and he
> can give some additional insights. I believe one of the large sites that he
> manages uses a combination of MySQL and Cassandra.
>
> Jim
>
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Peter Brawley
> Sent: Monday, February 25, 2013 10:56 PM
> To: Discussion of Hardware and Software issues
> Subject: Re: [dba-Tech] NOSQL goes SQL?
>
>
> On 2013-02-25 10:22 PM, Jim Lawrence wrote:
>> Hi Stuart:
>>
>> At the risk of being repetitious, NoSQL is not trying to replace SQL. The
>> only reason similar products Map Reduce are around because SQL can not do
>> the job of managing huge data.
>>
>> SQL databases handles up to a million pieces of data while NoSQL databases
>> handle billions of pieces of data.
> MySQL handles loads like that. The DB needs to be structured correctly
> according to whether it's mainly OLTP or OLAP, of course, or split into
> OLTP and OLAP instances. It might also benefit from partitioning, or
> from deployment of a MySQL Cluster.
>
> PB
>
> -----
>
>>
> http://gigaom.com/2013/02/21/sql-is-whats-next-for-hadoop-heres-whos-doing-i
>> t
>>
>> Just think if the UI to NoSQL databases was really easy there goes those
> big
>> bucks for the techs that manage these ugly monstrosities now get. ;-)
>>
>> Jim
>>
>> -----Original Message-----
>> From: dba-tech-bounces at databaseadvisors.com
>> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan
>> Sent: Monday, February 25, 2013 3:21 PM
>> To: Discussion of Hardware and Software issues
>> Subject: [dba-Tech] NOSQL goes SQL?
>>
>> So much for NOSQL being the answer to life, the universe and everything.
>>
>> http://www.theregister.co.uk/2013/02/25/hortonworks_stinger/
>>
>> Hortonworks has unveiled the Stinger Initiative, a project to make
> Hadoop´s
>> Hive data
>> warehouse friendlier with SQL and faster.
>> ...
>>    Hadoop is a open-source implementation of Google´s MapReduce and a NoSQL
>> system.
>>
>> However, the NoSQL crowds realised they need to make their architectures
>> work better with
>> SQL-like tools used by businesses in the real world.
>> ...
>> According to Hortonworks, Stinger will make Hive "a more suitable tool for
>> the decision
>> support queries people want to perform on Hadoop".
>>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>



More information about the dba-Tech mailing list