EmergencyEMERGENCY? Get 24/7 Help Now!

ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)

 | June 22, 2017 |  Posted In: Benchmarks, MySQL, Performance Schema

ClickHouse

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test. We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks: MariaDB ColumnStore vs. Clickhouse vs. Apache Spark), where it showed excellent results. ClickHouse by itself seems […]

Read More

Percona Monitoring and Management 1.1.5 is Now Available

 | June 21, 2017 |  Posted In: Database Monitoring, Events and Announcements, Insight for DBAs, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Software, PMM, Prometheus, ProxySQL

Percona Monitoring and Management (PMM)

Percona announces the release of Percona Monitoring and Management 1.1.5 on June 21, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM-667: Fixed the Latency graph in the ProxySQL Overview dashboard to plot microsecond values instead of milliseconds. PMM-800: Fixed the InnoDB Page Splits graph in the MySQL InnoDB Metrics Advanced dashboard to […]

Read More

Tracing MongoDB Queries to Code with Cursor Comments

 | June 21, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB

Tracing MongoDB Queries

In this short blog post, we will discuss a helpful feature for tracing MongoDB queries: Cursor Comments. Cursor Comments Much like other database systems, MongoDB supports the ability for application developers to set comment strings on their database queries using the Cursor Comment feature. This feature is very useful for both DBAs and developers for quickly […]

Read More

The MySQL High Availability Landscape in 2017 (The Elders)

 | June 20, 2017 |  Posted In: Group Replication, GTID, High-availability, MySQL, Percona XtraDB Cluster

High Availability

In this blog, we’ll look at different MySQL high availability options. The dynamic MySQL ecosystem is rapidly evolving many technologies built around MySQL. This is especially true for the technologies involved with the high availability (HA) aspects of MySQL. When I joined Percona back in 2009, some of these HA technologies were very popular – […]

Read More

Upcoming HA Webinar Wed 6/21: Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication

 | June 19, 2017 |  Posted In: Group Replication, High-availability, MySQL, Percona XtraDB Cluster, Technical Webinars

High Availability

Join Percona’s MySQL Practice Manager Kenny Gryp and QA Engineer, Ramesh Sivaraman as they present a high availability webinar around Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication on Wednesday, June 21, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now What are the implementation differences between Percona XtraDB Cluster 5.7, Galera Cluster […]

Read More

MariaDB Server 10.2 GA Release Overview

 | June 19, 2017 |  Posted In: InnoDB, MariaDB, MySQL

MariaDB Server 10.2

This blog post looks at the recent MariaDB Server 10.2 GA release. Congratulations to the MariaDB Foundation for releasing a generally available (GA) stable version of MariaDB Server 10.2! We’ll definitely spend the next few weeks talking about MariaDB Server 10.2, but here’s a quick overview in the meantime. Keep in mind that when thinking about […]

Read More

Peter Zaitsev’s Speaking Schedule: Percona University Belgium / PG Day / Meetups

 | June 16, 2017 |  Posted In: Cloud and MySQL, MySQL, Percona Monitoring and Management, Percona University

Peter Zaitsev Speaking Schedule

This blog shows Peter Zaitsev’s speaking schedule for this summer. Summer 2017 Speaking Engagements This week I spoke at the DB Tech Showcase OSS conference in Japan and am now heading to Europe. I have a busy schedule in June and early July, but there are events and places where we can cross paths and […]

Read More

Three Methods of Installing Percona Monitoring and Management

 | June 15, 2017 |  Posted In: MongoDB, MySQL, Percona Monitoring and Management

Installing Percona Monitoring and Management

In this blog post, we’ll look at three different methods for installing Percona Monitoring and Management (PMM). Percona offers multiple methods of installing Percona Monitoring and Management, depending on your environment and scale. I’ll also share comments on which installation methods we’ve decided to forego for now. Let’s begin by reviewing the three supported methods: […]

Read More

MySQL Triggers and Updatable Views

 | June 14, 2017 |  Posted In: Insight for DBAs, MySQL

MySQL Triggers

In this post we’ll review how MySQL triggers can affect queries. Contrary to what the documentation states, we can activate triggers even while operating on views: https://dev.mysql.com/doc/refman/5.7/en/triggers.html Important: MySQL triggers activate only for changes made to tables by SQL statements. They do not activate for changes in views, nor by changes to tables made by APIs […]

Read More