EmergencyEMERGENCY? Get 24/7 Help Now!

Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication High Availability Webinar: Q & A

and  | June 23, 2017 |  Posted In: Group Replication, High-availability, InnoDB, Percona XtraDB Cluster

High Availability Webinar

Thank you for attending the Wednesday, June 21, 2017 high availability webinar titled Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication. In this blog, I will provide answers to the Q & A for that webinar. You can find the slides and a recording of the webinar here. Is there a minimum MySQL server version for […]

Read More

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

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

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

Webinar Thursday, June 15, 2017: Demystifying Postgres Logical Replication

 | June 13, 2017 |  Posted In: MySQL, PostgreSQL, Replication, Technical Webinars

Postgres Logical Replication

Join Percona’s Senior Technical Services Engineer Emanuel Calvo as he presents Demystifying Postgres Logical Replication on Thursday, June 15, 2017 at 7 am PDT / 10 am EDT (UTC-7). Register Now The Postgres logical decoding feature was added in version 9.4, and thankfully it is continuously improving due to the vibrant open source community. In this […]

Read More

Q & A: MySQL In the Cloud – Migration, Best Practices, High Availability, Scaling

 | June 9, 2017 |  Posted In: Cloud and MySQL, Database Monitoring, High-availability, MySQL

MySQL in the Cloud

In this blog, we will provide answers to the Q & A for the MySQL In the Cloud: Migration, Best Practices, High Availability, Scaling webinar. First, we want to thank everybody for attending the June 7, 2017 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that we […]

Read More

ProxySQL Admin Interface Is Not Your Typical MySQL Server!

 | June 7, 2017 |  Posted In: MySQL

ProxySQL Admin

In this blog post, I’ll look at how ProxySQL Admin behaves in some unusual and unexpected ways from a MySQL perspective. ProxySQL allows you to connect to its admin interface using the MySQL protocol and use familiar tools, like the MySQL command line client, to manage its configuration as a set of configuration tables. This […]

Read More