Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

DEPRECATION WARNING: you are using an old version of Planet for the MySQL Community. You should stop using this beta and use the release (also update your feed). More detail about this in the blog post Graduating from Beta.

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.

Saturday, 04. February 2023

Import the World Database into Redis (from MORTENSI)

pI often need some dummy data for my tests and, as used as I am to import the SQL dump of the [world database](dev.mysql.com/doc/world-setup/en/) into MySQL, I wanted to make consistent tests and examples against the same simple dataset. So I converted the three tables of this dataset into Redis commands, so you can import […]/p pThe post Import the World Database into Redis appeared first on [...]
Published Saturday, 04. February 2023 12:19 • a day ago

Friday, 03. February 2023

New GPG Release Key for RPMs (from MariaDB Foundation Blog)

pAs mentioned in the previous batch of release notes (e.g. 10.6.11), our Yum/DNF/Zypper repositories for Red Hat Enterprise Linux, Centos, Fedora, openSUSE and SUSE will, from our next set of releases, be migrated to being signed with a new  … /p pContinue reading \"New GPG Release Key for RPMs\"/p pThe post New GPG Release Key for RPMs appeared first on MariaDB.org./p [...]
Published Friday, 03. February 2023 22:13 • a day ago

MariaDB at FOSDEM 2023 (from MariaDB Foundation Blog)

pMariaDB is at FOSDEM 2023, and it’s great to be back for the in-person event in Brussels for the first time since 2020. … /p pContinue reading \"MariaDB at FOSDEM 2023\"/p pThe post MariaDB at FOSDEM 2023 appeared first on MariaDB.org./p [...]
Published Friday, 03. February 2023 13:32 • 2 days ago

“A Grande Catastrophe” — MariaDB headlines in the main Finnish daily HS.fi (from Continuent Blog)

In this blog, Continuent’s CEO and Founder, Eero Teerikorpi, was prompted by a headline in the Finnish News to write about the MySQL and MariaDB business and ecosystem.Tags: MySQLMariaDBbusiness of open source money [...]
Published Friday, 03. February 2023 12:50 • 2 days ago

RocksDB microbenchmarks: compilers, Arm and x86 (from Small Datum)

pThis revisits my previous work to understand the impact of compilers and optimizer flags on the performance of RocksDB microbenchmarks. Benchmarks were run on Arm and x86 servers on both AWS and GCP using db_bench from RocksDB and benchHash from xxHash./pptl;dr/pp/pulliWhy won't AWS tell us whether Graviton3 is Neoverse N1 or N2/liliMuch time will be spent figuring out which compiler flags to use [...]
Published Thursday, 02. February 2023 23:15 • 3 days ago | Updated Friday, 03. February 2023 00:15 • 3 days ago

Thursday, 02. February 2023

MySQL 8.0 – Invisible Indexes (from Pythian Blog - MySQL Track)

Overview In this blog, we aim to discuss the new MySQL 8.0 feature: invisible indexes and how to manage index visibility. MySQL 8.0 supports invisible indexes, that is, indexes not used by the optimizer. This feature applies to indexes other... [...]
Published Thursday, 02. February 2023 14:30 • 3 days ago

MySQL Document Store - Peeking Under the Covers (from The Oracle MySQL Blog)

MySQL Document Store is a 'NoSQL' solution built on top of MySQL and using MySQL database tables. In this post, we show how to turn on logging so we can see the queried MySQL uses under the covers when we use the MySQL Document Store DRUC API. [...]
Published Thursday, 02. February 2023 05:00 • 3 days ago

Statistical rigor and database benchmarks (from Small Datum)

pI am good at benchmarks and not good at statistics. I have no doubt that my work lacks statistical rigor -- I am also wary of the X has a flaw, therefore X is useless argument that is overdone on the web, but I don't know whether that applies here.brbrUpdate - if you have a suggestions for a paper or book I should read then please share./ppThe challenge is that I have a finite budget (in my time a [...]
Published Wednesday, 01. February 2023 19:33 • 4 days ago | Updated Thursday, 02. February 2023 02:36 • 3 days ago

Wednesday, 01. February 2023

Introducing Point-in-Time Recovery for MySQL Heatwave Database Systems (from The Oracle MySQL Blog)

This blog introduces a new recovery option available for MySQL Database Systems (DB Systems) that, once enabled, permits data recovery to a specific point in time. [...]
Published Wednesday, 01. February 2023 19:59 • 4 days ago

Now Available: Tungsten Dashboard v1.0.13 Release (from Continuent Blog)

We are pleased to announce that Tungsten Dashboard v1.0.13 is now available. Tungsten Dashboard is a web-based UI for monitoring and managing Tungsten Clustering deployments of MySQL databases, freely included for Tungsten Clustering customers. We provide Tungsten Dashboard in addition to our command-line user interfaces for easy visual monitoring and management of Tungsten Clusters. Users are able [...]
Published Wednesday, 01. February 2023 09:37 • 4 days ago

Tuesday, 31. January 2023

MySQL Business-Critical Support — Three (3) Minutes Response Time Challenge! (from Continuent Blog)

When was the last time you had an Urgent Support Request related to your MySQL deployment for your MySQL support or MySQL consulting provider? How fast were they able to come back to you? And was this by someone who actually could help you, or just a call center acknowledging your request? Tags: MySQLMariaDB [...]
Published Tuesday, 31. January 2023 15:38 • 5 days ago

Introducing the PlanetScale API and OAuth applications (from PlanetScale Blog)

Manage your databases programmatically with the PlanetScale API.pRead the full story/p [...]
Published Tuesday, 31. January 2023 14:00 • 5 days ago

Database Administration for Galera Cluster online training course February/March (from Galera Blog)

Codership, the developers of Galera Cluster and Galera Manager, have new dates for the online DBA for Galera Cluster Training. There are two sets of times for our EMEA and American attendees, with the former happening on February 27th  and 28th, starting 10 AM CET and the latter happening on March 1st and 2nd, starting 9 AM EST.​​​​​ This is a hands on […] [...]
Published Tuesday, 31. January 2023 09:32 • 5 days ago

Monday, 30. January 2023

Percona Backup for MongoDB 2.0.3, Updates to Percona Distribution for MySQL: Release Roundup January 30, 2023 - Percona Database Performance Blog (from Percona Database Blog)

♦Percona software releases and updates January 9 - 30, 2022. [...]
Published Monday, 30. January 2023 12:16 • 6 days ago

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

pWith so much content online today, how do you find the ‘good stuff’ for a certain topic? While I can’t answer for other niches, if you’re interested in MySQL, PHP, and the LAMP stack, well, you already know the answer. Thank you for reading OpenLampTech! In OpenLampTech issue #63, we are looking at great content […]/p pThe post OpenLampTech issue #63 – Substack [...]
Published Monday, 30. January 2023 12:00 • 6 days ago

Using Oracle APEX with MySQL Heatwave Service for Data Visualisation and Reporting (from MySQL Solutions - On Premises & Cloud)

p /pUsing ORACLE APEX to Build and Visualize and Analyse MySQL Databasep Main objective of this blog is to connect MDS with APEX tool and visualize and get insights of MySQL data with low code solution called Oracle APEX. /ppBelow is the glimpse of topic to be covered in this blog /pp1. What is all about Oracle Apex /pp2. What are benefit of using Oracle Apex /pp3. Ins [...]
Published Thursday, 19. January 2023 17:09 • 17 days ago | Updated Monday, 30. January 2023 07:43 • 6 days ago

Sunday, 29. January 2023

Your Galera Cluster Production Questions, Answered (from Galera Blog)

One of the unpublished benefits of our training courses is that we hold an office hours session, usually one to two weeks after the training is complete, so that you can ask questions and receive answers. As always, we receive interesting questions, and this time we’ve decided to publish a selection of answers. You can […] [...]
Published Sunday, 29. January 2023 11:18 • 7 days ago

Friday, 27. January 2023

Announcing MySQL Shell 8.0.32 (from The Oracle MySQL Blog)

Announcing MySQL Shell 8.0.32 [...]
Published Friday, 27. January 2023 17:59 • 9 days ago

Common MySQL errors and how to fix them (from PlanetScale Blog)

An overview of some common MySQL error codes you may run into, what they mean, and how to solve them.pRead the full story/p [...]
Published Friday, 27. January 2023 14:00 • 9 days ago

Thursday, 26. January 2023

A Quick Guide to MySQL HeatWave with MySQL Shell for VS Code (from The Oracle MySQL Blog)

This blog post shows the benefits of using MySQL Shell for VS Code when working with a MySQL HeatWave instance. [...]
Published Thursday, 26. January 2023 17:33 • 10 days ago

Make Indexes Invisible Before Deleting Them (from SQL for Devs)

Deleting an unused index in the schema is always a nerve-stretching task. When it was still needed, the application will be slow until the index is recreated which may take a very long time depending on the table's size. But instead of deleting it, you can make it invisible so it's not used anymore. You can then make it visible again withi [...]
Published Thursday, 26. January 2023 16:08 • 10 days ago

Why You Need To Keep Track of Bugs - Percona Database Performance Blog (from Percona Database Blog)

♦A recent bug that appeared in MySQL 8.0.32 is a prime example of how a minor bug could have a significant impact on your life and company. [...]
Published Thursday, 26. January 2023 13:05 • 10 days ago

MySQL 8.0.32: thank you for the contributions (from The Oracle MySQL Blog)

We released MySQL 8.0.32 and we would like to thanks all those contributing to MySQL: thank you ! [...]
Published Thursday, 26. January 2023 09:53 • 10 days ago

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

The latest MySQL release has been published on January 17th, 2023. MySQL 8.0.32 contains some new features and bug fixes. As usual, it also contains contributions from our great MySQL Community. I would like to thank all contributors on behalf of the entire Oracle MySQL team ! MySQL 8.0.32 contains patches from Facebook/Meta, Alexander Reinert, Luke Weber, Vilnis Termanis, Naoki Someya, Maxim Masiu [...]
Published Thursday, 26. January 2023 09:52 • 10 days ago

Announcing MySQL Operator for Kubernetes 8.0.32-2.0.8 (from The Oracle MySQL Blog)

Announcing MySQL Operator for Kubernetes 8.0.32-2.0.8 [...]
Published Thursday, 26. January 2023 01:29 • 11 days ago

Wednesday, 25. January 2023

Sysbench 1.1.0 for Oracle Linux 9 (from lefred's blog)

Recently Jack asked me for a Sysbench package for OL9. In this post, you can find the RPM packages of Sysbench 1.1.0 build for Oracle Linux 9, RedHat Enterprise 9 and any RPM compatible system. Sysbench’s binary is linked with libmysqlclient.so.21 and libssl.so.3. Here are the two files, one for x86_64 and one for aarch64 (ARM): Enjoy MySQL and happy benchmark ! [...]
Published Wednesday, 25. January 2023 14:16 • 11 days ago

New Galera Manager installation videos for on premises and Amazon EC2 (from Galera Blog)

We have produced two new step-by-step videos for installing Galera Clusters either on premise and at Amazon EC2 environments. The videos can be replayed from links below. A step-by-step video on how to install Galera Cluster in an Amazon EC2 environment using Galera Manager A step-by-step video on how to install Galera Cluster in an […] [...]
Published Wednesday, 25. January 2023 14:00 • 11 days ago

Tungsten Cluster: How Does Failover Work? Part 1 of 3 (from Continuent Blog)

Did you ever wonder just what the Tungsten Manager is thinking when it does an automatic failover or a manual switch in a cluster? What factors are taken into account by the Manager when it picks a replica to fail over to? This blog post will detail the steps the Manager takes to perform a switch or failover. We will cover both the process and some possible reasons why that process might not comple [...]
Published Wednesday, 25. January 2023 13:49 • 11 days ago

Identify Active Databases and Users in MySQL - Percona Database Performance Blog (from Percona Database Blog)

♦Easy and quick ways to identify active databases and users in MySQL. [...]
Published Wednesday, 25. January 2023 13:40 • 11 days ago

5 Websites To Learn More SQL – Substack Repost (from Digital Owl's Prose)

pSQL is foundational in web and application programming. There are many websites and resources online to learn SQL. I like these 5 websites and think you will too… Read the article: 5 Websites To Learn More SQL Support the OpenLampTech publication with your free subscription. Thank you!/p pThe post 5 Websites To Learn More SQL – Substack Repost appeared first on Digital Owl's Prose [...]
Published Wednesday, 25. January 2023 12:00 • 11 days ago

New MySQL HeatWave capabilities released in 8.0.32 (from The Oracle MySQL Blog)

New MySQL HeatWave capabilities released in 8.0.32 [...]
Published Wednesday, 25. January 2023 05:34 • 11 days ago

Tuesday, 24. January 2023

Announcing MySQL Server 8.0.32 (from The Oracle MySQL Blog)

Announcing MySQL Server 8.0.32 [...]
Published Tuesday, 24. January 2023 23:54 • 12 days ago

MariaDB Java Connector 3.1.2 and 2.7.8 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.1.2 and 2.7.8 GA releases. Download Now These … Continued [...]
Published Tuesday, 24. January 2023 17:44 • 12 days ago

Planet for the MySQL Community Graduating from Beta (from J-F Gagné's MySQL Blog)

In May 2020, I published a Planet for the MySQL Community Pluto Beta.  I was satisfied with the result and was considering it done, but I did not invest the time to promote it to release (a non-beta site was running for a few months without being advertised).  I finally came to it, and today I am happy to deprecate the beta and announce the release of Planet for the MySQL Community.  In this post [...]
Published Tuesday, 24. January 2023 01:56 • 13 days ago | Updated Tuesday, 24. January 2023 01:56 • 13 days ago

Binding your application to the database in the Kubernetes cluster (from Percona Community Blog)

♦dbaas-operator is Yet Another DBaaS Kubernetes Operator (need to suggest yadbko as a name) that tries to simplify and unify Database Cluster deployments by building a higher abstraction layer on top of Percona Kubernetes Operators. So it becomes much easier to deploy the DB cluster with dbaas-operator and PMM DBaaS on top of it. But another part of the picture is applications and their workloads t [...]
Published Tuesday, 24. January 2023 00:00 • 13 days ago

Monday, 23. January 2023

The insert benchmark on ARM and x86 cloud servers (from Small Datum)

pI used the insert benchmark to compare ARM and x86 servers on AWS. For ARM I used c7g and for x86 I used c6i. The goal was to compare ARM vs x86 on similar hardware (OS, vcpu, RAM and EBS setups were the same). /ppWhile I am not trying to start a benchmarketing battle for c7g vs c6i or Postgres vs MySQL, I suppose that might happen. My goal in doing comparisons like this is to find things tha [...]
Published Monday, 23. January 2023 19:37 • 13 days ago | Updated Monday, 23. January 2023 20:16 • 13 days ago

Now Available: Tungsten Dashboard v1.0.12 Release (from Continuent Blog)

We are pleased to announce that Tungsten Dashboard v1.0.12 is now available. Tungsten Dashboard is a web-based UI for monitoring and managing Tungsten Clustering deployments of MySQL databases, freely included for Tungsten Clustering customers. We provide Tungsten Dashboard in addition to our command-line user interfaces for easy visual monitoring and management of Tungsten Clusters. Users are able [...]
Published Monday, 23. January 2023 15:13 • 13 days ago

Working of MySQL Replication Filters When Using Statement-based and Row-based Replication - Percona Database Performance Blog (from Percona Database Blog)

♦Explaining how the MySQL replication filter may increase the complexity of your DBA operations, with examples. [...]
Published Monday, 23. January 2023 14:14 • 13 days ago

[BUG] Stopping Purge/Resuming Purge in Error Logs After Upgrade to MySQL 5.7.40 - Percona Database Performance Blog (from Percona Database Blog)

♦Some clients report that whenever they trigger a truncate on any table in MySQL 5.7.40, the function is stopping the purge and then resuming it once it has found it stopped. [...]
Published Monday, 23. January 2023 12:55 • 13 days ago

Substring in MySQL – Syntax and Examples (from Devart MySQL Tool Blog)

pIn this article, we are going to talk about the MySQL SUBSTRING() function with its variations. Here, you will find a detailed guide with the basic syntax and examples of how to use this function. Moreover, we will demonstrate the benefits of MySQL coding in a handy IDE – dbForge Studio for MySQL that will […]/p pThe post Substring in MySQL – Syntax and Examples appeared first on [...]
Published Monday, 23. January 2023 12:37 • 13 days ago

Friday, 20. January 2023

What should be monitored on a busy Database/MysQL server? (from Geeks Worldwide)

On a busy MySQL server, some key metrics that should be actively monitored include: - Geeks Worldwide [...]
Published Friday, 20. January 2023 23:43 • 16 days ago

preFOSDEM MySQL Days 2023 – the Agenda (from The Oracle MySQL Blog)

Just before FOSDEM, the MySQL Team is organizing a 2 days conferences for and with the MySQL Community. Here is the agenda. [...]
Published Friday, 20. January 2023 21:38 • 16 days ago

Help! I Am Out of Disk Space! - Percona Database Performance Blog (from Percona Database Blog)

♦Leveraging the flexibility of Percona Operator for MySQL to fix an out-of-disk-space issue. [...]
Published Friday, 20. January 2023 13:17 • 16 days ago

How can I tell which Tungsten Connector mode I am using: Bridge, Proxy/Direct or Proxy/SmartScale? (from Continuent Blog)

pPart of the power of Tungsten Clustering for MySQL / MariaDB is its intelligent MySQL Proxy, known as the Tungsten Connector. Tungsten Connector has three main modes, and depending on the type of operations you are performing (such as if you need read-write splitting), we help you choose which mode is best. Hence the question, "How can I tell which Tungsten Connector mode I am using: Bridge, Proxy [...]
Published Friday, 20. January 2023 13:01 • 16 days ago

Where you can find MySQL in January-May 2023 (from The Oracle MySQL Blog)

List of conferences with MySQL during January-May 2023 [...]
Published Friday, 20. January 2023 11:33 • 16 days ago

A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more (from Vettabase)

In my first post in 2023, I want to give you a summary of MariaDB 10.10. Some may argue that I’m a bit late because it was released last November, and versions 10.11 and 11.0 have been announced since then… All that is correct, but 10.10 is the latest stable version. My usual friendly reminder: […] [...]
Published Friday, 20. January 2023 11:01 • 16 days ago

Introducing Chat2Query: An Innovative AI-Powered SQL Generator for Faster Insights (from TiDB and TiKV Blog)

pWe are excited to introduce Chat2Query, a revolutionary natural language query generator powered by OpenAI's GPT3, the technology behind ChatGPT, and TiDB, the distributed SQL database. /p pThe post Introducing Chat2Query: An Innovative AI-Powered SQL Generator for Faster Insights appeared first on PingCAP./p [...]
Published Friday, 20. January 2023 05:53 • 16 days ago

Thursday, 19. January 2023

Recently a Continuent Customer Asked: Part 3 (from Continuent Blog)

In this blog, part 3 of a series of “Recently a Customer Asked” posts for Tungsten University, we explore the question: "Why does the tprovision command fail with error “Can’t connect to local MySQL server through socket” when using the xtrabackup method?Tags: MySQLMariaDBxtrabackuptprovision [...]
Published Thursday, 19. January 2023 21:20 • 17 days ago

Help! I am out of disk space! (from TusaCentral - MySQL Blogs)

pHow we could  fix a nasty out of space issue leveraging the flexibility of Percona MySQL operator (PMO)  ♦/p pWhen planning a database deployment, one of the most challenging factors to consider is the amount of space we need to dedicate for Data on disk./p pThis is even more cumbersome when working on bare metal. Given it is definitely more difficult to add space when using this ki [...]
Published Thursday, 19. January 2023 14:11 • 17 days ago

A Quick Peek at MySQL 8.0.32 - Percona Database Performance Blog (from Percona Database Blog)

♦Recently, Oracle released MySQL 8.0.32 and there are some things of note. Dave Stokes takes a look. [...]
Published Thursday, 19. January 2023 13:49 • 17 days ago

Why MySQL Could Be Slow With Large Tables - Percona Database Performance Blog (from Percona Database Blog)

♦Reviewing key topics to consider for managing large tables more efficiently in MySQL. [...]
Published Thursday, 19. January 2023 12:40 • 17 days ago

FromDual Ops Center 1.2.0 for MariaDB, MySQL and compatible databases has been released (from Shinguz's Blog)

pFromDual has the pleasure to announce the release of the new version 1.2.0 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB, MySQL and compatible databases./p pThe FromDual Ops Center for MariaDB and MySQL (focmm) helps DBA's and System Administrators to better manage their MariaDB and MySQL databases and Galera Cluster farms. Ops Center makes DBA and Admins [...]
Published Thursday, 19. January 2023 11:01 • 17 days ago

On Writing to the MySQL Error Log (from Laurynas Biveinis' blog)

pIf you develop a 3rd party MySQL plugin, it might take a while for you to figure out how to make your plugin write to the server error log in an official supported way. Let's take a look. /p pFirst things first: you don't want to patch the core server and ideally you'd develop and distribute the plugin only. I don't think there exists a single plugin that pulls this off today, but that's the ideal [...]
Published Wednesday, 18. January 2023 14:04 • 18 days ago | Updated Thursday, 19. January 2023 07:52 • 17 days ago

Wednesday, 18. January 2023

Compiling MySQL 5.6 & 5.7 on Ubuntu 22.04 (from Small Datum)

One of my hobbies is testing open source DBMS for CPU regressions and for that I want to compare perf between old and new versions of the DBMS. Depending on the DBMS it can be a challenge to build the old DBMS with the current (modern) compiler toolchain. brUsing open source frequently means compiling from source and compiling from source eventually means debugging a failed build. Alas, the pr [...]
Published Wednesday, 30. November 2022 15:56 • 2 months ago | Updated Wednesday, 18. January 2023 23:56 • 18 days ago

Releasing ProxySQL v2.4.7! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.4.7 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.7! appeared first on ProxySQL./p [...]
Published Wednesday, 18. January 2023 17:43 • 18 days ago

RDS/Aurora IAM DB access with MySQL Shell (from Jay Janssen's MySQL and Infrastructure)

pAs probably with anyone experimenting with Innodb Cluster and MySQL 8, I’ve spent a good deal of time with MySQL Shell. I think for some old-timers MySQL Shell can initially come across as odd or difficult to understand. Partially, I think it is because Shell offers a deluge of new features from:/p ul limanaging local sandbox mysql instances/li li3 different shell languages (SQL, Javascript [...]
Published Wednesday, 18. January 2023 13:08 • 18 days ago

Announcing TiDB 6.5 LTS Release – Major Leap into 2023 with a Mature Enterprise Database (from TiDB and TiKV Blog)

pWe are proud to announce the TiDB 6.5 Long-Term Support (LTS) release with a host of new features, enhancements, and fixes in kernel capabilities, ease of use, and developer experience. /p pThe post Announcing TiDB 6.5 LTS Release – Major Leap into 2023 with a Mature Enterprise Database appeared first on PingCAP./p [...]
Published Wednesday, 18. January 2023 09:05 • 18 days ago

What is the N+1 query problem and how to solve it? (from PlanetScale Blog)

Learn what the N+1 queries problem is by working through an example N+1 query, updating it to a JOIN statement, and going over how to identify them in the future.pRead the full story/p [...]
Published Wednesday, 18. January 2023 08:01 • 18 days ago

Tuesday, 17. January 2023

clang, gcc & compiler flags vs the insert benchmark & ARM (from Small Datum)

pI have a large set of results from the Insert Benchmark run on AWS servers that use ARM CPUs (c7g). But before sharing them I wanted to make sure my builds (Postgres and MySQL compiled from source) weren't ruined by using the wrong compiler flags. And by wrong I mean that by default you get a build optimized for an older version of the ARM architecture. The flags that I tried optimize it for somet [...]
Published Tuesday, 17. January 2023 21:25 • 19 days ago | Updated Tuesday, 17. January 2023 23:23 • 19 days ago

Using Oracle Cloud Infrastructure GoldenGate with MySQL Databases (from The Oracle MySQL Blog)

OCI GoldenGate is a fully managed service providing a real-time data mesh platform, which uses replication to keep data highly available and enable real-time analysis. OCI GoldenGate supports several sources and targets, including MySQL and OCI MySQL HeatWave Database Service. In this article, we will find out how the MySQL deployment and connection types make it easier than ever to integrate with [...]
Published Tuesday, 17. January 2023 22:14 • 19 days ago

How MariaDB Xpand Accelerates SaaSification (from MariaDB Corporation Blog)

SaaSification is not only a tech thing. Entire industries are moving to more specialized services provided as applications and APIs. … Continued [...]
Published Tuesday, 17. January 2023 20:45 • 19 days ago

preFOSDEM MySQL Days 2023 – the Agenda (from lefred's blog)

As you know, before FOSDEM, the MySQL Community Team organizes a 2 days conference in Brussels. During these preFOSDEM MySQL Days, attendees will have the opportunity to learn more about MySQL from Oracle’s MySQL teams and selected professionals from the MySQL community. Here is the agenda: Thursday 2nd February Registration starts at 09:00 AM. Start End Title Speaker Company 09:30 AM 10:00 AM Welc [...]
Published Tuesday, 17. January 2023 19:46 • 19 days ago

Global WordPress High Availability Using Tungsten Clustering, Part 1 (from Continuent Blog)

Running highly-available WordPress is especially challenging, because WordPress is not by nature Active/Active-aware, and will refuse to run in an environment where database writes are active-active. In this blog post Part 1, we will explore the design considerations for making WordPress highly-available at the database layer. We also cover some other WordPress HA architecture needs, like the need [...]
Published Tuesday, 17. January 2023 17:51 • 19 days ago

Fast query performance with MySQL Hypergraph Optimizer for HeatWave (from The Oracle MySQL Blog)

Fast query performance with MySQL Hypergraph Optimizer for HeatWave [...]
Published Tuesday, 17. January 2023 06:04 • 19 days ago

Percona Monitoring and Management 2.34 preview release (from Percona Community Blog)

♦Percona Monitoring and Management 2.34 preview release Hello folks! Percona Monitoring and Management (PMM) 2.34 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. You can find [...]
Published Tuesday, 17. January 2023 00:00 • 20 days ago

Monday, 16. January 2023

Gcov in MariaDB (from MariaDB Foundation Blog)

pGcov is a coverage testing tool, used to create better programs. It can show which parts of the codebase are untested. Gcov is located in the same package as gcc. … /p pContinue reading \"Gcov in MariaDB\"/p pThe post Gcov in MariaDB appeared first on MariaDB.org./p [...]
Published Monday, 16. January 2023 15:35 • 20 days ago

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

pOpenLampTech is your media source for original and curated MySQL, PHP, and LAMP stack-related content. This week’s newsletter has many many great reads. Thank you for reading and making the publication a success. Please share with others! This week in OpenLampTech issue #61, we have articles covering: Want to support OpenLampTech? Great! Your free subscription […]/p pThe post OpenLampT [...]
Published Monday, 16. January 2023 12:00 • 20 days ago

MySQL HeatWave Report – December 2022 update (from MySQL expert Diary)

p- Read Replicas with Load Balancerbr - Replication Filtersbr - Replication Sources Without GTIDsbr - MySQL HeatWave for AWS/p pThis presentation is just a summary of new features in MySQL HeatWave./p pFor a more thorough and exhaustive view please read the following: /p p - docs.oracle.com/en-us/iaas/releasenotes/services/mysql-database//p p - dev.mysql.com/doc/relnotes/heatwave/en//p The post [...]
Published Monday, 16. January 2023 11:32 • 20 days ago

Setting Up PMM For Monitoring Your Databases on Windows (from Percona Community Blog)

♦Before deploying Percona Monitoring and Management (PMM) in production, you might want to test it or set up a development instance locally. Since many developers and DBAs have Windows desktops, I wanted to demonstrate how to set up PMM on Windows for an easy test environment. In this post, I’ll walk you through setting up PMM with Docker and WSL. If you’re a Linux user, check the blog post I wrote [...]
Published Monday, 16. January 2023 00:00 • 21 days ago

Friday, 13. January 2023

pt-online-schema-change resulted in missing MySQL triggers ? (from Mydbops Blog)

♦Recently, while doing a test process to examine resource usage and the time required to alter the table using pt-osc, it leads to a loss of triggers even though the –preserve-triggers option … [...]
Published Friday, 13. January 2023 20:27 • 23 days ago

Tungsten Cluster: Command Line Superpowers Using cctrl (from Continuent Blog)

The purpose of the cctrl command is to provide easy access to the Tungsten Manager layer, which in turn controls the entire cluster. In this post we will explore the cctrl> service command and the power it provides to the admin.Tags: MySQLMariaDBcctrlCLI superpowers [...]
Published Friday, 13. January 2023 13:49 • 23 days ago

Updating SQL_MODE (from MacLochlainns Weblog)

This is an update for MySQL 8 Stored PSM to add the ONLY_FULL_GROUP_BY mode to the global SQL_MODE variable when it’s not set during a session. Here’s the code: /* Drop procedure conditionally on whether it exists already. */ DROP PROCEDURE IF EXISTS set_full_group_by; /* Reset delimter to allow semicolons to terminate statements. */ DELIMITER […] [...]
Published Friday, 13. January 2023 07:06 • 23 days ago

GROUP BY Quirk (from MacLochlainns Weblog)

It’s always interesting to see how others teach SQL courses. It can be revealing as to whether they understand SQL or only understand a dialect of SQL. In this case, one of my old students was taking a graduate course in SQL and the teacher was using MySQL. The teacher made an issue of using […] [...]
Published Friday, 13. January 2023 06:30 • 23 days ago

Thursday, 12. January 2023

Releasing ProxySQL v2.4.6! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.4.6 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.6! appeared first on ProxySQL./p [...]
Published Thursday, 12. January 2023 22:15 • 24 days ago

MySQL HeatWave Database Service inbound replication channel troubleshooting guide (from The Oracle MySQL Blog)

Follow this guide to troubleshoot Inboud Replication Channel to OCI MySQL HeatWave Database Service if replication is not running [...]
Published Thursday, 12. January 2023 12:35 • 24 days ago

MariaDB Non-Code Contributions by Intel (from MariaDB Foundation Blog)

pI’ve mentioned in past blog posts that not every contribution is a code contribution. There are many possible contributions that are valuable, including testing, bug reports, helping the community, etc. … /p pContinue reading \"MariaDB Non-Code Contributions by Intel\"/p pThe post MariaDB Non-Code Contributions by Intel appeared first on MariaDB.org./p [...]
Published Thursday, 12. January 2023 11:49 • 24 days ago

Functional Indexes in MySQL (from The Oracle MySQL Blog)

First introduced to MySQL in version 8.013, functional indexes give us the ability to create indexes based on expressions rather than the values of data in a database column. In this post we discuss how to create functional indexes as well as some limitations and implications with their use. [...]
Published Thursday, 12. January 2023 11:00 • 24 days ago

Wednesday, 11. January 2023

MariaDB Java Connector 3.1.1 and 3.0.10 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.1.1 and 3.0.10 GA releases. Download Now These … Continued [...]
Published Wednesday, 11. January 2023 22:37 • 25 days ago

Insert benchmark on an 8-core AMD server (from Small Datum)

pI ran the insert benchmark on a Beelink SER 4700u that has 8 AMD cores, 16G RAM and NVMe SSD. I ran the test using 1, 2, 3 and 4 clients (threads) for MySQL (MyRocks, InnoDB) and Postgres. /pptl;dr/pp/pulliMySQL has CPU regressions from 5.6 to 8.0 that hurt performance/liliPostgres does not suffer from such CPU regressions/liliPostgres wasn't able to sustain the target insert rate (4000/s) fo [...]
Published Thursday, 05. January 2023 19:49 • 1 months ago | Updated Wednesday, 11. January 2023 22:14 • 25 days ago

Support’s notes from the field (from PlanetScale Blog)

A quick glimpse on Support at PlanetScale and the issues we see the most often.pRead the full story/p [...]
Published Wednesday, 11. January 2023 14:45 • 25 days ago

Tuesday, 10. January 2023

MySQL Connection Control (from The Oracle MySQL Blog)

What is MySQL Connection Control and how to use it. [...]
Published Tuesday, 10. January 2023 21:58 • 26 days ago

The flagship feature in the new LTS version RonDB 22.10.0 (from Mikael Ronstrom)

p In RonDB 22.10.0 we added a new major feature to RonDB. This feature means that variable sized disk columns in RonDB are stored in variable sized rows instead of using fixed size rows./ppThe history of disk data in RonDB starts already in 2004 when the NDB team at Ericsson had been acquired by MySQL AB. NDB Cluster was originally designed as an in-memory DBMS. The reason for this was based o [...]
Published Tuesday, 10. January 2023 18:12 • 26 days ago | Updated Tuesday, 10. January 2023 18:12 • 26 days ago

Solving N+1’s with Rails `exists?` queries (from PlanetScale Blog)

Learn how to solve your Rails applications N+1’s caused by `exists?` queries.pRead the full story/p [...]
Published Tuesday, 10. January 2023 17:30 • 26 days ago

Summary of RonDB 21.04.9 changes (from Mikael Ronstrom)

p RonDB 21.04 main use case is being the base of the data management platform in Hopsworks. As such every now and then some new requirements on RonDB emerges. But obviously the most important feature of development of RonDB 21.04 is on stability./ppHopsworks provides a free Serverless use case to try out the Hopsworks platform. Check it out on app.hopsworks.ai. Each user gets their own databas [...]
Published Tuesday, 10. January 2023 16:41 • 26 days ago | Updated Tuesday, 10. January 2023 16:41 • 26 days ago

Recently a Continuent Customer Asked: Part 2 (from Continuent Blog)

In this post we discussed the tprovision command and why it is always best to use a Replica node, not the Primary node, as the source for provisioning another Replica node.Tags: MySQLMariaDBtprovisionbackuprestore [...]
Published Tuesday, 10. January 2023 15:41 • 26 days ago

Elevate Your Percona Live Experience by Climbing MT. Elbert - Percona Database Performance Blog (from Percona Database Blog)

♦Join Peter Zaitsev right after Percona Live 2023 to climb Mt Elbert, the highest mountain in Colorado! [...]
Published Tuesday, 10. January 2023 13:04 • 26 days ago

Indexing JSON Data in MySQL (from The Oracle MySQL Blog)

Developers have been storing JSON data in MySQL databases since before the JSON data type existed. With the introduction of functional indexes, developers can now create indexes based on values in data stored in a column with the JSON data type. [...]
Published Tuesday, 10. January 2023 11:00 • 26 days ago

2022, a Year of Success and Accomplishment for PingCAP (from TiDB and TiKV Blog)

pTogether, our team accomplished a lot in 2022. We made many product innovations, offered better user and developer experiences, received recognition from various stakeholders, grew our user base significantly, and expanded our global presence with a growing team around the world. /p pThe post 2022, a Year of Success and Accomplishment for PingCAP appeared first on PingCAP./p [...]
Published Tuesday, 10. January 2023 04:17 • 26 days ago

Monday, 09. January 2023

RonDB News (from Mikael Ronstrom)

p The RonDB team has been busy in development in 2022. Now is the time to start releasing things. There are 5 things that we are planning to release in Q1 2023./ppRonDB 21.04.9: A new version of RonDB with a few new features required by the Hopsworks 3.1 release and a number of bug fixes. This is released today and will be described in a separate blog./ppRonDB 22.10.0: This is a new Long-Term [...]
Published Monday, 09. January 2023 17:02 • 27 days ago | Updated Monday, 09. January 2023 17:13 • 27 days ago

Find and remove unused & duplicate indexes in MySQL (from Pythian Blog - MySQL Track)

Overview: It is a general rule of thumb, that the more indexes you have on a table, the slower the INSERTs, UPDATEs, and DELETEs operations become. Indexes in MySQL—or for that matter, any database—are never static. Each time you modify... [...]
Published Monday, 09. January 2023 15:57 • 27 days ago

COUNT(*) vs COUNT(col) in MySQL - Percona Database Performance Blog (from Percona Database Blog)

♦There is a substantial difference in performance and even query results when using COUNT(*) or COUNT(col) in MySQL. Let's take a look. [...]
Published Monday, 09. January 2023 13:43 • 27 days ago

Updated Percona Distribution for MySQL, Percona XtraDB Cluster: Release Roundup January 9, 2023 - Percona Database Performance Blog (from Percona Database Blog)

♦Percona software releases and updates December 27 - January 9, 2023. [...]
Published Monday, 09. January 2023 12:17 • 27 days ago

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

pThank you so much for reading OpenLampTech and making it the success it is today. Wow! 600 developers reading each week! I am humbled to say the very least. In OpenLampTech issue #60, we are looking at some fantastic articles covering: Want to help OpenLampTech be a success and continue to grow? Your free subscription […]/p pThe post OpenLampTech issue #60 – Substack Repost appeared fi [...]
Published Monday, 09. January 2023 12:00 • 27 days ago

How to import data from Microsoft SQL Server to MySQL HeatWave Database Service (from The Oracle MySQL Blog)

If you have data stored in a Microsoft SQL Server database and you want to import it into MySQL HeatWave Database Service in OCI, you can use the procedure described in this article. [...]
Published Monday, 09. January 2023 11:29 • 27 days ago

How to speed up a Mysql replica? (from Geeks Worldwide)

There are several ways you can try to speed up a MySQL replica. Here are some ideas: - Geeks Worldwide [...]
Published Monday, 09. January 2023 03:22 • 27 days ago

The server requested authentication method unknown to the client [phpmyadmin] (from Geeks Worldwide)

It looks like you are trying to connect to a MySQL server using phpMyAdmin and you are encountering an error message saying that the server requested an authentication method unknown to the client. - Geeks Worldwide [...]
Published Monday, 09. January 2023 02:21 • 28 days ago

Friday, 06. January 2023

MySQL InnoDB Redo Log Archiving (from The Oracle MySQL Blog)

What is MySQL InnoDB Redo Log Archiving ? How does it work ? Discover this important MySQL InnoDB feature reading this blog post. [...]
Published Friday, 06. January 2023 13:49 • 1 months ago

Thursday, 05. January 2023

Live Migration from Azure Database for MySQL to MySQL HeatWave Database Service on OCI (from The Oracle MySQL Blog)

Live Migration from Azure Database for MySQL to MySQL HeatWave Database Service on Oracle Cloud (OCI) [...]
Published Thursday, 05. January 2023 17:01 • 1 months ago

Using MySQL Shell to generate table’s create statement from CSV file (from The Oracle MySQL Blog)

MySQL Shell is a command-line interface for interacting with MySQL servers. It allows you to run SQL queries and perform various tasks related to MySQL databases. In this post we will see how we can use MySQL Shell and a plugin to generate table's create statement from a CSV file containing records. [...]
Published Thursday, 05. January 2023 15:29 • 1 months ago

Quick Data Archival in MySQL Using Partitions - Percona Database Performance Blog (from Percona Database Blog)

♦A solution to remove space and rows from tables in a few seconds regardless of the size of a table, without causing any additional load on the MySQL database using table partitions. [...]
Published Thursday, 05. January 2023 15:13 • 1 months ago