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.

Monday, 08. August 2022

Database DevOps (from PlanetScale Blog)

Learn how PlanetScale enables databases to seamlessly fit into the DevOps lifecycle.pRead the full story/p [...]

MySQL: Waiting for query cache lock (from Shattered Silicon Open Source Database Blog)

pTroubleshooting performance degradation caused by pileup of queries stuck in "Waiting for query cache lock" state in MySQL and MariaDB./p pThe post MySQL: Waiting for query cache lock appeared first on Shattered Silicon./p [...]

OpenLampTech issue #38 – Substack Repost (from Digital Owl's Prose)

pWe have another massive newsletter for you this week. And OpenLampTech is growing! Thank you for making it a success! This week in OpenLampTech issue #38, we have content covering: MySQL Indexes PHP boolean comparisons Yoda Conditions Installing WordPress on LAMP And much more Be sure and grab a free subscription to the weekly OpenLampTech […]/p pThe post OpenLampTech issue #38 – Subst [...]

Friday, 05. August 2022

Running PMM with Docker on Ubuntu 20.04 (from Percona Community Blog)

I started at Percona a few weeks ago and was looking for a quick way to learn about PMM (Percona Monitoring and Management), which is one of my favorite technologies within Percona to monitor the health of our database infrastructure, explore new patterns in the database behavior, manage and improve the performance of our databases, all with customizable dashboards and real-time alerts using Grafan [...]

Setting up PMM for monitoring MySQL on a local environment (from Percona Community Blog)

Percona Monitoring and Management (PMM) is an open source database monitoring, observability, and management tool that can be used for monitoring the health of your database infrastructure, exploring new patterns in database behavior, and managing and improving the performance of your databases no matter where they are located or deployed. PMM is designed to work with MySQL (including Percona Serve [...]

Thursday, 04. August 2022

Connect to a MySQL database in Python (from PlanetScale Blog)

Connect a Python app to MySQL database with mysqlclient, mysql-connector-python, PyMySQL, and aiomysql.pRead the full story/p [...]

MariaDB Java Connector 3.0.7 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.0.7 GA release. Download Now Release Notes MariaDB … Continued [...]

Cycle Detection for Recursive Search in Hierarchical Trees (from SQL for Devs)

For storing trees in a database the adjacency list model is a straightforward implementation, where every row contains a reference to the parent row. One recursive query can select all parents or children for a specific row instead of the most common implementation to execute multiple queries. However, accidental loops in the data's references would fail a re [...]

Wednesday, 03. August 2022

Managing MySQL Configurations with the PXC Kubernetes Operator V1.10.0 Part 3: Conclusion (from Percona Database Performance Blog)

♦In part one and part two of this series, we introduced the different ways to manage MySQL configurations and precedence when using the Percona XtraDB Cluster (PXC) object and ConfigMap. In this post, we will see the precedence when secrets are used for MySQL configurations in Percona Operator for MySQL based on Percona XtraDB Cluster. […] [...]

Managing parentheses with the Doctrine 2 ORM QueryBuilder (from MonCode - Tech/Dev blog)

To change a small snippet on Doctrine 2 ORM to learn how to handle parentheses in the WHERE clause of an SQL query. [...]

MySQL WHERE Clause Inequality Comparison Operators (from Digital Owl's Prose)

pJust as you want to filter the rows of data returned in a SELECT query with the equality comparison operator (=), you can also create a conditional filter to test if 2 values are not equal to one another. Learn more in the following article. In MySQL, there are 2 ‘not equal to’ comparison operators […]/p pThe post MySQL WHERE Clause Inequality Comparison Operators appeared first on Digital O [...]

Tuesday, 02. August 2022

How PlanetScale prevents MySQL downtime (from PlanetScale Blog)

Learn how PlanetScale protects against downtime due to human error, system immaturity, and app issues.pRead the full story/p [...]

Monday, 01. August 2022

Ruby on Rails: 3 tips for deleting data at scale (from PlanetScale Blog)

Learn how to delete data in large Rails apps with destroy_async, delete, destroy, and scheduled cron jobs.pRead the full story/p [...]

Managing MySQL Configurations with the PXC Kubernetes Operator V1.10.0 Part 2: Walkthrough (from Percona Database Performance Blog)

♦In part one of this series, we introduced the different ways to manage MySQL configurations. In this post, we will walk through different possibilities and the changes happening while modifying MySQL configurations with the operator. Percona Distribution for MySQL Operator based on Percona XtraDB Cluster (PXC) provides three ways for managing MySQL, but the question […] [...]

OpenLampTech issue #37 – Substack Repost (from Digital Owl's Prose)

pWe are moving right along with the OpenLampTech publication. This week’s issue has a great developer interview, in addition to all the curated MySQL, PHP, and LAMP stack content you’ve come to expect. Let’s get to it. Enjoy OpenLampTech issue #37! In OpenLampTech issue #37, I’m sharing articles on: MySQL Generated Columns PHP solutions to […]/p pThe post OpenLampTech [...]

Friday, 29. July 2022

How to Benchmark Replication Performance in MySQL (from Percona Database Performance Blog)

♦In this blog, I will cover important aspects which you need to test when benchmarking replication setup. MySQL has great tools that could be used to test its performance. They include: sysbench – BMK-kit – mysqlslap – LinkBench – [...]

The world's first LATS benchmark (from Mikael Ronstrom)

p LATS stands for low Latency, high Availability, high Throughput and scalable Storage. When testing an OLTP DBMS it is important to look at all those aspects. This means that the benchmark should test how the DBMS works in scenarios where data fits in memory, where data doesn't fit in memory. In addition tests should run measuring both throughput and latency. Finally it isn't enough to run th [...]

Thursday, 28. July 2022

Better Replication Heartbeats (from Hack MySQL)

pWe’ve been measuring MySQL replication lag with heartbeats for more than a decade. It works, but can we do better? Let’s see./p [...]

The Slotted Counter Pattern (from PlanetScale Blog)

Handle MySQL increment counter bursts with the Slotted Counter PatternpRead the full story/p [...]

New stable release of RonDB, RonDB 21.04.8 (from Mikael Ronstrom)

pToday we released a new version of RonDB 21.04, the stable release series of RonDB. RonDB 21.04.8 fixes a few critical bugs and two new features. See the docs for more details of this released version./pMake it possible to use IPv4 sockets between ndbmtd and API nodespIn MySQL NDB Cluster all sockets have been converted to use IPv6 format even when IPv4 sockets are used. This led to MySQL NDB Clus [...]

Galera Manager updated to handle DigitalOcean updated API tokens (from Galera Blog)

A few weeks ago, we did a Galera Cluster webinar on Managed Galera Clusters on DigitalOcean. Some of you may notice that the current version of Galera Manager is 1.6.4, and one of the major fixes we have in there is to support the new API token format of DigitalOcean. DigitalOcean has documented this here: […] [...]

Wednesday, 27. July 2022

Behind the scenes: How we built Password Roles (from PlanetScale Blog)

Learn how we leveraged Vitess ACLs and VTTablet to build our password roles functionalitypRead the full story/p [...]

MariaDB & K8s: How to replicate MariaDB in K8s (from MariaDB Foundation Blog)

pIn the previous blog we have seen how to create a statefulset MariaDB application. Also, we learned how replication works in MariaDB in this blog. … /p pContinue reading \"MariaDB & K8s: How to replicate MariaDB in K8s\"/p pThe post MariaDB & K8s: How to replicate MariaDB in K8s appeared first on [...]

A Quick Peek At MySQL 8.0.30 (from Percona Database Performance Blog)

♦MySQL 8.0 is now over four years old and Oracle released the latest quarterly offering today with MySQL 8.0.30, which comes with lots of bug fixes and some interesting additions.  This is my take on the release notes for those who do not have the time to wade through them, comments in italics are my […] [...]

CodeIgniter 4 Query Parameter Binding with examples in MySQL (from Digital Owl's Prose)

pAs powerful and useful as the CodeIgniter 4 Query Builder class methods and functions are, there are times when you need to hand-craft your own queries. Perhaps they are complex. Or, you would just rather write the raw SQL. Learn how to safely use the input you need – typically as part of the WHERE […]/p pThe post CodeIgniter 4 Query Parameter Binding with examples in MySQL appeared fi [...]

Tuesday, 26. July 2022

MariaDB Node.js Connector 3.0.1 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Node.js 3.0.1 GA release. Download Now Release Notes MariaDB … Continued [...]

Monday, 25. July 2022

Safely dropping MySQL tables (from PlanetScale Blog)

Learn about how we're making it safer to drop tables and easier to detect if they're still in use.pRead the full story/p [...]

Managing MySQL Configurations with the PXC Kubernetes Operator V1.10.0 Part 1: Introduction (from Percona Database Performance Blog)

♦Introduction/FAQ Question: I need to run a production-grade open source MySQL DB. Answer: Percona to the rescue! Percona XtraDB Cluster (PXC) is an open source enterprise MySQL solution that helps you to ensure data availability for your applications while improving security and simplifying the development of new applications in the most demanding public, private, and […] [...]

OpenLampTech issue #36 – Substack Repost (from Digital Owl's Prose)

pHey hey, OpenLampTech is back this week with another packed issue of the best MySQL, PHP, and LAMP stack content I am sharing from the web. Enjoy! In OpenLampTech issue #36, we are looking at articles covering: PHP == vs === comparison operators MySQL ALTER TABLE Installing WordPress in a subdirectory. Why developers prefer Linux […]/p pThe post OpenLampTech issue #36 – Substack Repost [...]

Friday, 22. July 2022

Temporal Workflows at scale with PlanetScale - Part 1 (from PlanetScale Blog)

Learn how to create a more reliable workflow with Temporal and PlanetScalepRead the full story/p [...]

Thursday, 21. July 2022

The impact of max_background_threads, part 2 (from Small Datum)

pThis is a follow to the results I published for the impact of max_background_jobs on RocksDB performance. The previous post used an IO-bound workload. This post uses a cached workload. The purpose for this work is to evaluate my rule of thumb that the number of busy threads should be <= the number of CPU cores. This is explained in detail in the previous post.brbrtl;dr/pp/pulliSimilar to the re [...]

Preventing Stale Reads on Percona XtraDB Cluster by Enforcing Causality Checks on a Per-Query Basis (from Percona Database Performance Blog)

♦When we run a SELECT in a replica server and it returns a different result to the one we would have obtained had we queried the source server instead, due to changes in the dataset that have not yet been replicated or synchronized to the replica, we get what is known as a stale read. […] [...]

How to Resolve “Error Reading Relay Log Event” After Relay Log Corruption (from Percona Database Performance Blog)

♦In this blog, I explain how to recover from a replication failure caused by a corrupted relay log file. MySQL replica stores data received from its source binary log in the relay log file. This file could be corrupted due to various reasons, mostly hardware failures. If this happens, replication will stop working, and the […] [...]

Delete Duplicate Rows (from SQL for Devs)

After some time most application will have some duplicated rows resulting in bad user experience, higher storage requirements and less database performance. The cleaning process is usually implemented in application code with complex chunking behavior as the data does not fit into memory completely. However, a single SQL query can do the whole process, includ [...]

The impact of max_background_jobs on write throughput for RocksDB (from Small Datum)

pI rely on rules of thumb when configuring a DBMS for a benchmark. This post is about configuring the number of background threads and the number of client threads for RocksDB to improve throughput and quality of service (low variance) with IO-bound workloads. The background threads are used for compaction and memtable flushes. The option is max_background_jobs. /ppEventually I need to ev [...]

Wednesday, 20. July 2022

Announcing Teams: An easier way to manage database administrator access (from PlanetScale Blog)

Learn how you can manage database access with Teams and Directory SyncpRead the full story/p [...]

From email to myTinyTodo (from lefred's blog)

Usually, I receive a lot of emails, and sometimes I read them on my phone and then… I forgot about them.. (shame on me). On my Linux desktop, I used to use Get Things Gnome for a long time, due to the declining appeal of the project and the end of the extension for Thunderbird, I found it less and less useful. I was then looking for a solution to have my todolist accessible from everywhere and that [...]

Tuesday, 19. July 2022

We now display PlanetScale system status directly in your dashboard (from PlanetScale Blog)

Learn about how we built the new in-app system status using Vercel edge functions and StatusPagepRead the full story/p [...]

Percona XtraBackup 8.0.29 and INSTANT ADD/DROP Columns (from Percona Database Performance Blog)

♦Oracle’s MySQL 8.0.29 release extended the support for ALTER TABLE … ALGORITHM=INSTANT to 1) allow users to instantly add columns in any position of the table, and 2) instantly drop columns. As part of this work, the InnoDB redo log format has changed for all DML operations on the server. This new redo log format […] [...]

Exploiting the Powerful Filtering Capabilities of Tungsten Replicator (from Continuent Blog)

pIn this blog we take a look at how you can use Tungsten Replicator to replicate data from multiple sources, and merge into a single target using 3 simple yet effective filters./p Tags: MySQLMariaDBreplication filtersfiltering [...]

MariaDB on openEuler-ARM stack - Multi-NUMA study (from MySQL On ARM)

MariaDB on the openEuler-ARM stack has shown promising results during the initial evaluation. (If you have missed that blog click here). Taking the assessment further we decided to evaluate the setup in a multi-numa environment since it represents enterprise deployment. The aim is to find out if things scale like other OS-ARM stacks and if the bottleneck continues to remain the same or if something [...]

Monday, 18. July 2022

OpenLampTech issue #35 – Substack Repost (from Digital Owl's Prose)

pDo you know what time it is? It’s time for your weekly media resource on all things MySQL, PHP, and LAMP stack! Like I always say, I hope you enjoy this issue of OpenLampTech as much as I did! Thank you for reading and please share the OpenLampTech publication with others! This week in OpenLampTech […]/p pThe post OpenLampTech issue #35 – Substack Repost appeared first on Digital [...]

Iris Data Set with MySQL HeatWave Machine Learning & Zeppelin (from MySQL expert Diary)

pDuring the last 20 years MySQL has democratized the usage of transactional Now with MySQL HeatWave we are in the process of democratizing Analytics and Machine Learning./p pWith MySQL HeatWave,br valorizing your data has never been so easy!/p pIn this article I will show you how easy it is to use the Machine Learning capabilities of MySQL HeatWave. We will use the famous Iris dataset [...]

Rivers vs Axis (from Percona Community Blog)

It’s hard to find at least two people who would format the same SQL query in the same way. Everyone has their own style and their own arguments. And everyone is absolutely sure that this is the only right way. That was to be expected, because of the declarative nature of SQL. In imperative program languages, we define and control the order of statements execution, and it affects how we format our c [...]

Friday, 15. July 2022

MySQL Router Restful API (from MySQLHK)

pMySQL Router with InnoDB Cluster allows transparent routing access for application to backend MySQL Servers.  /ppRestful API (Http access) feature was added to MySQL Router since 8.0.17./ppThis article is written to provide a tutorial with Router Restful API.   It is tested with MySQL 8.0.29 release./ppbr/pSetup& Assumptionsp1. MySQL InnoDB Cluster 8.0.29 - Cluster Name as 'mycluster [...]

Thursday, 14. July 2022

How do database indexes work? (from PlanetScale Blog)

Learn how database indexes work under the hood and how they can be used to speed up queriespRead the full story/p [...]

Exploring MySQL on Kubernetes with Minkube (from Percona Database Performance Blog)

♦In this blog post, I will show how to install the MySQL-compatible Percona XtraDB Cluster (PXC) Operator on Minikube as well as perform some basic actions.   I am by no means a Kubernetes expert and this blog post is the result of my explorations preparing for a local MySQL Meetup, so if you have […] [...]

Wednesday, 13. July 2022

Write Kafka integration test with Testcontainers (from Geeky Hacker - Coding, Tech & Linux)

pWriting a Spring Boot Kafka integration test can be frustrating even by leveraging the spring-kafka-test library that supplies an embedded Kafka. That’s mainly due to the complex test configuration that [...]/p pThe post Write Kafka integration test with Testcontainers appeared first on Geeky Hacker./p [...]

How Percona Monitoring and Management Helps You Find Out Why Your MySQL Server Is Stalling (from Percona Database Performance Blog)

♦In this blog, I will demonstrate how to use Percona Monitoring and Management (PMM) to find out the reason why the MySQL server is stalling. I will use only one typical situation for the MySQL server stall in this example, but the same dashboards, graphs, and principles will help you in all other cases. Nobody […] [...]

Tags and FullText indexes in MySQL (from Percona Database Performance Blog)

♦As a principal architect at Percona, one of my duties is to tune MySQL database servers for our customers. The tuning effort looks at every aspect of the database service like the operating system, the MySQL configuration, the schema, the queries, etc. We have well-defined processes to tune the operating system and the MySQL configuration. […] [...]

What is the LAMP stack? OpenLampTech Repost (from Digital Owl's Prose)

pBuilt on time-tested open-source software, the LAMP stack is a popular choice in modern Web Development. Continue reading this OpenLampTech publication report… What is the LAMP stack? The LAMP stack is a well-established combination of 4 pieces of software that form one of the most robust web application architecture stacks. LAMP is actually an acronym created […]/p pThe post What [...]

Tuesday, 12. July 2022

How to build MySQL 8.0 C API (libmysqlclient) (from lefred's blog)

If you write C applications that need to connect to MySQL, you can use the MySQL C API aka libmysqlclient. The MySQL C API replaces the outdated MySQL-Connector-C. If you want to use MySQL 8.0 as a Document Store with the X Protocol, you need then to use MySQL Connector/C++ 8.0. Some have asked how to compile only the MySQL C API. Compiling only libmysqlclient As the FAQ stipulates it, it’s not pos [...]

Getting started with the PlanetScale CLI (from PlanetScale Blog)

Learn how to quickly get up and running with the PlanetScale CLI.pRead the full story/p [...]

A mirror manager system to simplify the distribution of MariaDB binaries and packages (from MariaDB Foundation Blog)

pThe MariaDB Foundation relies on public mirrors to distribute binaries and packages to the world. An overview of the full list can be seen at … /p pContinue reading \"A mirror manager system to simplify the distribution of MariaDB binaries and packages\"/p pThe post A mirror manager system to simplify the distribution of MariaDB binaries and packages appeared first on Mar [...]

Migrating Mission-Critical MySQL / MariaDB to the Cloud (from Continuent Blog)

pMigrating to the cloud with zero downtime is a problem that companies running mission-critical applications have to solve, but not on their own. If you’re running a MySQL or MariaDB database it can be easy. Many of our customers have done this successfully, simplifying their overall Cloud migration process by making the database layer easy to move. It’s one less thing to worry about./p Tags:  [...]

Percona Monitoring and Management 2.29.0 Preview Release (from Percona Community Blog)

Percona Monitoring and Management 2.29.0 Preview Release Hello folks! Percona Monitoring and Management (PMM) 2.29.0 is now available as a Preview Release. We encourage you to try this PMM Preview Release in testing environments only, as these packages and images are not fully production-ready. The final version is expected to be released through the standard channels in the coming week. Release No [...]

Monday, 11. July 2022

Setting up a server on GCP (from Small Datum)

p This is mostly a note to myself to explain what I do to setup a server on GCP for database benchmarks./ppCreate the instance/pp/polliConfirm that quota limits have not been reached on the Quotas page./liliGo to the VM instances page and click on Create Instance/liliEdit the instance name/liliEdit the region (us-west1 for me)/liliChoose the instance type. Click on Compute Optimized, select th [...]

MariaDB Python Connector 1.1.3 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Python 1.1.3 release. Download Now Release Notes MariaDB Connector/Python … Continued [...]

Percona Operator for MySQL Supports Group Replication (from Percona Database Performance Blog)

♦There are two Operators at Percona to deploy MySQL on Kubernetes: one is based on Percona XtraDB Cluster (PXC), production-ready and widely adopted another is based on Percona Server for MySQL, now in tech preview and not recommended for production yet We wrote a blog post in the past explaining the thought process and reasoning […] [...]

OpenLampTech issue #34 – Substack Repost (from Digital Owl's Prose)

pThese OpenLampTech newsletter editions are some of my favorite to read and I know they are for you as well. We have another packed issue for you this week so enjoy those articles you like most and please share the publication with others… In OpenLampTech issue #34, we have curated content covering: WP-CLI Is Drupal […]/p pThe post OpenLampTech issue #34 – Substack Repost appeared [...]

Friday, 08. July 2022

Weekly Musings – July 8, 2022 (from Ronald Bradford Blog)

A very succinct description of the responsibilities of leadership by Jawad Nagda (infographic below) shows a number of key features of management that are also needed in data storytelling such as empathy, integrity, and listening. I wish annual 1:1 performance reviews gave employees an opportunity to rate their manager in such detail? It would be […] [...]

MySQL: Compression, Indexes, and Two Smoking Barrels (from Percona Database Performance Blog)

♦Hello folks, we all know the benefits of table compression in MySQL, with current technology, processing speed, and compression disks, and in most cases, it is a benefit. Now, what happens when that doesn’t happen? In this simple blog, I’m going to show you something interesting that happens when you try to transition from a […] [...]

Thursday, 07. July 2022

Consensus algorithms at scale: Part 8 - Closing thoughts (from PlanetScale Blog)

In the final installment of the consensus algorithm series, we pull everything together with some final thoughts.pRead the full story/p [...]

Wednesday, 06. July 2022

Deploy requests now alert on potential unwanted changes (from PlanetScale Blog)

We've updated our Deploy Request UI to alert when a schema change could produce unintended changespRead the full story/p [...]

tprovision - Your New Database Provisioning Tool (from Continuent Blog)

pIn this blog, we cover tprovision. tprovision is a complete rewrite of the provisioning tool “tungsten_provision_slave,” included with Tungsten Cluster. It is streamlined and allows easy provisioning of replica databases./p Tags: MySQLMariaDBtprovisiontungsten_provision_slavetps.plrestorecluster node backup [...]

Using Percona Server for MySQL with Amazon KMS as Keyring (from Percona Database Performance Blog)

♦Percona Server for MySQL 8.0.28-20 introduces a new keyring component, component_keyring_kms, which allows using the AWS Key Management Service as a keyring. The component is also included in Percona XtraBackup 8.0.28, allowing backing up databases encrypted with this component. The feature is similar to the AWS keyring plugin included in MySQL Enterprise, but it is […] [...]

Synopsis of Mydbops 15th edition of MyWebinar (from Mydbops Blog)

We’re ecstatic and energised about the prospect of sowing seeds of knowledge in our opensource database community. Thank you to everyone who joined us for the 15th edition of MyWebinar. We hope that our time together helped to elevate and seam your work to perfection. We’re committed to giving back to the opensource database community … Continue reading Synopsis of Mydbops 15th edition of [...]

Evaluating MariaDB on openEuler-ARM stack (from MySQL On ARM)

openEuler is an opensource linux based operating system with a customized scheduler, io, libraries, etc.. It is optimized for ARM64 architecture and so it could be interesting to evaluate different enterprise software running on the openEuler-ARM stack. As part of this study, let’s explore how MariaDB that already has packages on ARM for different operating systems performs on openEuler. [...]

Tuesday, 05. July 2022

Announcing MariaDB Connector/Python 1.1 GA (from MariaDB Corporation Blog)

We are pleased to announce MariaDB Connector/Python 1.1 as GA (Generally Available). MariaDB Connector/Python, compliant with the Python DB API … Continued [...]

Announcing the PlanetScale and Hashnode July Hackathon (from PlanetScale Blog)

Build an open-source project and compete for $20,000 in prizes and swag! pRead the full story/p [...]

Introducing Buffered Error Logging in Percona Server for MySQL (from Percona Database Performance Blog)

♦The MySQL error log is usually used to store and later analyze error and warning messages, but in some cases, it is also used for high throughput debug messages for analyzing complex issues. These messages take up more space, slow down the server, and also make the error log harder to use for other issues. […] [...]

Interactively explore & visualize your MySQL HeatWave data with Apache Zeppelin (from MySQL expert Diary)

pIn this article I will show you how to properly configure Apache Zeppelin in order to take advantage of the Analytics and Machine Learning capabilities of MySQL HeatWave the MySQL in-memory query accelerator./p The post Interactively explore & visualize your MySQL HeatWave data with Apache Zeppelin first appeared on - Diary of a MySQL experts. [...]

Monday, 04. July 2022

Insert Benchmark for Postgres 12, 13, 14 and 15 (from Small Datum)

pI ran the Insert Benchmark for Postgres versions 12.11, 13.7, 14.3 and 15b1. Reports are provided for cached and IO-bound workloads. The benchmark is run on Intel NUC servers at low concurrency. The goal is to determine how performance changes over time. A description of the Insert Benchmark is here./pptl;dr/pp/pulliI am not a Postgres expert/liliregressions are small in most cases/ [...]

An intra-pandemic Staff Meeting (from MariaDB Foundation Blog)

pWell over two years ago was the last time the MariaDB Foundation staff had met. That was at FOSDEM, in February 2020. Thus, no big surprise, one of our topmost goals for 2022 was to have a staff meeting, face to face. … /p pContinue reading \"An intra-pandemic Staff Meeting\"/p pThe post An intra-pandemic Staff Meeting appeared first on [...]

OpenLampTech issue #33 – Substack Repost (from Digital Owl's Prose)

pThe publication is growing and we are sharing the good stuff in this OpenLampTech newsletter issue. Developer interviews, a curated WordPress resource, and the LAMP stack coverage you expect are all coming at ya in issue #33… In OpenLampTech issue #33, we have great content covering: Symfony components Is SQL Programming? WordPress FSE vs dynamic […]/p pThe post OpenLampTech issue #33 [...]

What Is a Database? (from Devart MySQL Tool Blog)

pThe article provides a general overview of the databases in simple terms, discusses their advantages and drawbacks, and covers the types of data to be used in databases to better understand and more effectively organize your databases. Contents What is data Definition of a database Components of a database Types of databases Architecture of a […]/p pThe post What Is a Database? appeared firs [...]

Sunday, 03. July 2022

5 common error messages: reasons and resolutions (from Geeky Hacker - Coding, Tech & Linux)

pThough we are constantly glued to our computers all day round, handling several errors is challenging. You might have been using your laptop for years, but there are issues that [...]/p pThe post 5 common error messages: reasons and resolutions appeared first on Geeky Hacker./p [...]

Friday, 01. July 2022

Consensus algorithms at scale: Part 7 - Propagating requests (from PlanetScale Blog)

In part 7 of the Consensus algorithm series, we combine everything we've worked at to cover propagating requests pRead the full story/p [...]

I have met the enemy, and they are us (from Die wunderbare Welt von Isotopp)

pAnother Friday, another replication hierarchy lost./p The error from June, July edition? pThe errors reported look awfully familiar: Binlog position is supposedly 4, and the error message has text about “max_allowed_packet”. Could it be another instance of this bug from early last month?/p pIndeed, one symptom was “a large binlog, larger than max_binlog_size” [...]

Thursday, 30. June 2022

The MySQL Track at the Southern California Linux Expo 2022 (from PHP With MySQL)

p Yes, SCaLE, or the Southern California Linux Expo is back. Friday is the MySQL track with eight presentations. A big thanks to all the presenters and we hope to see you at the LAX Hilton July 29th!/ppbr/ppMySQL 8.0 New Features/pp/pulliDave Stokes/liliAudience:Everyone/liliTopic:MySQL/liliMySQL now features quarterly releases that come with new features.  So if you do not know about has [...]

Digital Signatures: Another Layer of Data Protection in Percona Server for MySQL (from Percona Database Performance Blog)

♦Imagine you need to design an online system for storing documents on a per-user basis where nobody, including database administrators, would be able to change the content of those documents without being noticed by document owners. In Percona Server for MySQL 8.0.28-20, we added a new component called Encryption UDFs – an open-source alternative to […] [...]

Advanced Tungsten Troubleshooting Using Log Files (from Continuent Blog)

pTungsten Clustering is a powerful tool with many moving parts, including the Tungsten Connectors which may be installed on any application server. During a troubleshooting event, it is helpful to understand what to look for and where, in addition to understanding how the logs work together to provide a clear picture of the situation. In Tungsten version 7, we introduced a number of features design [...]

Wednesday, 29. June 2022

Identifying slow Rails queries with sqlcommenter (from PlanetScale Blog)

Learn how to use sqlcommenter with RailspRead the full story/p [...]

MariaDB Java Connectors 3.0.6 and 2.7.6 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.0.6 and 2.7.6 GA releases. Download Now Release … Continued [...]

Percona Live 2022: A retrospective (from Galera Blog)

We descended to Austin, Texas, to have a booth, and several talks and tutorials by Seppo Jaakola and Colin Charles, at Percona Live Austin 2022 (what a gap since the last in-person event we had was in 2019!). Present was also GUI developer of Galera Manager, Mihael Lenic and sales extraordinaire, Larissa Urse. Rather than […] [...]

MySQL SELECT and WHERE Clause Column Existence (from Digital Owl's Prose)

pI’m sharing another tip for anyone who wants to learn more about MySQL and how to use it. This post covers an example of the differences in columns specified in the WHERE clause but not the SELECT clause and vice-versa. Columns named in the WHERE clause but not the SELECT clause Any column used as […]/p pThe post MySQL SELECT and WHERE Clause Column Existence appeared first on Digital [...]

MySQL InnoDB Redo Log Archiving (from lefred's blog)

When performing physical backup on system that are heavily used, it can happen that the backup speed cannot keep up with the redo log generation. This can happen when the backup storage is slower than the redo log storage media and this can lead in inconsistency in the generated backup. MySQL Enterprise Backup (aka MEB) and probably Percona Xtrabackup, benefit from the possibility to sequentially w [...]

Tuesday, 28. June 2022

Announcing Vitess 14 (from PlanetScale Blog)

Learn about what was just released in Vitess 14pRead the full story/p [...]

Zero Downtime: Upgrading MySQL Server in a Tungsten Cluster (from Continuent Blog)

pTungsten Clustering allows for many types of maintenance to happen with no downtime at all. This blog post will explore how to upgrade the actual MySQL Server on all cluster nodes with zero downtime./p Tags: MySQLMariaDBzero downtimezero downtime maintenance updatesHigh Availability [...]

Releasing ProxySQL v2.4.2! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.4.2 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL [...]/p pThe post Releasing ProxySQL v2.4.2! appeared first on ProxySQL./p [...]

Announcing Vitess 14 (from Vitess)

We are pleased to announce the general availability of Vitess 14. Major Themes # In this new release, major improvements have been made in several areas of Vitess, including usability and reliability. Online DDL is now GA. Gen4 planner is the new default planner. VTAdmin and VTOrc are officially in beta with Vitess 14. Usability # Command-Line Syntax Deprecation # This release marks the beginning o [...]

Monday, 27. June 2022

Announcing MariaDB Connector/R2DBC 1.1 (from MariaDB Corporation Blog)

We are pleased to announce MariaDB Connector/R2DBC 1.1 as GA (Generally Available). MariaDB Connector/R2DBC 1.1 now implements the R2DBC 0.9.1 … Continued [...]

OpenLampTech issue #32 – Substack Repost (from Digital Owl's Prose)

pThere is a whole lot of great PHP, MySQL, and LAMP-stack content in this week’s OpenLampTech newsletter. But, would you expect any less? Me neither. Enjoy this edition and share with others. Thank you for being a dedicated reader! There is most definitely something for everyone in OpenLampTech issue #32. This week, we are looking […]/p pThe post OpenLampTech issue #32 – Substack [...]

Sunday, 26. June 2022

MySQL Query from JSON (from MacLochlainns Weblog)

One of my students asked how you could get JSON data out in tabular format. I said they should look at Øystein Grøvlen’s JSON_TABLE – Best of Both Worlds blog post from 2018. Unfortunately, the student wanted another example with the Video Store model that we use in class. For clarity, all path definitions start […] [...]

Friday, 24. June 2022

Fixing mmap performance for RocksDB (from Small Datum)

pRocksDB inherited support for mmap from LevelDB. Performance was worse than expected because filesystem readahead fetched more data than needed as I explained in a previous post. I am not a fan of the standard workaround which is to tune kernel settings to reduce readahead because that has an impact for everything running on that server. The DBMS knows more about the IO patterns and can use madvis [...]

Grouping and aggregations on Vitess (from PlanetScale Blog)

Vitess is a database proxy that creates an illusion of a single database, when in reality the query is sent to multiple MySQL instances. pRead the full story/p [...]

Percona Monthly Bug Report: June 2022 (from Percona Database Performance Blog)

♦Here 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 […] [...]

MySQL Backslashes (from MacLochlainns Weblog)

Yesterday, I wrote a blog post that showed you how to write a query returning a JSON structure for a 1:many relationship. The relationship was between the member and contact table. It returns one account_number from the member table and a list of first_name and last_name columns from the contact table in a JSON structure. […] [...]

Database as Code. Not only migrations (from Percona Community Blog)

We are used to the Everything as Code things and we love it. But how about Database as Code? If you have just dropped your DB migrations scripts to your pipeline, then it’s great, but that’s where “Database as Code” is just getting started. In this post, I will share my view on “Database as Code” mantra. Everything as Code And we will start with “Everything as Code” things. “Every [...]

Thursday, 23. June 2022

MariaDB 10.10 preview releases now available (from MariaDB Foundation Blog)

pWe are pleased to announce the fourth MariaDB series release under the new release model, MariaDB Maturing MariaDB more quickly br One of the purposes of the new model is to get features into the hands of users more quickly, in a form which supports stability by allowing the new feature to be more easily tested, separate from other new features being developed at the same time. … [...]