Tag: ProxySQL

Feed: Planet MySQL; Author: MySQL Performance Blog; Ananias Tsalouchidis | July 17, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Cloud and MySQL, Insight for DBAs, MySQL, MySQL DBaaS, ProxySQL PREVIOUS POST Now that Database-as-a-service (DBaaS) is in high demand, there is one question regarding AWS services that cannot always be answered easily : When should I use Aurora and when RDS MySQL? DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure, and without installing software. I’m not sure if there is a straightforward answer, but when trying to find out which solution best fits an organization ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Francisco Bordenave | July 16, 2018 |  Posted In: High-availability, InnoDB, Insight for DBAs, MySQL, open source databases PREVIOUS POST MySQL InnoDB Cluster is an Oracle High Availability solution that can be easily installed over MySQL to provide high availability with multi-master capabilities and automatic failover. In the previous post we presented the first component of InnoDB Cluster, group replication. Now we will go through the second component, MySQL Router.  We will address MySQL Shell in a final instalment of this three-part series. By then, you should have a good overview of the features offeed by MySQL InnoDB Cluster. MySQL ... Read More

Feed: Planet MySQL; Author: Dimitri Kravtchuk; 2018-07-05 22:55 | MySQL, Performance, InnoDB, Benchmarks, Sysbench, TPCC, IO-bound, Optane, REDO, DoubleWrite This post is mainly inspired by findings from the previous testing of MySQL 8.0 on TPCC workload(s) and observations from IO-bound Sysbench OLTP on Optane -vs- SSD. But also by several "urban myths" I'm often hearing when discussing with users about their IO-bound OLTP performance problems : Myth #1 : "if I'll double the number of my storage drives -- I'll get x2 times better TPS !" this was mostly true during "HDD era", and again.. (ex.: a single thread app ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Recently it's quite common to state that "Oracle's Acquisition Was Actually the Best Thing to Happen to MySQL". I am not going to argue with that - Oracle proved over years that they are committed to continue active development of this great open source RDBMS, and they have invested a lot into making it better and implementing features that were missed or became important recently. Unlike Sun Microsystems, they seem to clearly know what to do with this software to make it more popular and make money on it.Among the right things Oracle does ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | June 29, 2018 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL PREVIOUS POST Percona announces the release of Percona XtraDB Cluster 5.7.22-29.26 (PXC) on June 29, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.7.22-29.26 is now the current release, based on the following: Deprecated The following variables are deprecated starting from this release: wsrep-force-binlog-format wsrep_sst_method = mysqldump As long as the use of binlog_format=ROW is enforced in 5.7, wsrep_forced_binlog_format variable is much less significant. The same is related to mysqldump, as xtrabackup is now the recommended ... Read More

Feed: Planet MySQL; Author: Severalnines; Galera Cluster comes with many notable features that are not available in standard MySQL replication (or Group Replication); automatic node provisioning, true multi-master with conflict resolutions and automatic failover. There are also a number of limitations that could potentially impact cluster performance. Luckily, if you are not aware of these, there are workarounds. And if you do it right, you can minimize the impact of these limitations and improve overall performance. We have previously covered many tips and tricks related to Galera Cluster, including running Galera on AWS Cloud. This blog post distinctly dives into ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Vadim Tkachenko | June 25, 2018 |  Posted In: Containers, MySQL, Percona Monitoring and Management, Percona Server for MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL PREVIOUS POST Kubernetes, and its most popular distribution OpenShift, receives a lot of interest as a container orchestration platform. However, databases remain a foreign entity, primarily because of their stateful nature, since container orchestration systems prefer stateless applications. That said, there has been good progress in support for StatefulSet applications and persistent storage, to the extent that it might be already comfortable to have a production database instance running in Kubernetes. With ... Read More

Feed: Planet MySQL; Author: Severalnines; As we saw in the first part of this blog, a strongly consistent database cluster like Galera does not play well with container orchestration tools like Kubernetes or Swarm. We showed you how to deploy Galera and configure process management for Docker, so you retain full control of the behaviour.  This blog post is the continuation of that, we are going to look into operation and maintenance of the cluster. To recap some of the main points from the part 1 of this blog, we deployed a three-node Galera cluster, with ProxySQL and Keepalived on ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | June 20, 2018 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL PREVIOUS POST Percona announces the release of Percona XtraDB Cluster 5.6.40-26.25 (PXC) on June 20, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.40-26.25 is now the current release, based on the following: All Percona software is open-source and free. New feature PXC-907: New variable wsrep_RSU_commit_timeout allows to configure RSU wait for active commit connection timeout (in microseconds). Fixed Bugs PXC-2128: Duplicated auto-increment values were set for the concurrent sessions on ... Read More

Feed: Planet MySQL; Author: Severalnines; RDS is a Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations in comparison to running MySQL directly on Elastic Compute Cloud (EC2). But RDS is a convenient service, as long as you can live with the instances and configurations that it offers. Amazon RDS currently supports various MySQL and MariaDB versions as well as the, MySQL-compatible Amazon Aurora DB engine. It does support replication, but as you may expect from a predefined web console, there are some limitations. Amazon ... Read More