StormDB is a fully managed relational database service that provides reliable performance with seamless scalability. Unlike typical cloud databases, StormDB takes a different approach to storing your data in the cloud. Instead of running a database inside of a virtual machine, losing performance and reliability, StormDB is a Database Cloud. Like similar Storage Clouds, there is no virtualization. Everything is running directly on bare metal giving you performance, scalability, and reliability.
A typical cloud database is limited by scaling up to the size of the virtual instance it uses, but StormDB automatically shards data across a cluster of servers specifically tuned for the unique requirements of a database. There is no need to setup complex replication solutions or give up the consistency of your data to scale your database in the cloud. By sharding data across the StormDB Cloud, queries can also leverage the power of massively parallel processing (MPP) and return the results of complex queries across large datasets in a fraction of the time of the typical cloud database.

Required

Install

Solution

the Box
Finding a Dataset
Submitted by jim_mlodgenski on Wed, 10/24/2012 - 09:53Typically, when I give talks about PostgreSQL, Stado or Postgres-XC, I like to use examples as much as possible to get my points across to the audience. This usually presents a problem in deciding what data to use in the examples. The old stand-by is to use pgbench to generate a bunch of sample data, but the values are meaningless to the audience, and you're a bit limited with what you can show. I've also used the sample databases from PG Foundry but also found them lacking.
- jim_mlodgenski's blog
- Login or register to post comments
- Read more
Google Spanner and Postgres-XC
Submitted by jim_mlodgenski on Tue, 10/02/2012 - 19:18Reading through Google's Spanner paper, I can't help but see the parallels to Postgres-XC. Although the two solutions tackle different problem sets, the fact that they are both distributed databases with the goal of providing consistency out to the client, results in very similar architectures. Take for example the first paragraph in the abstract of the paper. If you change just a few words, it does a great job of describing what Postgres-XC can do:
Scaling PostGIS Location Data
Submitted by jim_mlodgenski on Wed, 09/12/2012 - 10:02Since first adding PostGIS support to Stado last year, I've heard from a number of people needing to scale their write workload in addition to reads. The architecture of Stado doesn't really lend itself to a write intensive application, but luckily Postgres-XC does. Write intensive PostGIS applications have a few interesting challenges that many applications don't experience. First is just the size of a typical row. A geometry column typically contains a lot of rich information, but that adds up to move size on disk.
- jim_mlodgenski's blog
- Login or register to post comments
- Read more



.png)

