The wild and crazy guys over at S&T Geotronics, James Sanderson and Marc Tessier, have decided to go full tilt with a Kickstarter version of their DIY Open Enigma Project. For those who missed the fanfare last year, they were featured on Instructables showing how to build an Arduino-based encryption machine that works exactly like a WWII era Enigma. You know, the thing that Alan friggin' Turing and his team at …[Read more]
When we launched the official MySQL repos back in October, we wanted to achieve a number of things: First, we closed a gaping hole in our distribution on Linux. Some Linux distros do not ship all the MySQL products, and not everyone is able to or always wants to use the distro packages. And the […]
The MySQL February Newsletter is available! Find out the latest news on MySQL products and MySQL Connect 2014, and read the technical tips written by MySQL experts at Oracle and in the community. Below are the highlights in this edition:
- Start Preparing for MySQL Connect 2014 Call for Papers
- New GA Release: MySQL for Visual Studio
- Blog: State of the UNION
- Blog: New MySQL Web Installer -- Have You Tried It Yet?
- Blog: MySQL Workbench: Frequent Crashes on Mac OS X? This Might Be The Fix
- Event: MySQL Seminars Are Coming to a City Near You
The SQL Editor in MySQL Workbench 6.1 adds a new interface for query results. This addition offers 4 new views to your query results, 2 for the result data itself and 2 for meta-information about the query that was executed.
Query Result Set Grid
The traditional result set grid. Run a SELECT query on a table with a primary key and you can edit the data. You must click the Edit button to enter edit mode.
Note: Until Workbench 6.1.1, the check was being done automatically for every SELECT query, but since that requires extra queries to MySQL, the check is now done on demand.
Result Set Form Editor
The new form editor for result sets comes in handy when you want to closely inspect the fields of each record (specially if it has multi-line text). You …[Read more]
Red Hat recently released a beta of what will become the next version of their Enterprise Linux. As many people have noticed, Red Hat opted for a forked version of MySQL 5.5 (which GA’d 3 years ago). MySQL has come a long way in those three years, and MySQL 5.6 was released just under a […]
In Part 1 we started our study of Amazon Services and looked at Amazon EC2. In this part, we will look at other Amazon services like EMR, DynamoDB and RDS.
- 1. Amazon Elastic Map Reduce
Amazon EMR is a web service which makes cloud computing very easy. Amazon’s EMR cluster comes preconfigured with Hadoop, which as mentioned earlier is a data processing and storage framework. This preconfiguration makes it very easy to start analysing your data in no time. Amazon EMR has applications in machine learning, financial analysis, bioinformatics etc.
Just like EC2, you can launch any number of EMR instances as you need and you will only be charged for the computing power you have used. EMR is preconfigured …[Read more]
What’s new in the MySQL Yum repositories A little over a month ago we launched the official MySQL Yum repository. An official repo was a long standing request from the community, and we’ve had it on our list of todos for a long time. We finally got it done, and in the process we modernized […]
What is SeaLion?
SeaLion is a Linux monitoring tool, built from the ground up for troubleshooting hundreds of servers.
Why did we create SeaLion?
We’ve another product line - CloudMagic which is a search centric email app. We manage petabytes of indexed user data spread across hundreds of servers. This data is hosted on AWS. Being a search centric email app, the search speed is critical. We take pride in being known for blazing fast search speeds. When a search query takes more than the threshold value, we get an alert and we debug.
Typically, it’s important at this point to determine if the issue was with the hosting provider or in our code. Inspite of having a suite of monitoring tools, we always fall back to the output of traditional commands. What took time? We check the usual suspects …[Read more]
We thought we’d get the festivities started a little early by offering a 20% flat discount on all Webyog products. Offer expires on November 27, 2013 at 23:59 PST. Grab the offer before it’s gone.
Head right away to the Online Shop and apply the coupon code: tg2013.
The post Thanksgiving Offer – 20% off …[Read more]
In the previous article we introduced Hadoop as the most popular Big Data toolset on the market today. We had just started talking about MapReduce as the major framework that makes Hadoop distinctive. So let’s continue the discussion where we left off.
MapReduce is really the key to understanding Hadoop’s parallel processing functionality as it enables data in various formats (XML, text, binary, log, SQL, ect) to be divided up and mapped out to many computers nodes and then recombined back to produce a final data set.