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.

Tuesday, 24. May 2022

Faster Logical Backup/Restore using pgcopydb – PostgreSQL (from Mydbops Blog)

No doubt, pg_dump/pg_restore is an amazing tool to perform logical backup and restorations in PostgreSQL. We have already explained in detail about pg_dump/pg_restore here. The tool pgcopydb is an Open Source tool that automates executing pg_dump and pg_restore between two PostgreSQL servers. It is a wrapper over pg_dump and pg_restore to simplify the process with … Continue reading Faster Lo [...]

Introducing PlanetScale Portals: Read-only regions (from PlanetScale Blog)

Put your data where your users and applications are.pRead the full story/p [...]

Store and Manage Logs of Percona Operator Pods with PMM and Grafana Loki (from Percona Database Performance Blog)

♦While it is convenient to view the log of MySQL or MongoDB pods with [crayon-628dac4d2041c427059493-i/], sometimes the log is purged when the pod is deleted, which makes searching historical logs a bit difficult. Grafana Loki, an aggregation logging tool from Grafana, can be installed in the existing Kubernetes environment to help store historical logs and […] [...]

Securing Your Cluster: View Your Security Stance Using tpm report (from Continuent Blog)

pIn this post we will explore a new command in v7.0.1, codetpm report/code. The purpose of codetpm report/code is to provide easy access to all of the settings that pertain to a specific topic. Since Security is a high priority at Continuent, the current default (and only) topic is the Security stance. The codetpm report/code command will evolve and grow over time. This first version is Continuent’ [...]

China Has Great Potential for MariaDB Server (from MariaDB Foundation Blog)

pOur Board Meeting in April 2022 elected two seasoned new voting board members. One of them is Xiang Peng (Sean), Director, RDS Open Source Databases at Alibaba Cloud. … /p pContinue reading \"China Has Great Potential for MariaDB Server\"/p pThe post China Has Great Potential for MariaDB Server appeared first on MariaDB.org./p [...]

Monday, 23. May 2022

Why we wrote the PlanetScale “Future Database” principles (from PlanetScale Blog)

We believe databases are lagging behind DevOps innovation and we wrote these principles to illustrate the path forward. pRead the full story/p [...]

Cyber Protection – best practices for backing up data (from MariaDB Foundation Blog)

pA few weeks ago we hosted a webinar together with Acronis and CPanel on security and backup best practices as both provide software in this space. … /p pContinue reading \"Cyber Protection – best practices for backing up data\"/p pThe post Cyber Protection – best practices for backing up data appeared first on MariaDB.org./p [...]

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

pWelcome back to this week’s OpenLampTech newsletter issue. In addition to the great PHP/MySQL content, I’ve edited one of the sections so there is a new feel to the publication. Enjoy reading the content! In OpenLampTech issue #27, you will find coverage on: PHP nonces WordPress backup plugin comparison MySQL deadlocks A free MySQL eBook […]/p pThe post OpenLampTech issue #27  [...]

Sunday, 22. May 2022

Exploring Aurora Serverless V2 for MySQL (from Mydbops Blog)

Aurora Serverless V2 is generally available around the corner recently 21-04-22 for MySQL 8 and PostgreSQL, with promising features that overcome the V1 disadvantages. Below are those major features Features Online auto instance upsize (vertical scaling) Read scaling (Supports up to 15 Read-replica) Supports mixed-configuration cluster ie, the master can be normal Aurora(provisioned) and readers &# [...]

MySQL – Fixing: Got fatal error 1236 from master when reading data from binary log: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; (from Shattered Silicon Open Source Database Blog)

pIf you spend all day every day looking after hundreds of MySQL servers, the chances are that you have encountered this problem. And the chances are that if your servers are configured properly (i.e. you have the same configuration the master and the slaves), the error is almost certainly spurious and doesn’t mean what it […]/p pThe post MySQL – Fixing: Got fatal error 1236 from m [...]

Saturday, 21. May 2022

MariaDB 10.9.1, 10.8.3, 10.7.4, 10.6.8, 10.5.16, 10.4.25, 10.3.35 and 10.2.44 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.9.1, the first Release Candidate (RC) in the MariaDB 10.9 series, MariaDB 10.8.3, the first Generally Available (GA) release in the MariaDB 10.8 series, MariaDB 10.7.4, the second Generally Available release in the MariaDB 10.7 series (all maintained for one year from their first GA release dates), as well as MariaDB 10.6 [...]

Friday, 20. May 2022

I Don't Want to Shard (MySQL) (from Hack MySQL)

pChapter 5 of Efficient MySQL Performance addresses sharding, and it was difficult to write but not for technical reasons. Let me say a little more on the matter./p [...]

Weekly Musings – May 20, 2022 (from Ronald Bradford Blog)

The Linux Foundation came across my reading path two separate times this week. As I continue to re-establish my larger footprint solely in the open-source ecosystem Setting an Open Source Strategy is a detailed report for any business to identify the potential return on investment (ROI) of participating in the open-source ecosystem. Every company uses […] [...]

Announcing MariaDB Community Server 10.8 GA and 10.9 RC (from MariaDB Corporation Blog)

We are pleased to announce MariaDB Community Server 10.8 as GA (Generally Available) and the first RC (Release Candidate) of … Continued [...]

MariaDB Q2 2022 maintenance releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Server 10.7.4, 10.6.8, 10.5.16, 10.4.25, 10.3.35, and 10.2.44 maintenance releases. … Continued [...]

MySQL authentication_oci plugin for Oracle Cloud (from Select All From MySQL)

Getting started with authentication_oci There is a new means of connecting seamlessly to a MySQL Database Service instance in the Oracle Cloud Infrastructure. It is a method that does not require passwords, and can utilize the public key found in a OCI user’s account profile, without anyone needing to access that profile directly . It derives its access… Read More » [...]

Thursday, 19. May 2022

FromDual Performance Monitor for MariaDB 2.0.0 has been released (from Shinguz's Blog)

pFromDual has the pleasure to announce the release of the new version 2.0.0 of its popular Database Performance Monitor for MariaDB and Galera Cluster codefpmmm/code./p pThe FromDual Performance Monitor for MariaDB (codefpmmm/code) enables DBAs and System Administrators to monitor and understand what is going on inside their MariaDB database instances and on the machines where the databases reside [...]

Wednesday, 18. May 2022

Now Available: Tungsten v6.1.17 Release (from Continuent Blog)

pWe are pleased to announce that Tungsten Clustering and Tungsten Replicator GA version 6.1.17 are now available. Tungsten allows enterprises running business-critical MySQL database applications to cost-effectively achieve continuous global operations with commercial-grade high availability (HA), geographically redundant disaster recovery (DR) and geographically distributed active/active./p Tags:& [...]

Determine All Calendar Days in a Month with MySQL (from Digital Owl's Prose)

pWatch this quick in-depth video short and learn how to find all the calendar days for a specific month using built-in MySQL date functions and recursive Common Table Expressions (CTEs). This is a repost of a free article over on my Kofi page as part of the “MySQL Learning Tier” membership… I wrote the article, […]/p pThe post Determine All Calendar Days in a Month with MySQ [...]

Tuesday, 17. May 2022

Dissecting the architecture of Google AlloyDB, Amazon Aurora, and MariaDB Xpand (from MariaDB Corporation Blog)

Welcome AlloyDB Recently, Google announced their AlloyDB database-as-a-service (DBaaS) product, whose design looks strikingly similar to that of AWS Aurora … Continued [...]

Monday, 16. May 2022

Codership releases Galera Cluster Enterprise Edition (from Galera Blog)

The Galera Cluster Enterprise Edition Codership is pleased to announce the Galera Cluster Enterprise Edition. Galera Cluster Enterprise Edition consists of an enhanced Galera Cluster server, Galera Manager and Galera Load Balancer.   The enhanced Galera Cluster Server includes 1) A new Online Schema Upgrade method called Non Blocking Operations (NBO), adds more high availability to your cluste [...]

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

pYour one-stop source for excellent PHP/MySQL technical content is here again this week for your reading pleasure. Enjoy this selection of articles I read and learned something from this week. Thank you for being here! OpenLampTech issue #26 has great articles covering: PHP Laravel try/catch WordPress block patterns How to backup and restore a MySQL […]/p pThe post OpenLampTech issue #26 R [...]

Friday, 13. May 2022

Xpanding Your Data Possibilities With MariaDB and Google Cloud (from MariaDB Corporation Blog)

As your user expectations grow, complexity becomes inherent that may limit your ability to act on data to innovate and … Continued [...]

MariaDB MaxScale Load Balancer with Master/Master Replication (from Shinguz's Blog)

pFor this how-to we were working with a MariaDB 10.6.5 database server and the newest MariaDB MaxScale 6.3.0 (aka 2.6) load balancer/proxy./p pAs a starting point we had a working MariaDB Master/Master replication with one active Master (Ma) and one passive Master (Mp). Whereas the passive Master was set to coderead_only/code. As a replication user we used the user codereplication/code./p Creati [...]

Weekly musings – May 13 2022 (from Ronald Bradford Blog)

As I reflect on this week of my technology journey with the conversations I had, what I learned, and what I wanted to do and write about, I decided what better way to work on multiple blog posts than write about what I’d like to write about. The 2022 observability conference o11yfest.org/ is a wrap. […] [...]

MySQL Windows DSN (from MacLochlainns Weblog)

Almost a Ripley’s Believe It or Not. An prior data science student told me that his new IT department setup a Windows component that let him connect his Excel Spreadsheets to their production MySQL database without a password. Intrigued, I asked if it was a MySQL Connector/ODBC Data Source Configuration, or DSN (Data Source Name)? […] [...]

Thursday, 12. May 2022

Streaming backup with MariaDB Backup (from Shinguz's Blog)

pBecause the original MariaDB documentation is a little bit sparse about this topic here are some notes about how to do a streaming MariaDB backup:/p pre # mariadb-backup --user=root --backup --parallel=4 --stream=mbstream | ssh root@target_machine "/usr/bin/mbstream -x -C /var/lib/mysql/" # mariadb-backup --user=root --prepare --target-dir=/var/lib/mysql /prebr [...]

A graph a day, keeps the doctor away ! – MySQL Checkpoint Age (from lefred's blog)

In a previous post, I explained how you can collect and plot metrics using MySQL Shell. This is a new series of article where I will explain how to read and understand some of the generated graphs. Understanding your workload and seeing the evolution of it over time can help anticipating problems and work on solutions before the breakdown. Let’s start the series with a concept that is not always we [...]

Take Your Applications Further with An Embedded Database-as-a-Service (from MariaDB Corporation Blog)

As the volume, velocity and variety of data grows exponentially each year, the challenge for application developers is a thorny … Continued [...]

MariaDB Performance Tuning and MySQL Performance Tuning (from Shattered Silicon Open Source Database Blog)

pA summary of basics of MariaDB and MySQL performance tuning, along with a few more advanced hints and tips. Beyond these, further tuning becomes very workload specific./p pThe post MariaDB Performance Tuning and MySQL Performance Tuning appeared first on Shattered Silicon./p [...]

Wednesday, 11. May 2022

Releasing ProxySQL v2.4.0! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.4.0 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.0! appeared first on ProxySQL./p [...]

Performance bugs: p50 vs p99 (from Small Datum)

pOne way to classify performance bugs is p50 vs p99. /pp/pulliA p50 performance bug occurs for all workloads/liliA p99 performance bug only happens for some workloads or in some contexts. By some workloads I mean it might only occur during hot backup or load. By some contexts I mean it might only happen under high concurrency or load spikes which don't represent the steady state./li/ulThe impa [...]

Multiple WHERE Clause Conditionals Using the MySQL AND Logical Operator (from Digital Owl's Prose)

pOftentimes, you need multiple filter conditionals in a WHERE clause in order to target specific rows of data. Continue reading this blog post and learn how to use the AND logical operator in WHERE clause queries… Practice Data For the practice queries in this post, I’m using the ‘category’ table from the well-known Sakila database: […]/p pThe post Multiple WHERE Claus [...]

MySQL Scalability: Sharding and Pod Architecture (from Continuent Blog)

pScalability is necessary to keep your database from crumbling under increased traffic. A scalable database must be able to handle larger data sets and more queries per second (both read and write), and the architecture must support these higher workloads seamlessly and efficiently. This blog attempts to explain what sharding is versus the pod architecture that some of our customers employ./p Tags: [...]

Placement of NULL values for ORDER BY with nullable columns (from SQL for Devs)

NULL values are most probably not placed where you want them to be when ordering data. But for good UX you will have to manage the sort order for missing data. With the NULLS FIRST and NULLS LAST option can the order placement for NULL values be changed. [...]

Tuesday, 10. May 2022

RocksDB internals: LRU (from Small Datum)

pRocksDB uses LRU to manage the size of the block cache. The LRU can suffer from mutex contention so I describe the implementation in detail here./ppAn interesting question is whether clock is a better choice than LRU assuming it suffers less from mutex contention. Until that is answered I hope to determine how much improvement can be made by changing the code to not move a block to the head of the [...]

Using mmap with RocksDB (from Small Datum)

pRocksDB inherited support for mmap from LevelDB. I was curious how performance with mmap compared buffered IO (pread) and ran benchmarks with db_bench. I haven't had great experiences with mmap for database workloads in the past but tried to be fair./pptl;dr/pp/pulliDon't use mmap for IO-bound workloads until issue 9931 is fixed/liliFor in-memory databases performance with mmap can be better than [...]

RocksDB internals: the series (from Small Datum)

pThis is a series of posts based on reading RocksDB source to figure out how things are implemented./pp/pullibytes pending compaction/liliintra-L0 compaction/lilicompaction stall counters/liliwrite rate limiter/liliprefetch and/or readahead/lilitrivial move and benchmark results/liliBlock cache/li/ulp/p [...]

Spring Cleaning: Discontinuing RHEL 6/CentOS 6 (glibc 2.12) and 32-bit Binary Builds of Percona Software (from Percona Database Performance Blog)

♦As you are probably aware, Red Hat Enterprise Linux 6 (RHEL 6 or EL 6 in short) officially reached “End of Life” (EOL) on 2020-11-30 and is now in the so-called Extended Life Phase, which basically means that Red Hat will no longer provide bug fixes or security fixes. Even though EL 6 and its […] [...]

Monday, 09. May 2022

The operational relational schema paradigm (from PlanetScale Blog)

An exploration of the current landscape of schema change methodology and what the future should look like.pRead the full story/p [...]

Creating Cloud-based Customer-Facing Apps with MariaDB, Upsolver and AWS (from MariaDB Corporation Blog)

Data is the nucleus of everything companies build, monetize and deploy on the cloud. On the cloud data gains scale, agility … Continued [...]

MySQL 8.0.29 and Percona XtraBackup Incompatibilities (from Percona Database Performance Blog)

♦Earlier last week, Oracle released their Q2 releases series. Unlike previous releases, backward compatibility has now been broken with previous versions of MySQL. MySQL 8.0.29 extended the support for the online DDL algorithm INSTANT. Prior to 8.0.29 only adding columns to the end of the table was supported. In 8.0.29, this functionality was extended to […] [...]

MyDumper 0.12.3-1 is Now Available (from Percona Database Performance Blog)

♦The new MyDumper 0.12.3-1 version, which includes many new features and bug fixes, is now available.  You can download the code from here. MyDumper is Open Source and maintained by the community, it is not a Percona, MariaDB, or MySQL product. In this new version we focused on: Refactoring tasks: Splitting mydumper.c and myloader.c into […] [...]

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

pYou know what time it is, right? Yep, it is time for OpenLampTech issue #25. There are several great reads in this week’s newsletter for PHP/MySQL developers. Enjoy them at your leisure and share the publication with other’s who will like the content as well… Ready for some PHP/MySQL content. Here you are! In OpenLampTech […]/p pThe post OpenLampTech issue #25 – Subst [...]

Saturday, 07. May 2022

Fedora for macOS ARM64 (from MacLochlainns Weblog)

I’m always updating VMs, and I was gratified to notice that there’s a Fedora arm64 ISO. If you’re interested in it, you can download the Live Workstation from here or the Fedora Server from here. Unfortunately, I only have macOS running on i7 and i9 Intel Processors. It would be great to hear back how […] [...]

Friday, 06. May 2022

Get Some Rest With the Tungsten API, Part 2 (from Continuent Blog)

pIn our last blog post on this topic we covered the basics of the new REST  API available with Tungsten version 7.0.0. In this post, Part 2, we explore the REST API in more detail, including payloads and advanced functionality. The API provides a vast pool of capabilities, and here we barely scratch the surface of what can be accomplished./p Tags: tungsten rest apitungsten version 7.0+payloads [...]

Thursday, 05. May 2022

To compress or not compress (from Small Datum)

pWhat are the benefits and costs from compressing the smaller levels of an LSM tree? You won't save much space from compressing them unless the LSM tree doesn't have data beyond L2. I usually suggest no compression for levels 0, 1 and 2. Here I share results from a benchmark to show the impact from using compression for those levels./pptl;dr - if levels 0, 1 and 2 are compressed:/pp/pulliBenefits/l [...]

Feature storytelling with Framer Motion (from PlanetScale Blog)

Learn how we used Framer Motion to create Rewind’s narrative animation.pRead the full story/p [...]

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

Percona Monitoring and Management 2.28.0 Preview Release Hello folks! Percona Monitoring and Management (PMM) 2.28.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 [...]

Wednesday, 04. May 2022

PostgreSQL \d commands versus MySQL's SHOW commands (from PHP With MySQL)

pOne type of databases is pretty much the same as any other type of database base, right? /ppWell, at one high abstract level that may be true.  But at the level where you have to use the database then things can be radically different.  /ppFor the past several years I have mainly bee focusing on MySQL but my new job is letting me explore PostgreSQL.  I have used PostgreSQL [...]

MySQL GROUP BY WITH ROLLUP – Substack Repost (from Digital Owl's Prose)

pI recently took some time to explore the MySQL GROUP BY WITH ROLLUP modifier. As a self-starter, I’m always unknowingly studying SQL concepts that I soon need for a query requirement. Call it luck or premonition, doesn’t matter to me. I’ll take these small wins thanks to my curiosity… I went for a deep dive […]/p pThe post MySQL GROUP BY WITH ROLLUP – Substack R [...]

Changing the sorting direction for multi-column mixed-ordering indexes for increased performance. (from SQL for Devs)

Any developer will create many indexes for a database to speed-up queries, but very seldom the column order direction within the index is considered. For a single-column index the ordering will not make any difference as the index can be scanned by the database forwards and backwards. But for multi-column indexes, matching ordering of the index and the query is cruci [...]

Tuesday, 03. May 2022

What's New in MariaDB 10.6 (from SeveralNines Open Source Database Blog)

pAs of January 2022, ClusterControl v1.9.2 introduced support for the latest version of MariaDB — version 10.6. MariaDB 10.6, released in July 2021, will be supported for the next four years or precisely until July 2026./p pIn this post, we will highlight the top features of MariaDB 10.6./p Atomic DDL (Data Definition Language) pThe first feature we will cover is Atomic DDL. By definition, “atom [...]

The MySQL Workshop Book Review (from Percona Community Blog)

Good books on MySQL for beginners are rare and excellent ones are even rarer. I often get requests from novices starting with MySQL or intermediates looking to level up on recommendations on books targeted at their level. The MySQL Workshop (Amazon link) by Thomas Pettit and Scott Cosentino is a must buy for those two groups, or those of us who would like a handy reference. This is a great book and [...]

Monday, 02. May 2022

Why Migrate Your PostgreSQL, MySQL or SQL Server to Google Cloud SQL? (from Pythian Blog - MySQL Track)

Whether you’re using a PostgreSQL, MySQL or SQL Server relational database, a migration to Google Cloud SQL can take it up a notch—automating management tasks, ensuring business continuity and staying up-to-date with security and compliance requirements. And, with a solution... [...]

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

pWow! This is the 6-month issue of the OpenLampTech newsletter. I’ve learned so much during this time in creating the newsletter for PHP/MySQL developers. Here’s to many more months of publishing! Enjoy this week’s articles! I hope you are in your comfy place and ready for a great read because this week’s OpenLampTech issue is […]/p pThe post OpenLampTech issue #24  [...]

Sunday, 01. May 2022

MySQL 8.0.29: thank you for the contributions (from lefred's blog)

When it’s time for a new MySQL release, it’s also time to thank our contributors ! Released on April 26th, MySQL 8.0.29 contains several contributions from our awesome Community and on behalf of the entire MySQL Team, I would like to thank you all ! This new releases contains patches from Vilnis Termanis, Luke Weber, Meik Milevczik, Song Zhibai, Zheng Lai, Øystein Grøvlen, Facebook, Biran Yue, Hope [...]

AWS MySQL Security on RDS: Database Level (from Mydbops Blog)

In the previous blog, we have gone through about network-level security in RDS. In this blog, we will see about the Database level security in RDS. After network-level restriction to host, we can’t allow a user to connect to the database from anywhere over the internet. We need to restrict user access at the Database … Continue reading AWS MySQL Security on RDS: Database Level U [...]

Saturday, 30. April 2022

MySQL RegExp Default (from MacLochlainns Weblog)

We had an interesting set of questions regarding the REGEXP comparison operator in MySQL today in both sections of Database Design and Development. They wanted to know the default behavior. For example, we built a little movie table so that we didn’t change their default sakila example database. The movie table was like this: CREATE […] [...]

Friday, 29. April 2022

Celebrating Olivier Bertrand of the CONNECT Engine (from MariaDB Foundation Blog)

pPlease join MariaDB Foundation in giving a bit of financial recognition to Olivier Bertrand, the developer behind the CONNECT Storage Engine! We will match your contribution up to a total of 5.000 €, on top of the 5.000 € … /p pContinue reading \"Celebrating Olivier Bertrand of the CONNECT Engine\"/p pThe post Celebrating Olivier Bertrand of the CONNECT Engine appeared first on M [...]

MariaDB Server Documentation as PDF (from MariaDB Foundation Blog)

pMariaDB Server Documentation is now released as a single PDF file, browsable offline. Download the over 3000 pages and check it out!br Better late than neverbr Some things take long! … /p pContinue reading \"MariaDB Server Documentation as PDF\"/p pThe post MariaDB Server Documentation as PDF appeared first on MariaDB.org./p [...]

Thursday, 28. April 2022

clang vs crc32c in RocksDB (from Small Datum)

pBy default RocksDB uses crc32c as a block checksum. The source is here and a benchmark is here (db_bench --benchmarks=crc32c). By default RocksDB is compiled with gcc on Linux but it is easy to switch to clang. I did that switch to compare benchmark performance between gcc and clang builds and the initial results were interesting./ppThe overhead for crc32c is apparent for benchmarks that do a lot [...]

Consensus algorithms at scale: Part 5 - Handling races (from PlanetScale Blog)

In part 5 of our consensus algorithms series, we discuss how we handle race conditions and forward progress requirements.pRead the full story/p [...]

Follow-up on an Unprivileged User can Crash your MySQL Server (from J-F Gagné's MySQL Blog)

A year ago, I blogged about An Unprivileged User can Crash your MySQL Server.  At the time, I presented how to protect yourself against this problem without explaining how to generate a crash.  In this post, I am revisiting this vulnerability, not giving the exploit yet, but presenting the fix.  Also, because the default configuration of Group Replication in 5.7 is still vulnerable (it is not in [...]

Wednesday, 27. April 2022

Poorman’s MySQL monitoring/trending (from lefred's blog)

I could have also called this article When Pandas meet Dolphins in MySQL Shell. Some time ago, I wrote a post related on how to collect initial relevant data when trying to seek help for MySQL. Since then, the MySQL Shell engineering team implemented another powerful native utility that collect all the essential information and more and store them in a single zip file. This zip archive contains TSV [...]

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

♦Oracle released MySQL Server 8.0.29 on April 26th and this is a quick review of the release notes.  I have put my own comments in italics. So what is in the ’29 release of MySQL Server?  Does it come festooned with new, neat features or is it a big bug-fix bonanza? The TL;DR While this […] [...]

MySQL MODIFY, CHANGE, RENAME – Kofi Blog Repost (from Digital Owl's Prose)

pI’ve been publishing paywall content over on my Kofi Page for the “MySQL Learning Tier” membership mostly in video format. Here is a free post for anyone interested in the type of content you can expect within the membership… MODIFY, CHANGE, and RENAME COLUMN – MySQL ALTER TABLE Clauses Learn the key differences, similarities, and […]/p pThe post MySQL MODIFY, C [...]

Monday, 25. April 2022

Use JSON schema validation for NoSQL-like jsonb columns with complete schema safety. (from SQL for Devs)

Extending a traditional database schema with NoSQL JSON columns can make the schema more understandable. When making use of it, the database will guarantee that all JSON data stored in a column is valid JSON. But you can also ensure each JSON document conforms to the application's expected domain model. [...]

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

pReady for your weekly dose of PHP/MySQL content? Well, you’re in luck because this issue of OpenLampTech has just what you need! In this week’s OpenLampTech issue #23, we are looking at articles on: WordPress WP_Query MySQL Deferred Joins Modern PHP MySQL data change capture Custom WordPress taxonomies And, a whole lot more…/p pThe post OpenLampTech issue #23 – Substack Rep [...]

Liquibase Data is Git for Databases (from Percona Community Blog)

Author’s Note: Robert will be demoing Liquibase Data at Percona Live 2022 on Wednesday, May 18 at 11:50am. Add this presentation to your schedule. Git is an amazing tool for collaboration — developers can work together to build better software faster. However, the usual Git workflow neglects the database. With Liquibase Data we’re bringing git to the database so you can easily version contain [...]

Saturday, 23. April 2022

Variable sized disk rows in RonDB (from Mikael Ronstrom)

p RonDB was a pure in-memory database engine in its origin. The main reason for this was to support low latency applications in the telecom business. However already in 2005 we presented a design at VLDB in Trondheim for the introduction of columns stored on disk. These columns cannot be indexed, but is very suitable for columns with large sizes./ppRonDB is currently targeting Feature Store ap [...]

Friday, 22. April 2022

PostgreSQL Sessions at Percona Live (from PHP With MySQL)

p I hope to see you next month in Austin at Percona Live.  The schedule lists two rooms of PG talks./ppbr/ppRoom 1/pTuesday, May 17 10:30am CDTManaging PostgreSQL With Ansiblebr11:30am CDTSimplifying the Top Complexities While Migrating From Oracle to PostgreSQLbr1:30pm CDTPostgreSQL Replication Conflicts: Avoiding Pitfallsbr2:30pm CDTThe Top 10 Mistakes When Migrating Oracle Databas [...]

Percona Live 2022 Tutorials (from PHP With MySQL)

p /ppLooking to get smarter? Well, Percona Live is next month in Austin and there is a full day of tutorials just waiting for you in Austin.  And I hope to see you there!/ppbr/pMonday, May 16 9:00am CDTCloud-native MongoDB 101 TutorialHigh Availability With Percona XtraDB ClusterMySQL Architectures : Design the Right Solution for Your NeedsPostgreSQL High Availability With PatroniPos [...]

Percona Live MySQL Sessions (from PHP With MySQL)

pPercona Live's schedule has very interesting MySQL talks.  This is an in person event in Austin Texas and one of the rooms will be livestreamed.  Please note there are TWO rooms to chose from./ppRoom 1 /pp Tuesday, May 17/p br11:30am CDTUsing Roles and Partial Revokes To Improve Security in MySQL 8.0br1:30pm CDTRocksDB Performance and Reliability Practicesbr2:30pm CDTVites [...]

Zero Impact on Index Creation with Amazon Aurora 3 (from Percona Database Performance Blog)

♦In the last quarter of 2021, AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version, porting many of the advantages MySQL 8 has over previous versions. While this brings a lot of new interesting features for Aurora, what we are going to cover here is to see how […] [...]

Wednesday, 20. April 2022

Create statefulset MariaDB application in K8s (from MariaDB Foundation Blog)

pIn the previous blog we created a stateless application, deployed with K8s resource Deployment, which allows one to replicate the application, but where data is lost when Pods are restarted, meaning there were no data consistency. … /p pContinue reading \"Create statefulset MariaDB application in K8s\"/p pThe post Create statefulset MariaDB application in K8s appeared first on MariaDB.org./p [...]

Meet Galera Cluster and Galera Manager developers at Percona Live Austin 16-18 May (from Galera Blog)

Percona Live 2022 will be May 16-18 at the AT&T Hotel and Conference Center in Austin. Codership will join the event with a booth and presentations by Seppo Jaakola and Colin Charles. By joining Percona Live in Austin you will have the opportunity to meet Galera Cluster and Galera Manager developers. At the booth we […] [...]

Zero impact on index creation with Aurora 3 (from TusaCentral - MySQL Blogs)

p♦Last quarter of 2021 AWS released Aurora version 3. This new version aligns Aurora with the latest MySQL 8 version porting many of the advantages MySQL 8 has over previous versions./p pWhile this brings a lot of new interesting features for Aurora, what we are going to cover here is to see how DDLs behave when using the ONLINE option. With a quick comparison with what happens in MySQL 8 standard [...]

Finding Differences Between MySQL Servers (from Percona Database Performance Blog)

♦When one is responsible for promoting application development from Dev through the various environments such as QA, UAT, etc., through Production, it is often useful to ensure that configurations in test environments are comparable to the final production environment.  This is especially true with systems where a team of DBAs manage the servers. Obviously, the […] [...]

Tuesday, 19. April 2022

pt-archiver with Auto-Increment Column – Debunking a Blame (from Percona Database Performance Blog)

♦As a best practice before dropping a large table in MySQL, pt-archiver can be used to delete all the records in batches. This helps to avoid a situation where your server may get stalled under certain circumstances. I recently read a comment from a user saying “The pt-archiver is not working as expected! It is […] [...]

Poorman’s MySQL table audit information – part 3 (from lefred's blog)

Recently we saw how we can catch audit information using invisible column, JSON data type and triggers in MySQL 8.0: Poorman’s MySQL table audit information Poorman’s MySQL table audit information – part 2 Of course, the creation of these triggers can quickly become a tedious operation. Once again, MySQL has all what we need to make it simple. As you may know, it’s impossible to create triggers fro [...]

Combine schema-full and schema-free data with JSON columns by copying ideas of NoSQL databases (from SQL for Devs)

There's an endless discussion happening between developers whether to use a SQL or NoSQL database. Overall it's a controversial topic whether the database should have a schema and changing it may be complex, or whether the application should handle the schema and the NoSQL database has a simplistic data model. But by utilizing JSON columns, you can merge the NoSQL be [...]

Monday, 18. April 2022

Champs Recap: Devart’s Award-Winning Products in Q1 2022 (from Devart MySQL Tool Blog)

pIt’s time for a brief recap that covers all the badges that dbForge products for MySQL, Oracle, and PostgreSQL were awarded in Q1 2022—all owing to the steadily positive response from our users on a variety of review platforms. dbForge Studio for MySQL: 9 new badges on G2 dbForge Studio for MySQL is a top-tier […]/p pThe post Champs Recap: Devart’s Award-Winning Products in Q1 20 [...]

Expose Databases on Kubernetes with Ingress (from Percona Database Performance Blog)

♦Ingress is a resource that is commonly used to expose HTTP(s) services outside of Kubernetes. To have ingress support, you will need an Ingress Controller, which in a nutshell is a proxy. SREs and DevOps love ingress as it provides developers with a self-service to expose their applications. Developers love it as it is simple […] [...]

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

pWhere can you find weekly content on all the things PHP, MySQL, the LAMP stack and related frameworks? If you guessed the OpenLampTech newsletter then you’re correct! Let’s dive into this week’s issue… I’m including so much original and curated content in these weekly newsletters, it’s a wonder my email service provider can even deliver […]/p pThe post Ope [...]

Sunday, 17. April 2022

Access Patterns for MySQL (from Hack MySQL)

pAccess patterns intrigue me because it seems that everyone knows what they are and talks about them, but there’s also very little written about them—in MySQL literature, at least. That’s why I set out to enumerate a list of access patterns (specific to MySQL). Since there’s no apparent standard for access patterns, I cannot say how my list measures up, but after spending most my [...]

Saturday, 16. April 2022

Galera Manager April 2022 release – now with managed clusters on Digital Ocean (from Galera Blog)

Codership is pleased to announce a new release of Galera Manager. This is version 1.6.1 of Galera Manager GUI. Users will notice many usability improvements, and multiple fixes for issues filed at the galera-manager-support issue tracker. The biggest user facing feature is now being able to deploy Galera Manager managed nodes on DigitalOcean, in addition […] [...]

Friday, 15. April 2022

Poorman’s MySQL table audit information – part 2 (from lefred's blog)

I really enjoyed to dig into the solution I described yesterday in this post, to generate table audit information using invisible columns and triggers. In this post, I will focus only on the solution using a JSON column to store the audit information. Yesterday, I wrote that it’s also possible to track all changes an not only the last one but also keep information about what changed. I wanted to il [...]

Correcting MySQL Inaccurate Table Statistics for Better Execution Plan (from Percona Database Performance Blog)

♦Abstract: By diving into the details of our case study, we will explain how incorrect table statistics may lead the optimizer to choose a suboptimal execution plan. We will also go into how MySQL calculates the table statistics and the ways to correct the table statistics to prevent it from happening again. Case study: Incorrect table […] [...]

Three (3) Essentials for Production Environments (from Continuent Blog)

pWhen an application is a primary source of revenue for an organization, keeping Production operations going is critical. This blog discusses three things that can help prevent issues in Production. In fact, that’s why multiple environments exist - to make sure that the final act, delivered in Production, runs smoothly; read on to find out how to make sure your labor is not in vain!/p Tags: My [...]

SQL Engineering Guidelines (from Die wunderbare Welt von Isotopp)

pWhere I work, the native database is MySQL. This is what the database team fully supports./p pOther databases, notably Postgres, are in use mostly because external products we run require them. Internal projects should use MySQL. An external company provides limited support for running Postgres./p pThe recommended version of MySQL to be used is currently the latest 8.0. It has a large number of im [...]

Thursday, 14. April 2022

Poorman’s MySQL table audit information (from lefred's blog)

Today, somebody asked me how he could track the creation of a record (who created it and when) and who and when it was last modified. Usually, this is performed in a different table, called audit table. In MySQL you can create an audit table and populate it using triggers. But of course, this person had some constraints, otherwise it would have been too easy: no other table could be used/created th [...]

Wednesday, 13. April 2022

MySQL Workbench GUI – Create Table (from Digital Owl's Prose)

pIn this blog post, you will learn how to create a MySQL table using the various tools MySQL Workbench provides without typing any SQL code. Continue reading and learn how… No MySQL Code? I don’t have anything against MySQL code. As a matter of fact, I actually like it. This blog and a lot of […]/p pThe post MySQL Workbench GUI – Create Table appeared first on Digital Owl� [...]

Tuesday, 12. April 2022

What is MariaDB Enterprise and How to Manage it with ClusterControl? (from SeveralNines Open Source Database Blog)

pHave you ever wondered what products MariaDB Enterprise has to offer? Is it different from MariaDB Community? Can I manage them with ClusterControl?/p pMariaDB provides two distributions of their software — Enterprise and Community. The Community consists of the MariaDB Server, which has Galera embedded; you can use either standard, asynchronous or semi-synchronous replication or, as an alternati [...]

Summarizing the different implementations of tiered compaction (from Small Datum)

pThis is my first attempt to summarize tiered compaction as implemented by RocksDB, Cassandra, ScyllaDB and HBase. I have limited experience with tiered compaction (that will change) and limited knowledge of Cassandra, ScyllaDB and HBase (that won't change soon) so I will make mistakes but enjoy the learning process. To keep this brief I ignore the variants optimizations for time-series and I don't [...]

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

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

Face to Face with Semi-Synchronous Replication (from Percona Database Performance Blog)

♦Last month I performed a review of the Percona Operator for MySQL Server which is still Alpha.  That operator is based on Percona Server for MySQL and uses standard asynchronous replication, with the option to activate semi-synchronous replication to gain higher levels of data consistency between nodes.  The whole solution is composed as: Additionally, Orchestrator […] [...]

Update rows based on values of another table or the result of another query (from SQL for Devs)

Updates to rows are always performed on a single table for a specific number of rows. When e.g. a discount should be applied to all products based on their category an UPDATE query is executed for every category. However, when the UPDATE query depends on data of a different table, a more efficient approach is possible: The UPDATE can be joined to t [...]

A face to face with semi-synchronous replication (from TusaCentral - MySQL Blogs)

p♦/p pLast month I performed a review of the Percona Operator for MySQL Server (www.percona.com/doc/kubernetes-operator-for-mysql/ps/index.html) which is still Alpha.  That operator is based on Percona Server and uses standard asynchronous replication, with the option to activate semi-synchronous  replication to gain higher levels of data consistency between nodes. /p pThe whole solu [...]

MariaDB & K8s: Deploy MariaDB and WordPress using Persistent Volumes (from MariaDB Foundation Blog)

pIn the previous blog, MariaDB & K8s: Create a Secret and use it in MariaDB deployment, we used the Secrets resource to hide confidential root user data, and in the blog before that in the series, MariaDB & … /p pContinue reading \"MariaDB & K8s: Deploy MariaDB and WordPress using Persistent Volumes\"/p pThe post MariaDB & K8s: Deploy MariaDB and WordPress using Persistent V [...]