Tag: ProxySQL

Feed: Planet MySQL. Author: Marco. A story around replication lag and Flow-Control.In the last few months we had 2 main actors in the the MySQL ecosystem, ProxySQL and Group-Replication (with the evolution to InnoDB Cluster). While I had extensively covered the first, my last serious work on GR, goes back to some lab version in the past years. Given the decision Oracle made to declare it GA, and the Percona decision to provide some level of support to GR, I decide it was time for me to take a look at it again.A lot of reviews were already done covering different topics ... Read More

Feed: Percona Database Performance Blog. Author: Manjot Singh. Manjot Singh  | July 20, 2017 |  Posted In: High-availability, ProxySQL, Replication PREVIOUS POST In this blog post, we’ll look at how to deploy ProxySQL. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. It was created for DBAs by René Cannaò, as a means of solving complex replication topology issues. When bringing up ProxySQL with my clients, I always get questions about where it fits into the architecture. This post should ... Read More

Feed: Planet MySQL. Author: Frederic Descamps. As you may know by now, MySQL 8.0.2 DMR is out ! o/ Many features have been added (see ‘s announcement) and of course the replication also brought new features and improvements (see this post from Luís Soares). But some improvements in the monitoring broke the added sys view used by ProxySQL to monitor the state of a member of the group: mysql> select * from sys.gr_member_routing_candidate_status; +------------------+-----------+---------------------+----------------------+ | viable_candidate | read_only | transactions_behind | transactions_to_cert | +------------------+-----------+---------------------+----------------------+ | YES | NO | 0 | 0 | +------------------+-----------+---------------------+----------------------+ This is because now the table ... Read More

Feed: Percona Database Performance Blog. Author: Alexey Zhebel. Alexey Zhebel  | July 14, 2017 |  Posted In: Database Monitoring, Events and Announcements, Insight for DBAs, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Software, PMM, Prometheus, ProxySQL PREVIOUS POST Percona announces the release of Percona Monitoring and Management 1.2.0 on July 14, 2017. For installation instructions, see the Deployment Guide. PMM Server 1.2.0 introduced the following changes: Updated Components New Features PMM-737: New graphs in System Overview dashboard: Memory Advanced Details Saturation Metrics PMM-1090: Added ESXi support for PMM Server virtual appliance. UI Fixes PMM-707: Fixed QPS metric in MySQL Overview dashboard to always show queries per second regardless of the selected ... Read More

Feed: Planet MySQL. Author: Severalnines. In our “MySQL on Docker” blog series, we continue our quest to make Galera Cluster run smoothly in different container environments. One of the most important things when running a database service, whether in containers or bare-metal, is to eliminate the risk of data loss. We will see how we can leverage a promising feature in Kubernetes called StatefulSet, which orchestrates container deployment in a more predictable and controllable fashion. In our previous blog post, we showed how one can deploy a Galera Cluster within Docker with the help of Kubernetes as orchestration tool. However, ... Read More

Feed: Planet MySQL. Author: Roberto V. Zicari. “Spark and Ignite can complement each other very well. Ignite can provide shared storage for Spark so state can be passed from one Spark application or job to another. Ignite can also be used to provide distributed SQL with indexing that accelerates Spark SQL by up to 1,000x.”–Nikita Ivanov. I have interviewed Nikita Ivanov,CTO of GridGain.Main topics of the interview are Apache Ignite, Apache Spark and MySQL, and how well they perform on big data analytics. RVZ Q1. What are the main technical challenges of SaaS development projects? Nikita Ivanov: SaaS requires that ... Read More

Feed: Planet MySQL. Author: Severalnines. ClusterControl v1.4.2 comes with a number of improvements around ProxySQL. The previous version, also known as “The ProxySQL Edition”, introduced a full integration of ProxySQL with MySQL Replication and Galera Cluster. With ClusterControl v1.4.2, we introduced some amazing features to help you running ProxySQL at scale in production. These features include running ProxySQL in high availability mode, keeping multiple instances in sync with each other, managing your existing ProxySQL instances and caching queries in one click. High Availability with Keepalived ProxySQL can be deployed as a distributed or centralized MySQL load balancer. Setting up a ... Read More

Feed: Planet MySQL. Author: TwinDB. When we started working with a customer they asked us to setup for them more reliable and performant MySQL database. At the time they were using Percona XtraDB cluster with ELB to balance read traffic between PXC nodes. There was no writer redundancy – if a writer node was down, the app was down. The app by the way is a Magento backed online shop. All stuff was running in AWS. We started to design the new database architecture. The first component we threw away was ELB. A simple OLTP sysbench test showed that ELB ... Read More

Feed: Percona Database Performance Blog. Author: Kenny Gryp. Kenny Gryp and Ramesh Sivaraman  | June 23, 2017 |  Posted In: Group Replication, High-availability, InnoDB, Percona XtraDB Cluster PREVIOUS POST 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 Group Replication? MySQL Group Replication is GA since MySQL Community 5.7.17. This is the lowest version that you ... Read More

Feed: Percona Database Performance Blog. Author: Alexey Zhebel. Alexey Zhebel  | 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 PREVIOUS POST 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 show correct page merge success ratio. PMM-1007: ... Read More