memsql

Announcing MemSQL Start[c]up 2.0

MemSQL is excited to announce Start[c]up 2.0 – the second annual programming competition hosted by Codeforces with an onsite at MemSQL HQ in San Francisco, California. Start[c]up 2.0 consists of two rounds. Round 1 is online and takes place on July 27th at 10:00 AM PST. Round 1 follows regular Codeforces rules and consists of 5 problems. For this round, the complexity of the problems will be comparable to a regular Codeforces round. There are no eligibility restrictions to participate in the...


Get in the DeLorean! It’s Time for the Database News Roundup.

Stop it database industry, we’re blushing. Imitation is the sincerest form of flattery and, as the spring conference season gives way to summer vacations, we’ve noticed a flood of announcements from database vendors doing their best MemSQL impressions. Here are a few stories that caught our attention. Oracle and SQL Server Go In-Memory The new Oracle 12c and SQL Server 2014 both feature in-memory storage engines on top of their existing disk-based storage. Seek latency and disk contention...


How MemSQL Distributes Data

The world is moving toward highly-parallel, distributed systems up and down the stack. It started with the app servers on the front lines. Now it’s happening at the data layer. This is generally a good thing, but these kinds of systems can sometimes feel like a foreign country. In this article we’ll talk about how MemSQL spreads the work around a cluster of servers without sacrificing ease of use. There are two kinds of machines in a MemSQL cluster: aggregators and leaves. The same...


MemSQL Tip Tuesday: How to Use the MemSQL Cluster Installer

Whether installing MemSQL on premises or in the cloud, the Cluster Installer is a fast way to get started. The Cluster Installer is a simple command line tool that installs and configures an entire MemSQL Cluster to your specifications. Watch this short instructional video to see how easy it is. There are several advantages to using the Cluster Installer. It is faster and more error-proof than installing manually. Then, once you’ve installed MemSQL with the Cluster Installer, making...


The Story Behind MemSQL’s Skiplist Indexes

The most popular data structure used for indexing in relational databases is the Btree (or its variant the B+tree).  Btrees rose to popularity because they do fewer disk I/O operations to run a lookup compared to other balanced trees.  To the best of my knowledge, MemSQL is the first commercial relational database in production today to use a skiplist as its primary index backing data structure.  A lot of research and prototyping went into the decision to use a skiplist.  I hope to provide...


MemSQL to Present at XLDB Conference on Sept. 11

MemSQL is proud to be a part of this year’s XLDB conference, hosted by Stanford University next week on September 11. The 7th Extremely Large Database Conference is designed to help answer the growing need for systems and tools capable of managing and analyzing extremely large data sets, and will focus on practical solutions to capture and leverage big data. More than 98 percent of all the world’s stored information is digital, a drastic increase from 25% only thirteen years ago. Newer data...


Celebrating the MemSQL start[c]up Finals

This weekend MemSQL challenged some of the world’s best computer programmers in the finals of the inaugural MemSQL start[c]up competition. Similar to computer programming competitions held by Google and Facebook, MemSQL’s start[c]up showcased the best from around the world in a grueling 3 hour competition. [slideshow_deploy id=’664′] MemSQL Engineers pieguy, nika, exod40, SkidanovAlex and dolphinigle created a complex problem set for contestants. Made up...


MemSQL Releases 2.1 - Increasing the Value of All Data in the Enterprise

Today, MemSQL released version 2.1 of its real-time analytics platform, which is available for immediate download. This release includes new features and enhancements to give customers the ability to access, explore and increase the value of data, regardless of the size, age, or format. The release also includes additional SQL surface area and a custom AWS CloudFormation template for fast and easy deployment in the cloud. Here are the new features customers will see in the release: ...


Announcing start[c]up

MemSQL is excited to announce start[c]up – a programming competition, hosted by Codeforces with an onsite at MemSQL HQ in San Francisco, California. Start[c]up consists of two rounds. Both rounds will be prepared by MemSQL engineers: pieguy, nika,exod40, SkidanovAlex and dolphinigle. Round 1 is online and takes place on July 13. Round 1 follows regular Codeforces rules and consists of 5 problems. For this round, the complexity of the problems will be comparable to a regular Codeforces...


Excellent Post On MemSQL Architecture

http://highscalability.com/blog/2012/8/14/memsql-architecture-the-fast-mvcc-inmem-lockfree-codegen-and.html