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.

 

Now Open – AWS US East (Ohio) Region | AWS Blog

As part of our ongoing plan to expand the AWS footprint, I am happy to announce that our new US East (Ohio) Region is now available. In conjunction with the existing US East (Northern Virginia) Region, AWS customers in the Eastern part of the United States have fast, low-latency access to the suite of AWS infrastructure services.

Source: Now Open – AWS US East (Ohio) Region | AWS Blog

Low latency to US East (Virginia) should provide an opportunity to try out some cross region experimentation to work on fault tolerance and high availability.

Disney Open Source

Open Source Software is important to The Walt Disney Company. Disney has established an Open Source Program to encourage our developers to utilize Open Source, contribute to Open Source projects, and to release software as Open Source. We’ve created this site to highlight Disney’s Open Source projects. We encourage you to explore our projects and we welcome your collaboration and contributions. This is just the beginning; there’s more to come, so stay tuned!

Source: Disney Open Source

This is intriguing. As one might expect many of the projects deal with animation and film making. I think this highlights the movement to open source the basic tools that are being developed to help corporations do their thing.