• Contact Us
  • Support
  • Questions? Contact Us Today: 617.630.2800
  • Follow us on Twitter
  • Join our Facebook Group
  • Find us on LinkedIn
  • Subscribe to our RSS Feed
  • Search Site

  • Solutions
    • By Use Case
    • By Industry
    • By Delivery Model
  • Product
    • Product Architecture
    • Scale Out via Data Distribution
    • Scale Out via Read/Write Splitting
    • Data Traffic Management
    • Availability
    • Key Features / Benefits
    • Easing Capacity Planning
    • What is Database Sharding?
  • Resources
    • Datasheets
    • Case Studies
    • Whitepapers
    • Webinars
    • Videos
    • Scale Out Readiness Calculator
    • Database Assessment
    • Benchmark
    • Frequently Asked Questions
    • Documentation
  • Blogs
    • ScaleBase Blog
    • CTO Blog
  • Company
    • Customers
    • Management
    • News
      • Press Releases
      • Coverage
      • Events
    • Partners
    • Investors
    • Careers
    • Contact Us

You are here: ScaleBase / Blog / Some ScaleBase Use Cases

Some ScaleBase Use Cases

07 Aug 2011 / 0 Comments / in Blog, ScaleBase/by Paul Campaniello

As we approach our general availability release, we’re starting to see popular usage scenarios for ScaleBase. I thought this would be a great time to publish three of the common scenarios we see. I’ll probably publish more in the next blog post.

Machine Generated Data

I personally love this term, coined by Curt Monash (see here). It means that the data is generated by machines (sensors, RFID tags, etc) and the amount of data is growing at a much faster pace than human generated data. In my previous, pre-startup, life I’ve seen some examples of machine generated data – and all the applications had major database issues owing to the incredible number of writes the databases had to handle.

ScaleBase looks like a perfect solution to this situation – as it demonstrated at numerous POCs of companies who do Machine Generated Data. I’m still not at liberty to discuss specific customers, but that will change soon, I promise.

The concept of massive writes (machine generated data systems can reach 60% and even 70% writes) is supported very nicely with ScaleBase. Because each database feels only a small portion of the overall system write operations, unlimited database hits/second can be supported. In some POCs, we have reached thousands of writes per second – and the ScaleBase instances weren’t even close to choking.

Online Gaming

Online Gaming is another topic altogether. Massive writes are accompanied by a massive number of reads, and latency of reads is critical. Many social gaming applications work on cloud environments (like Amazon EC2) and basically try to keep most of their data in the database cache. This is a good technique, but limited by the size of machines that Amazon supports – which is not too large (read more in the great Baron Schwartz post here).

That scenario is ScaleBase bread and butter. Since we make every database smaller in size,  each database can store most of its data in cache, resulting in a major performance improvement.

On a personal note, as a long time gamer I am very excited to see which companies are evaluating ScaleBase. My only regret is that Sierra Online didn’t survive to run Quest For Glory 15 on ScaleBase ;-)

SaaS Solutions

Well, of course SaaS solutions can suffer from massive writes or from overly large databases, but I want to address a different topic – multi-tenancy.

We hardly ever talk about multi-tenancy with ScaleBase, but we offer great multi-tenancy solutions. We can store data on a specific customer in the nearest geographic database, or ensure that an EU customer’s details are stored in an EU data center. So you can meet regulatory demands, or improve database response time – in a way that is transparent to the application.

This is just another capability of our sharding solution; instead of dividing data based on a hash function you can shard data based on a predefined list or range of values. We saw quite a few POCs that targeted this feature – and they worked like a charm.

 

I was always told about the “rule of three” – so I just focused on the most popular scenarios we’ve seen. I’ll look into some other scenarios in my next post, which will probably be published next week.

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe to Blog


 

Tweet
database assessment
Popular
  • Can Prepared Statements Improve Your Scalability?May 23, 2011, 5:57 pm
  • MemoryImageSeptember 6, 2011, 10:33 am
  • Backing Up MySQL With ScaleBaseSeptember 12, 2011, 8:34 am
  • Running TPC-C on MySQL/RDSJune 15, 2011, 8:45 pm
Recent
  • ScaleBase presents a Webinar on how to Optimize MySQL Scalability...May 19, 2013, 3:30 pm
  • MySQL Sharding Blog Series: Does Sharding Make Sense on...May 16, 2013, 10:03 am
  • MySQL Sharding Blog Series: Does Sharding Work in the Cloud?May 13, 2013, 9:45 am
  • MySQL Sharding Blog Series: How to Avoid Re-writing ApplicationsMay 6, 2013, 11:54 am
Comments
  • [...] business model, and a strong executive. Scalebase,...February 4, 1:49 am by The Investing Edge of Enterprise IT
  • [...] Recently some customers running on Amazon EC2 asked...December 28, 3:27 pm by High Availability for your ScaleBase instance | MySQL | Syngu
  • [...] ScaleBase Releases Database TPC-C Performance Results...December 12, 2:29 pm by ScaleBase achieves 180K NO-TPM TPCC results on... | MySQL | Syngu
  • Hi Milo - I totally agree. You need to understand how you're...September 6, 10:33 am by liran
Tags
Amazon RDS application re-write Big Data Funding cloud sharding Database Availability database capacity database cloud database scalability database scalability strategy database sharding database virtualization data traffic manager Elastic Load Balancing Hadoop high availability Industry News MySQL MySQL 5.6 MySQL Clustering MySQL Scalability MySQL Scalability Issues MySQL scale out MySQL Sharding MySQL Tuning NewSQL next gen apps NOSQL scalability of databases Sharding single point of failure thread pool

Recent Comments

  • The Investing Edge of Enterprise IT on Management
  • High Availability for your ScaleBase instance | MySQL | Syngu on High Availability for your ScaleBase instance

Solutions

  • Solutions
    • Centralized Database Management & Visibility
    • Scalability
    • Database Availability
    • Delivery Models
    • Industry Solutions

Products

  • Product Overview
    • Product Architecture
    • Scale Out via Data Distribution
    • Scale Out via Read/Write Splitting
    • Data Traffic Management
    • Availability
    • Key Features / Benefits
    • Easing Capacity Planning
    • Database Sharding

Resources

  • Datasheets
  • Case Studies
  • Whitepapers
  • Webinars
  • Videos
  • Scale Out Readiness Calculator
  • Benchmark
  • Frequently Asked Questions
  • Documentation
  • Database Assessment

Company

  • Company
    • Customers
    • Management
    • News
    • Partners
    • Investors
    • Careers
© 2012 Scalebase Inc.

  • |Home
  • |Sitemap
  • |Privacy Policy
  • |Contact Us
  • |Blog