Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 306 Next 30 Older Entries

Displaying posts with tag: NoSQL (reset)

Wanted: Evaluators to Try MongoDB with Fractal Tree Indexing
+0 Vote Up -0Vote Down

We recently resumed our discussion around bringing Fractal Tree indexes to MongoDB.  This effort includes Tokutek’s interview with Jeff Kelly at Strata as well as my two recent tech blogs which describe the compression achieved on a generic MongoDB data set and performance improvements we measured using on our implementation of Sysbench for MongoDB.  I have a full line-up of benchmarks and blogs planned for the next few months, as our project continues.  Many of these

  [Read more...]
The Last Mile for Big Data – Strata Overview with Jeff Kelly of Wikibon (Part 2)
+0 Vote Up -0Vote Down

During the second half of our CUBE discussion with Wikibon analyst Jeff Kelly at this year’s Strata Conference in Santa Clara, we talked about the tipping point for Big Data. Strata veterans could see at a glance that this year’s conference was markedly different. No longer the exclusive domain of geeks and database administrators, this year’s Strata featured some of the biggest enterprise vendors around. With heavy weight enterprise players Intel and EMC Greenplum announcing their own Hadoop distributions, big data is clearly going mainstream. Now that we know how to capture, store, access and analyze big data, what’s the next step? Listen in to hear my conversation with Jeff Kelly about taking big data

  [Read more...]
MySQL and MongoDB – Strata Discussion with Jeff Kelly of Wikibon (Part 1)
+1 Vote Up -0Vote Down

We had the opportunity to do a CUBE interview with Wikibon analyst Jeff Kelly at last week’s Strata Conference in Santa Clara. In the first part of our conversation, we discuss how our success in integrating Tokutek’s Fractal Tree® technology into MySQL has led us to another popular database, MongoDB. We explain the results of our recent benchmarking tests with MongoDB, which indicate that adding indexing can also improve performance for this popular NoSQL database with faster insertion rates, lower query latency and

  [Read more...]
MongoDB + Fractal Tree Indexes = High Compression
+2 Vote Up -0Vote Down

One doesn’t have to look far to see that there is strong interest in MongoDB compression. MongoDB has an open ticket from 2009 titled “Option to Store Data Compressed” with Fix Version/s planned but not scheduled. The ticket has a lot of comments, mostly from MongoDB users explaining their use-cases for the feature. For example, Khalid Salomão notes that “Compression would be very good to reduce storage cost and improve IO performance” and Andy notes that “SSD is getting more and more common for

  [Read more...]
NoSQL is Great, But You Still Need Indexes
+1 Vote Up -0Vote Down

I’ve said it before, and, as is the nature of these things, I’ll almost certainly say it again: your database performance is only as good as your indexes.

That’s the grand thesis, so what does that mean? In any DB system — SQL, NoSQL, NewSQL, PostSQL, … — data gets ingested and organized. And the system answers queries. The pain point for most users is around the speed to answer queries. And the query speed (both latency and throughput, to be exact) depend on how the data is organized. In short: Good Indexes, Fast Queries; Poor Indexes, Slow Queries.

But building indexes is hard work, or at least it has been for the last several decades, because almost all indexing is done with B-trees. That’s true of

  [Read more...]
The Data Day, Two days: February 11/12 2013
+0 Vote Up -0Vote Down

ClearStory sheds light on data analysis service. Illuminating ‘dark data’. More.

For 451 clients: ClearStory bags $9m in series A funding, sheds light on its data analysis service bit.ly/Y6v8sV By Krishna Roy

— Matt Aslett (@maslett) February 12, 2013

For 451 clients: Global IDs makes ‘big data’ MDM play via cloud and Hadoop, touts profitable growth bit.ly/Y6v6kL By Krishna Roy

— Matt Aslett (@maslett) February 12, 2013

ScaleBase releases version 2.0 of its MySQL database scalability software bit.ly/WGtEtN

  [Read more...]
MySQL-State of the Union. Interview with Tomas Ulin.
+8 Vote Up -0Vote Down
“With MySQL 5.6, developers can now commingle the “best of both worlds” with fast key-value look up operations and complex SQL queries to meet user and application specific requirements” –Tomas Ulin. On February 5, 2013, Oracle announced the general availability of MySQL 5.6. I have interviewed Tomas Ulin, Vice President for the MySQL Engineering team [...]
Neither fish nor fowl: the rise of multi-model databases
+0 Vote Up -0Vote Down

One of the most complicated aspects of putting together our database landscape map was dealing with the growing number of (particularly NoSQL) databases that refuse to be pigeon-holed in any of the primary databases categories.

I have begun to refer to these as “multi-model databases” in recognition of the fact that they are able to take on the characteristics of multiple databases. In truth though there are probably two different groups of products that could be considered “multi-model”:

True multi-model databases that have been designed specifically to serve multiple data models and use-cases

Examples include:
FoundationDB, which is being designed to

  [Read more...]
NoSQL with MySQL's Memcached API
Employee +0 Vote Up -0Vote Down

One of our training courses has a section covering MySQL's Memcached API, and how it works. In the discussion, there's a line that goes like this:

 "A key is similar to a primary key in a table, and a value is similar to a second column in the same table"

For someone well versed in database tables but not so much in key-value stores, that sentence might take a bit of grasping. So, let's break it down.

An Example Key/Value Store 

Imagine the table kvstore has a column key and a column value. Also imagine that we've set up the Memcached plugin in MySQL and configured it to use that table and those columns as its store. I won't get into that bit for now, but trust me, it's not that hard.

You might be familiar with statements like this:

  [Read more...]
Introducing Data Fabric Design for Commodity SQL Databases
+3 Vote Up -0Vote Down
Extract from THE SCALE-OUT BLOG by Robert Hodges (CEO, Continuent)http://scale-out-blog.blogspot.com Data management is undergoing a revolution. Many businesses now depend on data sets that vastly exceed the capacity of DBMS servers. Applications operate 24x7 in complex cloud environments using small and relatively unreliable VMs. Managers need to act on new information from those systems in
Introducing Data Fabric Design for Commodity SQL Databases
+2 Vote Up -0Vote Down
Data management is undergoing a revolution.  Many businesses now depend on data sets that vastly exceed the capacity of DBMS servers.  Applications operate 24x7 in complex cloud environments using small and relatively unreliable VMs.  Managers need to act on new information from those systems in real-time. Users want constant and speedy access to their data in locations across the planet.

It is tempting to think popular SQL databases like MySQL and PostgreSQL have no place in this new world.  They manage small quantities of data, lack scalability features like parallel query, and have weak availability models.  One reaction is to discard them and adopt alternatives like Cassandra or MongoDB.  Yet open source SQL databases have tremendous strengths:  simplicity, robust transaction support, lightning fast operation, flexible

  [Read more...]
MySQL Presentations from FOSDEM 2013
Employee +4 Vote Up -0Vote Down

FOSDEM 2013

The Free and Open source Software Developers’ European Meeting (FOSDEM) is a two-day event organized by volunteers to promote the widespread use of Free and Open Source software.

I attended for the first time over the weekend and was really impressed by the number of people there, the energy and the quality of the content. The event really lives up to it’s name and is very developer-focused.

In the end, I got the opportunity to make 2 presentations. The first is a general introduction to MySQL Cluster….



The second illustrates how you can realise the benefits promised by NoSQL data stores wihtout losing the consistency and flexibility of relational databases…



Impressions of FOSDEM 13
+0 Vote Up -0Vote Down
FOSDEM 13 is now over, I am on my way home and I would like to share some thoughts sparkled by the intense atmosphere that I have lived in these two days in Brussels. I have to admit, I was tempted to skip FOSDEM this year: the last 3 weeks have been crazily busy and I travelled a lot, leaving my family alone for too long. But now I am glad I made the effort.  

read more

Moving from MySQL to Couchbase
+0 Vote Up -0Vote Down

Before moving to Couchbase and working with NoSQL technology I had for years been a MySQL user. Making that leap from MySQL to NoSQL requires a number of changes, not least of which to the way you structure your data and then query it. 

I’ve tried to distil the first part of that process down into a simpler form and steps in a new blog post oat the Couchbase blog http://blog.couchbase.com/how-move-mysql-couchbase-server-20-part-1


FOSDEM 2013, another nice open source event in Europe!
+2 Vote Up -0Vote Down
FOSDEM is a free event that offers open source communities a place to meet, 
share ideas and collaborate.
It is renowned for being highly developer-oriented 
and brings together 5000+ geeks from all over the world.

 
This year again, be sure that FOSDEM will be the place to be in February!

Do you have any doubts? Really ? Dude, repeat after me :

  • Free event
  • During a week-end
  • Beer
  • 5000+ open source geeks
  • Beer
  • MySQL and Friends devroom
  • NoSQL devroom
  • No registration needed (open source man!)
  • Ok, that sounds good?

    Well, here are the informations to attend this terrific event :

    • How to register? : Are you kidding me?
    • When : 2 & 3 February 2013 (Hurry up guys!)
    • Where : Brussels (beers!!!)

      [Read more...]
    Searching document stores in 2013: from 1983 to SQL:2003 in a blink?
    Employee +2 Vote Up -0Vote Down

    I love the new NoSQL systems: more choices! After years of RDBMS dominance there are hundrets of NoSQL systems offering a wide range of data models, data distribution strategies and interfaces. Polyglot persistence describes the market change. I am most fascinated by document stores: nested data and data distribution go hand-in-hand. Nested data, finally. And, for those who like it: schemaless or even schemafree. Maybe something to learn for MySQL? But their search capabilities… A word or two on SQL (SELECT … FROM … WHERE – SFW) and nested data.

    Learn from NoSQL document stores

    The classical relational data model requests all data to be in

      [Read more...]
    The Data Day, Two days: January 9/10 2013
    +0 Vote Up -0Vote Down

    SAP on HANA. Funding for Guavus and ScaleArc. And more

    It’s alive! @451research‘s 2013 Database survey is available now at bit.ly/451db13 #mysql #nosql #newsql #postgresql etc etc

    — Matt Aslett (@maslett) January 9, 2013

    #SAPonHANA is official. Read the press release for the SAP Business Suite powered by #SAP

      [Read more...]
    Our 2013 Database survey is now live
    +0 Vote Up -0Vote Down

    451 Research’s 2013 Database survey is now live at http://bit.ly/451db13 investigating the current use of database technologies, including MySQL, NoSQL and NewSQL, as well as traditional relation and non-relational databases.

    The aim of this survey is to identify trends in database usage, as well as changing attitudes to MySQL following its acquisition by Oracle, and the competitive dynamic between MySQL and other databases, including NoSQL and NewSQL technologies.

    There are just 15 questions to answer, spread over five pages, and the entire survey should take less than ten minutes to complete.

    All individual responses are of course

      [Read more...]
    [Plus] readers choice 2012 : It’s time to vote!
    +2 Vote Up -0Vote Down

    Oh yes, 2012 was an incredible year for the MySQL Community!
    That’s why I would like to change the rules this year and I would like to offer you a new survey for this [Plus] reader’s choice 2012.

    Community users, bloggers and events made the whole community last year, tell us how you used this community?
    It will only take 5 minutes of your precious time, votes will be closed Jan. 31.

    Vote for what you used! (with your heart, again…)

    Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit

      [Read more...]
    Move over Marcia: Top Ten for 2012
    +0 Vote Up -0Vote Down

    Well, it’s that time of the year again for top ten lists. There have been many versions showing up on the web the last few days, including Time Magazine’s “Top 10 Everything of 2012″ list, with 55 wide ranging lists!

    Last year we started using Google Analytics to see what content for blogs was most popular on Tokutek.com and generated a 2011 top ten list, ending up with a few surprises.  This year saw spikes in some interesting areas as well, including flash performance, NASA and Big Data, and MongoDB.

    Without further adieu, here is the top ten list for 2012:

    10. Announcing TokuDB v6.1

      [Read more...]
    2012, the Best Year for MySQL (...so far, but more to come)
    +9 Vote Up -3Vote Down
    It's the end of the year and, before the world ends ;-) , I feel the pressure to follow up on last year's article "2011, a great year for MySQL in Review". I'll adopt a similar format and mention things in context, covering products, marketing, momentum, etc. at a high level. I may have missed something and I hope my colleagues will contribute to the list.

    I really do think it's been the best year for MySQL so far... well, at least since when I signed my contract with MySQL AB at the end of 2007. We're just at the beginning of our journey and I wish to the MySQL family, to our community and ecosystem an even better 2013!

    Summary





      [Read more...]
    NoSQL Memcached API for MySQL: Latest Updates
    Employee_Team +4 Vote Up -0Vote Down

    With data volumes exploding, it is vital to be able to ingest and query data at high speed. For this reason, MySQL has implemented NoSQL interfaces directly to the InnoDB and MySQL Cluster (http://www.mysql.com/products/cluster/) (NDB) storage engines, which bypass the SQL layer completely. Without SQL parsing and optimization, Key-Value data can be written directly to MySQL tables up to 9x faster, while maintaining ACID guarantees.

    In addition, users can continue to run complex queries with SQL across the same data set, providing real-time analytics to the business or anonymizing sensitive data before loading to big data platforms such as Hadoop, while still maintaining all of the advantages of their existing relational database infrastructure.

    This and more is discussed in the latest Guide to MySQL and NoSQL

      [Read more...]
    On Big Data, Analytics and Hadoop. Interview with Daniel Abadi.
    +0 Vote Up -0Vote Down
    “Some people even think that “Hadoop” and “Big Data” are synonymous (though this is an over-characterization). Unfortunately, Hadoop was designed based on a paper by Google in 2004 which was focused on use cases involving unstructured data (e.g. extracting words and phrases from Webpages in order to create Google’s Web index). Since it was not [...]
    Distributed Clustering Services
    +0 Vote Up -0Vote Down
    Apart from my consulting as part of ScaleIn, I also invest to bootstrap companies with really disruptive ideas; and in the process met few database specific companies who are already[...]
    Typical “Big” Data Architecture
    +1 Vote Up -0Vote Down
    Here is the typical “Big” data architecture, that covers most components involved in the data pipeline. More or less, we have the same architecture in production in number of places[...]
    MySQL and Hadoop Integration - Unlocking New Insight
    Employee_Team +4 Vote Up -0Vote Down

    “Big Data” offers the potential for organizations to revolutionize their operations. With the volume of business data doubling every 1.2 years, analysts and business users are discovering very real benefits when integrating and analyzing data from multiple sources, enabling deeper insight into their customers, partners, and business processes.

    As the world’s most popular open source database, and the most deployed database in the web and cloud, MySQL is a key component of many big data platforms, with Hadoop vendors estimating 80% of deployments are integrated with MySQL.

    The new Guide to MySQL and Hadoop (http://www.mysql.com/why-mysql/white-papers/mysql_wp_hadoop.php) presents the tools enabling integration between the two data platforms, supporting the data lifecycle from

      [Read more...]
    Election 2012: Twitter Breaks Records with MySQL
    Employee_Team +8 Vote Up -0Vote Down
    Twitter VP of Infrastructure Operations Engineering Mazen Rawashdeh shared news and numbers yesterday on his blog:

    "Last night, the world tuned in to Twitter to share the election results as U.S. voters chose a president and settled many other campaigns. Throughout the day, people sent more than 31 million election-related Tweets (which contained certain key terms and relevant hashtags). And as results rolled in, we tracked the surge in election-related Tweets at 327,452 Tweets per minute (TPM). These numbers reflect the largest election-related Twitter conversation during our 6 years of existence, though they don’t capture the total volume of all Tweets yesterday."

    "Last night, Twitter averaged about 9,965 TPS from 8:11pm to 9:11pm PT, with a


      [Read more...]
    MySQL Cluster 7.3: On-Demand Webinar and Q&A Available
    Employee_Team +3 Vote Up -0Vote Down

    The on-demand webinar for the MySQL Cluster 7.3 Development Release is now available.

    You can learn more about the design, implementation and getting started with all of the new MySQL Cluster 7.3 features from the comfort and convenience of your own device, including:

    - Foreign Key constraints in MySQL Cluster

    - Node.js NoSQL API 

    - Auto-installation of higher performance distributed, clusters

    We received some great questions over the course of the webinar, and I wanted to share

      [Read more...]
    Two Cons against NoSQL. Part I.
    +1 Vote Up -1Vote Down
    Two cons against NoSQL data stores read like this: 1. It’s very hard to move data out from one NoSQL to some other system, even other NoSQL. There is a very hard lock in when it comes to NoSQL. If you ever have to move to another database, you have basically to re-implement a lot [...]
    On Eventual Consistency– Interview with Monty Widenius.
    +1 Vote Up -0Vote Down
    “For analytical things, eventual consistency is ok (as long as you can know after you have run them if they were consistent or not). For real world involving money or resources it’s not necessarily the case.” — Michael “Monty” Widenius. In a recent interview, I asked Justin Sheehy, Chief Technology Officer at Basho Technologies, maker [...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 306 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.