Monthly Archives - April 2016

Percona Monitoring and Management

Percona Monitoring and Management

Percona is excited to announce the launch of Percona Monitoring and Management Beta!
Percona Monitoring and Management (PMM) is a fully open source solution for both managing MySQL platform performance and tuning query performance. It allows DBAs and application developers to optimize the performance of the Database Layer. PMM is an on-premises solution that keeps […]

Read more

How Percona XtraDB Cluster certification works

Percona XtraDB Cluster 5.7

In this blog, we’ll  discuss how Percona XtraDB Cluster certification works. Percona XtraDB Cluster replicates actions executed on one node to all other nodes in the cluster and make it fast enough to appear as it if is synchronous (aka virtually synchronous).

Let’s understand all the things involved in the process (without losing data integrity).

There are two […]

Read more

The final three Database Performance Team characters are . . .

The last email introduced two members of the Percona Database Performance Team: The Maven and The Specialist. Now we’re ready to reveal the identity of the final three team members.
The Database Performance Team is comprised of our services experts, who work tirelessly every day to guarantee the performance of your database. Percona’s support team is […]

Read more

Webinar Q & A for Introduction to Troubleshooting Performance: What Affects Query Execution?

Query Execution

In this blog, I will provide answers to the Webinar Q & A for Introduction to Troubleshooting Performance: What Affects Query Execution?
First, I want to thank you for attending the April, 7 webinar. This webinar is the third in the “MySQL Troubleshooting” webinar series and last introductory webinar in the series. The recording and […]

Read more

Creating Geo-Enabled applications with MongoDB, GeoJSON and MySQL

Creating Geo-Enabled applications with MongoDB, GeoJSON and MySQL

This blog post will discuss creating geo-enabled applications with MongoDB, GeoJSON and MySQL.
Introduction
Recently I published a blog post about the new GIS features in MySQL 5.7. Today I’ve looked into how to use MongoDB (I’ve tested with 3.0 and 3.2, with 3.2 being much faster) for the same purpose. I will also talk about GIS […]

Read more

MySQL Document Store Developments

MySQL Document Store

This blog will discuss some recent developments with MySQL document store.
Starting MySQL 5.7.12, MySQL can be used as a real document store. This is great news!
In this blog post, I am going to look into the history-making MySQL work better for “NoSQL” workloads and more of the details on what MySQL document store offers […]

Read more

Percona Live featured talk with Álvaro Hernández Tortosa — ToroDB: Supercharging your RDBMS with MongoDB super powers

Percona Live Álvaro Hernández Tortosa

Welcome to the last Percona Live featured talk with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona […]

Read more

Orchestrator-agent: How to recover a MySQL database

orchestrator-agent

In our previous post, we showed how Orchestrator can handle complex replication topologies. Today we will discuss how the Orchestrator-agent complements Orchestrator by monitoring our servers, and provides us a snapshot and recovery abilities if there are problems.
Please be aware that the following scripts and settings in this post are not production ready (missing error handling, etc.) […]

Read more

Evaluating Database Compression Methods: Update

column compression

This blog post is an update to our last post discussing database compression methods, and how they stack up against each other. 
When Vadim and I wrote about Evaluating Database Compression Methods last month, we claimed that evaluating database compression algorithms was easy these days because there are ready-to-use benchmark suites such as lzbench.
As easy […]

Read more

Percona Live featured talk with Ying Qiang Zhang — What’s new in AliSQL: Alibaba’s branch of MySQL

Percona Live featured talk

Welcome to the next Percona Live featured talk with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona […]

Read more