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.

Sunday, 16. January 2022

Configuring MySQL Query Metrics (from Hack MySQL)

pEditors and technical reviewers suggested that I cover how to configure MySQL query metrics in chapter 1 of Efficient MySQL Performance, but I deferred because it was out of scope for the book, which focuses on engineers using MySQL, not DBAs. As such, there’s only a note in chapter 1 that says: “Ask your DBA or read the MySQL manual.” But I’ll cover the topic here because [...]
Published Sunday, 16. January 2022 20:40 • 2 hours ago

Introduction to Face Recognition using Python (from MORTENSI)

pA few years ago (just a few, in 2003) I discussed the thesis for my degree in Electronic Engineering: “Classification of Log-Gabor Features for Biometric Face Recognition“. It was a really engaging project and I achieved good results in terms of recognition rate using a wavelet transform and a neural network classificator. Afterwards, I dropped […]/p pThe post Introduction to Fac [...]
Published Sunday, 16. January 2022 20:08 • 2 hours ago

Saturday, 15. January 2022

Accessing Complex Structures in MariaDB Server Code in bpftrace Probes - First Steps (from MySQL Entomologist (former?) Blog)

pI had already written many blog posts about bpftrace. All my public talks devoted to bpftrace included a slide about "problems", and one of them usually sounded like this:/pblockquotep...access to complex structures (bpftrace needs headers)... /p/blockquotepSo, today I decided to demonstrate how to resolve this minor problem. As an example I tried to reproduce gdb debugging steps from this older p [...]
Published Saturday, 15. January 2022 20:45 • a day ago | Updated Saturday, 15. January 2022 20:45 • a day ago

Friday, 14. January 2022

Extending MySQL using the Component Infrastructure – part 7: messages to users (from lefred's blog)

This post is the seventh post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: Extending MySQL using the Component Infrastructure – part 1 Extending MySQL using the Component Infrastructure – part 2: building the server Extending MySQL using the Component Infrastructure – part 3: component services Extending [...]
Published Friday, 14. January 2022 12:22 • 2 days ago

Sysbench for arm and MySQL 8.0 (from lefred's blog)

For my presentation for the next FOSDEM MySQL Devroom, I needed to create some load. As usual, for this task, what better than sysbench ? The “problem” was that my system was already setup and I used OL7 on the always free Ampere compute instance on OCI. As you may know, this is an ARM architecture (aarch64) and there was not sysbench rpm package available for this OS and architecture. I also wante [...]
Published Friday, 14. January 2022 08:44 • 3 days ago

Time to check Galera Cluster security? (from Galera Blog)

There are plenty of articles on the Internet that tell you to setup a Galera Cluster by disabling an OS based firewall and also disabling SELinux. While we agree that this might be the fastest way to get your Galera Cluster setup, it is not necessarily good security hygiene, and we would prefer if you […] [...]
Published Friday, 14. January 2022 08:11 • 3 days ago

Thursday, 13. January 2022

FOSDEM 2022 MySQL devroom schedule updated ! (from FOSDEM MySQL & Friends Devroom)

Hello, Due to a complete misunderstanding about the available slots, FOSDEM’s organization had to remove 2 talks from the previous planned agenda. However, we didn’t want to announce to previously accepted speakers that their talks were cancelled ! Therefore, we decided, with FOSDEM’s approval, to extend the FOSDEM 2022 MySQL Devroom, opening our room on […] [...]
Published Thursday, 13. January 2022 18:37 • 3 days ago

Migrate RDB to Cloud SQL Using Google’s Dataflow (from Pythian Blog - MySQL Track)

Most corporations have huge amounts of data in RDBMS (relational database management system). When considering a RDBMS data transfer and you only need a subset of data to migrate to the cloud, follow this very efficient and easy data ingestion... [...]
Published Thursday, 13. January 2022 15:00 • 3 days ago

Extending MySQL using the Component Infrastructure – part 6: functions (from lefred's blog)

This post is the sixth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: Extending MySQL using the Component Infrastructure – part 1 Extending MySQL using the Component Infrastructure – part 2: building the server Extending MySQL using the Component Infrastructure – part 3: component services Extending My [...]
Published Thursday, 13. January 2022 08:47 • 4 days ago

2.26.0 Preview Release (from Percona Community Blog)

2.26.0 Preview Release Percona Monitoring and Management 2.26.0 is now available as a Preview Release. PMM team really appreciates your feedback! 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 Notes can be [...]
Published Thursday, 13. January 2022 00:00 • 4 days ago

Wednesday, 12. January 2022

How to Prevent AWS Outages from Bringing Your Database Down (from Continuent Blog)

pYou’ve seen the recent news about AWS outages; enterprises have to think about where their physical AWS data centers are and treat them as a single point of failure. As such, enterprises running business-critical and mission-critical applications are accounting for geography of public cloud resources in their business-continuity plans. Learn about a solution for continuous operations for your MySQ [...]
Published Wednesday, 12. January 2022 15:26 • 4 days ago

CodeIgniter 4 Query Helper getLastQuery() method – MySQL Prototyping (from Digital Owl's Prose)

pI’m resharing a post I first published over on my Medium account for interested readers here. As you know, SQL is my passion and sweet spot. But, I also have an affinity for PHP and CodeIgniter. Continue reading and learn how I prototype Query Builder patterns in CodeIgniter 4… CodeIgniter 4 Query Helper methods I […]/p pThe post CodeIgniter 4 Query Helper getLastQuery() method & [...]
Published Wednesday, 12. January 2022 12:00 • 4 days ago

Extending MySQL using the Component Infrastructure – part 5: privileges (from lefred's blog)

This post is the fifth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: Extending MySQL using the Component Infrastructure – part 1 Extending MySQL using the Component Infrastructure – part 2: building the server Extending MySQL using the Component Infrastructure – part 3: component services Extending My [...]
Published Wednesday, 12. January 2022 08:02 • 5 days ago

Tuesday, 11. January 2022

MariaDB Deadlocks (from Shinguz's Blog)

pWe get ever and ever again customer requests concerning Deadlocks. First of all, Deadlocks are usually an application problem, not a database problem! The database itself manifests the application problem with the following message which is sent to the application as an error:/p pre ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction /prebrpIf your application r [...]
Published Tuesday, 11. January 2022 14:18 • 5 days ago

Online DDL With Group Replication in MySQL 8.0.27 (from Percona Database Performance Blog)

♦In April 2021, I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented.  Anyhow, in that article I have shown how an online DDL was de facto locking the […] [...]
Published Tuesday, 11. January 2022 13:25 • 5 days ago

Online DDL with Group Replication In MySQL 8.0.27 (from TusaCentral - MySQL Blogs)

pLast April 2021 I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented. /p pAnyhow, in that article I have shown how an online DDL was de facto locking the whole cluster for a very long time even when using the consistency level set to EVENTUAL./p pThis art [...]
Published Tuesday, 11. January 2022 13:04 • 5 days ago

MariaDB in 2021 (from MariaDB Foundation Blog)

pAt Vettabase we support various databases,and in particular we are MariaDB enthusiasts. Even more, we’re proud to be MariaDB Foundation Technology Partners. So I’m happy to write this small wrap-up about the MariaDB Foundation public activities in 2021! … /p pContinue reading \"MariaDB in 2021\"/p pThe post MariaDB in 2021 appeared first on MariaDB.org./p [...]
Published Tuesday, 11. January 2022 12:55 • 5 days ago

Extending MySQL using the Component Infrastructure – part 4: error logging (from lefred's blog)

This post is the fourth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: Extending MySQL using the Component Infrastructure – part 1 Extending MySQL using the Component Infrastructure – part 2: building the server Extending MySQL using the Component Infrastructure – part 3: component services Extending M [...]
Published Tuesday, 11. January 2022 08:53 • 6 days ago

Vitess Schema Tracking (from Vitess)

What is Schema Tracking? # In a distributed relational database system, like Vitess, a central component is responsible for serving queries across multiple shards. For Vitess, it is VTGate. One of the challenges this component faces is being aware of the underlying SQL schema being used. This awareness facilitates query planning. Table schemas are stored in MySQL’s information_schema, meaning that [...]
Published Tuesday, 11. January 2022 00:00 • 6 days ago

Monday, 10. January 2022

Differential Flame Graphs to Highlight Performance Schema Waits Impact (from MySQL Entomologist (former?) Blog)

pYet another type of flame graphs that I had not discussed yet is a differential flame graph (again invented by Brendan Gregg). It shows the difference of two flame graphs in a clear way (assuming they are comparable - it's on you to make sure comparison makes sense and interpret the output properly). The flame graph is drawn using the "after" profile (such that the frame widths show values for th [...]
Published Monday, 10. January 2022 20:03 • 6 days ago | Updated Monday, 10. January 2022 20:09 • 6 days ago

UTF8MB4 (from Die wunderbare Welt von Isotopp)

pOn Twitter, Jan Wildeboer linked an article by Adam Hooper on MySQL and the weird codeutf8mb4/code character set./p pThe recommendation is correct:/p pIn MySQL, use codeutf8mb4/code when you mean to work with codeutf8/code in your programming language./p pThe background and reasoning for this (and why it is wrong) is way more complicated than outlined by Adam Hooper. So let’s walk throug [...]
Published Monday, 10. January 2022 15:28 • 6 days ago

MySQL “No space left on device from storage engine” (from Mydbops Blog)

We have planned for archiving the data to improve the DB performance and to reclaim the space. We were evaluating Compression in InnoDB and TokuDB. To find out the best compression method. We started benchmarking the compression ratio between InnoDB and TokuDB. Everything goes well for some time, but after a few hours got an … Continue reading MySQL “No space left on device from storag [...]
Published Monday, 10. January 2022 14:44 • 6 days ago

MySQL 8.0 Functional Indexes (from Percona Database Performance Blog)

♦Working with hundreds of different customers I often face similar problems around running queries. One very common problem when trying to optimize a database environment is index usage. A query that cannot use an index is usually a long-running one, consuming more memory or triggering more disk iops. A very common case is when a […] [...]
Published Monday, 10. January 2022 13:24 • 6 days ago

OpenLamp.tech issue #8 (from Digital Owl's Prose)

pIt’s that time once again. I’ve published another issue of OpenLamp.tech, the newsletter for PHP/MySQL developers, over the weekend with all the curated content for your reading experience. There is plenty to learn for everyone so dig in… I start my day every day with Refind. You should too. This week in the OpenLamp.tech newsletter, […]/p pThe post OpenLamp.tech issue #8 a [...]
Published Monday, 10. January 2022 12:00 • 6 days ago

Extending MySQL using the Component Infrastructure – part 3: component services (from lefred's blog)

This post is the third post of a series of articles on extending MySQL with the Component Infrastructure: Extending MySQL using the Component Infrastructure – part 1 Extending MySQL using the Component Infrastructure – part 2: building the server Extending MySQL using the Component Infrastructure – part 3: component services Extending MySQL using the Component Infrastructure – part 4: error logging [...]
Published Monday, 10. January 2022 07:13 • 7 days ago

Saturday, 08. January 2022

Visualizing MySQL Plan Execution Time With Flame Graphs (from MySQL Entomologist (former?) Blog)

pIn the previous post I've already shown one non-classical but useful application of flame graphs as a visualization of something interesting for MySQL DBAs (besides usual stack traces from profilers), time spent on waits or even statements execution by stages with related waits as reported by performance_schema. Today I am going to abuse the tools even more and try to show the real impact of each [...]
Published Saturday, 08. January 2022 20:20 • 8 days ago | Updated Saturday, 08. January 2022 20:20 • 8 days ago

Friday, 07. January 2022

Extending MySQL using the Component Infrastructure – part 2: building the server (from lefred's blog)

This post is the second post of a series of articles on extending MySQL with the Component Infrastructure: Extending MySQL using the Component Infrastructure – part 1 Extending MySQL using the Component Infrastructure – part 2: building the server Extending MySQL using the Component Infrastructure – part 3: component services Extending MySQL using the Component Infrastructure – part 4: error loggin [...]
Published Friday, 07. January 2022 11:41 • 9 days ago

Thursday, 06. January 2022

Visualizing Performance Schema Events with Flame Graphs (from MySQL Entomologist (former?) Blog)

pHappy New Year 2022, dear readers! It's not the first time I am writing something about or illustrate some points with a flame graph. No wonder. Flame graph concept and related tools by Brendan Gregg provide a great way for visualizing metrics in any nested hierarchies, with function calls stacks being just the most popular and known example of them./ppIn this new blog post that I am writing while [...]
Published Thursday, 06. January 2022 20:52 • 10 days ago | Updated Thursday, 06. January 2022 20:52 • 10 days ago

De-Mystifying Tungsten Cluster Topologies, Part 2: CAA vs. MSAA (from Continuent Blog)

pIn this short post we will highlight the key differences between Multi-Site Active/Active (MSAA) and Composite Active/Active (CAA) topologies. The core principle behind an active/active topology is that you have more than one writable cluster. So why do we have more than one type of Active/Active topology?/p Tags: active/activeMySQLMariaDB [...]
Published Thursday, 06. January 2022 20:04 • 10 days ago

From SQL to Redis Searches: an introduction (from MORTENSI)

pIn my previous post I shared a few methods to export a table from MySQL (or any other relational database) and import the rows into Redis Server in the form of Redis Hashes, which is a convenient Redis data structure for this purpose. Now the next step is understanding how to operate with this Redis […]/p pThe post From SQL to Redis Searches: an introduction appeared first on mortensi./p [...]
Published Thursday, 06. January 2022 17:31 • 10 days ago

Extending MySQL using the Component Infrastructure – part 1 (from lefred's blog)

This post is the first post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: Extending MySQL using the Component Infrastructure – part 1 Extending MySQL using the Component Infrastructure – part 2: building the server Extending MySQL using the Component Infrastructure – part 3: component services Extending My [...]
Published Thursday, 06. January 2022 16:34 • 10 days ago

Wednesday, 05. January 2022

In Application and Database Design, Small Things Can Have a Big Impact (from Percona Database Performance Blog)

♦With modern application design, systems are becoming more diverse, varied and have more components than ever before. Developers are often forced to become master chefs adding the ingredients from dozens of different technologies and blending them together to create something tasty and amazing. But with so many different ingredients, it is often difficult to understand […] [...]
Published Wednesday, 05. January 2022 14:27 • 11 days ago

Comparing AMD EPYC Performance with Intel Xeon in GCP (from Percona Database Performance Blog)

♦Recently we were asked to check the performance of the new family of AMD EPYC processors when using MySQL in Google Cloud Virtual Machines. This was motivated by a user running MySQL in the N1 machines family and willing to upgrade to N2D generation considering the potential cost savings using the new AMD family.  The […] [...]
Published Wednesday, 05. January 2022 13:11 • 11 days ago

My Friendly Medium List (from Digital Owl's Prose)

pHey everyone, I’m creating a dedicated page of ‘Friend links‘ for all of my Medium first articles and blogs. Continue reading to learn more and how to gain access to them… Medium’s Friend Link If you’re a paying Medium member, not only can you read unlimited blog posts by any author on the platform, but […]/p pThe post My Friendly Medium List appeared firs [...]
Published Wednesday, 05. January 2022 12:00 • 11 days ago

Tuesday, 04. January 2022

MySQL Track at SCaLE 19x (from PHP With MySQL)

p SCaLE 19X – the 19th annual Southern California Linux Expo – will take place  March 3-6, 2022 in Pasadena, CA. /ppSCaLE is the largest community-run open-source and free software conference in North America. It is held annually in the greater Los Angeles area.  A year might have been skipped due to Covid-19 but it looks like we will be back in person this year.  /p♦b [...]
Published Tuesday, 04. January 2022 19:48 • 12 days ago | Updated Tuesday, 04. January 2022 19:48 • 12 days ago

Failover comparison in Aurora MySQL 2.10.0 using proxySQL vs Aurora’s cluster endpoint (from ProxySQL Blog)

p  Aurora cluster promises a high availability solution and seamless failover procedure. However, how much is actually the downtime when a failover happens? And how proxySQL can help in minimizing the downtime ? A little sneak peek on the results ProxySQL achieves up to 25x less downtime and the impressive up to ~9800x less errors [...]/p pThe post Failover comparison in Aurora MySQL 2.10.0 using p [...]
Published Tuesday, 04. January 2022 15:58 • 12 days ago

Percona Server for MySQL Encryption Options and Choices (from Percona Database Performance Blog)

♦Security will always be a main focal point of a company’s data. A common question I get from clients is, “how do I enable encryption?” Like every good consulting answer, it depends on what you are trying to encrypt. This post is a high-level summary of the different options available for encryption in Percona Server […] [...]
Published Tuesday, 04. January 2022 15:03 • 12 days ago

Backup MySQL for Fun and Profit! (from Continuent Blog)

pSo we’ve established how important backups are, RTO, RPO, and how you can be a hero by having backups that align with business objectives. We just need to pick a good backup tool(s) to take backups of your MySQL database. Databases evolve, grow, and business needs change. That’s why it is important to constantly reevaluate your backup strategy, because what worked last year may not be appropriate [...]
Published Tuesday, 04. January 2022 14:40 • 12 days ago

Taking a Look at BTRFS for MySQL (from Percona Database Performance Blog)

♦Following my post MySQL/ZFS Performance Update, a few people have suggested I should take a look at BTRFS (“butter-FS”, “b-tree FS”) with MySQL. BTRFS is a filesystem with an architecture and a set of features that are similar to ZFS and with a GPL license. It is a copy-on-write (CoW) filesystem supporting snapshots, RAID, and […] [...]
Published Tuesday, 04. January 2022 12:06 • 12 days ago

Monday, 03. January 2022

FOSDEM 2022 MySQL devroom schedule (from FOSDEM MySQL & Friends Devroom)

The schedule of the MySQL Devroom 2022 is now published: here. Thank you to everyone who submitted a talk. As usual we received more submissions than available slots. Title Speaker Start Encrypting binary (and relay) logs in MySQL Matthias C 9:00 Flame Graphs for MySQL DBAs Valerii Kravchuk 9:30 Hash join in MySQL 8.0 Øystein […] [...]
Published Monday, 03. January 2022 10:42 • 13 days ago

Friday, 31. December 2021

Percona Support Team New Year Greetings! (from Percona Database Performance Blog)

♦In Percona Support we spend a few hours per week doing Labs: short collective projects, not directly related to the tickets. One of our last labs was about to get ready for the winter holiday season which means preparing the tree and decorating it. To do it we used our favorite tools: MySQL, and ASCII […] [...]
Published Friday, 31. December 2021 16:06 • 16 days ago

Wednesday, 29. December 2021

Q & A on Webinar “MySQL Performance for DevOps” (from Percona Database Performance Blog)

♦First I want to thank everyone who attended my November 16, 2021 webinar “MySQL Performance for DevOps“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide during the webinar. Q: Hi! We have troubles with DELETE queries. We have to […] [...]
Published Wednesday, 29. December 2021 12:30 • 18 days ago

Pedal to the metal or what else can speedup your CPU-bound application? (from MySQL Performance Blog)

A story about using huge pages to boost MySQL performance [...]
Published Wednesday, 29. December 2021 12:00 • 18 days ago

5 PHP Date Functions and Their MySQL Equivalents (from Digital Owl's Prose)

pAnyone working with data is going to encounter date values at some point. Dates are necessary for many reasons. If you’re a PHP/MySQL Developer, you have date function options for both the database and your programming language of choice. In this post, I cover 5 PHP date functions and their (somewhat) MySQL equivalents with examples […]/p pThe post 5 PHP Date Functions and Their MySQL [...]
Published Wednesday, 29. December 2021 12:00 • 18 days ago

Tuesday, 28. December 2021

Migrate a MySQL Table to Redis (from MORTENSI)

pIn this post I will list a few options to migrate a table from MySQL to Redis logically. I will run examples using the classical world database. The world database can be downloaded here, so if you would like to try the examples, just import it in your MySQL instance. There are several ways to […]/p pThe post Migrate a MySQL Table to Redis appeared first on mortensi./p [...]
Published Tuesday, 28. December 2021 22:38 • 19 days ago

Check Your Current MySQL Version in 6 Ways (from Devart MySQL Tool Blog)

pMySQL is an extremely popular open-source RDMS, and it’s widely used by millions of companies and professionals. In this article, you will learn how to check the current MySQL version, and how to update it if necessary. Contents Why do you need to know your MySQL version? Different ways how to get your MySQL version […]/p pThe post Check Your Current MySQL Version in 6 Ways appeared first on [...]
Published Tuesday, 28. December 2021 13:35 • 19 days ago

Adaptive Thread Pool: Improving MySQL Scalability With AI (from MySQL Performance Blog)

In our previous blog post we discussed the purpose of a thread pool, various approaches to implementing a thread pool, along with a simulation model describing thread pool implementations in MariaDB and Percona Server. In this post we will look into another methodology of tuning the thread pool size, namely the adaptive Hill Climbing algorithm. [...]
Published Tuesday, 28. December 2021 12:00 • 19 days ago

How To Gracefully Stop and Start Tungsten Clusters (from Continuent Blog)

pAs system administrators, we are called upon to be responsible for a vast quantity of discrete subsystems, each with its own set of operating rules. When starting and stopping any subsystem, it is the best practice to do so gracefully whenever possible to ensure data integrity. In this blog post, we detail the best practices for stopping and starting a Tungsten Cluster./p Tags: MySQLMariaDBsy [...]
Published Tuesday, 28. December 2021 08:14 • 20 days ago

Monday, 27. December 2021

Building out the MySQL InnoDB ClusterSet for High Availability & Disaster Recovery in a fully supported Platform (from Select All From MySQL)

InnoDB Cluster has been around for what feels like a long time. It is the core platform for MySQL High Availability. InnoDB Cluster NOW extends that core feature into a platform that also enables DR support where multiple Disaster Recovery Regions are capable. [...]
Published Monday, 27. December 2021 19:45 • 20 days ago

Trick to Simulate a Linux Server with less RAM (from J-F Gagné's MySQL Blog)

I created the first draft of this post many years ago.  At that time, I was working with physical servers having 192 GB of RAM or more.  On such systems, doing memory pressure tests with MySQL is complicated.  I used a trick to simulate a Linux server with less RAM (also works with vms, probably not with Kubernetes or containers).  I recently needed the trick again and as I will refer to it in a [...]
Published Tuesday, 14. December 2021 00:49 • 1 months ago | Updated Monday, 27. December 2021 15:47 • 20 days ago

Efficient MySQL Performance (from Hack MySQL)

pAfter 17 years with MySQL, I wrote a book: Efficient MySQL Performance./p pI’ll make a bold claim: a MySQL book like this has never been written—not even close. The preface explains why this book is unique:/p [...]
Published Monday, 27. December 2021 14:30 • 20 days ago

Backup Performance Comparison: mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup (from Percona Database Performance Blog)

♦In this blog post, we will compare the performance of performing a backup from a MySQL database using mysqldump, MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. All these available options are open source and free to use for the entire community. To start, let’s see the results of the test. Benchmark […] [...]
Published Monday, 27. December 2021 13:30 • 20 days ago

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

We are merry & galvanized for bestowing seeds of cognizance to our opensource database community. Thank you to all those who attended in our 12th edition of MyWebinar.  We hope our session was able to elevate & seam your workmanship to perfection. We are committed in giving back to our opensource database community by hosting more … Continue reading Synopsis of Mydbops 12th edition of [...]
Published Monday, 27. December 2021 12:29 • 20 days ago

How to replace `docker` with `podman` for PMM development (from Percona Community Blog)

What is Podman? Podman is a daemonless container engine for developing, managing, and running OCI (Open Container Initiative) Containers on your Linux System. Containers can either be run as root or in rootless mode. More details here. Check out also Kubernetes Podcast to learn more about podman and listen to it’s creators. Why to replace? Especially in development I need simplest possible so [...]
Published Monday, 27. December 2021 00:00 • 21 days ago

Sunday, 26. December 2021

Spinning in the Cloud: How to Fix MySQL 8.0 Log Commit for Containers (from MySQL Performance Blog)

If you are running MySQL as a Kubernetes pod or a Docker container, there is a chance you are using CPU quota to limit its resource usage. Which is also typical for cloud environments. But do you know what kind of issues you may see when running MySQL in environments like that? [...]
Published Sunday, 26. December 2021 21:00 • 21 days ago

Connect to Redis with Python (from MORTENSI)

pPython clients you can use to connect to a Redis Server are listed in the documentation. I personally use redis-py, but Redis the company has just released Redis OM for Python, so I think it is worth to have a look. I will share here basic instructions to connect to a Redis Server and test […]/p pThe post Connect to Redis with Python appeared first on mortensi./p [...]
Published Sunday, 26. December 2021 00:59 • 22 days ago

Friday, 24. December 2021

Understand, Setup and Test a Redis Cluster in less than 10 minutes (from MORTENSI)

pYou already know how to setup a Redis Server in a few seconds following my advices in this post, now it’s time to think big and learn how to scale a Redis Server. Let’s start with a quote from the documentation. Redis is, mostly, a single-threaded server from the POV of commands execution (actually modern […]/p pThe post Understand, Setup and Test a Redis Cluster in less than 10 [...]
Published Friday, 24. December 2021 00:14 • 24 days ago

MariaDB threadpool and NUMA scalability (from MySQL On ARM)

MariaDB/MySQL default uses one thread per connection. This approach is generally good if the connection is active for a longer time. If the connections are short-lived then the cost of creating a connection could overshadow the cost of running the query. Also, with increasing scalability, OS-scheduling introduces more jitter. In this case, threadpool could act as a good alternative. [...]
Published Friday, 24. December 2021 00:00 • 24 days ago

Thursday, 23. December 2021

Vision: Continuent's Founder Story (from Continuent Blog)

pRemember what 2001 looked like from a technology point of view? In this vlog, the Founder and CEO of Continuent, industry veteran Eero Teerikorpi, tells the story of the beginning of Continuent, and the bold vision that got us here. Since 2001, Continuent has pioneered the need for cloud-savvy business-critical MySQL databases that are platform-agnostic, highly-available, and globally-scaling./p T [...]
Published Thursday, 23. December 2021 08:48 • 25 days ago

10.8 preview feature: IN, OUT, INOUT, IN OUT parameters in CREATE FUNCTION (from MariaDB Foundation Blog)

pAs an Oracle compatibility syntax extension, the IN, OUT, and INOUT / IN OUT quantifiers of stored function parameters was requested in MDEV-10654. … /p pContinue reading \"10.8 preview feature: IN, OUT, INOUT, IN OUT parameters in CREATE FUNCTION\"/p pThe post 10.8 preview feature: IN, OUT, INOUT, IN OUT parameters in CREATE FUNCTION appeared first on MariaDB.org./p [...]
Published Thursday, 23. December 2021 04:16 • 25 days ago

Percona Supports Community Events - Organize Yours With Us! (from Percona Community Blog)

One of the things we love doing in Percona is participating in community events and inspiring people to stay connected in the changing world. We have experience in organizing community dinners, meetups, lectures at universities, booths, and even conferences both in-person and virtually. Percona speakers give talks on events all around the globe. Have you ever thought about organizing a themed meeti [...]
Published Thursday, 23. December 2021 00:00 • 25 days ago

Wednesday, 22. December 2021

Merry Christmas from the RonDB team (from Mikael Ronstrom)

p This year we bring a new christmas present in the form of a new release of RonDB 21.04./ppIt is packed with improvements, our focus has been on extending support for more platforms while at the same time increasing the quality of RonDB./ppNormally the RonDB 21.04.2 would have been released in October 2021. However we had a number of support issues where we had crashes due to running very lar [...]
Published Wednesday, 22. December 2021 22:37 • 25 days ago | Updated Wednesday, 22. December 2021 22:38 • 25 days ago

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

pFollowing up on our announcement of the new release model, first used in 10.7.0, we are pleased to announce that the MariaDB Server 10.8.0 preview releases are now available. … /p pContinue reading \"MariaDB 10.8.0 preview releases now available\"/p pThe post MariaDB 10.8.0 preview releases now available appeared first on MariaDB.org./p [...]
Published Wednesday, 22. December 2021 16:51 • 25 days ago

CodeIgniter 4 Query Builder set() function with update() (from Digital Owl's Prose)

pCodeIgniter 4 Query Builder class has an update() function used to process UPDATE Data Manipulation Language (DML) commands. Using update() as a standalone function call is perfectly valid. However, there is also a set() function used for setting column values as you would with the SET keyword in an SQL UPDATE statement. Used in conjunction […]/p pThe post CodeIgniter 4 Query Builder set() f [...]
Published Wednesday, 22. December 2021 12:00 • 25 days ago

Tuesday, 21. December 2021

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

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Python 1.0.9 GA release. Download Now Release Notes MariaDB … Continued [...]
Published Tuesday, 21. December 2021 15:23 • 26 days ago

Monday, 20. December 2021

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

pWe are pleased to announce that Tungsten Clustering and Tungsten Replicator GA versions 6.1.16 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: [...]
Published Monday, 20. December 2021 16:18 • 27 days ago

OpenLamp.tech issue #6 (from Digital Owl's Prose)

pHey all good folks! I’ve published another issue of your favorite newsletter, OpenLamp.tech, the newsletter for PHP/MySQL developers. This issue (like all the rest) is loaded with fantastic curated content. Enjoy and do share with others! I enjoy writing and curating the OpenLamp.tech newsletter. If you would like to support my efforts and you are […]/p pThe post OpenLamp.tech issue #6 [...]
Published Monday, 20. December 2021 12:00 • 27 days ago

Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave ! (from lefred's blog)

This post is the third and last of a series of articles dedicated to MySQL Database Service (MDS): Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave ! The goal of this series if to get familiar with MDS, HeatWave and useful M [...]
Published Monday, 20. December 2021 07:00 • 28 days ago

PMM development and testing with help of minikube (from Percona Community Blog)

Why Some time ago I needed to test PG14 with the new pg_stat_monitor version that wasn’t released. I decided to log my journey so I would spend less effort next time to replicate it. I do use podman and run PMM with its help but I also like to hack PMM DBaaS features and think that k8s and minikube are perfect and better scalable solutions for the different development environments and especi [...]
Published Monday, 20. December 2021 00:00 • 28 days ago

Friday, 17. December 2021

High Performance MySQL - How to Scale Tungsten Clusters (from Continuent Blog)

pRecently, a Continuent customer asked: “What is your approach for scaling up MySQL clusters for a higher number of queries per second and larger data sets?” Scaling, like availability, is a multifaceted question. In this blog post we will detail and discuss the best practices for scaling Tungsten Clusters./p Tags: scalinglarge data setsMySQLMariaDB [...]
Published Friday, 17. December 2021 20:11 • 1 months ago

Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System (from lefred's blog)

This post is the second of a series of articles dedicated to MySQL Database Service (MDS): Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave ! The goal of this series if to get familiar with MDS, HeatWave and useful MySQL She [...]
Published Friday, 17. December 2021 18:14 • 1 months ago

Difference Between SQL and NoSQL: Complete Tutorial (from Devart MySQL Tool Blog)

pSQL databases have been in use for many decades—and surely they will be in use for many years into the future. In this guide, we will cover the major differences between SQL and NoSQL databases, highlight the pros and cons of the two, and outline the best database tools. Contents What is a SQL database? What is a […]/p pThe post Difference Between SQL and NoSQL: Complete Tutor [...]
Published Friday, 17. December 2021 09:47 • 1 months ago

Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System (from lefred's blog)

This post is the first of a series of articles dedicated to MySQL Database Service (MDS): Using MySQL Database Service in OCI – Part 1: creating a MySQL DB System Using MySQL Database Service in OCI – Part 2: importing Data to MySQL DB System Using MySQL Database Service in OCI – Part 3: faster with MySQL HeatWave ! The goal of this series if to get familiar with MDS, HeatWave and useful MySQL Shel [...]
Published Friday, 17. December 2021 09:02 • 1 months ago

Tricky Problems? MariaDB debug container (from MariaDB Foundation Blog)

pMariaDB does have bugs. Users see them sometimes. Sometimes developers look for a long time at bug reports and code and still cannot see how the situation occurred. … /p pContinue reading \"Tricky Problems? MariaDB debug container\"/p pThe post Tricky Problems? MariaDB debug container appeared first on MariaDB.org./p [...]
Published Friday, 17. December 2021 03:02 • 1 months ago

New Service – quay.io/mariadb-foundation/mariadb-devel (from MariaDB Foundation Blog)

pDuring the development of MariaDB, a lot of things are tested. However the most important workload to be tested is the one we don’t have access to, and that is your workload. … /p pContinue reading \"New Service – quay.io/mariadb-foundation/mariadb-devel\"/p pThe post New Service – quay.io/mariadb-foundation/mariadb-devel appeared first on MariaDB.org./p [...]
Published Friday, 17. December 2021 00:40 • 1 months ago

Log4j RCE 0-day Mitigation (from Vitess)

Background # A critical vulnerability CVE-2021-44228 in the Apache Log4j logging library was disclosed on Dec 9. The project provided release 2.15.0 with a patch that mitigates the impact of this CVE. It was quickly found that the initial patch was insufficient, and an additional CVE CVE-2021-45046 followed. This has been fixed in release 2.16.0. Who is affected? # The bulk of vitess code is in gol [...]
Published Friday, 17. December 2021 00:00 • 1 months ago

Thursday, 16. December 2021

Introducing Alejandro Duarte: Developer Advocate – Cloud Apps / DevOps (from MariaDB Corporation Blog)

Hello, World!  My name is Alejandro Duarte, and I recently joined the Developer Relations team at MariaDB—a team that focuses … Continued [...]
Published Thursday, 16. December 2021 18:55 • 1 months ago

Rails that scales - Powered by Vitess (from Vitess)

Past - Frameworks without scale # Over the past couple of decades, there has been a steady rise in the complexity of the development stacks that the developers across the globe have been using. The web has advanced from being just HTML files, to also include CSS and JavaScript with their own multitudes of frameworks like Redwood, Next.js, and Angular, among many others. The number of library depend [...]
Published Thursday, 16. December 2021 00:00 • 1 months ago

Tuesday, 14. December 2021

MariaDB Enterprise Server 10.6.5-2, and others, now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Enterprise Server 10.6.5-2, 10.5.13-9, 10.4.22-14, 10.3.32-14, and 10.2.41-14. See the … Continued [...]
Published Tuesday, 14. December 2021 21:00 • 1 months ago

Is the MariaDB JDBC driver affected by the Log4j vulnerability? (from MariaDB Corporation Blog)

Is the MariaDB Java connector affected by the security vulnerability recently discovered in Log4? By default, the Java connector does … Continued [...]
Published Tuesday, 14. December 2021 18:44 • 1 months ago

Log4Shell and MariaDB (CVE-2021-44228) (from MariaDB Corporation Blog)

Several MariaDB customers have asked us about CVE-2021-44228 aka “Log4Shell”, a vulnerability in the Log4j Java logging framework which may … Continued [...]
Published Tuesday, 14. December 2021 18:44 • 1 months ago

How to Use Rsync to Provision a Tungsten Cluster Node (from Continuent Blog)

pIn this blog post we examine in depth how to best provision one MySQL database cluster node from another using rsync. Since there are many possible ways to handle provisioning by rsync, we will do multiple posts on the topic, starting with the most basic - both the source and target database nodes are fully offline for the duration of the rsync. While this is not an ideal scenario because two node [...]
Published Tuesday, 14. December 2021 14:08 • 1 months ago

TiDB Operator Source Code Reading (V): Backup and Restore (from TiDB and TiKV Blog)

This post explains the design and implementation of the backup and restore features provided by TiDB Operator. You'll learn about the core logic of three related controllers and the backup-manager. [...]
Published Tuesday, 14. December 2021 00:00 • 1 months ago

Monday, 13. December 2021

MariaDB: WITH TIES syntax (from Vettabase)

pSemantics and use cases of the WITH TIES syntax. Continue reading MariaDB: WITH TIES syntax→/p pThe post MariaDB: WITH TIES syntax appeared first on Vettabase./p [...]
Published Monday, 13. December 2021 12:41 • 1 months ago

Handling case sensitive column in pt-archiver (from Mydbops Blog)

To copy the data of the particular column of the table to another table/server, We have an option to export the data as CSV and import the data back to a different table. But when the table size is large and we need to copy the data only for the required data to the target … Continue reading Handling case sensitive column in pt-archiver → [...]
Published Monday, 13. December 2021 12:21 • 1 months ago

OpenLamp.tech issue #5 (from Digital Owl's Prose)

pHey hey! I’ve published another issue of OpenLamp.tech, the newsletter for PHP/MySQL developers over the weekend. Come and enjoy the great content!!! As always, I’ve curated some great reads this week for us all. I’d love it if you could help spread the word by sharing these posts with others who will value the newsletter […]/p pThe post OpenLamp.tech issue #5 appeared firs [...]
Published Monday, 13. December 2021 12:00 • 1 months ago

Sunday, 12. December 2021

Read CSV with Python (from MacLochlainns Weblog)

In 2009, I showed an example of how to use the MySQL LOAD DATA INFILE command. Last year, I updated the details to reset the secure_file-priv privilege to use the LOAD DATA INFILE command, but you can avoid that approach with a simple Python 3 program like the one in this example. You also can […] [...]
Published Sunday, 12. December 2021 07:17 • 1 months ago

Saturday, 11. December 2021

MariaDB Announces New Innovation Release Model (from MariaDB Foundation Blog)

pQuarterly release structure delivers new features to the community fasterbr REDWOOD CITY, Calif. and HELSINKI – December 9, 2021 – MariaDB Corporation Ab and MariaDB Foundation today announced a new release model for MariaDB Server, by MariaDB Corporation referred to as MariaDB Community Server, centered on the goal of delivering new features and innovation fas [...]
Published Saturday, 11. December 2021 15:31 • 1 months ago

Three ways to patch Log4Shell CVE-2021-44228 vulnerability (from Geeky Hacker - Coding, Tech & Linux)

pAs you may have heard over the news, a new vulnerability (CVE-2021-44228) was discovered in Log4j 2 library by Alibaba. This zero-day vulnerability allows remote code execution and potentially affect [...]/p pThe post Three ways to patch Log4Shell CVE-2021-44228 vulnerability appeared first on Geeky Hacker./p [...]
Published Saturday, 11. December 2021 14:50 • 1 months ago

Friday, 10. December 2021

A look into Percona XtraDB Cluster Non Blocking Operation for Online Schema Upgrade (from TusaCentral - MySQL Blogs)

pPercona XtraDB Cluster 8.0.25 has introduced a new option to perform online schema modifications: NBO (Non Blocking Operation)./p pWhen using PXC the cluster relies on wsrep_OSU_method parameter to define the Online Schema Upgrade (OSU) method the node uses to replicate DDL statements.  ♦/p pUntil now we normally have 3 options:/p ul liUse Total Isolation Order (TOI, the default)/li liUs [...]
Published Friday, 10. December 2021 10:00 • 1 months ago

Using MySQL Shell to generate table’s create statement from CSV file (from lefred's blog)

Recently, I wrote several articles on how to load data from CSV files to migrate from different databases to MySQL Database Service: How to import data from PostgreSQL to MySQL Database Service How to import data from Amazon Redshift to MySQL Database Service How to import data from Microsoft SQL Server to MySQL Database Service Import data from Amazon Aurora PostgreSQL to MySQL Database Service in [...]
Published Friday, 10. December 2021 09:32 • 1 months ago

Best Alternative to phpMyAdmin (from Devart MySQL Tool Blog)

pThe article provides a brief feature overview of the phpMyAdmin software and dbForge Studio for MySQL. In the article, you can find a feature comparison of both tools and see why dbForge Studio for MySQL is considered to be the best alternative to phpMyAdmin and is worthy of use. Contents What is the use of […]/p pThe post Best Alternative to phpMyAdmin appeared first on Devart Blog./p [...]
Published Friday, 10. December 2021 07:21 • 1 months ago

LFX experience (from Vitess)

I was a part of the LFX Fall Intern program working on Vitess for 2021 and it was a great learning experience for me. I got introduced to Kubernetes in my previous internship through which I came to know about CNCF and then about the LFX program (CNCF is part of the LinuxFoundation). Participating in LFX Intern program helped me develop my interest towards the internals of databases, query parsing [...]
Published Friday, 10. December 2021 00:00 • 1 months ago

Thursday, 09. December 2021

Geo-Distributed Galera Clusters (from Continuent Blog)

pGalera Cluster provides high availability and scalability for MySQL. While this provides high availability in a local region or site, it does not provide any provisions for disaster recovery (DR) or any multi-site deployment in general, so let’s explore how we could extend the functionality of Galera Cluster to deploy at geo-scale./p Tags: MySQLMariaDBgalera clusterHA [...]
Published Thursday, 09. December 2021 16:31 • 1 months ago

MariaDB Devroom at FOSDEM 2022 CfP is now open (from Shinguz's Blog)

pAlso in 2022 there will be a FOSDEM (Free and Open source Software Developers' European Meeting) on 5 and 6 February 2022. This time again online from Brussels (Belgium)./p pMariaDB has again its own Devroom and the Call for Papers (CfP) is now open for your submissions. We are looking for interesting topics about your daily business, technical presentations, war stories, point of views of manage [...]
Published Thursday, 09. December 2021 15:36 • 1 months ago

An Unprivileged User can crash your MySQL Server (from J-F Gagné's MySQL Blog)

Yes, your read the title correctly: an unprivileged user can crash your MySQL Server.  This applies for the default configuration of MySQL 8.0.21 (and it is probably the case for all MySQL 8 GA versions).  Depending on your configuration, it might also be the case for MySQL 5.7.  This needs malicious intent and a lot of determination, so no need to panic as this will not happen by accident.  I am [...]
Published Monday, 19. October 2020 01:09 • over a year ago | Updated Thursday, 09. December 2021 14:33 • 1 months ago

A Look Into Percona XtraDB Cluster Non-Blocking Operation for Online Schema Upgrade (from Percona Database Performance Blog)

♦Percona XtraDB Cluster 8.0.25 (PXC) has introduced a new option to perform online schema modifications: NBO (Non-Blocking Operation). When using PXC, the cluster relies on the wsrep_OSU_method parameter to define the Online Schema Upgrade (OSU) method the node uses to replicate DDL statements.  Until now, we normally have three options: Use Total Isolation Order (TOI, […] [...]
Published Thursday, 09. December 2021 14:32 • 1 months ago

Delivering Faster Innovation to MariaDB’s Community (from MariaDB Corporation Blog)

MariaDB Community Server is moving to a new release model that will deliver a new release series once a quarter, rather than once a year. [...]
Published Thursday, 09. December 2021 14:00 • 1 months ago

Testing Percona Distribution for MySQL Operator Locally with Kind (from Percona Database Performance Blog)

♦We have a quickstart guide for how to install Percona Distribution for MySQL Operator on minikube. Installing the minimal version works well as it is described in the guide. After that, we will have one HAproxy and one Percona XtraDB Cluster (PXC) node to work with. Minikube provides Kubernetes locally. One can try using the […] [...]
Published Thursday, 09. December 2021 13:11 • 1 months ago

MySQL Query Performance (from MacLochlainns Weblog)

Working through our chapter on MySQL views, I wrote the query two ways to introduce the idea of SQL tuning. That’s one of the final topics before introducing JSON types. I gave the students this query based on the Sakila sample database after explaining how to use the EXPLAIN syntax. The query only uses only […] [...]
Published Thursday, 09. December 2021 08:01 • 1 months ago