Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

This website is in beta. A description of what it tries to achieve is in the Planet MySQL Community - Requirements RFC.

And a clarification about the MySQL Community/Ecosystem: it is not limited the users of the MySQL Database. In the current context, it also includes people interested in MySQL Variants including MariaDB Server, Percona Server, Galera, Amazon RDS and Aurora, Google Cloud SQL for MySQL, and Azure and Alibaba flavor(s) of MySQL/MariaDB/Percona Servers.

Thursday, 26. November 2020

New adventures (from Mikael Ronstrom)

p After more than 30 years of hard work at Ericsson, MySQL, Sun and Oracle I found/ppthe time to start some new adventures in my life./ppbr/ppI have spent most of that time developing NDB Cluster and the MySQL Server./ppMost of this time have been spent on developing new features improving/ppfunctionality and performance of these products./ppbr/ppThe NDB Cluster product has been developed to a [...]

How a Top Game Company Uses Chaos Engineering to Improve Testing (from TiDB and TiKV Blog)

NetEase Fuxi AI Lab is China's first professional game AI research institution. In their search for a Chaos Engineering tool to test their Kubernetes-based AI training platform, they chose Chaos Mesh and have improved their system resiliency ever since. [...]

Wednesday, 25. November 2020

MariaDB Server MiniFest Wed 9 Dec 2020 (from MariaDB Foundation Blog)

pNew MariaDB releases come with regular intervals. Releasing a new version is a balance between new functionality and bugfixes on one side, and stability on the other. […]/p pThe post MariaDB Server MiniFest Wed 9 Dec 2020 appeared first on [...]

Top n Window Function queries in MySQL (from Digital Owl's Prose)

pTop n Window Function queries over a specific subset of data are common in analysis and reporting requirements. Luckily, in MySQL, there are Window functions we can use for this type of query. To be quite honest, you don’t necessarily need Window Functions. You can retrieve those top 3 (or whatever) types of results with […]/p pThe post Top n Window Function queries in MySQL appeared f [...]

Connection Basics: For Zero Downtime Geographically-Distributed Apps (from Continuent Blog)

pThis blog provides basic information about business-critical application to database connections; my team focuses on MySQL, MariaDB, and Percona Server for MySQL on Linux/Unix that’s infrastructure-agnostic (on-prem, VM, hybrid-cloud, cloud, multi-cloud, etc.)./p Tags: multi-region mysqlhybrid-cloud mysqlgeographically-distributed mysqlmysql proxydatabase connectionszero downtimescalingLoad B [...]

MariaDB Connector C++ Now RC (from MariaDB Corporation Blog)

C++ developers can now use the native MariaDB Connector/C++ to connect their applications to MariaDB Server on premises and in the cloud on MariaDB SkySQL. [...]

Tuesday, 24. November 2020

Paradigm shift on double date range scans (from Saving you from MySQL quicksand!)

At my employer (Messagebird) we are using Vividcortex (a.k.a. Solarwinds DPM nowadays) for query insights and this gives us a top 20 list of our most time consuming queries on a specific host. When you start to make one of your slow queries on your primary faster or offload them to read-replicas, new ones will … Continue reading Paradigm shift on double date range scans → [...]

Scaling ProxySQL rapidly in Kubernetes (from Pythian Blog - MySQL Track)

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. Today’s post was originally published on November 26, 2019. It’s not uncommon these days for... [...]

Monitoring Percona XtraDB Cluster - Key Metrics (from SeveralNines Open Source Database Blog)

pPercona XtraDB Cluster is a very well known high availability solution in MySQL world. It is based on Galera Cluster and it does provide virtually synchronous replication across multiple nodes. As with every database, it is crucial to keep track of what is happening in the system, if performance is on the expected levels and, if not, what is the bottleneck. This is of utmost importance to be able [...]

How to Run a Database on AWS with Better Performance and Lower Cost (from TiDB and TiKV Blog)

This article illustrates the best practices of running TiDB on AWS, including how to choose the suitable cloud storage and properly configure the system. [...]

Monday, 23. November 2020

Uncommon Sense MySQL – When EXPLAIN Can Trash Your Database (from Percona Database Performance Blog)

♦If I ask you if running EXPLAIN on the query can change your database, you will probably tell me NO; it is common sense. EXPLAIN should show us how the query is executed, not execute the query, hence it can’t change any data. Unfortunately, this is the case where common sense does not apply to […] [...]

Recover Percona XtraDB Cluster in Kubernetes From Wrong MySQL Config (from Percona Database Performance Blog)

♦Kubernetes operators are meant to simplify the deployment and management of applications. Our Percona Kubernetes Operator for Percona XtraDB Cluster serves the purpose, but also provides users the flexibility to fine-tune their MySQL and proxy services configuration. The document Changing MySQL Options describes how to provide custom [crayon-5fc00ccd29ef3367144021-i/] configuration to the operator [...]

On the Observability of Outliers (from Percona Community Blog)

pAt work, I am in an ongoing discussion with a number of people on the Observability of Outliers. It started with the age-old question “How do I find slow queries in my application?” aka “What would I want from tooling to get that data and where should that tooling sit?” As a developer, I just […]/p pThe post On the Observability of Outliers appeared first on Percona Community Blog./p [...]

Making MariaDB understand MySQL JSON (from MariaDB Foundation Blog)

pGood news for MySQL users wishing to upgrade to MariaDB: MariaDB 10.5.7 onwards understands formerly-incompatible MySQL JSON fields! This blog entry explains how to install and use them. […]/p pThe post Making MariaDB understand MySQL JSON appeared first on [...]

2020 Tungsten MySQL Use Case Webinar Series – Now Available On-Demand (from Continuent Blog)

pNow available on demand: Watch the Continuent Tungsten MySQL Use Case Webinar Series for 2020 with Eero Teerikorpi, Founder & CEO of Continuent./p Tags: MySQLtungsten clusteringWebinaruse caseHigh Availabilitydata protectiongeo-scalegeo-distributedAWS Aurorazero downtimeon-demandDisaster RecoveryMySQL use case [...]

InnoDB Data Locking – Part 2.5 “Locks” (Deeper dive) (from MySQL Server Blog)

All together now pLet’s now put together all that we’ve learned in InnoDB Data Locking – Part 2 “Locks” about table and record locks to understand following situation:/ppremysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM t FOR SHARE; +----+ | id | +----+ | 5 | | 10 | | 42 | +----+ 3 row [...]

Sunday, 22. November 2020

MySQL Self-Join (from MacLochlainns Weblog)

I’m switching to MySQL and leveraging Alan Beaulieu’s Learning SQL as a supporting reference for my Database Design and Development course. While reviewing Alan’s Chapter 5: Querying Multiple Tables, I found his coverage of using self-joins minimal. In fact, he adds a prequel_film_id column to the film table in the sakila database and then a […] [...]

Geo-Redundancy for MySQL InnoDB And NDB Clusters (from MySQL Support Blogs)

MySQL highly available solutions, InnoDB Cluster (it uses InnoDB storage engine and is based on Group Replication plugin) and NDB Cluster (NDB storage engine), offer high scalability and redundant topologies. InnoDB Cluster can be configured with up to 9 replicas, in single primary configuration or multi-primary. NDB Cluster instead, while being a much different solution, offers the chance to [...]

Saturday, 21. November 2020

Upgrading from MariaDB 10.4 to MariaDB 10.5 Galera Cluster (from Shinguz's Blog)

pBecause upgrading from MariaDB 10.4 to MariaDB 10.5 (non-clustered) seems not to be a problem [ 1 ] we take the challenge and try to create a receipt based on the MariaDB 10.3 to MariaDB 10.4 Galera Cluster upgrade documentation [ 3 ]:/p Before you start pBefore you begin with the upgrade you should consider a few things:/p ulliDowngrade is officially not supported! [ 4 ] It might work, or not [...]

Friday, 20. November 2020

How to Secure MySQL: Part One (from SeveralNines Open Source Database Blog)

pWhenever application security is mentioned, people think of securing applications against some of the most frequent attacks such as injection, broken authentication, sensitive data exposure, and the like. However, while these attacks are prevalent, knowing how to protect your application from them alone will not be sufficient - especially when you’re running MySQL. Today we are going to look at a [...]

Partial Restore of a Table into a MariaDB Galera Cluster (from Shinguz's Blog)

pIn my former Blog Post Partial Table or Schema restore from codemariabackup/code full backup we worked out the basics of a partial restore of a table into a MariaDB database instance./p pAn now we use this know-how to try the same procedure on a Galera Cluster./p pThe backup is done in the exact same way as described in the mentioned article. We can even use the backup made there./p pFor the re [...]

MariaDB/MySQL Datenbank-Administrator/in gesucht (from Shinguz's Blog)

pAusschreibungszeitraum: Q4 2020 bis Q2 2021. Später bitte nicht mehr melden./p pEiner unserer Kunden sucht eine/n erfahrene/n MariaDB/MySQL Datenbank-Administrator/in. Arbeitspensum: 80 bis 100% in Festanstellung. Arbeitsort: Hauptstadt Bern (Schweiz).br Erfahrung im Betrieb von MariaDB/MySQL Datenbanken im Enterprise-Umfeld sind erforderlich sowie gute MariaDB/MySQL sowie Galera Cluster Kenntnis [...]

Thursday, 19. November 2020

Faster logical backup of a single table in MySQL. (from Mydbops Blog)

Logical backup’s are of great use in data migration across cloud environments and table level recoveries. The new Mysql shell 8.0.22 ,has introduced a couple of new utilities named util.dumpTable() and util.exportTable() to export individual tables from a MySQL. Prior to 8.0.22 it is not possible to make a backup of single table using MySQL … Continue reading Faster logical backup of a [...]

A Blog Shamelessly Bribing You to Review Percona Monitoring and Management! (from Percona Database Performance Blog)

♦We would love you to help us spread the word about Percona Monitoring and Management (PMM) to make sure even more people are aware of it and adopting it. And we are not afraid to offer (modest) bribes! If you already use PMM please write an independent review of its pros and cons on the […] [...]

Wednesday, 18. November 2020

Auditing Changes to Classified Data Stored in MySQL 8.0 (from MySQL Server Blog)

The Challenge Often with sensitive information, you need to have an audit log. Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc. In a prior blog I discussed how to audit the selection of classified data.… [...]

Tuesday, 17. November 2020

Wondering How to Run Percona XtraDB Cluster on Kubernetes? Try Our Operator! (from Percona Database Performance Blog)

♦Kubernetes has been a big trend for a while now, particularly well-suited for microservices. Running your main databases on Kubernetes is probably NOT what you are looking for. However, there’s a niche market for them. My colleague Stephen Thorn did a great job explaining this in The Criticality of a Kubernetes Operator for Databases. If […] [...]

Monitoring Percona Server for MySQL - Key Metrics (from SeveralNines Open Source Database Blog)

pIn this blog post, we are going to look into some key metrics and status when monitoring a Percona Server for MySQL to help us fine-tune the MySQL server configuration for a long run. Just for the heads up, Percona Server has some monitoring metrics that are only available on this build. When comparing on version 8.0.20, the following 51 statuses are only available on Percona Server for MySQL, whi [...]

Tame Black Friday Gremlins — Optimize Your Database for High Traffic Events (from Percona Database Performance Blog)

♦It’s that time of year! The Halloween decorations have come down and the leaves have started to change and the Black Friday/Cyber Monday buying season is upon us! For consumers, it can be a magical time of year, but for those of us that have worked in e-commerce or retail, it usually brings up…different emotions. […] [...]

PingCAP, the Company Behind TiDB, Raises $270 Million in Series D Funding (from TiDB and TiKV Blog)

With great pleasure, we are announcing that we have raised $270 million in Series D funding led by global investors. We are looking for more innovations, global expansion, and more team growth as we strive to build the database of the future. [...]

Monday, 16. November 2020

Taking SkySQL for a spin to launch a Galera Cluster (from Galera Blog)

If you haven’t already tried SkySQL, it is worth noting that you can now launch a Galera Cluster. SkySQL is an automated Database as a Service (DBaas) solution to launch a Galera Cluster within Google Cloud Platform. Launching a Galera Cluster is currently a tech preview and you are still eligible for USD$500 worth of credit, […] [...]

TiDB on KubeSphere: Run a Cloud-Native Distributed Database on a Hybrid-Cloud Kubernetes Platform (from TiDB and TiKV Blog)

A site reliability engineer gives a step-by-step tutorial on how to deploy TiDB on KubeSphere, an open-source, distributed GUI operating system with Kubernetes as its kernel. [...]

Sunday, 15. November 2020

Configure a MySQL Database Service (MDS) DB System (from MySQL Support Blogs)

It’s now more than two months since MDS, the managed MySQL Server solution by Oracle MySQL team, hosted on Oracle Cloud Infrastructure (OCI), became available in several regions on the 1st of September. You can find online several resources online, such as: MDS documentation Oracle MySQL blog MySQL Database Service Release Notes If you haven’t tried it for free, time to do so with the free [...]

Saturday, 14. November 2020

MariaDB/MySQL IS NULL conditions and indexes (from Vettabase)

pIt is quite common to use an equality condition and an IS NULL condition on the same columns. Unfortunately, this could make queries very slow. Continue reading MariaDB/MySQL IS NULL conditions and indexes→/p pThe post MariaDB/MySQL IS NULL conditions and indexes appeared first on Vettabase./p [...]

Friday, 13. November 2020

Monitoring that AUTO_INCREMENT values won’t reach the limit (from Vettabase)

pAUTO_INCREMENT primary keys are useful, because they save usthe trouble to generate a unique value for every row, delegating this task to the database. But when we reach the limit we need to take some action, or we won’t be able to insert more rows. Continue reading Monitoring that AUTO_INCREMENT values won’t reach the limit→/p pThe post Monitoring that AUTO_INCREMENT values won’t reach th [...]

Ansible Inventory Automation Using Consul and Orchestrator (from Pythian Blog - MySQL Track)

Here at Pythian we get a lot of exposure to new technologies and implementation strategies via the work we do internally and for our clients. The most noteworthy technology stack that I’ve seen get a lot of traction in the... [...]

Kubernetes Scaling Capabilities with Percona XtraDB Cluster (from Percona Database Performance Blog)

♦Our recent survey showed that many organizations saw unexpected growth around cloud and data. Unexpected bills can become a big problem, especially in such uncertain times. This blog post talks about how Kubernetes scaling capabilities work with Percona Kubernetes Operator for Percona XtraDB Cluster (PXC Operator) and can help you to control the bill. Resources […] [...]

Full-Text Searches in MySQL: The Good, the Bad and the Ugly (from SeveralNines Open Source Database Blog)

pSometimes when searching in a MySQL database you might want to run full-text search queries against character-based data. Today we’re discussing the advantages and disadvantages of such search methods./p What are Full-Text Searches in MySQL? pFull-text search is a technique that enables you to search for records that might not perfectly match the search criteria. Full-text searches in MySQL are [...]

Watch the Replay: Zero Downtime MySQL - Always Available, Guaranteed Lottery Game Access (from Continuent Blog)

pWatch the replay of this Zero Downtime MySQL use case webinar with Continuent CEO Eero Teerikorpi and find out how Kentucky Lottery achieved continuous MySQL operations with high availability, data protection, and disaster recovery using a Composite Active/Passive Tungsten Clustering Topology./p Tags: WebinarMySQLuse casetungsten clusteringmysql clustercontinuous mysql operationsHigh Availabi [...]

Thursday, 12. November 2020

Using your FRM file to get Schema and then import idb files.. (from Another MySQL DBA)

p This is a topic that overall you never should have to do... Why? Because you created backups right... You have tested and know the backups work so you can just restore those backups and get your lost schema and related data... /ppHowever that one instance in the corner office.. you never got around to setting up.. it not that important... just crashed and now you realize how you actuall [...]

Wednesday, 11. November 2020

MariaDB SkySQL Takes a Data Security First Approach (from MariaDB Corporation Blog)

Data security is a guiding principle for MariaDB SkySQL, and all SkySQL databases incorporate features that make them secure by default. [...]

Partial Table or Schema restore from mariabackup full backup (from Shinguz's Blog)

pFor me it was for a long time not clear if a codemariabackup/code full backup can be used to do partial table or schema restores. Now we faced this challenge with a customer. So time to try it out.../p pThis test was made with MariaDB 10.5.5. So it may not work with some older MariaDB releases.../p Backup pBecause I do not know during the backup if I need a full or a partial restore I always w [...]

Live Events This Week and More Basic Videos (from PHP With MySQL)

p    The Granite State Code Camp is this Saturday November 14th and I will be speaking on new Features in MySQL 8./pp    Sadly Babbletech is going to be canceled but you can catch my talk on MySQL Indexes and Histograms that was recorded at the All Things Open Conference. /pp  And I am slowly adding more videos to my Dave's MySQL Basics series for beginn [...]

Emergency Release of MariaDB 10.5.8, 10.4.17, 10.3.27, and 10.2.36 is now available (from MariaDB Foundation Blog)

pWhy do we release MariaDB again only a week after the 10.5.7, 10.4.16, etc? What's the emergency?/p pThe post Emergency Release of MariaDB 10.5.8, 10.4.17, 10.3.27, and 10.2.36 is now available appeared first on [...]

How to Allow a Remote MySQL Database Connection (from Pythian Blog - MySQL Track)

Here at Pythian we like to pay attention to what brings people to our site, and one of the main queries we’ve been seeing is “How can I allow a remote MySQL database connection?” Since our mission is to help... [...]

MariaDB 10.5.8, 10.4.17, and others now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Server 10.5.8, 10.4.17, 10.3.27, and 10.2.36. See the release notes... Read more » [...]

Rolling sum and average – Window Functions MySQL (from Digital Owl's Prose)

pRolling sum and average query results are possible by combining the aggregate functions SUM() or AVG() with the OVER() clause, making for powerful analytic queries. I recently learned how to compute a rolling average or sum of values by using the Windowing option of the OVER() clause, applying the concepts to a data set I […]/p pThe post Rolling sum and averag [...]

Flink + TiDB: A Scale-Out Real-Time Data Warehouse for Second-Level Analytics (from TiDB and TiKV Blog)

By combining Apache Flink and TiDB, we offer an efficient, easy-to-use, real-time data warehouse with horizontal scalability and high availability. [...]

Tuesday, 10. November 2020

How to Deploy Percona Server for MySQL for High Availability (from SeveralNines Open Source Database Blog)

pPercona Server for MySQL 8.0 offers a number of clustering solutions for high availability out-of-the-box:/p ulliSingle-master: ulliAsynchronous replication/li liSemi synchronous replication/li /ul/li liMulti-master: ulliGroup replication/li liInnoDB Cluster (a combination of MySQL Router, MySQL Shell and Percona Server with Group Replication)/li /ul/li /ulpThe most popular, battle-test [...]

Monday, 09. November 2020

Vitess Operator for Kubernetes (from Vitess)

Introduction In this blog, I would like to explore Vitess Operator for Kubernetes. This post demonstrates the sample implementation of Vitess in Kubernetes topology. I also explore common DBA tasks by demonstrating how they are handled in the Vitess ecosystem. Vitess, out of the box, comes with a lot of tools and utilities that one has to either incorporate or develop to manage MySQL topology. Let’ [...]

Sunday, 08. November 2020

MySQL Client in 8.0.21+ (from MacLochlainns Weblog)

Having recently installed a fresh copy of MySQL 8.0.21 on Windows, I took careful note of parsing changes in the MySQL Shell. It was tedious that we lost multiple statement processing, which is supported in the MySQL Client and MySQL Workbench because it uses MySQL Client. It was frustrating when I subsequently discovered that the […] [...]

Max row per group, sad answers only (from Small Datum)

pToday I learned that frequently asked questions on StackOverflow get their own tag. The tag greatest-n-per-group is for answers to questions about writing SQL to find the max row per group. By max row I mean the aggregated columns, group by columns and other columns for the row that has the max or min value in a group. By sad answers only I mean there is a lot of confusion about this, StackOv [...]

Friday, 06. November 2020

Asynchronous Replication Automatic Failover in MySQL 8.0.22 (from SeveralNines Open Source Database Blog)

p /p pOracle recently released MySQL 8.0.22, and this new version came with a new asynchronous connection failover mechanism. It allows a replica to automatically establish an asynchronous replication connection to a new source, in case its existing one fails./p pIn this blog, we'll look at this connection failover mechanism./p Overview pThe asynchronous failover mechanism can be used to keep a [...]

Various Backup Compression Methods Using Mysqlpump (from Percona Database Performance Blog)

♦Mysqlpump is a client program that was released with MySQL 5.7.8 and is used to perform logical backups in a better way. Mysqlpump supports parallelism and it has the capability of creating compressed output. Pablo already wrote a blog about this utility (The mysqlpump Utility), and in this blog, I am going to explore the […] [...]

Configuring MySQL in a Docker Container (from Pythian Blog - MySQL Track)

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular post from the past. Today’s post was originally published on May 23, 2018. In recent weeks I’ve been focusing... [...]

Conditional Updates (from MacLochlainns Weblog)

While I’m switching labs next term after more than a decade with more comprehensive lab set, I’m hoping the new exercises build the students’ core SQL skill set. Next term, I hope to see whether the change is successful. I’ve opted for using Alan Beaulieu’s Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition, because […] [...]

Thursday, 05. November 2020

ChaosMesh to Create Chaos in Kubernetes (from Percona Database Performance Blog)

♦In my talk on Percona Live (download the presentation), I spoke about how we can use Percona Kubernetes Operators to deploy our own Database-as-Service, based on fully OpenSource components and independent from any particular cloud provider. Today I want to mention an important tool that I use to test our Operators: ChaosMesh, which actually is […] [...]

Deploying Percona Monitoring and Management 2 Without Access to the Internet (from Percona Database Performance Blog)

♦Normally it is quite easy to deploy Percona Monitoring and Management (PMM) Server as a Docker container as per the official documentation. However, when working in very restrictive environments, it is possible the server doesn’t have access to the public Internet, so pulling the image from the Docker hub is not possible. Fortunately, there are a […] [...]

Automatic connection failover for Asynchronous Replication (from MySQL expert Diary)

pSince MySQL 8.0.22 there is a mechanism in asynchronous replication that makes the receiver automatically try to re-establish an asynchronous replication connection to another sender, in case the current connection gets interrupted due to the failure of the current sender./p pThe post Automatic connection failover for Asynchronous Replication first appeared on - Diary of a MySQL expert. [...]

Wednesday, 04. November 2020

Running Percona Kubernetes Operator for Percona XtraDB Cluster with Kata Containers (from Percona Database Performance Blog)

♦Kata containers are containers that use hardware virtualization technologies for workload isolation almost without performance penalties. Top use cases are untrusted workloads and tenant isolation (for example in a shared Kubernetes cluster). This blog post describes how to run Percona Kubernetes Operator for Percona XtraDB Cluster (PXC Operator) using Kata containers. Prepare Your Kubernetes Clus [...]

RANK() and DENSE_RANK() differences (from Digital Owl's Prose)

pThe Window Ranking functions: ROW_NUMBER(), RANK(), and DENSE_RANK() each rank rows with an increasing integer value. I wrote a previous blog post, ROW_NUMBER() Window Function – find duplicate values, where I covered how the ROW_NUMBER() window function can be used to target any duplicate rows, with the use of the PARTITION BY clause in the […]/p pThe post RA [...]

MariaDB & Ecosystem Fragmentation (from MariaDB Foundation Blog)

pWe hear you, Kristian Köhntopp! Thank you  for taking the time to articulate what many others are probably For those of you to whom this sounds cryptic, let me share how I interpreted Kristian Köhntopp’s blog MySQL: Ecosystem fragmentation (, published last week:br Kristian noted that the question &# [...]

MariaDB 10.5.7, 10.4.16, 10.3.26, 10.2.35 and 10.1.48 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.5.7, MariaDB 10.4.16, MariaDB 10.3.26, MariaDB 10.2.35 and MariaDB 10.1.48, the latest stable releases in their respective series. […]/p pThe post MariaDB 10.5.7, 10.4.16, 10.3.26, 10.2.35 and 10.1.48 now available appeared first on [...]

MariaDB 10.5.7, 10.4.16, and others now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Server 10.5.7, 10.4.16, 10.3.26, 10.2.35, and 10.1.48. See the release... Read more » [...]

DM 2.0 GA: Secure, Easy, Highly Available Data Migration (from TiDB and TiKV Blog)

DM 2.0 has reached general availability. It supports highly available migration tasks and shard merging and migration in optimistic mode. [...]

Tuesday, 03. November 2020

Fixing Data Slowdowns Without Breaking the Bank (from Percona Database Performance Blog)

♦In this year’s Open Source Data Management Software survey, we asked organizations “What issues have you experienced in the last 12 months?” The main issue, flagged by three-quarters of respondents, was performance. Given the adverse impact that data slowdown has on business performance – especially during high traffic events – effectively managing them is essential […] [...]

MySQL Audit Data Consolidation – Made Simple (from MySQL Server Blog)

pIn this blog, I am going to demonstrate how to create your own consolidated audit log archive across many mysql instances. In a followup I’ll show how to extend this example by creating a simple hash chain on that archive – so you can prove whether or not its been modified or tainted in any way and if so where.…/p [...]

Adjusting MySQL 8.0 Memory Parameters (from Percona Database Performance Blog)

♦So you’ve just added some more memory to your MySQL server; now what? If you’ve been around the MySQL block for a while, you know that nothing is automatically changed to take advantage of this new system RAM. Let’s have a look at a few parameters you would want to adjust. InnoDB Parameters innodb_buffer_pool_size The […] [...]

Choosing the Right Enterprise-Grade Disaster Recovery Solution for the Financial Industry (from TiDB and TiKV Blog)

Financial companies have stringent requirements for high availability and disaster recovery, which many databases cannot meet. This article describes how TiDB addresses both these issues with a range of options that make it an excellent choice for the industry. [...]

Streaming Vitess at Bolt (from Vitess)

Previously posted on link at Nov 3, 2020. Traditionally, MySQL has been used to power most of the backend services at Bolt. We’ve designed our schemas in a way that they’re sharded into different MySQL clusters. Each MySQL cluster contains a subset of data and consists of one primary and multiple replication nodes. Once data is persisted to the database, we use the Debezium MySQL Connec [...]

Why run MySQL on ARM - Part 2 (from MySQL On ARM)

In the previous blog, we saw that users don’t lose anything by moving to MySQL on ARM. Infact, users are set to gain performance and save cost. In this blog post we will see performance numbers and analyze them to understand points where ARM scores. [...]

Monday, 02. November 2020

An Overview of the Percona XtraDB Cluster Kubernetes Operator (from SeveralNines Open Source Database Blog)

pIf you have been around in the container world, you would know that it is pretty challenging to adopt a full Kubernetes automation for a clustered database system, which commonly adds a level of complexity to the container-based architecture for these stateful applications. That's where a Kubernetes Operator can help us to address this problem. A Kubernetes Operator is a special type of controller [...]

Understanding MySQL Memory Usage with Performance Schema (from Percona Database Performance Blog)

♦Understanding how MySQL uses memory is key to tuning it for optimal performance as well as troubleshooting cases of unexpected memory usage, i.e. when you have MySQL Server using a lot more than you would expect based on your configuration settings. Early in MySQL history, understanding memory usage details was hard and included a lot […] [...]

MySQL 5.6 End of Life Reminder (from PHP With MySQL)

p This is a reminder that MySQL 5.6 reaches End of Life status in February 2021.  I have been sending out such reminders since February of this year. But in my presentations this year when I bring up the 5.6 EOL, there are a lot of users out there that are surprised to hear the news./pp    Wikipedia says ""End-of-life" ("EOL") is a term used with respect to a [...]

Query Metrics Requirements for MySQL (from Hack MySQL)

Let’s answer a question which, to my knowledge, has never been systematically addressed: What are the requirements for a production-ready query metrics app at scale? I am uniquely qualified to answer that because I have written four query metrics apps, two of which are the open-source standard for MySQL: pt-query-digest and the original (v1) code behind the query metrics/analysis part of Perc [...]

Friday, 30. October 2020

Announcing Vitess 8 (from PlanetScale Blog)

On behalf of the Vitess maintainers team, I am pleased to announce the general availability of Vitess 8 for MySQL. [...]

CVE-2020-15180 – Affects Percona XtraDB Cluster (from Percona Database Performance Blog)

♦Galera replication technology, a key component of Percona XtraDB Cluster, suffered from a remote code execution vulnerability. Percona has been working with the vendor since early September on this issue and has made releases available to address the problem. Applicability A malicious party with access to the WSREP service port (4567/TCP) as well as prerequisite […] [...]

Percona Monthly Bug Report: October 2020 (from Percona Database Performance Blog)

♦At Percona, we operate on the premise that full-transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter […] [...]

Using the Percona Audit Log Plugin for Database Security (from SeveralNines Open Source Database Blog)

Why Do You Need To Use an Audit Plugin For Your Database? pAuditing in a database doesn't deviate from its meaning as it shares the same connotation i.e. to inspect, examine, and evaluate for such database events/transactions that are being logged or performed within your database. It in fact adds more feasibility for databases especially as a security feature, as it commends the administrative si [...]

Releasing ProxySQL 2.0.15 (from ProxySQL Blog)

pProxySQL is proud to announce the latest release of ProxySQL version 2.0.15 on the 30th of October 2020 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, and freely usable and accessible according [...]/p pThe post Releasing ProxySQL 2.0.15 appeared first on ProxySQL./p [...]

Watch the Replay: Geo-Scale Five9s MySQL - Worldwide Roaming Access for Millions of Mobile Phones (from Continuent Blog)

pJoin the replay of this webinar which discusses the use of geo-distributed active/active MySQL clusters for Telco providers, and on how to cost-effectively provide worldwide mobile roaming access with cloud-based Tungsten MySQL clusters./p Tags: WebinarMySQLuse casetungsten clusteringmysql clustergeo-distributedgalera clustergalera alternativesknowroaminggeo-scale [...]

Thursday, 29. October 2020

MariaDB SkySQL Updates for Cloud Data Warehousing and HTAP Topologies (from MariaDB Corporation Blog)

The newest release of MariaDB SkySQL includes MariaDB Enterprise ColumnStore 5.4. ColumnStore is a columnar smart engine used to accomplish... Read more » [...]

Migrating Azure Database for MySQL/MariaDB to an On-Prem Server (from SeveralNines Open Source Database Blog)

pDatabase migrations can impose huge challenges when you consider how to start, what tools to use, and how to achieve a full database migration successfully. Earlier, we have listed the top open source you can use on migration for MySQL or MariaDB. In this blog, we'll show you how to migrate data from Microsoft Azure Database for MySQL or MariaDB./p pMicrosoft Azure is now known to be a contender [...]

2020 Percona Survey Results Reveal the Latest Open Source Database Trends (from Percona Database Performance Blog)

♦At our recent Percona Live ONLINE we announced the release of the 2020 Open Source Data Management Software Survey results.  This year, we wanted to build upon the data we collected in 2019 and continue to monitor the open source industry’s pulse. The 2020 survey was perhaps reflective of the wider world environment, as companies […] [...]

MySQL/MariaDB: use SQL properly to run less queries (from Vettabase)

pReducing the number of queries is important with any DBMS. There are two reasons for this: reducing the latency of applications; and reducing the workload for the database servers. Continue reading MySQL/MariaDB: use SQL properly to run less queries→/p pThe post MySQL/MariaDB: use SQL properly to run less queries appeared first on Vettabase./p [...]

MySQL 8.0.22 Replication Enhancements (from MySQL High Availability)

pMySQL 8.0.22 was released roughly a week ago. It includes some nice additions to replication that we would like to call out. Here they are:/p ulliAutomatic Asynchronous Replication Connection Failover (WL#12649). This work, by Hemant Dangi, implements a mechanism in asynchronous replication that makes the replica automatically try to re-establish an asynchronous replication connection to anothe [...]

Metrics Relation Graph Helps DBAs Quickly Locate Performance Problems in TiDB (from TiDB and TiKV Blog)

TiDB v4.0.7 introduced a new feature: the metrics relation graph. It helps users clearly see the relationship between different performance metrics in a database cluster and thus quickly locate the root causes of performance problems. [...]

Why run MySQL on ARM - Part 1 (from MySQL On ARM)

MySQL on ARM is gaining consistent momentum and community is excited about it. Beyond performance, users also tend to explore other aspects like feature-set, ecosystem, support, etc… Let’s explore what users would gain/lose by moving to mysql on arm. [...]

Wednesday, 28. October 2020

MariaDB SkySQL Adds Clustering for Continuous Availability (from MariaDB Corporation Blog)

MariaDB SkySQL now includes a clustering option for virtually-synchronous replication and high availability. [...]

Migrating Google Cloud SQL for MySQL to an On-Prem Server (from SeveralNines Open Source Database Blog)

pGoogle Cloud SQL for MySQL is a fully-managed database service that helps you set up, maintain, manage, and administer your MySQL relational databases on Google Cloud Platform. However, there are differences between Cloud SQL and standard MySQL functionality like limited control, restricted resources, data locality, budget and security, which may influence your final decision to move out from the [...]

MariaDB SkySQL Adds Distributed SQL with Dynamic Elasticity (from MariaDB Corporation Blog)

With MariaDB SkySQL distributed SQL, dynamically changing a service's node count is as easy as clicking a button. Adding or decreasing the node count including providing copies for HA and load balancing is done transparently behind the scenes. [...]

Say Hello to Libcoredumper – A New Way to Generate Core Dumps, and Other Improvements (from Percona Database Performance Blog)

♦In a perfect world, we expect all software to run flawlessly and never have problems such as bugs and crashes. We also know that this perfect world doesn’t exist and we better be as prepared as possible to troubleshoot those types of situations. Historically, generating core dumps has been a task delegated to the kernel. […] [...]

Aurora multi-Primary first impression (from TusaCentral - MySQL Blogs)

pFor what reason should I use a real multi-Primary setup? brTo be clear, not a multi-writer solution where any node can become the active writer in case of needs, as for PXC or PS-Group_replication. brNo, we are talking about a multi-Primary setup where I can write at the same time on multiple nodes. brI want to insist on this “why?”./p pAfter having excluded the possible solutions mentioned above, [...]

MySQL: Ecosystem fragmentation (from Die wunderbare Welt von Isotopp)

pSometimes things change in a way that is hard to put a finger on, but I am doing this MySQL thing since 3.23, and commercially since 2005, and the environment is changing. These days, when you talk to people in need of MySQL, the first thing you have to ask them is “Which MySQL”. And by that I do not mean a version number in the first place./p pThe answer may be:/p ul liAWS RDS MySQL/li liAW [...]

ROW_NUMBER() Window Function – find duplicate values. (from Digital Owl's Prose)

pMany times, we do not want duplicate rows or values in our SQL tables. On the other hand, in some situations, it does not matter if there are duplicates present. For whatever reason, suppose duplicates have found their way into one of your tables. How can you find them quickly and easily? The ROW_NUMBER() Window […]/p pThe post ROW_NUMBER() Window Function – find duplicate valu [...]

Tuesday, 27. October 2020

LSM local secondary indexes (LSM LSI) (from Small Datum)

pThis expands on my previous post about RID-lists for RocksDB. RocksDB doesn't provide secondary indexes, nor does it know about schemas but applications that use RocksDB can add both and MyRocks is an example of that./ppMany DBMS use the concept of local vs global secondary indexes and partitioned tables are one place where this matters. Assuming a B-Tree is used for the index, then a local second [...]

Using MySQL 8 Persisted System Variables (from Percona Database Performance Blog)

♦This blog discusses new features about the persisted system variables and how we can use it to make variable changes persistent. The MySQL server maintains system variables that control its operations. The dynamic variables used prior to the MySQL 8 release are not persistent and are reset upon restart. These variables can be changed at […] [...]

Using CTEs in TPC-H in NDB Cluster (from Mikael Ronstrom)

p In the previous post I showed some improvements based on using/ppWindows functions in rewritten TPC-H queries. In this blog post/ppI will discuss the improvements made in Q15 using a CTE (Common/ppTable Expression). This is again based on inspiration from new and/ppold blogs written by Öystein Grövlen (should be norwegian ö's)./ppbr/ppHere is Q15 in TPC-H:/ppcreate view revenue (supplier_no, [...]

A First Glance at Amazon Aurora Serverless RDS (from Percona Database Performance Blog)

♦If you often deploy services in the cloud, you certainly, at least once, forgot to stop a test instance. I am like you and I forgot my share of these. Another mistake I do once in a while is to provision a bigger instance than needed, just in case, and forget to downsize it. While […] [...]

Using Windows functions in TPC-H with NDB Cluster (from Mikael Ronstrom)

p This is probably the first time I post a blog that handles variants of/pphow to use SQL :)/ppI got the inspiration from reading some new and old blogs by Öystein Grövlen/ppwhere he mentioned various ways to rewrite queries as Common Table/ppExpressions (CTEs) and using windows functions instead of using subqueries./ppI tried this and found that the rewritten queries was faster using windows [...]

The risks of MySQL release policy (from Vettabase)

pMySQL 8.0 and 5.7 follow a new release policy that exposes users to important risks. They broke compatibility with Xtrabackup (again). Continue reading The risks of MySQL release policy→/p pThe post The risks of MySQL release policy appeared first on Vettabase./p [...]