My Twitter Digest for 11/03/2016

My Twitter Digest for 11/02/2016

My Twitter Digest for 10/31/2016

The MySQL n00b: MyRocks: migrating a large MySQL dataset from InnoDB to RocksDB to reduce footprint

Enter RocksDB and the LSM (Log Structured Merge) technology: we are entering a new planet as far as data storage goes. The idea of an “append only” type of approach for writing database rows is something I never heard before. Databases usually are the most random writer ever! And although SSD will not suffer from write randomness, there are other factors that need to be taken into consideration. I’ll not go into more details about how LSM or RocksDB work, or why LSM is good for your SSD and your workload, as there is plenty of information about it on Mark’s blog (see above) or on the official page for RocksDB and for MyRocks (the RocksDB engine for MySQL) on GitHub; just check the Wiki there.

Source: The MySQL n00b: MyRocks: migrating a large MySQL dataset from InnoDB to RocksDB to reduce footprint

MyRocks and RocksDB sound like something worth exploring even for our small big data tables.

My Twitter Digest for 10/25/2016

My Twitter Digest for 10/20/2016

My Twitter Digest for 10/19/2016

Windows Subsystem for Linux Windows Interoperability Brings Linux Commands to Windows CLI

The Windows Subsystem for Linux can invoke native Windows binaries and be invoked from a Windows command line. This feature is available to Windows 10 users running Anniversary Update build 14951. This new interoperability functionality delivers a seamless experience between Windows and WSL. Technical details on how this interoperability works can be found on the WSL blog.

Source: Windows Interoperability | MSDN

This is pretty cool. From either command prompt (CMD) or PowerShell you can use the syntax bash -c “ls -la” to invoke basic Linux commands without launching the Ubuntu environment. More advanced tools like curl are also available.

The article indicates the reverse is also true but I wasn’t able to get Windows binaries running from the bash window. I don’t know if it’s a bug or something about my configuration.