by Alexander Rubin | Feb 3, 2016 | MySQL
MySQL 5.7 has been released, and there are some exciting new features now available that I’m going to discuss in this blog — specifically around geographic information system (GIS).I’ve used GIS features in MySQL for a long time. In my previous blog... by Alexander Rubin | Jan 21, 2016 | MySQL
We’d like to thank everybody for joining us on January 7th for our “Tired of MySQL Making You Wait?” webinar with Percona’s Alexander Rubin, Principal Consultant and SolarWinds’ Janis Griffin, Database Evangelist.Too often developers and... by Alexander Rubin | Dec 2, 2015 | MySQL
Join Alexander Rubin, Principal Consultant, Percona as he provides an overview of MySQL 5.7 features. Wednesday, December 9, 2015 10:00AM PST (GMT -08:00).MySQL® 5.7 is a great release that has a lot to offer, especially in the areas of development and... by Alexander Rubin | Nov 25, 2015 | Hardware and Storage, MySQL, Percona Software
Introduction In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own Internet of Things with Particle Photon board. That implementation is great, but requires constant internet (wi-fi) access as the Particle Photon board does... by Alexander Rubin | Oct 23, 2015 | MySQL
Personal Projects with the Internet of ThingsSo you want to do a personal project with the Internet of Things (maybe a home automation or metrics collection or something else)? In this blog post I will tell about my recent experience with this. I... by Alexander Rubin | Oct 7, 2015 | Insight for DBAs, MySQL
What is Apache Spark? Apache Spark is a cluster computing framework, similar to Apache Hadoop. Wikipedia has a great description of it: Apache Spark is an open source cluster computing framework originally developed in the AMPLab at University of California, Berkeley... by Alexander Rubin | Aug 24, 2015 | MySQL, Webinars
Thank you for attending my July 22 webinar titled “Advanced Query Tuning in MySQL 5.6 and 5.7” (my slides and a replay available here). As promised here is the list of questions and my answers (thank you for your great questions).Q: Here is the explain... by Alexander Rubin | Apr 29, 2015 | MySQL
About 2 weeks ago Oracle published the MySQL 5.7.7-labs-json version which includes a very interesting feature called “Generated columns” (also know as Virtual or Computed columns). MariaDB has a similar feature as well: Virtual (Computed)... by Alexander Rubin | Feb 25, 2015 | Insight for DBAs, MySQL
MySQL introduced the Event Scheduler in version 5.1.6. The Event Scheduler is a MySQL-level “cron job”, which will run events inside MySQL. Up until now, this was not a very popular feature, however, it has gotten more popular since the adoption of Amazon... by Alexander Rubin | Aug 4, 2014 | Insight for DBAs, MySQL, Webinars
I will be presenting two webinars in August: Aug 6, 10 a.m. PDT: Advanced Query Tuning in MySQL 5.6 and Beyond Aug 13, 10 a.m. PDT: Using Performance Schema to Monitor and Troubleshoot MySQL 5.6This Wednesday’s webinar on advanced MySQL query tuning... by Alexander Rubin | Jun 19, 2014 | MySQL
In my previous post about geo-spatial search in MySQL I described (along with other things) how to use geo-distance functions. In this post I will describe the geo-spatial distance functions in more details.If you need to calculate an exact distance between 2... by Alexander Rubin | Jun 11, 2014 | Insight for DBAs, MySQL, Percona Software
When you make a change to your MySQL configuration in production it would be great to know the impact (a “before and after” type of picture). Some changes are obvious. For many variables proper values can be determined beforehand, i.e.... by Alexander Rubin | Jun 9, 2014 | Insight for DBAs, MySQL
Hosting a shared MySQL instance for your internal or external clients (“multi-tenant”) was always a challenge. Multi-tenants approach or a “schema-per-customer” approach is pretty common nowadays to host multiple clients on the same MySQL... by Alexander Rubin | Jun 2, 2014 | MySQL
In my previous post about Hadoop and Impala I benchmarked performance of analytical queries in Impala.This time I’ve tried InfiniDB for Hadoop (open-source version) on the modern hardware with an 8-node Hadoop cluster. One of the main... by Alexander Rubin | May 7, 2014 | Insight for DBAs, MySQL, Percona Software
The new Percona Server 5.5.37-35.0 and Percona Server 5.6.17-65.0-56, announced yesterday (May 6), both include the open source version of the MySQL Audit Plugin. The MySQL Audit Plugin is used to log all queries or connections (“audit” MySQL... by Alexander Rubin | Apr 21, 2014 | MySQL
Apache Hadoop is commonly used for data analysis. It is fast for data loads and scalable. In a previous post I showed how to integrate MySQL with Hadoop. In this post I will show how to export a table from MySQL to Hadoop, load the data to Cloudera Impala... by Alexander Rubin | Mar 24, 2014 | MySQL, Percona Live
In my previous post I’ve showed some new MySQL 5.6 features which can be very helpful when creating geo-enabled applications. In this post I will show how we can obtain open-source GIS data, convert it to MySQL and use it in our GEO-enabled applications. I... by Alexander Rubin | Jan 7, 2014 | MySQL
MySQL and Scaling-up (using more powerful hardware) was always a hot topic. Originally MySQL did not scale well with multiple CPUs; there were times when InnoDB performed poorer with more CPU cores than with fewer CPU cores. MySQL 5.6 can scale significantly... by Alexander Rubin | Dec 7, 2013 | MySQL
Because most MySQL production systems probably run on Linux, I’ve decided to place the most important Linux tuning tips that will help improve MySQL performance. There is nothing new here, most of them are well known, however, I’ve decided to collect those... by Alexander Rubin | Oct 23, 2013 | MySQL, Percona Events, Percona Live
The upcoming Percona Live London conference, November 11-12, features quite a number of talks about the latest MySQL features and related technologies. There will be a lots of talks about the new MySQL 5.6 features: Opening keynote highlights MySQL 5.6 new features....