Author: MySQL Planet

Feed: Planet MySQL; Author: Kedar Vaijanapurkar; In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to prove it. Prove it technically that it actually is a Friday. This blog post is my attempt to share the proofs of existence of a “Friday”. Using MySQL datetime function: dayname MySQL [(Kedar)]> select dayname(now()); +----------------+ | dayname(now()) | ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; Query latencies in one data center are larger than elsewhere for one replication hierarchy, but only in the high percentiles. This impacts production and traffic is being failed away from that data center to protect production. When the P50 and P90 look okay, but the P99 and the P99.9 do not, the database(s) operate normally, and only some queries are running slow. The initial guess was “for some queries the plan has flipped, but only in that data center.” But first let’s have a look at the database size and the schema. The schema ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; Two weeks ago I was being drawn into the debug of artdb, the Replication hierarchy used by our Artifactory instance. Artifactory overloaded the database. This was incident-handled by optimizing a number of slow queries using some covering index trickery, and by upgrading the hardware substantially. Using the runway we bought, we found and partially fixed the following problems: Fixed: A number of very expensive reporting queries were sped up 16x to 20x using covering indexes, from 180s runtime to 8s-12s runtime. Fixed: We optimized our database and data size by completing the data lifecycle ... Read More

Feed: Planet MySQL; Author: PlanetScale; JavaScript Object Notation (JSON) is a light-weight text-based file format similar to YAML or XML which simplifies data exchange. It was invented by Douglas Crockford in the early 2000s and became increasingly popular with the rise of document-based (also called NoSQL) databases. JSON supports strings, numbers, booleans, objects, and arrays as well as null values. A simple JSON example containing key-value pairs, an object "bandMembers" and an array "songs" would look like this: { "artist": "Starlord Band", "bandMembers": { "vocals": "Steve Szczepkowski", "guitar": "Yohann Boudreault", "bass": "Yannick T.", "drums": "Vince T." }, "bandMembersCount": 4, "album": ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; When you develop an application you expect success, and often success comes with growth problems.  These problems especially show themselves in the area of data storage, where being stateful is not as easy to scale as the stateless parts of the application. There are several stages of approaching database scalability: Configuration and query optimization. This step can help a lot, and I would recommend a recent book by Daniel Nichter “Efficient MySQL Performance: Best Practices and Techniques”, which goes into this topic. If #1 is done and you continue to push the limits ... Read More

Feed: Planet MySQL; Author: Vitess; There was an idea. An idea to make Vitess self-reliant. An idea to get rid of the friction between Vitess and external fault-detection-and-repair tools. An idea that gave birth to VTOrc…Both VTOrc and Orchestrator are tools for managing MySQL instances. If I were to describe these tools using a metaphor, I would say that they are kinda like the monitor of a class of students. They are responsible for keeping the MySQL instances in check and fixing them up in case they misbehave, just like how a monitor ensures that no mischief happens in the ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; We are looking to provide simplified ways to deploy Percona software in cloud environments, especially for more advanced scenarios like replication and multi-node cluster (in the case of Percona XtraDB Cluster). For this I propose trying out our new Terraform provider, with the capabilities: Deploy in AWS or GCP Cloud. The provider will automatically create instances and deploy Percona Server for MySQL Deploy either Percona Server for MySQL or Percona XtraDB Cluster Choose instance size Choose storage volume size, type, and IOPs Multi-node async replication or multi-node Percona XtraDB Cluster Customize MySQL configuration ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In a post written earlier this year – Percona Server for MySQL Encryption Options and Choices –  I discussed some of the options around encryption in MySQL.  Being such a complex topic, that post was meant to clarify and highlight various aspects of “encryption” at different levels.  I recently had this topic come up again, but specifically around column-level encryption and various options so I wanted to touch on this in more detail. As of the current release of Percona Server for MySQL, there is no built-in way to define a single column ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; This article outlines the basic configurations for setting up and deploying Percona XtraDB Cluster 8.0 (PXC) on Amazon EC2, as well as what is new in the setup compared to Percona XtraDB Cluster 5.7. What is Percona XtraDB Cluster an ideal fit for? Percona XtraDB Cluster is a cost-effective, high-performance clustering solution for mission-critical data. It combines all the improvements, and functionality found in MySQL 8 with Percona Server for MySQL‘s Enterprise features and Percona’s upgraded Galera library. A Percona XtraDB Cluster environment is an ideal fit for applications requiring 5-9s uptime with ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; The availability of MySQL HeatWave on Amazon Web Services (AWS) was announced on Monday, September 12, extending Oracle’s commitment to multi-cloud access. Many industry experts applaud this new platform support for MySQL HeatWave -- some of their quotes are included here ... Read More