EmergencyEMERGENCY? Get 24/7 Help Now!

Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7

 | March 13, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server for MySQL, Percona XtraDB Cluster, Technical Webinars

My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available here for playback along with the slides). I didn’t have time to answer many of the questions during the session and so in this post I answer all of them. Thanks to everyone who attended! Q: […]

Read More

MySQL and geospatial programming: An introduction to GIS

 | March 13, 2015 |  Posted In: Insight for Developers, MySQL

Geographic information systems (GIS) are used by application developers to incorporate geographic information into their datasets to create apps with cool features such finding the address to the best steakhouse in town or the locations of local points of historical interest (the list is endless). In a nutshell, GIS captures, store, checks and displays data […]

Read More

Easy query metrics with MySQL Performance Schema

 | March 12, 2015 |  Posted In: MySQL, Percona Cloud Tools, Percona Server for MySQL

The MySQL Performance Schema exposes so much data that it’s not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics – like min, max, and average query execution time – with a few clicks: Click “Apply” and about two minutes later you’ll have query metrics from Performance Schema, collected and […]

Read More

Advanced JSON to MySQL indexing

 | March 10, 2015 |  Posted In: MySQL

This post will discuss some excellent methods of getting JSON to MySQL indexing to work smoothly. What is JSON JSON is an text based, human readable format for transmitting data between systems, for serializing objects and for storing document store data for documents that have different attributes/schema for each document. Popular document store databases use […]

Read More

5 free handy tools for monitoring and managing MySQL replication

 | March 9, 2015 |  Posted In: MySQL, Percona Software, Percona Toolkit

MySQL Replication is very simple to set up. In this post I’ll discuss its importance and five handy tools for monitoring and managing MySQL replication. What is MySQL Replication? It’s the process of copying the (real-time events) data from one master instance to another slave instance and maintaining the redundant consistent data in a different […]

Read More

How to test if CVE-2015-0204 FREAK SSL security flaw affects you

 | March 5, 2015 |  Posted In: MySQL, Security

The CVE-2015-0204 FREAK SSL vulnerability abuses intentionally weak “EXPORT” ciphers which could be used to perform a transparent Man In The Middle attack. (We seem to be continually bombarded with not only SSL vulnerabilities but the need to name vulnerabilities with increasing odd names.) Is your server vulnerable? This can be tested using the following GIST […]

Read More

Steve ‘Woz’ Wozniak to speak at Percona Live MySQL Conference & Expo 2015

 | March 5, 2015 |  Posted In: Events and Announcements, MySQL, Percona Live

I am thrilled to announce that Apple co-founder and Silicon Valley icon and philanthropist Steve Wozniak will participate in a moderated Q&A on creativity and innovation April 14 during this year’s Percona Live MySQL Conference and Expo in Santa Clara, California. In addition to “The Woz,” as Steve is nicknamed, we have a great lineup […]

Read More

Percona XtraDB Cluster 5.6.22-25.8 is now available

 | March 5, 2015 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraDB Cluster

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on March 5th 2015. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.22-72.0 including all the bug fixes in it, Galera Replicator 3.9, and on Codership wsrep API 25.8, Percona XtraDB Cluster 5.6.22-25.8 is now […]

Read More