Frequently Asked Questions
Q. Is this a "NoSQL" solution?
No, StormDB supports traditional SQL, strongly conforms to ANSI SQL:2008, is fully acid, all while being scalable.
Q. Do you shard the data?
StormDB distributes the data amongst multiple nodes in our cloud, and, crucially, it ensures a global consistent view of the data thanks to cluster-wide MVCC (Multi-version Concurrency Control) via the Global Transaction Manager component. Other commercial and non-commercial sharding solutions may not guarantee such consistency.
Q. Do you support write-intensive applications?
Yes, write-intensive applications can take advantage of StormDB running on multiple servers and spreading out the write load. StormDB is well-suited for OLTP.
Q. Do you support read-heavy applications?
Yes, with read-intensive applications data is spread out amongst multiple nodes, effectively giving you more cache and more hardware resources to serve it. It eliminates the need for other solutions such as memcached.
Q. Do you support Business Intelligence applications?
Yes, StormDB includes Massively Parallel Processing (MPP) capability with sophisticated query planning and inter-node communication that allows it to fulfill query requests over large data sets quickly. StormDB is well-suited for Data Warehousing and Data Marts.
Q. Do I need to take into account that data is split across servers when designing my database schema?
Your existing applications will work fine, but for fastest response time, it is helpful to be mindful of data locality. Please see the documentation for more details.
Q. What kind of client connectivity do you offer?
StormDB is wire-level protocol compatible with PostgreSQL. That means StormDB will work with any PostgreSQL-compatible driver, which includes JDBC, ODBC, OLE DB, Python, Ruby, perl DBI, Tcl, and Erlang.
That also means that many apps written for PostgreSQL will work with modifications against StormDB, even including the well-known pgAdmin utility.
Q. How does Postgres-XC and Stado relate to StormDB?
Our staff includes architects and developers of both open source Postgres-XC and Stado, and we offer support for both of those projects. StormDB is based on the Postgres-XC code base, with many significant improvements. See a comparison here.
Q. I am interested in moving to StormDB. Can I get help with migrations?
Yes, we can provide services to help you migrate over to StormDB.
Q. Do you support geo-distributed database clusters.
A StormDB-based solution will depend on your particular requirements. Please contact firstname.lastname@example.org.
Q. Does StormDB run in a Virtual Machine?
No, StormDB runs on bare metal. When it comes to databases, we feel running on bare metal is important to most efficiently take advantage of hardware resources and provide good performance. Databases need to be sure that when they fsync to the disk that its really written, not to a "virtual disk"
Q. Is my data multi-tenant with others?
Yes. You and other customers will be sharing a cluster of servers. The data is locked down such that you cannot access one another's data nor even glean information about the names of other databases or users on the same cluster.
The multi-tenancy allows the workload to be shared amongst multiple users, helping to keep your costs low while at the same time being able to utilize the resources of a cluster more powerful than a single server. You only pay for what you use.
Q. Is my data safe?
Yes, StormDB automatically replicates your data behind the scenes to handle failures and ensure that you lose no data.
Also, you may schedule automatic backups at the frequency of your choosing, to help mitigate issues due to you or your applications accidentally deleting data.
Q. If I use your service, am I locked in?
StormDB is currently free during the initial beta period. Afterward, you only pay for what you use.
StormDB has its roots in a free and open source database called PostgreSQL, but with additional enhancements. Your data is yours. You can export your data off of StormDB at anytime and use PostgreSQL, other PostgreSQL-related solutions, or any other RDBMS. If for any reason, your not happy with the StormDB server, simply point PostgreSQL's pg_dump utility at your database, export your data and load it into a PostgreSQL instance.
Q. Can I also buy a private StormDB Cloud?
Please contact email@example.com.