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.

Wednesday, 30. November 2022

MariaDB C++ Connector 1.1.2 RC now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/C++ 1.1.2 RC release. Download Now Release Notes MariaDB … Continued [...]

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 [...]

Upload Ongoing MyDumper Backups to S3 (from Percona Database Performance Blog)

♦If you are using MyDumper as your Logical Backup solution and you store your backups on S3, you need to take a local backup and then upload it to S3. But what if there is not enough space to hold the backup on the server where we are taking the backup? Even if we have […] [...]

All of the tech PlanetScale replaces (from PlanetScale Blog)

PlanetScale is more than just a drop-in replacement for MySQL. Learn about everything PlanetScale can do for you.pRead the full story/p [...]

PHP 8.0 Reaches End of Life (from Percona Database Performance Blog)

♦While the LAMP stack – Linux/Apache/MySQL/PHP – is not the dominant platform it was a decade ago, there are still many websites that depend on it. One of the pillars of this quartet had a milestone last week when PHP 8.0 passed into End Of Life status. While it will still have limited security issue […] [...]

Simulate LEAD() Window Function using correlated subquery (from Digital Owl's Prose)

pIn my honest opinion, MS Access is one garbage of a database. More likely, database is too strong of a word. While I won’t be using Access in this article, there is a story there (but I’m not here to have an Access bash party). Continue reading for an example of how you may use […]/p pThe post Simulate LEAD() Window Function using correlated subquery appeared first on Digital Owl [...]

Generate Invisible Primary Key (GIPK) MySQL 8.0 (from Mydbops Blog)

The Primary key is like the hero of a row, which has more beneficial features in the table while performing any task on the table. The DBA knows the importance of the primary key in the table and how to handle it. Notable features of having a primary key: From 8.0.30, no need to maintain … Continue reading Generate Invisible Primary Key (GIPK) MySQL 8.0 → [...]

Tuesday, 29. November 2022

Insert benchmark: Postgres, InnoDB and MyRocks with low concurrency (from Small Datum)

pThis has results for the insert benchmark using Postgres, InnoDB and MyRocks. For an overview of the insert benchmark see here and here. Some information on the performance summaries generated by my test scripts is here. I used small servers and ran the test at low concurrency (1 or 2 threads) for cached and IO-bound workloads. The insert benchmark has several phases and the interesting [...]

Small servers for performance testing, v4 (from Small Datum)

pI am setting up my fourth cluster of small servers to test open source database software. Cluster might be an overstatement because each cluster is limited to 2 or 3 servers. The clusters were/are:br/pulliv1 - Intel NUC5i3ryh (5th gen core i3), 8G RAM, SATA disk for OS, Samsun 850 EVO m.2 for db/liliv2 - Intel NUC7i5bnh (7th gen core i5), 16G RAM, Samsung 850 EVO SATA for OS, Samsung 960 EVO m.2 f [...]

MySQL Data Archival With Minimal Disruption (from Percona Database Performance Blog)

♦We all know that data is important, and some businesses need historical data to be available all the time. The problem is that queries on large tables perform poorly if they are not properly optimized. We get many customer requests in Managed Services to purge/archive large tables, and to achieve it, we use pt-archiver. Recently, […] [...]

SSM – PMM 1.x Fork with Additional Features (from Shattered Silicon Open Source Database Blog)

pSSM is a fork of PMM 1.x with additional features, updates and fixes. Notable new features in the initial release include QAN query harvesting via slow log in RDS, manual node cleanup functionality, and ARM64 builds./p pThe post SSM – PMM 1.x Fork with Additional Features appeared first on Shattered Silicon./p [...]

PMM, Federated Tables, Table Stats, and Lots of Connections! (from Percona Database Performance Blog)

♦Earlier in the year, I was working on an issue where one of my clients had reported a massive influx in connection on their hosts after enabling Percona Monitoring and Management (PMM). This was something I had not seen before and after researching for a couple of days I discovered that if you monitor a […] [...]

Howto connect to MySQL using a client certificate (from lefred's blog)

More and more people are requesting how they could connect to MySQL without using a password but using a SSL certificate. Known as X509. CA Certificate A CA certificate is a digital certificate issued by a certificate authority (CA). It’s used by clients to verify the SSL certificates sign by this CA. Such certificates is usually paid and needs to be manually installed with MySQL Server. But by def [...]

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

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

Monday, 28. November 2022

Galera Cluster for MySQL 8.0.30 released (from Galera Blog)

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.30 (release notes, download) with Galera replication library 4.13 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.30, adding a synchronous option for your MySQL High […] [...]

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

pWe have another packed issue of OpenLampTech for you this week. And, we have our first sponsor with a smashing deal to help you configure your MySQL servers with ease. Thank you Releem for partnering with OpenLampTech this week! In OpenLampTech issue #54, we have content covering: Read OpenLampTech issue #54 Want to know how […]/p pThe post OpenLampTech issue #54 – Substack Repost appe [...]

15 Best MySQL GUI Clients for macOS (from Devart MySQL Tool Blog)

pWell, we can’t argue that Windows is the key platform for database development and management software—but what if you are a Mac user? Who said you can’t have equal opportunities to set up easy daily work with, for instance, MySQL databases? Simply take a closer look and you’ll see an abundance of top-tier MySQL tools […]/p pThe post 15 Best MySQL GUI Clients for macOS appe [...]

Friday, 25. November 2022

Exploring Data Dump and Load Utility With MySQL Shell (from Percona Database Performance Blog)

♦In this blog post, I will try to cover a few dump and data-loading utilities offered by MySQL Shell. What is MySQL Shell? It is a robust client and code editor for MySQL. In addition to having APIs for dealing with MySQL, MySQL Shell offers scripting capabilities for JavaScript and Python. It provides an AdminAPI […] [...]

Thursday, 24. November 2022

Ghost Conditions For Unindexed Columns (from SQL for Devs)

Creating the correct indexes for e.g. user-defined data filtering or seldom used conditions is one of the most challenging tasks. You can't make an index for every column and must guess the most important ones. But you will still miss some resulting in slow queries. An excellent approach is adding ghost conditions to a query that are in [...]

MySQL Variables – Definition and Examples (from Devart MySQL Tool Blog)

pMySQL variables store data, label data, and let developers create more accurate and efficient code by turning long and complicated strings of characters into one simple variable. This article will explore user-defined variables. User-defined variables let us execute various data sets with one command and use this data whenever needed. Mastering variables in MySQL is […]/p pThe post MySQL Var [...]

Champs Recap: Award-Winning dbForge Products in Q2-Q4 2022 (from Devart MySQL Tool Blog)

pFollowing our previous recap that covered the awards garnered by dbForge products in Q1 2022, and a compelling selection of DBTA 2022 Readers’ Choice Awards, we believe now is the perfect moment to catch up with the rest of the year as it’s coming to a close. We have gathered all of the accolades in […]/p pThe post Champs Recap: Award-Winning dbForge Products in Q2-Q4 2022 appear [...]

Wednesday, 23. November 2022

Online DDL Tools and Metadata Locks (from Percona Database Performance Blog)

♦One thing I commonly hear when working with my clients is “I want to change my DDL strategy in order to avoid locking in my database! The last time I used the same old method I ended up in a metadata lock situation!” I agree that metadata locks can be painful, but unfortunately, it’s completely […] [...]

MySQL Dual Passwords – How To Manage Them Programmatically (from Percona Database Performance Blog)

♦What is dual password in MYSQL and how it works was already covered by my colleague Brian Sumpter in Using MySQL 8 Dual Passwords. However, let me do a brief recap here about it. Dual password is the MySQL mechanism that allows you to keep two passwords active at the same time. This feature is […] [...]

Tuesday, 22. November 2022

Troubleshooting Percona Operators With troubleshoot.sh (from Percona Database Performance Blog)

♦Percona loves and embraces Kubernetes. Percona Operators have found their way into the hearts and minds of developers and operations teams. And with growing adoption, we get a lot of valuable feedback from the community and our support organization. Two of the most common questions that we hear are: What are the best practices to […] [...]

Introducing VDiff V2 (from Vitess)

Vitess is a solution that allows you to infinitely scale MySQL while providing clients and apps with a single logical view of the fleet of MySQL instances comprising any number of Keyspaces and Shards. Vitess also provides the cluster and data management tools that make it possible to manage a massive cluster and perform complex workflows using VReplication, such as: Moving tables into Vitess or be [...]

Monday, 21. November 2022

pt-online -schema corner case: When you don’t want to replicate your alter activities across the whole cluster. (from Pythian Blog - MySQL Track)

Intro When we want to perform a heavy ALTER TABLE against  a several gigabytes table the options are quite a few but the one I tend to use the most is pt-online-schema-change (pt-osc). This tool is very mature and solid... [...]

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

pNow that OpenLampTech is one year old, I have a point to prove. That I can consistently provide the MySQL, PHP, and LAMP stack communities with a valuable newsletter publication. Challenge accepted. This week’s issue is full of great content so give it a read! 📚 In OpenLampTech issue #53, we have some fantastic content […]/p pThe post OpenLampTech issue #53 – Substack Repost appe [...]

AlmaLinux MySQL Workbench (from MacLochlainns Weblog)

AlmaLinux doesn’t natively support MySQL Workbench but these notes will help you install it. The great news is that MySQL Workbench works perfectly once you’ve installed all the dependent libraries. It’ll look like the following: Disclaimer of sorts: AlmaLinux is an open-source, community-driven project that intends to fill the gap left by the demise of […] [...]

MongoDB Rule for Indexing (Series: 1) (from Mydbops Blog)

Any database must have an index, thus MongoDB is not exceptional in this regard. MongoDB features a tonne of interesting index types with fantastic properties based on the use cases it was created for. It has been a very long time since I considered writing a series of blogs about the MongoDB index at all … Continue reading MongoDB Rule for Indexing (Series: 1) → [...]

Sunday, 20. November 2022

Fedora 37 – some packages I built (from lefred's blog)

Today I upgraded my home computers to Fedora 37. I’m using some software that don’t have any rpm available for Fedora 37. Some of these applications, I used them every day and I couldn’t work on my machine without them. Hamster is one of them, I use it for time tracking. However the project seems to not be maintained for some time. I use it with the Gnome-Shell extension too. I also regularly use s [...]

MySQL IOPS for Reads and Surprsies (from Hack MySQL)

When you think about IOPS, you probably think about writes because MySQL write I/O has a long tradition of optimization, benchmarking, new algorithms, new storage engines, and so forth. There’s no shortage of material on MySQL write I/O; just two examples from Percona are Scaling IO-Bound Workloads for MySQL in the Cloud and Tuning MySQL/InnoDB Flushing for a Write-Intensive Workload. But in [...]

ETL from a Django Model (from Die wunderbare Welt von Isotopp)

pContinued from last weeks article on data warehouses./p pAt work, I was tasked with building a capacity model for data center growth. The basic assumption of these things is often that the future behaves similarly to the past, so the future predicted capacity model is somehow an extension of past growth. I needed old server usage data, and was indeed able to find that in one of our systems, call [...]

Saturday, 19. November 2022

SSD read response time: raw device vs a filesystem (from Small Datum)

pI am trying to understand why 4kb random reads from an SSD are about 2X slower when using a filesystem vs a raw device and this reproduces across different servers but I am only sharing the results from my home Intel NUCs. The symptoms are, the read response time is:br/pulli~2X larger per iostat's r_await for reads done via a filesystem vs a raw device (.04 vs .08 millisecs)/lili~3X larger per blk [...]

Friday, 18. November 2022

PlanetScale and HIPAA (from PlanetScale Blog)

PlanetScale can now enter into Business Associate Agreements (BAA) with Single-tenant customers.pRead the full story/p [...]

Making Your MySQL Backup Process up to 17X Faster – Introducing Percona XtraBackup Smart Memory Estimation (from Percona Database Performance Blog)

♦Taking a MySQL backup using Percona XtraBackup (PXB) consists of basically two steps: 1) take the backup and 2) prepare the backup. Briefly speaking, taking a backup means that PXB will copy all of the files from your instance and transfer them to another location. While it does the copy, it spawns a thread that […] [...]

Comparing Optimizer Results (from Shinguz's Blog)

pA while ago I read a paper about Optimizer Benchmarks: How Good Are Query Optimizers, Really? by Viktor Leis from Fakultät für Informatik of the Technische Universität München./p Because we have from time to time problems with slow queries of customers especially after upgrading to new database releases it is interesting for me, how different optimizers cope with a query. Sometimes it is not clea [...]

MariaDB 10.11 is LTS (from MariaDB Foundation Blog)

pImportant news: MariaDB 10.11, which just was declared RC, is a long-term maintenance version. The industry standard term to refer to that concept is LTS (as in long-term support), and we too use this term for the releases that get a significantly longer lifetime of bug fixes. … /p pContinue reading \"MariaDB 10.11 is LTS\"/p pThe post MariaDB 10.11 is LTS appeared first on MariaDB.org./p [...]

Thursday, 17. November 2022

MariaDB 10.11.1 RC and 10.10.2 GA now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.11.1, the first release candidate in the MariaDB 10.11 series, and MariaDB 10.10.2 the first generally available release in the short-term MariaDB 10.10 series. … /p pContinue reading \"MariaDB 10.11.1 RC and 10.10.2 GA now available\"/p pThe post MariaDB 10.11.1 RC and 10.10.2 GA now available appeared first on Mar [...]

Announcing MariaDB Community Server 10.10 GA and 10.11 RC (from MariaDB Corporation Blog)

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

MySQL Dual password how to manage them programmatically (from TusaCentral - MySQL Blogs)

pWhat is dual password in MYSQL and how it works was already covered by my colleague Brian Sumpter here (www.percona.com/blog/using-mysql-8-dual-passwords/). ♦/p pHowever let me do a brief recap here about it./p pDual password is the MySQL mechanism that allows you to keep two passwords active at the same time. This feature is part of a more extended set of Password management features impleme [...]

Migration of your data from one database to another (from Shinguz's Blog)

pBefore you consider migrating your data from MySQL to another database you have to know which objects have to be migrated./p pWith this query you will find the objects to consider:/p pre SELECT TABLE_SCHEMA AS `SCHEMA`, IF(TABLE_TYPE = 'BASE TABLE', 'TABLE', TABLE_TYPE) AS OBJECT_TYPE, TABLE_NAME AS `OBJECT_NAME` , IFNULL(ENGINE, '') AS ENGINE, IFNULL(TABLE_ROWS, '') AS `ROWS` , IFNULL [...]

How To Get Your Backup to Half of Its Size – Introducing ZSTD Support in Percona XtraBackup (from Percona Database Performance Blog)

♦Having a backup of your database is like insurance, you have to pay a monthly price to ensure you have a service available when you need to. When talking about backups, the storage required to keep your backups is what comes into factor when talking about price, the bigger your backup, or the bigger the […] [...]

AlmaLinux MySQL+Perl (from MacLochlainns Weblog)

A quick primer on Perl programs connecting to the MySQL database. It’s another set of coding examples for the AlmaLinux instance that I’m building for students. This one demonstrates basic Perl programs, connecting to MySQL, returning data sets by reference and position, dynamic queries, and input parameters to dynamic queries. Naturally, a hello.pl is a […] [...]

Secured MySQL InnoDB Cluster with Certificate creation using OpenSSL (from MySQLHK)

pThis is a demo tutorial to show how we can create InnoDB Cluster with newly installed Certificate and having X509 certificate verification via MySQL Router connection.   /ppbr/ppRecorded Video/ppThe full process is recorded on Youtube - showing creating InnoDB Cluster with newly installed CA, Server Certificates.  The Router creation is configured with SSL Server certificate from th [...]

Wednesday, 16. November 2022

All About MariaDB MaxScale Database Proxy For Read-Write Splitting (from MariaDB Corporation Blog)

In this article, you will learn about database proxies and how to connect a Java web service, implemented with Spring … Continued [...]

The OpenLampTech Developer Newsletter is One Year Old (from Digital Owl's Prose)

pThe OpenLampTech developer newsletter is one year old! I honestly don’t know where the past year went. Obviously, I had my nose buried in some fantastic content since OpenLampTech publishes mostly curated newsletters. I tell you though, don’t think it isn’t a challenge adding your own thoughts and commentary to someone else’s great content because […]/p pThe post The OpenLampTech Developer N [...]

Of Stars and Snowflakes (from Die wunderbare Welt von Isotopp)

A sample system pWhen you have an Online Transactional Database, you have to record transactions at some point in time. That means you get a table with time dimension in your OLTP system. Consider for example a system that records Reservations. Users exist and can reserve Things to use, for a day./p pYou probably get a structure such as this:/p pp ♦ /p /p pIn an OLTP database, a res [...]

Tuesday, 15. November 2022

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

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

How PlanetScale Boost serves your SQL queries instantly (from PlanetScale Blog)

Learn how we use a partial materialization engine for database caching alongside your database.pRead the full story/p [...]

Introducing PlanetScale Boost (from PlanetScale Blog)

Up to 1,000× faster queries in just a few clicks with our groundbreaking caching technology.pRead the full story/p [...]

Bad Optimizer Plan on Queries Combining WHERE, ORDER BY and LIMIT (from J-F Gagné's MySQL Blog)

Sometimes, the MySQL Optimizer chooses a wrong plan, and a query that should execute in less than 0.1 second ends-up running for 12 minutes !  This is not a new problem: bugs about this can be traced back to 2014, and a blog post on the subject dates of 2015.  But even if this is old news, because this problem recently came to my attention, it is a problem worth writing on. This is an improved [...]

Galera Manager Webinar: Managed Galera Clusters For You (from Galera Blog)

This has been a gigantic year for Galera Manager, that if you’ve tried our releases from earlier this year to what we have today, we’ve taken on feedback to improve the UI plus add features that make our users happier and more efficient in production. In this webinar we will cover: How to create a […] [...]

Why you need to take your time choosing a WordPress hosting service (from Geeky Hacker - Coding, Tech & Linux)

pAccording to Yahoo Finance’s ‘Web Hosting Services Global Market Report 2022’, we are seeing a massive surge in the global market with a CAGR of 13.2 percent. At the rate [...]/p pThe post Why you need to take your time choosing a WordPress hosting service appeared first on Geeky Hacker./p [...]

replicate_rewrite_db as a system variable in MariaDB (from MariaDB Foundation Blog)

pMariaDB 10.11.0, our latest preview release, features quite a number of improvements. The one we’ll talk about here is replicate-rewrite-db. … /p pContinue reading \"replicate_rewrite_db as a system variable in MariaDB\"/p pThe post replicate_rewrite_db as a system variable in MariaDB appeared first on MariaDB.org./p [...]

Monday, 14. November 2022

Enable innodb_print_all_deadlocks Parameter To Get All Deadlock Information in mysqld Error Log (from Percona Database Performance Blog)

♦At Percona Managed Services, sometimes clients’ applications face deadlock situations and need all historic deadlock information for application tuning. We could get the LATEST DETECTED DEADLOCK from SHOW ENGINE INNODB STATUS\G: [crayon-6387c4648d96c650228919/] But how could we view all past deadlock information? We could enable innodb_print_all_deadlocks,  and all deadlocks in InnoDB user t [...]

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

pUnbelievably, the OpenLampTech developer newsletter is one year old. Thank you so much for reading and making it possible! I appreciate each and every one of you. In this week’s OpenLampTech issue #52, we have articles covering: Want to support the OpenLampTech publication with a free subscription? Great! Simply head over to the publication page […]/p pThe post OpenLampTech issue #52 & [...]

FOSDEM 2023 MySQL Devroom – extra info (from FOSDEM MySQL & Friends Devroom)

Hi all, As you know the CfP for the devroom has been open and you may have noticed that we have only half a day that we also need to share. Therefore, we will have only 4 sessions and they should look like this: We didn’t decide yet which of the two colors will be […] [...]

Friday, 11. November 2022

pre-FOSDEM MySQL Days 2023 (from lefred's blog)

Hello dear MySQL Community ! As you may already know FOSDEM 2023 is again going to be held in-person. FOSDEM will take place February 4th and 5th 2023. We have also decided to put our pre-FOSDEM MySQL Day on track for a fifth edition. As for the last edition, the event will be spread over 2 days. These 2 extra days related to the world’s most popular open source database will take place just before [...]

Upgrading your Galera Cluster from MySQL 5.7 to MySQL 8.0 (from Galera Blog)

Recently we had a question on getting your Galera Cluster upgraded from MySQL 5.7 to MySQL 8.0. While we have plenty of extensive documentation on Upgrading Galera Cluster, this blog covers the Linux example for a rolling major upgrade (the procedure is documented, but this is more extensive). So we will describe going from MySQL […] [...]

Thursday, 10. November 2022

Run MySQL in Kubernetes: Solutions, Pros and Cons (from Percona Database Performance Blog)

♦This blog post continues the series of comparisons of solutions to run databases on Kubernetes. Previous blog posts: Run MongoDB in Kubernetes: Solutions, Pros and Cons Run PostgreSQL in Kubernetes: Solutions, Pros and Cons The initial release of MySQL was in 1995 and Kubernetes was released 19 years later in 2014. According to DB-engines, MySQL […] [...]

CfP for the MariaDB, MySQL and Friends devroom FOSDEM 2023 now open (from MariaDB Foundation Blog)

pFOSDEM 2023 is happily once again going to be an in-person event, and MariaDB will be participating as part of the MariaDB, MySQL and Friends devroom. … /p pContinue reading \"CfP for the MariaDB, MySQL and Friends devroom FOSDEM 2023 now open\"/p pThe post CfP for the MariaDB, MySQL and Friends devroom FOSDEM 2023 now open appeared first on MariaDB.org./p [...]

ProxySQL Support for MySQL caching_sha2_password (from Percona Database Performance Blog)

♦Every day we use dozens if not hundreds of applications connecting to some kind of data repository. This simple step is normally executed over the network and, given so, it is subject to possible sniffing with all the possible related consequences. Given that, it is normally better to protect your connection using data encryption like SSL, […] [...]

Journée MySQL Innovation et Cloud (from lefred's blog)

Next week, November 16th, I will participate to the MySQL Innovation and Cloud Virtual Day in French. My colleagues will present what’s new in MySQL 8.0.31 and also summarize all the big news that was announced at Oracle Cloud World in Las Vegas. Attendees will learn about the MySQL HeatWave offering in OCI. I will be presenting something that is only available in MySQL on-prem and in OCI as a mana [...]

FOSDEM 2023 MariaDB, MySQL and Friends Devroom – Call for Papers (from FOSDEM MySQL & Friends Devroom)

Now that FOSDEM is again going to held in-person event, MariaDB and MySQL will once again have a devroom. FOSDEM 2023 will take place on Sat 4 – Sun 5 February 2023. However, there are some changes in the organization. Each project will be responsible for its track, so we will divide the devroom into […] [...]

Wednesday, 09. November 2022

Build Your Own Command-line Replica with GTID-aware mariadb-binlog (part 1) (from MariaDB Corporation Blog)

This blog post begins a three part series to create and customize your own asynchronous MariaDB replication client. With the … Continued [...]

Unique Indexes With Some Rows Excluded (from SQL for Devs)

Unique indexes are used to ensure that some values or combinations of values are unique. However, they only work when the uniqueness constraint should be enforced on all table rows because it can not be limited to ignore e.g. soft-deleted ones. But with partial indexes, supported by PostgreSQL, this is possible because a WHERE condition can control the includ [...]

MySQL: Using UNION, INTERSECT, & EXCEPT (from Percona Database Performance Blog)

♦MySQL 8.0.31 added INTERSECT and EXCEPT to augment the long-lived UNION operator. That is the good news. The bad news is that you have to be careful using the EXCEPT operator as there is a trick. Let’s start with some simple tables and load some simple data. [crayon-6387c4648ff10935205871/] So each table has four rows of […] [...]

Databases on un-RAID-ed storage? (from Die wunderbare Welt von Isotopp)

pWhere I work, we run bare-metal databases on non-redundant local storage. That is, a database is a very cheap frontend blade server. It has 2 CPUs, with 8 cores/16 threads each. It contains 128 GB of memory, 2 or 4 TB of local NVME and it has a 10 GBit/s network interface. It costs around 120 to 150 Euro per month to run for 5 years, including purchase price and all datacenter costs./p pIt AWS ter [...]

Tuesday, 08. November 2022

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

We are pleased to announce that Tungsten Dashboard v1.0.11 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 [...]

MariaDB Java Connector 3.0.9 and 2.7.7 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Java 3.0.9 and 2.7.7 GA releases. Full Release Notes … Continued [...]

MariaDB C Connector 3.3.3 and 3.1.19 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C 3.3.3 and 3.1.19. Download Now Release Notes and Changelog … Continued [...]

Monday, 07. November 2022

MariaDB Community Server Q4 2022 maintenance releases (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 10.9.4, 10.8.6, 10.7.7, 10.6.11, 10.5.18, 10.4.27, and 10.3.37 … Continued [...]

Generating Slow Query Log with MySQL Shell (from lefred's blog)

Recently, I wrote three articles on how to analyze queries and generate a slow query log for MySQL Database Service on OCI: In these post, we were generating a slow query log in text or JSON directly in Object Storage. Today, we will see how we can generate a slow query log in text directly using MySQL Shell and form Performance Schema. The generated log can be used to digest the queries with a too [...]

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

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

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

pThis week’s OpenLampTech newsletter has a great mix of round-up posts for you across the PHP and MySQL backend web space. In just 1 more week, we are 1 year old! How nuts is that?!? Enjoy this week’s publication and share with others. In OpenLampTech issue #51, we are looking at content covering: A free […]/p pThe post OpenLampTech issue #51 – Substack Repost appeared first [...]

MariaDB 10.9.4, 10.8.6, 10.7.7, 10.6.11, 10.5.18, 10.4.27 and 10.3.37 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.9.4, MariaDB 10.8.6 and MariaDB 10.7.7, the latest Generally Available releases in their respective short-term series (maintained for one year from their first GA release dates), as well as MariaDB 10.6.11, MariaDB 10.5.18, MariaDB 10.4.27 and MariaDB 10.3.37, the latest stable release in their respective long-term series [...]

Bandwidth, IOPS and Latency (from Die wunderbare Welt von Isotopp)

pp ♦ /p /p pA harddisk from 1998./p pThe opening image for this post shows the stock photo of a hard disk platter. You can see a movable arm that can ride in and out of a stack of rotating platters coated with some kind of metal oxide. We sometimes call this kind of storage condescendingly “rotating rust”, when in reality it is a triumph of material science./p pMoving an arm costs [...]

Friday, 04. November 2022

Seamless failover with Galera Load Balancer (from Galera Blog)

Continuing on from Setting up Galera Load Balancer (GLB), wouldn’t it be nice to ensure that Galera Load Balancer (GLB) handles failover, seamlessly? Router: ------------------------------------------------------ Address : weight usage map conns 188.166.179.177:3306 : 1.000 0.500 N/A 1 165.22.50.152:3306 : 1.000 0.500 N/A 1 165.22.49.92:3306 : 1.000 0.000 N/A 0 ------------------------------------- [...]

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

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

Thursday, 03. November 2022

ProxySQL support for MySQL caching_sha2_password (from TusaCentral - MySQL Blogs)

pIn our time, every day we use dozens if not hundreds of applications connecting to some kind of data repository. This simple step is normally executed over the network and given so, it is subject to possible sniffing with all the possible related consequences.♦br/p pGiven that it is normally better to protect your connection using data encryption like SSL, or at the minimum, make the informat [...]

WHAT IF… The User Exists on the Replica and Not in the Primary? (Or Any Other Objects?) (from Percona Database Performance Blog)

♦Hey folks, This blog is straightforward but, at the same time, handy. At Percona, we know that the audience of our blogs is not limited to DBAs but includes a broader range of IT professionals, such as sysadmins, help desk employees, NOC operators, and developers as well. Sometimes people (and also some DBAs, why not?) […] [...]

Raspberry on the Rocks: Build Percona Server for MySQL With MyRocks on Your Raspberry Pi (from Percona Database Performance Blog)

♦Raspberry PI is a small single-board computer (SBCs) developed by the Raspberry Pi Foundation in association with Broadcom. This tiny computer is extremely popular and widely used in many areas. Thanks to its size, low cost, and low energy requirements, it can be used to collect data in remote locations or from sensor devices. We […] [...]

Best MySQL GUI Clients for Linux in 2022 (from Devart MySQL Tool Blog)

pLinux has a reputation as an operating system for programmers. So, if you are a software developer who designs MySQL-based solutions, chances are high that you will do it on Linux. Thus, it would be great to have a MySQL IDE for Linux to simplify the work. But the question arises: is there an appropriate […]/p pThe post Best MySQL GUI Clients for Linux in 2022 appeared first on Devart Blog./ [...]

Wednesday, 02. November 2022

Set Theory in MySQL 8.0: UNION and Now INTERSECT and EXCEPT (from Percona Database Performance Blog)

♦Are you familiar with the UNION statement for your SQL queries? Most likely, you are. It has been supported for a long time. In case you are not familiar with UNION, don’t worry, I’m going to show you how it works with simple examples. Considering “Set Theory”, other than the UNION, starting from the newly […] [...]

INTERSECT and EXCEPT commands in MySQL (from Digital Owl's Prose)

pMySQL now supports the INTERSECT and EXCEPT set operators. Set operators work on the results of multiple SELECT statements. In this post, we will see example queries using INTERSECT and EXCEPT commands for a better understanding While MySQL has supported UNION and UNION ALL commands, there were no INTERSECT or EXCEPT commands in the language. […]/p pThe post INTERSECT and EXCEPT commands in [...]

Tuesday, 01. November 2022

s/optimal/better/g - on reviewing conference papers (from Small Datum)

pI spent a few years reviewing papers for database conferences. I think that is winding down. I was OK as a reviewer, definitely not great, and this summarizes my experience.brbrFor starters, I am in awe of good reviwers. As a reviewer you get to see feedback from the other reviwers after submitting your review. And I was always nervous while waiting to see the other reviews. Was my review an outli [...]

Reasons for writeback with an update-in-place B-Tree (from Small Datum)

pAre there well known names for the things that trigger dirty page writeback with an update-in-place B-Tree? Some of my performance discussions would be easier if I could point to those definitions.brbrI spent many years keeping InnoDB, an update-in-place B-Tree, happy in production and a shorter time with WiredTiger, a copy-on-write random (CoW-R) B-Tree. At work I recently revisited the topi [...]

Quantifying storage on Linux (from Small Datum)

pSome things are complicated but I understand them (RocksDB). Clearly that isn't too complicated and the complexity might be a barrier to entry which boosts the demand for my skills. Other things are complicated and I don't understand them that well. Clearly those things are too complicated.brbrYes, I am trying to be funny but what I wrote above might be true for many of us. In this case the thing [...]

How to Generate Test Data for MySQL With Python (from Percona Database Performance Blog)

♦For testing purposes, especially if you’re working on a project that uses any database technology to store information, you may need data to try out your project. In that case, you have two options: Find a good dataset (Kaggle) or, Use a library like Faker Through this blog post, you will learn how to generate […] [...]

One million connections (from PlanetScale Blog)

Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL.pRead the full story/p [...]

Monday, 31. October 2022

MySQL Integers: INT, BIGINT, and more (from PlanetScale Blog)

Gain a deeper understanding of the MySQL integer types by exploring the different options (INT, BIGINT, MEDIUMINT, etc) and how they are stored.pRead the full story/p [...]

Coroot – The Next Level in Kubernetes Observability (from Percona Database Performance Blog)

♦To follow up on my previous Kubernetes articles: Installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation) and Have Percona Server for MySQL running (Using Percona Kubernetes Operators With K3s Part 2: Percona Server for MySQL Operator) Monitoring with Percona Monitoring and Management (PMM): Using Percona Kubernetes Operators With K3s […] [...]

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

pThis week’s OpenLampTech newsletter takes a different approach to my choice of curated stories. Continue reading and see how. 📚 In OpenLampTech issue #50, we are looking at articles covering: If you would like to support the OpenLampTech publication with a free subscription, then please subscribe today. Thank you./p pThe post OpenLampTech issue #50 – Substack Repost appeared first on D [...]

AlmaLinux LAMP (from MacLochlainns Weblog)

After installing and configuring MySQL 8.0.30, I installed the Apache Web Server, PHP and the MySQLi packages. Here are the step-by-step instructions after installing and configuring the MySQL Server and provisioning a student user and the sakila and studentdb databases (blog for those steps). After installing the major components, I completed the HTTPS configuration steps […] [...]

Sunday, 30. October 2022

AlmaLinux MySQL+Python (from MacLochlainns Weblog)

After installing and configuring MySQL 8.0.30, I installed the Python connector. During that process on AlmaLinux, there were several changes since I last installed the Python’s mysql module. Here are the step-by-step instructions after installing and configuring MySQL Server (blog for those steps). Using the MySQL Connector/Python X DevAPI Reference, you must install the pip […] [...]

Database migration with Spring Boot and Flyway (from Geeky Hacker - Coding, Tech & Linux)

pDatabase migration or schema evolution is inevitable in any long-lasting project. While NoSQL databases give more leeway, relational databases are pretty rigid regarding schema evolution. Hence, having a suitable tool [...]/p pThe post Database migration with Spring Boot and Flyway appeared first on Geeky Hacker./p [...]

Friday, 28. October 2022

What is Database Clustering? (from Continuent Blog)

Continuent is the leading provider of database clustering for MySQL, MariaDB, and Percona MySQL, enabling mission-critical apps to run on these open source databases globally. Having worked with several Fortune 100 customers and been around these database “farms,” I feel comfortable discussing what clustering is, and some of the benefits of clustering your database servers.Tags: MySQLMariaDBCl [...]

Galera Cluster for MySQL 5.7.39 released (from Galera Blog)

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.38 (release notes, download). This release incorporates all changes to MySQL 5.7.39, adding a synchronous option for your MySQL High Availability solutions. We have backported the InnoDB wsrep applier lock wait timeout from […] [...]

Thursday, 27. October 2022

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

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

pt-archiver Misbehaving With Secondary Index (from Percona Database Performance Blog)

♦Not long ago, we found a long-running query in one of our clients on Managed Services. While reviewing this long-running query, we found it was generated by a pt-archiver operation. That doesn’t sound good, right? I was able to reproduce the issue on my test environment. In this article, I will show you how to […] [...]