MemSQL is the next-generation database that solves the problems of the disk component most limiting for most current applications.
It is time to touch the next generation MemSQL database!

')
From the creator of the project, Nikita Shamnugov:“MemSQL is the next generation database that solves the problems of the disk component most limiting for most current applications. Offering a familiar SQL interface to the data stored in memory, MemSQL makes it possible to deal with large traffic and rapid growth when developing large-scale web applications. MemSQL significantly improves read and write performance and greatly simplifies application development and support. Developed by MemSQL in faraway California, San Francisco, by a private company with partial support from First RoundCapital and NEA. ”
System requirements:
- 64-bit Linux
- Ideal for machines with multi-core processors and 8 GB of RAM
- Minimum OS Versions: Amazon AMI (2012.03), CentOS (6.0), Debian (6.0), Fedora (15), OpenSUSE (11.1), Red Hat (6.1), Ubuntu (10.04)
Currently available for download:
- Developer Edition - 10 GB limit
- Trial Edition - 30 days limit
After entering the name and email address on the download page, the user receives a license.
To download the distribution, you can use the instructions.
$ wget download.memsql.com/3678fc4a65244b83a200911ef0e936f4/memsqlbin_amd64.tar.gz
$ tar -xzf memsqlbin_amd64.tar.gz
$ cd memsqlbin
$ chmod +x check_system
$ ./check_system
$ ./memsqld --port 3307
Archive size ~ 120 MB.
By default, MemSQL runs on port 3306 (as in MySQL). In the example, 3307 is specified to avoid possible conflicts with a possibly running MySQL.
You can use mysql to work with MemSQL.
$ mysql -u root -h 127.0.0.1 -P 3307 --prompt="memsql> "
To complete the work
killall memsqld
MemSQL allows you to recover all data from disk. It writes data to disk immediately after the transaction in memory. A combination of logging and snapshots is used.
Download from the site