Planet for the MySQL Community

Multitenant data management with TiDB ^{(from InfoWorld)}

pIn a previous article, we explored various approaches to managing data for multitenant applications. We examined the benefits, compromises and limitations of different deployment models, including share-nothing, share-everything, and hybrid. We discussed the needs and challenges of each approach, from ensuring data isolation and scalability to managing customized tenant requ [...]

Published Monday, 30. December 2024 09:00 • 6 hours ago

Speedb vs RocksDB on a large server ^{(from Small Datum)}

pI am happy to read about storage engines that claim to be faster than RocksDB. Sometimes the claims are true and might lead to ideas for making RocksDB better. I am wary about evaluating such claims because that takes a lot of time and when the claim is bogus I am reluctant to blog about that because I don't want to punch down on a startup.brbrHere I share results from the RocksDB benchmark script [...]

Published Friday, 27. December 2024 01:14 • 4 days ago | Updated Sunday, 29. December 2024 19:58 • 19 hours ago

Monitoring Multi-threaded Replication Lag With Performance Schema ^{(from Hack MySQL)}

pUsed to be that replication lag was as simple as codeSeconds_Behind_Master/code (renamed to codeSeconds_Behind_Source/code). But with multi-threaded replication (MTR) this is no longer the case. It’s time to relearn replication lag monitoring using Performance Schema tables./p [...]

Published Sunday, 29. December 2024 01:07 • a day ago

What do you expect from vector storage in databases? ^{(from MariaDB Foundation Blog)}

pWe’re no mind readers, so from time to time, we like to do polls. Polls are quantitative in nature, so coming up with the right question is not enough – … /p pContinue reading \"What do you expect from vector storage in databases?\"/p pThe post What do you expect from vector storage in databases? appeared first on MariaDB.org./p [...]

Published Saturday, 28. December 2024 11:33 • 2 days ago

IBM upgrading Gold to Platinum ^{(from MariaDB Foundation Blog)}

pGood news: IBM is upgrading their Gold sponsorship to Platinum!br Our trinity: Adoption, Openness, Continuitybr The three pillars of MariaDB Foundation are Adoption, Openness, and Continuity. … /p pContinue reading \"IBM upgrading Gold to Platinum\"/p pThe post IBM upgrading Gold to Platinum appeared first on MariaDB.org./p [...]

Published Friday, 27. December 2024 13:13 • 3 days ago

Dolphie Works with Dolt ^{(from DoltHub Blog)}

Dolt is a drop in-replacement for MySQL, which means it can be used with any MySQL-compatible tool. One such tool is Dolphie, a real-time… [...]

Published Friday, 27. December 2024 00:00 • 4 days ago

Thoughts on ScyllaDB License Change ^{(from Peter Zaitsev)}

pAs you may have heard, ScyllaDB is moving to a Source Available License. Seeing this move from so many companies from MongoDB to Redis should not surprise everyone. This is what happens to “corporate-owned” Open Source Software these days. Yet it is interesting to explore ScyllaDB’s situation in more detail. First, I think ScyllaDB’s license […]/p pThe post Thoughts on ScyllaDB License Chang [...]

Published Thursday, 26. December 2024 08:15 • 4 days ago

Host Database Serverlessly On AWS Fargate - Just Like Your Applications ^{(from WeSQL Blog)}

Running a database in the cloud often means paying for idle capacity and dealing with persistent storage overhead. AWS ECS + Fargate changes that equation by letting you pay only for actual compute time and seamlessly integrate with S3 for storage, effectively separating compute from data. This guide shows you how to host a MySQL-compatible database (WeSQL) using Fargate’s pay-as-you-go model while [...]

Published Thursday, 26. December 2024 00:00 • 5 days ago

A Message From the Community Team ^{(from The Oracle MySQL Blog)}

For the final day of our Advent Calendar of Content, we bring you a message from the Community Team. [...]

Published Tuesday, 24. December 2024 05:00 • 6 days ago

MySQL enters a new decade! ^{(from The Oracle MySQL Blog)}

For this penultimate article before Christmas, let's announce the 30th anniversary of MySQL! [...]

Published Monday, 23. December 2024 09:00 • 7 days ago

Resolving MySQL Binlog Errors and Reclaiming Disk Space ^{(from Mydbops Blog)}

Learn how to troubleshoot and resolve MySQL binlog errors like 'Target log not found in binlog index' to free up valuable disk space. [...]

Published Monday, 23. December 2024 08:57 • 7 days ago

10% Slower Than MySQL ^{(from DoltHub Blog)}

Four years ago DoltDB was about 15x slower than MySQL. At the time, we faced skepticism regarding Prolly-tree performance and scalability… [...]

Published Monday, 23. December 2024 00:00 • 8 days ago

Troubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB ^{(from MinervaDB Blog)}

pTroubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB Troubleshooting AUTO_INCREMENT Max Value Problems in MySQL and MariaDB involves addressing issues related to hitting the maximum value of an AUTO_INCREMENT column. This can [...]/p pThe post Troubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB appeared first on The WebScale Database Inf [...]

Published Sunday, 22. December 2024 19:10 • 8 days ago

Resource Semaphore Mechanisms in InnoDB ^{(from MinervaDB Blog)}

pInnoDB Synchronization Mechanisms: Understanding Semaphore-Like Constructs for Concurrency Management InnoDB employs various synchronization mechanisms to manage concurrency and resource allocation, which function similarly to resource semaphores. While the term "resource semaphore" is not explicitly used [...]/p pThe post Resource Semaphore Mechanisms in InnoDB appeared first on The WebScale Data [...]

Published Sunday, 22. December 2024 18:52 • 8 days ago

MySQL Blog Revisited - OCI TypeScript SDK ^{(from The Oracle MySQL Blog)}

For the 22nd day of our Advent Calendar of Content, we bring you a summary of all the MySQL Blog posts that demonstrate using the OCI TypeScript SDK [...]

Published Sunday, 22. December 2024 05:00 • 8 days ago

MySQL Shorts Revisited - DBA Goodies ^{(from The Oracle MySQL Blog)}

For the 21st day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on topics that would interest DBAs. [...]

Published Saturday, 21. December 2024 05:00 • 9 days ago

Resolving MySQL Error 1412 and Understanding Transaction Isolation Levels ^{(from MinervaDB Blog)}

pResolving MySQL Error 1412 and Understanding Transaction Isolation Levels Understanding MySQL Transaction Error 1412 and Isolation Levels Error 1412: "Table definition has changed, please retry transaction" MySQL Error 1412 occurs when a transaction attempts to [...]/p pThe post Resolving MySQL Error 1412 and Understanding Transaction Isolation Levels appeared first on The WebScale Database Infras [...]

Published Friday, 20. December 2024 18:59 • 10 days ago

Amazon RDS for MariaDB supports minors 11.4.4, 10.11.10, 10.6.20, 10.5.27 ^{(from AWS What's New)}

pAmazon Relational Database Service (Amazon RDS) for MariaDB now supports MariaDB minor versions 11.4.4, 10.11.10, 10.6.20, and 10.5.27. We recommend that you upgrade to the latest minor versions to fix known security vulnerabilities in prior versions of MariaDB, and to benefit from the bug fixes, performance improvements, and new functionality added by the MariaDB community.br br You can leverage [...]

Published Friday, 20. December 2024 18:00 • 10 days ago

MariaDB Day Sat 1 Feb 2025 in Brussels ^{(from MariaDB Foundation Blog)}

pWe have the date, we have the place , we have the theme! So we ask you to save the date.br Date: Saturday 1 Feb 2025 (10:00-17:00)br Place: Brussels, SQ Lily-Rose, Avenue Arnaud Fraiteur 15-23, close to FOSDEMbr Theme: Vectors, RAG and all things new in MariaDB Serverbr Registration: Please register here with Meetupbr With the Open Source community convening for FOSDEM, we have noted Brussels is a [...]

Published Friday, 20. December 2024 17:15 • 10 days ago

MySQL Transaction ERROR 1412 and Isolation Levels ^{(from Percona Database Blog)}

♦This blog post explains the cause of “ERROR 1412 (HY000): Table definition has changed, please retry transaction” with the specific Isolation level settings. Background As per the MySQL documentation, this error should occur for “operations that make a temporary copy of the original table and delete the original table when the temporary copy is built.” […] [...]

Published Friday, 20. December 2024 14:09 • 10 days ago

Revolutionizing Loyalty Programs: Rakuten’s Journey to Distributed SQL ^{(from PingCAP Blog)}

pAchieving a balance between scalability and operational efficiency has become a defining challenge for data-driven businesses. At HTAP Summit 2024, Alex Bai, Engineering Manager at Rakuten, and Tim Liu, Engineering Lead, shared their journey of overcoming the limitations of traditional databases like Apache Cassandra and MySQL to meet the demands of high-traffic platforms and critical […]/p [...]

Published Friday, 20. December 2024 11:19 • 10 days ago

MySQL Retrospective - ISAM & MySAM Log ^{(from The Oracle MySQL Blog)}

Let's stay a bit longer with MySQL 3.2x to advance the MySQL Retrospective in anticipation of the 30th Anniversary. [...]

Published Friday, 20. December 2024 10:00 • 10 days ago

MySQL Retrospective – ISAM & MyISAM Log ^{(from lefred's blog)}

Let’s stay a bit longer with MySQL 3.2x to advance the MySQL Retrospective in anticipation of the 30th Anniversary. The idea of this article was suggested to me by Daniël van Eeden. Did you know that in the early days, and therefore still in MySQL 3.20, MySQL used the ISAM storage format? IBM introduced the […] [...]

Published Friday, 20. December 2024 09:04 • 10 days ago

Transition from AWS DMS to zero-ETL to simplify real-time data integration with Amazon Redshift ^{(from AWS Database Blog)}

The zero-ETL integrations for Amazon Redshift are designed to automate data movement into Amazon Redshift, eliminating the need for traditional ETL pipelines. With zero-ETL integrations, you can reduce operational overhead, lower costs, and accelerate your data-driven initiatives. This enables organizations to focus more on deriving actionable insights and less on managing the complexities of data [...]

Published Thursday, 19. December 2024 20:16 • 11 days ago

Releem vs RDS Performance Insights ^{(from Releem Blog)}

Compare Releem and RDS Performance Insights for monitoring and tuning MySQL [...]

Published Thursday, 19. December 2024 18:49 • 11 days ago

Amazon RDS Proxy announces caching_sha2_password authentication support for MySQL on Aurora and RDS ^{(from AWS What's New)}

pAmazon RDS Proxy announces caching_sha2_password authentication plugin support for client to proxy connections on MySQL on Aurora and RDS.br br Customers need to use plugins to perform authentication between databases and clients while using RDS Proxy. Starting with MySQL 8.4, community MySQL uses caching_sha2_password plugin as the default, which is more secure than the previous default plugins. [...]

Published Thursday, 19. December 2024 18:00 • 11 days ago

Percona XtraBackup 101: Decompress and Decrypt or Decrypt and Decompress? ^{(from Percona Database Blog)}

♦This blog is not intended to offer anything extraordinary; instead, consider it an anecdote, a lesson, or simply a proper way of doing things without the need to run a test when in doubt. That said, I must emphasize that, as always, testing everything before deploying to production is essential. Let’s dive into the story: […] [...]

Published Thursday, 19. December 2024 17:00 • 11 days ago

Building for Scale: The Blueprint for Distributed SQL Databases That Meet Modern Demands ^{(from PingCAP Blog)}

pWelcome to the Distributed SQL Era: What AWS’s Entry Means for You Modern applications are pushing the boundaries of what databases can handle. As businesses expand, they face unprecedented demands—hyper-scaling applications, global deployments, and real-time responsiveness—that traditional databases simply weren’t designed to meet. Distributed SQL databases have emerged as a blueprint for success [...]

Published Thursday, 19. December 2024 15:18 • 11 days ago

Indexing code at scale with Glean ^{(from Engineering at Meta)}

pWe’re sharing details about Glean, Meta’s open source system for collecting, deriving, and working with facts about source code. In this blog post we’ll talk about why a system like Glean is important, explain the rationale for Glean’s design, and run through some of the ways we’re using Glean to supercharge our developer tooling at [...]/p pRead More.../p pThe post Indexing code at scale with Gle [...]

Published Thursday, 19. December 2024 14:00 • 11 days ago

MariaDB Galera Cluster with MariaDB MaxScale – Getting Started with Read Write Split ^{(from Galera Blog)}

MariaDB Galera Cluster is a synchronous multi-master database cluster solution that provides MariaDB high availability and data consistency. MariaDB MaxScale is a database proxy that can be used to improve the performance, scalability, and security of MariaDB Galera Cluster. Codership (the makers of Galera Cluster) have a long term partnership with MariaDB Corporation, including joint […] [...]

Published Thursday, 19. December 2024 09:47 • 11 days ago

Inside MySQL: Sakila Speaks - Season 2 Begins ^{(from The Oracle MySQL Blog)}

The second season of the podcast Inside MySQL: Sakila Speaks has begun. In the first episode, Fred and Scott discuss how they got started with MySQL and some of their favorite features. [...]

Published Thursday, 19. December 2024 05:00 • 11 days ago

Navigating Business Growth: How TiDB Scales Petabyte-Level Data Volumes ^{(from PingCAP Blog)}

pBusiness growth is an exciting milestone, bringing more users, transactions, and opportunities to innovate. However, with growth comes significant technical challenges, such as: In this blog, we’ll explore how TiDB, an open-source distributed SQL database, addresses these business growth challenges. We’ll also walk through real-world examples from companies such as Bolt and Flipkart. B [...]

Published Wednesday, 18. December 2024 22:01 • 12 days ago

Amazon RDS for MySQL supports Innovation Release version 9.1 in Amazon RDS Database Preview Environment ^{(from AWS What's New)}

pAmazon RDS for MySQL now supports MySQL Innovation Release 9.1 in the Amazon RDS Database Preview Environment, allowing you to evaluate the latest Innovation Release on Amazon RDS for MySQL. You can deploy MySQL 9.1 in the Amazon RDS Database Preview Environment that has the benefits of a fully managed database, making it simpler to set up, operate, and monitor databases.br br MySQL 9.1 is the lat [...]

Published Wednesday, 18. December 2024 19:55 • 12 days ago

MySQL Telemetry: OpenTelemetry Logging ^{(from The Oracle MySQL Blog)}

OpenTelemetry provides a standard for transferring observability data. MySQL has already added support for OpenTelemetry Traces and OpenTelemetry Metrics. We recently added support for OpenTelemetry Logging. [...]

Published Wednesday, 18. December 2024 19:06 • 12 days ago

Optimize Amazon RDS performance with io2 Block Express storage for production workloads ^{(from AWS Database Blog)}

Choosing the right storage configuration that meets performance requirements is a common challenge when creating and managing database instances. In this post, we provide an end-to-end guide for what storage class to choose depending on your use case. In addition, we compare the performance of different storage volumes on open source engines supported by Amazon RDS, to validate them from a database [...]

Published Wednesday, 18. December 2024 17:42 • 12 days ago

How To Deal with a AUTO_INCREMENT Max Value Problem in MySQL and MariaDB ^{(from Percona Database Blog)}

♦An application down due to not being able to write into a table anymore due to a maximum allowed auto-increment value may be one of the worst nightmares of a DBA. Typical errors related to this problem in MySQL will look like this: [crayon-677194e836035323556608/] or [crayon-677194e83603b099813130/] While the solution could be easy and fairly quick […] [...]

Published Wednesday, 18. December 2024 14:10 • 12 days ago

MySQL Retrospective - MySQL 3.20 ^{(from The Oracle MySQL Blog)}

Let's do a move into the past for the MySQL Advent Calendar before the 30th Anniversary and talk about MySQL 3.20 [...]

Published Wednesday, 18. December 2024 10:51 • 12 days ago

MySQL Retrospective – MySQL 3.20 ^{(from lefred's blog)}

To further advance the MySQL Retrospective in anticipation of the 30th Anniversary, today, let’s discuss the very first version of MySQL that became availble to a wide audient though the popular InfoMagic distribution: MySQL 3.20! In 1997, InfoMagic incorporated MySQL 3.20 as part of the RedHat Contrib CD-ROM (MySQL 3.20.25). Additionally, version 3.20.13-beta was also […] [...]

Published Wednesday, 18. December 2024 09:45 • 12 days ago

Dublin MySQL Meetup, Thu, January 16, 20254pm GMT (UTC+0) ^{(from ODBMS.org)}

Place: Oracle office, Oracle EMEA Liimted, East Point Business Park, Fairview, Dublin 3 Agenda: 4:00 – 4:30 pm Welcome and Welcome Coffee 4:30 – 5:15 pm – MySQL replication topologies for availability and scale by Stuart... [...]

Published Tuesday, 17. December 2024 16:24 • 13 days ago

Belfast MySQL Meetup,Wed. January 15, 2025 6pm GMT (UTC+0) ^{(from ODBMS.org)}

Place: The Woodworkers, United Kingdom, BT7 1RS Agenda: 6:00 – 6:30 pm Welcome and Welcome Coffee 6:30 – 7:15 pm – MySQL replication topologies for availability and scale by Stuart Davey, the MySQL HW Data Architect... [...]

Published Tuesday, 17. December 2024 16:19 • 13 days ago

How Mercari Scaled Its SaaS Platform with Distributed SQL ^{(from PingCAP Blog)}

pAt HTAP Summit 2024, Takashi Honda, a Database Reliability Engineer at Mercari, shared insights into why distributed SQL has become indispensable for SaaS platforms. Drawing from his extensive experience optimizing large-scale infrastructures, Honda illustrated how traditional databases like MySQL and PostgreSQL often reach their limits in performance, scalability, and operational inefficienc [...]

Published Tuesday, 17. December 2024 15:34 • 13 days ago

MySQL Shorts Episode 80 Is Available ^{(from The Oracle MySQL Blog)}

The latest episode of MySQL Shorts is now available. [...]

Published Tuesday, 17. December 2024 14:29 • 13 days ago

January MySQL Meetups - Belfast & Dublin, Ireland ^{(from The Oracle MySQL Blog)}

Belfast & Dublin Meetups [...]

Published Tuesday, 17. December 2024 13:23 • 13 days ago

JavaScript is still number one – JetBrains report ^{(from InfoWorld)}

pJavaScript is the most-used programming language, according to JetBrains’ State of Developer Ecosystem Report 2024. But the languages with the most promising growth prospects are TypeScript, Rust, and Python, the report says. /p pThis year’s report found that JavaScript, with 61% of developers worldwide using it to create web pages, remains the most popular programming la [...]

Published Tuesday, 17. December 2024 02:42 • 14 days ago

WeSQL Outperforms AWS RDS MySQL Single AZ -- 4-6x the Speed, 1/2 the cost ^{(from WeSQL Blog)}

When people hear "S3" and "OLTP database" in the same sentence, skepticism is a common reaction. [...]

Published Tuesday, 17. December 2024 00:00 • 14 days ago

Shrink storage volumes for your RDS databases and optimize your infrastructure costs ^{(from AWS Database Blog)}

Recently, Amazon RDS launched the ability to shrink storage volumes using Amazon RDS Blue/Green Deployments – a nice addition to the list of new use cases that Blue/Green Deployments now supports. In this post, we cover how to use the new storage volume shrink feature in Amazon RDS Blue/Green Deployments to minimize the downtime required to perform the storage size reduction operation. We also revi [...]

Published Monday, 16. December 2024 20:49 • 14 days ago

Best practices for creating a VPC for Amazon RDS for Db2 ^{(from AWS Database Blog)}

You can create an Amazon RDS for Db2 instance by using the AWS Management Console, AWS Command Line Interface (AWS CLI), AWS CloudFormation, Terraform by Hashicorp, AWS Lambda functions, or other methods. One of the prerequisites for creating an RDS for Db2 instance is to configure the virtual private cloud (VPC) appropriately. This post shows how to create a VPC with best practices for any Amazon [...]

Published Monday, 16. December 2024 20:43 • 14 days ago

MariaDB Point In Time Recovery ^{(from MariaDB Corporation Blog)}

Database backup and restore are arguably the most important tasks of the database administrator (DBA). Once in a while, the … Continued [...]

Published Monday, 16. December 2024 19:06 • 14 days ago

Rapyd Enhances Performance and Security by Migrating from Amazon RDS to MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

By migrating to MySQL Enterprise Edition, Rapyd has strengthened its competitive edge, improved service reliability, and enhanced database performance. Read the full blog. [...]

Published Monday, 16. December 2024 18:45 • 14 days ago

Best practices for safely performing schema changes in Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pAzure Database for MySQL - Flexible Server is built on the open-source MySQL database engine, and the service supports MySQL 8.0 and newer versions. This means that users can take advantage of the flexibility and advanced capabilities of MySQL’s latest features while benefitting from a fully managed database service./p pWhile newer versions and features can provide a lot of value, the recent issue [...]

Published Monday, 16. December 2024 17:42 • 14 days ago

MySQL Blog Revisited - MySQL Shell ^{(from The Oracle MySQL Blog)}

For the 16th day of our Advent Calendar of Content, we bring you a summary of all the MySQL Blog posts that discuss handy features of MySQL Shell. [...]

Published Monday, 16. December 2024 05:00 • 14 days ago

DBAs not dead ( punk ) ! ^{(from The consistent voice)}

DBAs not dead ( punk ) !♦pToday’s post has been inspired ( fueled ? ) by this linkedin post about what devops should worry about. And the analogy to DBA just triggered me given that amount of failures and bullshit i keep witnessing on a daily basis in my professional life. So here’s my opinion on the matter ( the DBA that is, since devops is none of my business so far )./pplet’s quote the DBA secti [...]

Published Sunday, 15. December 2024 18:08 • 15 days ago

Releem vs EverSQL ^{(from Releem Blog)}

Compare Releem and EverSQL for SQL Query Optimization [...]

Published Sunday, 15. December 2024 17:17 • 15 days ago

MySQL Shorts Revisited - SQL Commands ^{(from The Oracle MySQL Blog)}

For the 15th day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on how to use various SQL commands. [...]

Published Sunday, 15. December 2024 05:00 • 15 days ago

AWS re:Invent2024 Aurora 发布了啥 – DSQL 篇 ^{(from Chen Zongzhi's GitHub blog)}

这个是前年AWS re:Invent 2022 的内容, 有兴趣可以看这个链接: Aurora re:Invent 2022 [...]

Published Sunday, 15. December 2024 00:00 • 16 days ago

MySQL Retrospective - Certifications ^{(from The Oracle MySQL Blog)}

This post is a brief retrospective on MySQL certification over the years and versions. [...]

Published Saturday, 14. December 2024 11:16 • 16 days ago

Ma Madeleine de Proust ^{(from The consistent voice)}

pA more personal story/ppThe “madeleine de Proust” is a powerful literary and cultural concept that originates from Marcel Proust’s renowned novel “À la recherche du temps perdu” (In Search of Lost Time), specifically from the first volume “Du côté de chez Swann” (Swann’s Way), published in 1913 In this work, Proust describes a pivotal moment where the narrator tastes a madeleine cake dipped in tea [...]

Published Friday, 13. December 2024 18:38 • 17 days ago

HeatWave Japan User Group. Q&A with Masataka Narita and Tatsuya Naito ^{(from ODBMS.org)}

Q1. We hear about GenAI every day. How can we leverage HeatWave GenAI specifically? What makes HeatWave GenAI unique? The big difference is that the entire GenAI process can be completed within customer’s HeatWave. There are... [...]

Published Friday, 13. December 2024 14:36 • 17 days ago

The Mystery of ProxySQL Galera Writer Switchover! ^{(from Vettabase)}

Writer switchover issues with ProxySQL and Galera can feel like an unsolved puzzle. Recently, I encountered two strange behaviors that revealed underlying issues in how ProxySQL interacts with Galera clusters. In this post, I’ll walk through the unexpected behaviors I faced, and the troubleshooting approaches that helped me address these challenges, and workarounds to avoid them. ProxySQL is one of [...]

Published Friday, 13. December 2024 12:03 • 17 days ago

Running Drupal using Always Free Resources in Oracle Cloud ^{(from The Oracle MySQL Blog)}

With the introduction of the Always Free tier of HeatWave MySQL, we can now run a Drupal site at no cost by using Always Free Compute and an Always Free HeatWave MySQL instance. Check out this post to find out how. [...]

Published Friday, 13. December 2024 05:00 • 17 days ago

Mydumper Works with Dolt ^{(from DoltHub Blog)}

Dolt is a drop in-replacement for MySQL, which means it can be used with any MySQL-compatible tool. One such tool is Mydumper and its… [...]

Published Friday, 13. December 2024 00:00 • 18 days ago

Defining a Scalable System: What It Really Means to Be “Future Proof” ^{(from PingCAP Blog)}

pBuilding a scalable system that’s also future proof has become a critical factor for organizations who want to maintain a competitive edge. At HTAP Summit 2024, PingCAP Software Architect Sunny Bains uncovered the challenges and solutions associated with scaling such complex systems. He highlighted the importance of robust, flexible architectures and showcased how TiDB, an […]/p pThe p [...]

Published Thursday, 12. December 2024 16:47 • 18 days ago

MySQL with Diagrams Part One: Replication Architecture ^{(from Percona Database Blog)}

♦In this series, “MySQL with Diagrams,” I’ll use diagrams to explain internals, architectures, and structures as detailed as possible. In basic terms, here’s how replication works: the transactions are written into a binary log on the source side, carried into the replica, and applied. The replica’s connection metadata repository contains information that the replication receiver [̷ [...]

Published Thursday, 12. December 2024 14:35 • 18 days ago

MySQL Rockstar 2013: Q&A with Sveta Smirnova. ^{(from ODBMS.org)}

Q1. You work at work Percona as Principal Support Engineer for MySQL, its forks and utilities. What are your responsibilities? My title is Principal Support Engineering Coordinator and my responsibility is to ensure that... [...]

Published Thursday, 12. December 2024 10:24 • 18 days ago

MySQL Blog Revisited - Regular Expressions ^{(from The Oracle MySQL Blog)}

For the 12th day of our Advent Calendar of Content, we bring you a summary of all the MySQL Blog posts that discuss regular expressions and how they can be used in MySQL. [...]

Published Thursday, 12. December 2024 05:00 • 18 days ago

Run Database in GitHub Actions, Persisting Data to S3, and Access it Publicly ^{(from WeSQL Blog)}

When it comes to running a database for development, testing, demos, or short-lived workloads, cost and complexity can be big headaches. Traditional database hosting—like a VPS, a cloud VM, or a managed service—comes with ongoing costs, storage expenses, and configuration overhead. You often end up paying for resources even when you're not using them. [...]

Published Thursday, 12. December 2024 00:00 • 19 days ago

Transforming Databases for the AI Era: The Vector Revolution ^{(from MariaDB Corporation Blog)}

I recently joined MariaDB as VP of Product Management, coming from a background in Artificial Intelligence (AI) Engineering and Product … Continued [...]

Published Wednesday, 11. December 2024 21:33 • 19 days ago

Some MySQL Router 8.4.3 read-write splitting quips ^{(from MySQL-Med)}

Naughty Router read-write split port! After some testing, I was quite surprised when... Continue reading → [...]

Published Wednesday, 11. December 2024 18:34 • 19 days ago

MariaDB spinout SkySQL secures seed funding to ‘bring conversational AI to databases’ ^{(from TechCrunch)}

pAnyone who’s followed the fortunes of MySQL and MariaDB these past 15 years will probably remember SkySQL, another brand that once existed within that same database ecosystem and, a year ago, became a stand-alone company once more. That company today announced it has raised its first outside funding — a $6.6 million seed round — […]/p p© 2024 TechCrunch. All rights reserved [...]

Published Wednesday, 11. December 2024 17:00 • 19 days ago

CodeQL zero to hero part 4: Gradio framework case study ^{(from The GitHub Blog)}

pLearn how I discovered 11 new vulnerabilities by writing CodeQL models for Gradio framework and how you can do it, too./p pThe post CodeQL zero to hero part 4: Gradio framework case study appeared first on The GitHub Blog./p [...]

Published Wednesday, 11. December 2024 15:00 • 19 days ago

Optimizing Tungsten Node Availability Checks: Balancing Recovery and Aggressiveness for Cluster Stability ^{(from Continuent Blog)}

Tungsten Clustering ensures high availability with robust failover capabilities, driven by the Tungsten Manager's health checks and predefined rules. In this blog post, we explore key processes like handling heartbeat gaps, network partitions, and availability checks. We also provide tips for tuning parameters to optimize performance and maintain a resilient database cluster.Tags: tungsten clu [...]

Published Wednesday, 11. December 2024 09:42 • 19 days ago

MySQL Shorts Revisited - Working with JSON ^{(from The Oracle MySQL Blog)}

For the 11th day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on making working with JSON easier. [...]

Published Wednesday, 11. December 2024 05:00 • 19 days ago

America First Credit Union: Streamlining Member Onboarding with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

This blog covers how America First Credit Union adoption of MySQL Enterprise Edition has transformed its membership onboarding process, reducing complexity, improving system performance, and boosting member satisfaction. [...]

Published Wednesday, 11. December 2024 01:26 • 20 days ago

MySQL-9.0, Dolt, and Caching SHA-2 Auth Support ^{(from DoltHub Blog)}

Lately, we've seen customers install the latest innovation release of MySQL (i.e. MySQL-9.0) and then have problems connecting to a Dolt SQL… [...]

Published Wednesday, 11. December 2024 00:00 • 20 days ago

MariaDB Enterprise Server Q4 2024 Maintenance Releases with Backported Features ^{(from MariaDB Corporation Blog)}

New maintenance releases for MariaDB Enterprise Server 10.6.20-16 and 10.5.27-21 are now available. These releases include new backported features. Download … Continued [...]

Published Tuesday, 10. December 2024 17:56 • 20 days ago

Simplifying AI Development: A Practical Guide to HeatWave GenAI’s RAG & Vector Store Features ^{(from MySQL expert Diary)}

pThis tutorial explores HeatWave GenAI, a cloud service that simplifies interacting with unstructured data using natural language. It combines large language models, vector stores, and SQL queries to enable tasks like content generation, chatbot, and retrieval-augmented generation (RAG). The focus is on RAG and how HeatWave GenAI’s architecture helps users gain insights from their data./p The post [...]

Published Tuesday, 10. December 2024 09:26 • 20 days ago

Running WordPress using Always Free Resources in Oracle Cloud ^{(from The Oracle MySQL Blog)}

With the introduction of the Always Free tier of HeatWave MySQL, we can now run a WordPress site at no cost by using Always Free Compute and an Always Free HeatWave MySQL instance. Check out this post to find out how. [...]

Published Tuesday, 10. December 2024 05:00 • 20 days ago

A Tour of config.yaml ^{(from DoltHub Blog)}

Hot on the heels of my overview of Dolt configuration, I'm going to do a deep dive on , the configuration file for a Dolt SQL Server. As I… [...]

Published Tuesday, 10. December 2024 00:00 • 21 days ago

Index Usage For EXTRACT(YEAR FROM …), YEAR(…) etc. ^{(from Use The Index, Luke)}

Automatic Rewrite of Date and Time RangespThe following chart shows which DBMS rewrites codewhere/code clause expressions that access the year part of a codedate/code or codetimestamp/code (or the like) into a range expression such as codets >= DATE'2024-01-01' AND ts < DATE'2025-01-01'/code. This enables the use of a sort-based index on the codets/code column./p♦olliUnconditionally rewritten [...]

Published Tuesday, 10. December 2024 00:00 • 21 days ago

Enhancing MariaDB’s Capabilities part 2 ^{(from The consistent voice)}

pStill running after Stonebraker’s prediction about database engine convergence/pWhat is OQGRAPH?pOQGRAPH, or the Open Query GRAPH engine, is a specialized storage engine designed for handling hierarchical and complex graph data within relational database management systems (RDBMS) like MariaDB. It allows users to access and manipulate data as graphs, which is particularly useful for storing and qu [...]

Published Monday, 09. December 2024 13:54 • 21 days ago

Killer Blog for MySQL Administrators ^{(from Kedar MySQL Blog)}

pThis is by far the most killer MySQL blog that I wanted to write for really long as a part of a Killer DBA series. Time is hard to find,…/p The post Killer Blog for MySQL Administrators first appeared on Change Is Inevitable. [...]

Published Monday, 09. December 2024 07:00 • 21 days ago

MySQL Shorts Revisited - Functions Galore ^{(from The Oracle MySQL Blog)}

For the ninth day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on internal MySQL functions. [...]

Published Monday, 09. December 2024 05:00 • 21 days ago

Decentralized Wikipedia Update ^{(from DoltHub Blog)}

Dolt is a decentralized database. In the past ten years or so decentralization has gone through a few hype cycles. I think we're in a pro… [...]

Published Monday, 09. December 2024 00:00 • 22 days ago

Frequently Asked Questions - Releem ^{(from Releem Blog)}

Frequently asked questions from our users [...]

Published Sunday, 08. December 2024 06:44 • 22 days ago

MySQL Retrospective - The Middle Years ^{(from The Oracle MySQL Blog)}

As part of the Advent calendar of content for this year, we are going to take a stroll down memory lane into the history of MySQL. In this first post, we will highlight some of the major milestones of the middle years. [...]

Published Sunday, 08. December 2024 05:00 • 22 days ago

How to tune Redis for High Traffic Applications? ^{(from MinervaDB Blog)}

pRedis Optimization Guide for High-Traffic Applications Tuning Redis for high-traffic applications requires careful optimization of configuration, hardware, data structures, and monitoring. Here's a comprehensive guide to ensure Redis handles high traffic efficiently: 1. Optimize Redis [...]/p pThe post How to tune Redis for High Traffic Applications? appeared first on The WebScale Database Infrast [...]

Published Saturday, 07. December 2024 19:39 • 23 days ago

MySQL Shorts Revisited - MySQL Shell ^{(from The Oracle MySQL Blog)}

For the seventh day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on MySQL Shell. [...]

Published Saturday, 07. December 2024 05:00 • 23 days ago

KB Kookmin Bank: Pioneering Open-Source Banking with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

KB Kookmin Bank thoroughly evaluated multiple options, including PostgreSQL, MariaDB, and MongoDB. Ultimately, it chose MySQL Enterprise Edition for its proven stability, robust technical support, cost-effectiveness, and comprehensive enterprise features, such as advanced replication and secure backup solutions. Read the full blog. [...]

Published Saturday, 07. December 2024 04:31 • 23 days ago

From caching to real-time analytics: Essential use cases for Amazon ElastiCache for Valkey ^{(from AWS Database Blog)}

Valkey is an open-source, distributed, in-memory key-value data store that offers high-performance data retrieval and storage capabilities, making it an ideal choice for scalable, low-latency modern application development. Originating as a fork of Redis OSS following recent licensing changes, Valkey maintains full compatibility with its predecessor while providing high performance alternative for [...]

Published Friday, 06. December 2024 20:59 • 24 days ago

Automate pre-checks for your Amazon RDS for MySQL major version upgrade ^{(from AWS Database Blog)}

Amazon Relational Database Service (Amazon RDS) for MySQL currently supports a variety of Community MySQL major versions including 5.7, 8.0, and 8.4 which present many different features and bug fixes. Upgrading from one major version to another requires careful consideration and planning. For a complete list of compatible major versions, see Supported MySQL major versions […] [...]

Published Friday, 06. December 2024 20:54 • 24 days ago

Why Pinterest Modernized Its Graph Service with Distributed SQL ^{(from PingCAP Blog)}

pPinterest, one of the world’s leading visual search and discovery platforms, recently undertook a significant overhaul of its graph storage service. At the HTAP Summit 2024, Pinterest Senior Software Engineer Ke Chen discussed the company’s transition from its legacy Zen system to a new architecture built on top of TiDB, an advanced distributed SQL database. […]/p pThe post Why P [...]

Published Friday, 06. December 2024 20:50 • 24 days ago

MySQL High Availability and Disaster Recovery: Navigating the Top Solutions and Their Challenges ^{(from Continuent Blog)}

This article explores some of the leading MySQL — also including MySQL variants MariaDB and Percona Server — high availability (HA) and disaster recovery (DR) solutions – in alphabetical order, including AWS Aurora, Continuent Tungsten, DIY MySQL clusters, Galera Cluster, and MySQL InnoDB Cluster.Tags: MySQLHigh AvailabilityDisaster Recoverysolution comparisonAWS AuroraGalerainnodb clustertung [...]

Published Friday, 06. December 2024 12:11 • 24 days ago

MySQL Retrospective - Forgotten Functions ^{(from The Oracle MySQL Blog)}

For our MySQL Advent Calendar before the 30th Anniversary Year, let's have a look at some MySQL Retrospective [...]

Published Friday, 06. December 2024 11:00 • 24 days ago

Doltgres System Tables Update ^{(from DoltHub Blog)}

We've been hard at work getting Doltgres, a Postgres-flavored version of Dolt, ready for its beta release in Q1. This includes making sure… [...]

Published Friday, 06. December 2024 00:00 • 25 days ago

Release of RonDB 22.10.7 ^{(from Mikael Ronstrom)}

pToday we released a new release of the stable series of RonDB. This version RonDB 22.10.7 is mostly a bug fix release, but also contains a few new features that were required for the Kubernetes integration of RonDB./ppThe major development in RonDB is currently around RonDB 24.10 which is aimed for a first release in 1-2 months./ppRonDB 22.10.7 contains the following new features:/pRONDB-789: Find [...]

Published Thursday, 05. December 2024 19:46 • 25 days ago | Updated Thursday, 05. December 2024 19:46 • 25 days ago

Complete Guide to MariaDB Logs: Audit, Configuration, and More ^{(from Releem Blog)}

In this guide, we’ll walk through the various types of MariaDB logs, where to find them, and how to make the most of the insights they hold. With the right strategies, you can turn your logs into a powerful tool for maintaining and optimizing your database. [...]

Published Thursday, 05. December 2024 14:54 • 25 days ago

Clustercontrol adds Percona Server Pro, and support for MySQL v8.4, Elasticsearch v8.15, Valkey v8.0 in latest release ^{(from Severalnines Blog)}

pClustercontrol (CC) v2.3.0 is now live, featuring new enterprise binaries support for Percona Server Pro clusters and support for MySQL v8.4, Elasticsearch v8.15, and Valkey v8.0. Let’s dive into these key updates and discover what’s new! New enterprise binaries with compatibility for Percona Server Pro We have upgraded our enterprise binaries with Percona Server Pro […]/p pThe post Clusterc [...]

Published Thursday, 05. December 2024 13:25 • 25 days ago

MySQL HeatWave: Real-Time Analytics and High-Performance Data Processing ^{(from Devart MySQL Tool Blog)}

pMySQL HeatWave, an Oracle Cloud service, delivers high-performance query processing, efficiently manages large data volumes, and combines transactional and analytical processing within the same system. This article highlights its key features and benefits./p pThe post MySQL HeatWave: Real-Time Analytics and High-Performance Data Processing appeared first on Devart Blog./p [...]

Published Thursday, 05. December 2024 10:25 • 25 days ago

MySQL Shorts Revisited - MySQL Document Store ^{(from The Oracle MySQL Blog)}

For the fourth day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are discussed MySQL Document Store. [...]

Published Thursday, 05. December 2024 05:00 • 25 days ago

Using Connector Failover for MariaDB MaxScale Resiliency ^{(from MariaDB Corporation Blog)}

MariaDB MaxScale is an excellent solution for making your MariaDB Server database deployments highly available… but how do you make … Continued [...]

Published Wednesday, 04. December 2024 16:30 • 26 days ago

Deploy a Magento Open Source LAMP-stack e-commerce app on Azure with one click! ^{(from Azure for MySQL Blog)}

What is Magento Open Source? pMagento Open Source is a free and flexible e-commerce platform that allows you to create and manage online stores. It offers powerful features such as product catalog management, shopping cart, checkout, payment, shipping, marketing, analytics, and more. Magento Open Source is also highly customizable and extensible, enabling you to tailor your store to your specific n [...]

Published Wednesday, 04. December 2024 15:31 • 26 days ago

The Evolution of Stateful Applications in Kubernetes ^{(from Percona Database Blog)}

♦Recently I listened to Lenny Rachitsky’s podcast, where he invited Shreyas Doshi for the second time. The session was titled “4 questions Shreyas Doshi wishes he’d asked himself sooner”. One of the questions Shreyas brought up was, “Do I actually have a good taste?”. This is an interesting question to ask for an experienced product […] [...]

Published Wednesday, 04. December 2024 14:29 • 26 days ago

Optimise your database before scaling ^{(from Vettabase)}

Nowadays, there is a common misconceptions that we don’t need to optimise the technologies we use, because we can just scale out or scale up. Whereas scaling out means to add one or more instances of a technology, and scaling up means to run the technology on better servers. Both these options are made easy by the cloud. But trying to scale a database that needs optimisation has many drawback [...]

Published Wednesday, 04. December 2024 12:02 • 26 days ago

MySQL Retrospective - The Logo ^{(from The Oracle MySQL Blog)}

MySQL Advent Calendar Restrospective [...]

Published Wednesday, 04. December 2024 11:02 • 26 days ago

MySQL High Availability: Techniques to Ensure Uptime in Critical Systems ^{(from ProxySQL Blog)}

pA single hour of downtime costs companies an average of $300,000, with critical systems like databases bearing the brunt of this risk. MySQL, widely used for managing essential data, requires high availability (HA) solutions to maintain smooth uptime and avoid disruptions that can lead to financial loss or reputational damage. Ensuring the continuous availability [...]/p pThe post MySQL High Avai [...]

Published Wednesday, 04. December 2024 10:25 • 26 days ago

You like LEGOs ? so do I ^{(from The consistent voice)}

You like LEGOs ? so do Ialso that why i like MariadB so much !pLego has long been celebrated as a powerful tool for creativity and imagination, allowing builders of all ages to construct anything they can envision within the constraints set by the building blocks. Each Lego piece serves as a fundamental component, offering a unique shape, color, and function that can be combined in countless ways. [...]

Published Wednesday, 04. December 2024 10:09 • 26 days ago

Dolt Configuration ^{(from DoltHub Blog)}

Dolt configuration is a bit of a mess. To start, it's a union of Git and MySQL styles of configuration. Then, Dolt specific configuration is… [...]

Published Wednesday, 04. December 2024 00:00 • 27 days ago

Enabling Read-Write splitting for automatic query distribution – all with MySQL Router ^{(from MySQL-Med)}

I'm just trying out the v8.4 Read-Write configuration for MySQL Router, that comes default in the community edition and, as they say, TL;DR "it's default upon bootstrap". Continue reading → [...]

Published Tuesday, 03. December 2024 19:18 • 27 days ago

How to Rename a MySQL Database ^{(from Devart MySQL Tool Blog)}

pWhen working with MySQL databases, you may encounter the need to change a database name. However, MySQL no longer supports a direct renaming option. The RENAME DATABASE command, available in earlier versions, was removed due to the risk of data loss. Despite this, renaming a database in MySQL is still possible. This article explores the […]/p pThe post How to Rename a MySQL Database appeared [...]

Published Tuesday, 03. December 2024 17:10 • 27 days ago

Who Ate My MySQL Table Rows? ^{(from Percona Database Blog)}

♦TL;DR ALTER TABLE and OPTIMIZE TABLE on an InnoDB table, which rebuilds the table without blocking concurrent changes to it (i.e., executed using INPLACE algorithm) and concurrent DML or purge activity on the table can occasionally lead to two significant problems: ALTER/OPTIMIZE TABLE failing with an unnecessary duplicate key error (even though there are no […] [...]

Published Tuesday, 03. December 2024 16:07 • 27 days ago

Building a Restaurant Management System with Azure Database for MySQL ^{(from Azure for MySQL Blog)}

What we'll build ul liA restaurant database system that manages:/li ul liMenu items and categories/li liCustomer orders and reservations/li liStaff scheduling/li liInventory tracking/li /ul /ul Prerequisites pTo get the most out of this blog post, you should have a basic understanding of database concepts and familiarity with using SQL. In addition, before getting started, it’s important to ensure [...]

Published Tuesday, 03. December 2024 16:01 • 27 days ago

The Light MySQL Startup Optimization on EBS Volumes ^{(from J-F Gagné's MySQL Blog)}

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables. I already wrote four posts on the subject, they are listed below. In this post, I use the system analysis of the previous post to revisit the light optimization on EBS volumes. With this analysis, I am able to determine why the previous tests did not show [...]

Published Tuesday, 26. November 2024 15:44 • 1 months ago | Updated Tuesday, 03. December 2024 15:52 • 27 days ago

Understanding InnoDB Tablespace Duplicate Check (MySQL Startup with Many Tables) ^{(from J-F Gagné's MySQL Blog)}

This post is a little long, please bear with me as after the intro, you can skip to the essential.In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables. I already wrote three posts on the subject, they are listed below. In this post, I focus on describing the startup phase InnoDB Tablespace Duplicate Check (Duplicate Check for [...]

Published Tuesday, 19. November 2024 16:53 • 1 months ago | Updated Tuesday, 03. December 2024 15:52 • 27 days ago

InnoDB Tablespace Duplicate Check Threads (and EBS Volumes for MySQL Startup with Many Tables) ^{(from J-F Gagné's MySQL Blog)}

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables. I already wrote five posts on the subject, they are listed below. In this post, I use the knowledge we gained in the previous two posts to show the interest of tuning InnoDB Tablespace Duplicate Check Threads, making startup 30% in one case (2:28 vs. 3:33) and 5% in [...]

Published Tuesday, 03. December 2024 15:29 • 27 days ago | Updated Tuesday, 03. December 2024 15:38 • 27 days ago

Galera Cluster for MySQL 8.0.40-26.21, and MySQL 8.4.3-26.21 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.40-26.21 (release notes, download), with Galera replication library 4.21 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.3-26.21 (release notes, download), our [...]

Published Tuesday, 03. December 2024 15:26 • 27 days ago

Problematic Improved Offline Mode Error in MySQL 9 ^{(from J-F Gagné's MySQL Blog)}

I am writing this quick post to share what I think is a problematic new behavior of Offline Mode in MySQL 9. Basically, the new default behavior in MySQL 9 is to write the username of the user which set offline_mode to ON. I think this behavior has not been considered from a security point of view because it leaks a root username in the error message presented to the users. My [...]

Published Monday, 02. December 2024 19:03 • 28 days ago | Updated Tuesday, 03. December 2024 14:31 • 27 days ago

AWS Database Migration Service gets gen AI-powered schema conversion ^{(from InfoWorld)}

pAmazon Web Services (AWS) has updated its Database Migration Service’s schema conversion feature with a new generative AI-powered capability that automates schema conversion to a great extent./p pThe schema conversion feature, announced at the ongoing annual re:Invent conference, helps enterprises convert the source database schema and procedures to the target database s [...]

Published Tuesday, 03. December 2024 10:05 • 27 days ago

MySQL Shorts Revisited - HeatWave MySQL ^{(from The Oracle MySQL Blog)}

For the third day of our Advent Calendar of Content, we bring you a summary of all the MySQL Shorts that are focussed on HeatWave MySQL [...]

Published Tuesday, 03. December 2024 05:00 • 27 days ago

Dolt SSL Authentication ^{(from DoltHub Blog)}

Dolt is the world's first and only version controlled SQL database. Dolt is fully MySQL-compatible. You connect to it with any MySQL client… [...]

Published Tuesday, 03. December 2024 00:00 • 28 days ago

Lina One Enhances Telemarketing Productivity with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

With the successful deployment of MySQL Enterprise Edition, Lina One has improved telemarketing productivity across its call centers and set a new standard for efficiency and security in the insurance industry. Read the blog. [...]

Published Monday, 02. December 2024 21:50 • 28 days ago

Leveraging Cost Tags to enhance Cost Governance for HeatWave MySQL ^{(from The Oracle MySQL Blog)}

Tagging is an essential practice in managing and organizing cloud resources. In Oracle Cloud Infrastructure (OCI), tagging is an integral part of the OCI Identity and Access Management service(IAM) which provides a systematic way to categorize and manage resources effectively, such as cost tracking, cloud resource searching, filtering and logical organization. In this blog post, we will explore h [...]

Published Monday, 02. December 2024 21:44 • 28 days ago

MySQL GTID tags and binlog events ^{(from Daniël's Database Blog)}

pMySQL 8.4 and newer have extended the Global Transaction ID (GTID) functionality with a new “tag” option./p Refresher on GTID pA GTID is a unique ID that is assigned to a transaction. This is used if codegtid_mode/code is set to codeON/code. The benefit of this is that a transaction can be uniquely identified in a MySQL replication setup with multiple levels. Among others this makes it easier to r [...]

Published Monday, 02. December 2024 19:43 • 28 days ago | Updated Monday, 02. December 2024 19:43 • 28 days ago

MySQL Shorts Episode 79 is Available ^{(from The Oracle MySQL Blog)}

The latest episode of MySQL Shorts is now available. [...]

Published Monday, 02. December 2024 17:00 • 28 days ago

November Product Update ^{(from Readyset Blog)}

♦p👋 Hello December! Hope everyone had a great November and for those who celebrated, a wonderful Thanksgiving. brbrBefore we dive in, a quick note: our VP of Product, Tanmay Sinha, and I are currently at AWS re:Invent and would love to connect with you! If you’re/p [...]

Published Monday, 02. December 2024 16:55 • 28 days ago

Percona Monitoring and Management 3.0.0-Beta - Tech Preview ^{(from Percona Community Blog)}

Percona Monitoring and Management 3.0.0 Beta - Tech Preview We’re excited to announce the Tech Preview (Beta) release of Percona Monitoring and Management (PMM) 3.0.0-Beta. This release is intended for testing environments only, as it’s not yet production-ready. The GA (General Availability) release will be available through standard channels in the upcoming months. Release notes To see [...]

Published Monday, 02. December 2024 00:00 • 29 days ago

MySQL Retrospective - The Early Years ^{(from The Oracle MySQL Blog)}

As part of the Advent calendar of content for this year, we are going to take a stroll down memory lane into the history of MySQL. In this first post, we will highlight some of the major milestones of the early years. [...]

Published Sunday, 01. December 2024 05:00 • 29 days ago

Duwamish Trail Cleanup – Saturday, December 7, 2024 ^{(from Jeremy Cole)}

Who? You! Anyone can help if you can spend a bit of time and muscle power. Whether you like to bike, walk, or just happen to drive by the trail and see others using it, or have never even seen it and want to make Seattle a better place – come on out! We can […] [...]

Published Saturday, 30. November 2024 22:09 • 30 days ago

RocksDB on a big server: LRU vs hyperclock, v2 ^{(from Small Datum)}

pThis post show that RocksDB has gotten much faster over time for the read-heavy benchmarks that I use. I recently shared results from a large server to show the speedup from the hyperclock block cache implementation for different concurrency levels with RocksDB 9.6. Here I share results from the same server and different (old and new) RocksDB releases./ppResults are amazing on a large (48 cores) s [...]

Published Saturday, 30. November 2024 01:54 • 1 months ago | Updated Saturday, 30. November 2024 01:54 • 1 months ago

MySQL October 2024 GA Releases Now Available ^{(from ODBMS.org)}

This October release is the third LTS release and second Innovation release since MySQL announced our move to a new LTS/Innovation release model. For more info click here. Also you can read LEFRED blog... [...]

Published Friday, 29. November 2024 12:13 • 1 months ago

On MySQL Belgian Days 2025. Q&A with Frederic Descamps ^{(from ODBMS.org)}

Q1. You just announced that the MySQL Belgian Days 2025 event will be held before FOSDEM. What is FOSDEM? And why is it relevant to the MySQL Community? FOSDEM is a free event for software... [...]

Published Friday, 29. November 2024 11:35 • 1 months ago

Using Perl to Query Dolt Databases ^{(from DoltHub Blog)}

A couple of decades ago, as a brand-new CS grad just entering the world of big tech, I was given the Programming Perl book – also… [...]

Published Friday, 29. November 2024 00:00 • 1 months ago

MySQL NDB Cluster replication: Merge replication for active-active clusters ^{(from The Oracle MySQL Blog)}

Learn about the merge replication topology used for building scalable, bi-directional, multi-primary replication deployments using MySQL NDB Cluster. This topology makes it possible to reliably scale out circular replication forming three, four, or more clusters all containing the same data. [...]

Published Thursday, 28. November 2024 14:18 • 1 months ago

Try RAG with MariaDB Vector on your own MariaDB data! ^{(from MariaDB Foundation Blog)}

pThe day has come that you have been waiting for since the ChatGPT hype began: You can now build creative AI apps using your own data in MariaDB Server! … /p pContinue reading \"Try RAG with MariaDB Vector on your own MariaDB data!\"/p pThe post Try RAG with MariaDB Vector on your own MariaDB data! appeared first on MariaDB.org./p [...]

Published Thursday, 28. November 2024 07:44 • 1 months ago

Auto Adapting Configuration Parameters in MySQL ^{(from The Oracle MySQL Blog)}

MySQL 8.4 changes the default values of built-in configurations when compared to MySQL 8.0. These changes are designed to auto adapt with the machine making the MySQL server production ready out of the box. [...]

Published Thursday, 28. November 2024 06:30 • 1 months ago

BELGIAN MYSQL, MARIADB and friends COMMUNITY DINNER – FRIDAY 31 January 2025 ^{(from FOSDEM MySQL & Friends Devroom)}

FOSDEM is back in town! And the MySQL Devroom is back after one year of absence on the main event. Same as the last few year the MySQL community team is once again organizing the Belgian MySQL Days. This provides us with the opportunity to bring the community together to socialize and exchange idea’s over a […] [...]

Published Wednesday, 27. November 2024 16:12 • 1 months ago

MariaDB extensibility ^{(from The consistent voice)}

Enhancing MariaDB’s Capabilities: Exploring Extensibility OptionspMariaDB, a powerful open-source database system, offers a versatile feature that many developers overlook: User-Defined Functions (UDFs). This capability, inherited from MySQL’s early days (around 25 years ago in version 3.21.24), allows you to extend the database’s functionality in ways that can significantly enhance your applicatio [...]

Published Wednesday, 27. November 2024 13:17 • 1 months ago

On NEXTGRES and the evolution of PostgreSQL. Q&A with Jonah Harris. ^{(from ODBMS.org)}

Q1: What is NEXTGRES? NEXTGRES is a next-generation, enterprise-class evolution of PostgreSQL designed to unify diverse data types, code execution, and computational workloads within a single, scalable system. By integrating multiple data models–including relational,... [...]

Published Wednesday, 27. November 2024 10:48 • 1 months ago

Productionizing Dolt ^{(from DoltHub Blog)}

So you've been using Dolt for a while, and you are ready to take the next step and use it in production. Whether you are running your… [...]

Published Wednesday, 27. November 2024 00:00 • 1 months ago

Black Friday or Dark Friday? Depends If MySQL Stands the Rush ^{(from Another Boring Tech Blog)}

pBlack Friday or Dark Friday? Tips to Ensure Your MySQL Instance Survives Black Friday is one of the most demanding days of the year for e-commerce and online services, and your database is at the heart of it all. A slow or offline MySQL instance can turn your Black Friday into a Dark Friday, costing.../p pO post Black Friday or Dark Friday? Depends If MySQL Stands the Rush apareceu primeiro em Ano [...]

Published Tuesday, 26. November 2024 23:13 • 1 months ago

Faster MySQL Startup with Many Tables (1M+) ^{(from J-F Gagné's MySQL Blog)}

I have been scratching my head about MySQL startup for some time. There is much to say about this, and many other posts will probably follow. For now, it is enough to know that with many tables (millions) the startup of MySQL 8.0+ (including 8.0, 8.4 and 9.0) is suboptimal (to say the least). With very little changes, I was able to speed it up, from 2:39 to 1:09 (1 minute and 9 [...]

Published Tuesday, 03. September 2024 15:39 • 4 months ago | Updated Tuesday, 26. November 2024 15:48 • 1 months ago

A New Trend: Organizations Moving Away from Managed MySQL ^{(from Continuent Blog)}

Cloud-based managed MySQL services like Amazon Aurora promised simplicity, scalability, and cost savings. But as adoption grows, many organizations are uncovering hidden costs, operational challenges, and limitations. This blog explores why companies are migrating back to on-premises MySQL and how solutions like Tungsten Clusters are empowering them to regain control, cut costs, and ensure flexibil [...]

Published Tuesday, 26. November 2024 14:53 • 1 months ago

Use MySQL Shell To Run JavaScript And Python Scripts From The Command Line ^{(from The Oracle MySQL Blog)}

How to use MySQL Shell to run JavaScript and Python scripts to connect to a MySQL database and execute queries. In this example, I show you how to dump and load a database table with a JavaScript script. [...]

Published Monday, 25. November 2024 21:47 • 1 months ago

RocksDB benchmarks: large server, leveled compaction ^{(from Small Datum)}

pI recently shared benchmark results for RocksDB a few weeks ago for both leveled and universal compaction on a small server. This post has results from a large server with leveled compaction. /pptl;dr/pp/pullithere are a few regressions from bug 12038/liliQPS for overwrite is ~1.5X to ~2X better in 9.x than 6.0 (ignoring bug 12038)/liliotherwise QPS in 9.x is similar to 6.x/li/ulp/ppHardware/ [...]

Published Saturday, 09. November 2024 19:40 • 2 months ago | Updated Monday, 25. November 2024 18:10 • 1 months ago

RocksDB benchmarks: large server, universal compaction ^{(from Small Datum)}

pThis post has results from a large server with universal compaction from the same server for which I recently shared leveled compaction results. The results are boring (no large regressions) but a bit more exciting than the ones for leveled compaction because there is more variance. A somewhat educated guess is that variance more likely with universal./pptl;dr/pp/pullithere are some small regressi [...]

Published Monday, 25. November 2024 17:50 • 1 months ago | Updated Monday, 25. November 2024 18:10 • 1 months ago

Choosing the Right Data Types for Database Attributes ^{(from The consistent voice)}

pSelecting appropriate data types for database attributes is crucial for performance, storage efficiency, and data integrity. Here’s an explanation of the importance of choosing the right data types:/pPerformanceulliQuery Efficiency: Using appropriate data types speeds up query processing./liliIndexing: Certain data types are more efficient for indexing./liliSorting and Searching: Operations are fa [...]

Published Monday, 25. November 2024 15:48 • 1 months ago

Azure Database for MySQL bindings for Azure Functions (Public Preview) ^{(from Azure for MySQL Blog)}

pThe latest addition to the continuous advancements in Azure Database for MySQL is the introduction of Azure Database for MySQL bindings for Azure Functions, now available in Public Preview. These newly released input and output bindings enable seamless integration with Azure Functions, allowing developers and organizations to build at-scale event-driven applications and serverless APIs that integr [...]

Published Monday, 25. November 2024 14:30 • 1 months ago

MySQL 9.1 is out! Thank you for your contributions! ^{(from The Oracle MySQL Blog)}

Within this blog post, we want to thanks all our contributors and list all the contributions that have been processed and released with MySQL 9.1 [...]

Published Monday, 25. November 2024 13:04 • 1 months ago

MySQL 9.1 is out! Thank you for your contributions! ^{(from lefred's blog)}

Last month we released MySQL 9.1, the latest Innovation Release. Of course, we released bug fixes for 8.0 and 8.4 LTS but in this post, I focus on the newest release. Within these releases, we included patches and code received by our amazing Community. Here is the list of contributions we processed and included in […] [...]

Published Monday, 25. November 2024 13:00 • 1 months ago

Speed is the killer app ^{(from InfoWorld)}

pWhy do enterprises so often choose to run applications in the cloud even when it may not be the cheapest option? Why do they turn to open source even if it’s not the most feature-complete choice? And why is generative AI so frothy hot even though, as my InfoWorld colleague David Linthicum argues, “Companies are good at spending money [on AI] but bad at building and deploying [...]

Published Monday, 25. November 2024 09:00 • 1 months ago

Talk: The implementation of MariaDB parallel replication ^{(from MariaDB Foundation Blog)}

pOn November 6 2024 I presented a talk with the title: “The implementation of MariaDB parallel replication” at a local TeqHub meetup in Copenhagen. … /p pContinue reading \"Talk: The implementation of MariaDB parallel replication\"/p pThe post Talk: The implementation of MariaDB parallel replication appeared first on MariaDB.org./p [...]

Published Monday, 25. November 2024 08:26 • 1 months ago

Enhancing Developer Agility and Performance in Financial Services with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

This blog outlines how MySQL Enterprise Edition enhances developer agility and performance in financial services. [...]

Published Monday, 25. November 2024 05:45 • 1 months ago

RBL Bank Enhances Security and Efficiency with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

RBL Bank's strategic shift to MySQL Enterprise Edition fortified its cybersecurity defenses and streamlined operations, positioning the bank for continued growth and customer satisfaction in the competitive banking landscape. Read the blog. [...]

Published Monday, 25. November 2024 04:44 • 1 months ago

Balancing Perf Trade-offs ^{(from DoltHub Blog)}

I ran into a performance trade-off last week attempting to improve long-running queries by changing the ways rows are structured. A more… [...]

Published Sunday, 24. November 2024 00:00 • 1 months ago

How to Identify Processes Using Swap Memory on Linux ^{(from Another Boring Tech Blog)}

pIdentifying which processes have pages swapped out of memory when troubleshooting performance issues on a Linux system is often helpful. Swapping can impact system performance, so knowing which processes are affected is important in diagnosing and resolving these issues. Checking Swap Usage by Process Linux provides detailed process information in the /proc directory. By leveraging.../p pO post Ho [...]

Published Saturday, 23. November 2024 12:34 • 1 months ago

Pipelined DML in TiDB: A Breakthrough for Managing Large Transactions ^{(from PingCAP Blog)}

pManaging large transactions in distributed databases has always been a tough nut to crack. From processing millions of records during migrations to tackling complex workflows like ETL (Extract, Transform, Load), businesses need database solutions that are not only fast but also reliable. TiDB has long been at the forefront of distributed SQL database innovation, and […]/p pThe post Pipelined [...]

Published Friday, 22. November 2024 21:00 • 1 months ago

Accelerating Distributed SQL Adoption: How Plaid Migrated 41 Services from Amazon Aurora in One Year ^{(from PingCAP Blog)}

pPlaid is a financial services company that builds a data transfer network for applications to connect with users’ bank accounts. At HTAP Summit 2024, Zander Hill, Experienced Software Engineer at Plaid, and Andrew Chen, Engineering Manager at Plaid, shared an in-depth look into their company’s ambitious migration from Amazon Aurora to a distributed SQL database […]/p pThe post Accelerating D [...]

Published Friday, 22. November 2024 19:14 • 1 months ago

New Contact Management in HeatWave MySQL ^{(from The Oracle MySQL Blog)}

Customer contacts in HeatWave is a new feature that streamlines notification management by allowing you to assign specific contacts for all critical databases. With this capability, your Cloud Ops and DBA team can stay informed about operational issues, maintenance updates, and service announcements, ensuring timely responses. [...]

Published Friday, 22. November 2024 14:21 • 1 months ago

MariaDB 11.6.2 and MariaDB 11.7.1 now available ^{(from MariaDB Foundation Blog)}

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 11.7.1, the latest rolling release Release Candidate (RC), and MariaDB 11.6.2, the latest Generally Available (GA) rolling release. … /p pContinue reading \"MariaDB 11.6.2 and MariaDB 11.7.1 now available\"/p pThe post MariaDB 11.6.2 and MariaDB 11.7.1 now available appeared first on MariaDB.org./p [...]

Published Friday, 22. November 2024 09:16 • 1 months ago

Replica Preserve Commit Order and Measuring Lag ^{(from Hack MySQL)}

pWith multi-threaded replication (MTR), a replica can commit transactions in the same order as the source, or not. This is determined by sysvar codereplica_preserve_commit_order/code (RPCO). As of MySQL v8.0.27 (released October 2021) it’s ON by default, but it was OFF by default for several years prior. In either case, it’s relatively new compared to 20+ years of single-threaded replic [...]

Published Friday, 22. November 2024 00:01 • 1 months ago

Automate database user management with AWS Lambda and AWS Systems Manager ^{(from AWS Database Blog)}

Amazon Web Services (AWS) users frequently use multiple accounts, organizing them efficiently with AWS Organizations. This system structures the accounts hierarchically and groups them into Organizational Units (OUs). However, this setup can sometimes add complexity, especially for teams that support the entire organization. Consider the following example of a database operations team’s predicament [...]

Published Thursday, 21. November 2024 23:06 • 1 months ago

Amazon RDS for MySQL LTS version 8.4 is now generally available ^{(from AWS Database Blog)}

Today, Amazon RDS has announced support for MySQL version 8.4, which is the latest Long-Term Support (LTS) major version from the MySQL community. With that, Amazon RDS now supports MySQL Community Edition versions 8.0 and 8.4. In addition to the two community-supported LTS releases, Amazon RDS also offers MySQL 5.7 under RDS Extended Support, where RDS provides critical patches and bug fixes for t [...]

Published Thursday, 21. November 2024 21:24 • 1 months ago

Amazon RDS Blue/Green Deployments Green storage fully performant prior to switchover ^{(from AWS What's New)}

pAmazon Relational Database Service (Amazon RDS) Blue/Green Deployments now support managed initialization of Green storage volumes that accelerates the loading of storage blocks from Amazon S3. This ensures that the volumes are fully performant prior to switchover of the Green databases. Blue/Green Deployments create a fully managed staging environment, or Green database, by restoring the Blue dat [...]

Published Thursday, 21. November 2024 18:00 • 1 months ago

Amazon RDS for MySQL now supports MySQL 8.4 LTS release ^{(from AWS What's New)}

pAmazon RDS for MySQL now supports MySQL major version 8.4, the latest long-term support (LTS) release from the MySQL community. RDS for MySQL 8.4 is integrated with AWS Libcrypto (AWS-LC) FIPS module (Certificate #4816), and includes support for multi-source replication plugin for analytics, Group Replication plugin for continuous availability, as well as several performance and feature improvemen [...]

Published Thursday, 21. November 2024 18:00 • 1 months ago

Announcing MariaDB Community Server 11.7 RC with Vector Search and 11.6 GA ^{(from MariaDB Corporation Blog)}

We are pleased to announce the general availability (GA) of MariaDB Community Server 11.6 and the release candidate (RC) of … Continued [...]

Published Thursday, 21. November 2024 17:22 • 1 months ago

Testing Dolphie For the First Time: Features and Feedback ^{(from Another Boring Tech Blog)}

pIn this blog post, I will test Dolphie, an open-source project by Charles Thompson. Dolphie is an open-source tool that provides real-time analytics for MySQL, MariaDB, and ProxySQL. As a first-time user, my goal is to go from zero to hero, exploring how easy it is to start using the tool while getting familiar with.../p pO post Testing Dolphie For the First Time: Features and Feedback apareceu p [...]

Published Thursday, 21. November 2024 17:10 • 1 months ago

Belgian MySQL Days 2025, Thursday 30th January 2025 9:00AM ^{(from ODBMS.org)}

ICAB Incubator, Belgium, 1040 Thursday 30th January 2025 9:00AM Join us for the preFOSDEM MySQL Belgian Days, a must-attend event for all MySQL enthusiasts! TO REGISTER As usual, this exciting in-person gathering will take... [...]

Published Thursday, 21. November 2024 15:36 • 1 months ago

Where can you find MySQL during December 2024 – February 2025 ^{(from ODBMS.org)}

By Lenka Kasparova, MySQL Community Manager You can find the new list of conferences and events we are part of during December 2024 to February 2025 here [...]

Published Thursday, 21. November 2024 14:39 • 1 months ago

AWS Compute Optimizer now supports rightsizing recommendations for Amazon Aurora ^{(from AWS What's New)}

pAWS Compute Optimizer now provides recommendations for Amazon Aurora DB instances. These recommendations help you identify idle database instances and choose the optimal DB instance class, so you can reduce costs for unused resources and increase the performance of under-provisioned workloads.br br AWS Compute Optimizer automatically analyzes Amazon CloudWatch metrics such as CPU utilization, netw [...]

Published Wednesday, 20. November 2024 22:30 • 1 months ago

Introducing scaling to 0 capacity with Amazon Aurora Serverless v2 ^{(from AWS Database Blog)}

Amazon Aurora Serverless v2 now supports scaling capacity down to 0 ACUs, enabling you to optimize costs during periods of database inactivity. Aurora Serverless is an on-demand, auto scaling configuration of Aurora that automatically adjusts your database capacity based on your workload requirements. Aurora Serverless measures database capacity in Aurora Capacity Units (ACUs) billed per [...]

Published Wednesday, 20. November 2024 22:21 • 1 months ago

MariaDB Java Connector 3.5.1 now available ^{(from MariaDB Corporation Blog)}

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

Published Wednesday, 20. November 2024 19:23 • 1 months ago

MySQL Memory Usage: A Guide to Optimization ^{(from Releem Blog)}

Let’s explore the core elements of MySQL memory usage with best practices for trimming excess in demanding environments. [...]

Published Wednesday, 20. November 2024 18:19 • 1 months ago

Dolphie – “Rerecord not fadeaway” ^{(from MySQL-Med)}

One of the coolest features is being able to go back in time with Dolphie and analyze what was happening at a specific moment. Continue reading → [...]

Published Wednesday, 20. November 2024 17:37 • 1 months ago

Understanding MySQL DDL Space Requirements ^{(from Another Boring Tech Blog)}

pThis blog post will explore MySQL’s file storage behavior during DDL operations, particularly with InnoDB tables. Using a practical example, we’ll discuss where and how MySQL stores data during different types of DDL operations. Setting the Stage: Table Structure Consider a table sbtest1 with 30 million rows, created as follows: [crayon-67475e6392cbe420388237/] This table is actively used.../p pO [...]

Published Wednesday, 20. November 2024 17:34 • 1 months ago

Building a Resilient Embedding System for Semantic Search at Airtable ^{(from Airtable Engineering Blog)}

pWhen ChatGPT burst into the public eye in 2022, a small team of engineers at Airtable started ideating on the different ways our platform could leverage this new set of capabilities. One idea kept popping up: rich, semantic search over customer data./ppImagine a marketing team asking, “Can you find past campaigns similar to this one?”, a product management team asking “can you find engineers whose [...]

Published Wednesday, 20. November 2024 17:27 • 1 months ago

AWS Advanced NodeJS Driver is Generally Available ^{(from AWS What's New)}

pThe Amazon Web Services (AWS) Advanced NodeJS Driver is now generally available for use with Amazon RDS and Amazon Aurora PostgreSQL and MySQL-compatible database clusters. This database driver provides support for faster switchover and failover times, Federated Authentication, and authentication with AWS Secrets Manager or AWS Identity and Access Management (IAM).br br The Amazon Web Services (AW [...]

Published Wednesday, 20. November 2024 17:00 • 1 months ago

Azure Database for MySQL support for MySQL 9.1 Innovation Release and MySQL 8.4 LTS - Public Preview ^{(from Azure for MySQL Blog)}

pWe are thrilled to announce the public preview of Azure Database for MySQL support for two exciting MySQL versions: MySQL 9.1 (Innovation Release) and MySQL 8.4 (LTS). These additions empower developers and database administrators with the latest MySQL features and enhancements to build, innovate, and optimize their applications on Azure./p pDuring the public preview phase, support for MySQL 9.1 ( [...]

Published Wednesday, 20. November 2024 16:39 • 1 months ago

Database Security: Best Practices to Protect Your MySQL Infrastructure ^{(from ProxySQL Blog)}

pAs of 2024, MySQL ranks as the second most popular database management system globally. MySQL has become a go-to choice for database management due to its dependable performance, stability, and open-source licensing. However, its popularity also brings significant security challenges like SQL injection attacks and unauthorized data access. As cyber threats evolve, protecting MySQL [...]/p pThe pos [...]

Published Wednesday, 20. November 2024 09:41 • 1 months ago

How Companies Can Improve Database Performance with ProxySQL ^{(from ProxySQL Blog)}

pThe efficiency of a company's database systems is not just an IT concern but a central business issue. Slow databases can drag down the entire user experience, leading to lost revenue and decreased efficiency. So, what's the secret to turbocharging database performance and staying ahead of potential bottlenecks? ProxySQL is an innovative middleware solution [...]/p pThe post How Companies Can Impr [...]

Published Wednesday, 20. November 2024 09:23 • 1 months ago

Newest MariaDB Enterprise Server release series reaches RC ^{(from MariaDB Corporation Blog)}

We are thrilled to introduce our newest major release of MariaDB Enterprise Server. For this release, we looked at how … Continued [...]

Published Tuesday, 19. November 2024 22:58 • 1 months ago

Using Dolphie for MySQL focus monitoring & performance tuning. ^{(from MySQL-Med)}

We can use so many different observability tools to get notifications, alerts, react, generate reports, etc. from so many different companies, using agents, proxies, repositories, and so on and so forth. And after exchanging experiences with dolphie's author himself, Charles, the idea here is to go that little bit further in monitoring MySQL. Continue reading → [...]

Published Tuesday, 19. November 2024 19:11 • 1 months ago

Long and Silent / Stressful MySQL Startup with Many Tables ^{(from J-F Gagné's MySQL Blog)}

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables. I already wrote two posts on the subject, the links are below. So far, I did not share what brought my attention to this, and it is the subject of this post. Also, and because it is related, I come back to the optimization / contribution I already made on [...]

Published Monday, 11. November 2024 21:20 • 2 months ago | Updated Tuesday, 19. November 2024 17:11 • 1 months ago

Using Loki and Promtail to Display PostgreSQL Logs From a Kubernetes Cluster in PMM ^{(from Percona Database Blog)}

♦This is a follow-up to my colleagues Nickolay and Phong’s Store and Manage Logs of Percona Operator Pods with PMM and Grafana Loki and Agustin’s Turbocharging Percona Monitoring and Management With Loki’s Log-shipping Functionality blog posts. Here, I focus on making PostgreSQL database logs from a Kubernetes cluster deployed with the Percona Operator for PostgreSQL […] [...]

Published Tuesday, 19. November 2024 14:21 • 1 months ago

Ignite 2024: New innovations in Azure Database for MySQL ^{(from Azure for MySQL Blog)}

pThe Azure Database for MySQL team is thrilled to unveil a suite of new features and innovations that are designed to empower both developers and enterprise organizations with the ability to get more out of their data with robust performance and efficiency, advanced security, and greater scalability for their applications./p pWhether you're looking to leverage cutting-edge innovations, ensure high [...]

Published Tuesday, 19. November 2024 14:00 • 1 months ago

Where can you find MySQL during December 2024 - February 2025 ^{(from The Oracle MySQL Blog)}

MySQL Conferences 12/24-2/25 [...]

Published Tuesday, 19. November 2024 09:41 • 1 months ago

Postgres's missing quality of life features ^{(from DoltHub Blog)}

We are hard at work building Doltgres, the Postgres-compatible version of Dolt. Dolt is the world's first and only version-controlled SQL… [...]

Published Tuesday, 19. November 2024 00:00 • 1 months ago

Anatomy of a Throttler, part 3 ^{(from PlanetScale Blog)}

Design considerations for implementing a database throttler [...]

Published Tuesday, 19. November 2024 00:00 • 1 months ago

Amazon Aurora MySQL 3.08 (compatible with MySQL 8.0.39) is generally available ^{(from AWS What's New)}

pStarting today, Amazon Aurora MySQL-Compatible Edition 3 (with MySQL 8.0 compatibility) will support MySQL 8.0.39. In addition to several security enhancements and bug fixes, MySQL 8.0.39 contains enhancements that improve database availability when handling large number of tables and reduce InnoDB issues related to redo logging, and index handling.br br Aurora MySQL 3.08 also includes multiple av [...]

Published Monday, 18. November 2024 21:35 • 1 months ago

My “PostgreSQL” story (PostgreSQL, Streaming Replication, Yugabyte, PGD, CockroachDB & StandbyMP story) ^{(from MySQL-Med)}

Learning how to evaluate PostgreSQL Streaming Replication, Yugabyte, PGD, CockroachDB & StandbyMP for highly available solutions. Continue reading → [...]

Published Monday, 18. November 2024 18:36 • 1 months ago

Why Query Caching Is the Most Cost-Effective Way To Scale Databases — and Everyone’s Missing It ^{(from Readyset Blog)}

pScaling databases is no small task, and in the rush to find fast, affordable solutions, teams often overlook a key technique: query caching. By intelligently caching database queries, we’re sidestepping many of the typical challenges and costs that come with sharding, complex materialized views and resource-intensive indexes. Yet,/p [...]

Published Monday, 18. November 2024 18:01 • 1 months ago

Amazon Aurora MySQL now supports R7i instances ^{(from AWS What's New)}

pAmazon Aurora with MySQL compatibility now supports R7i database instances powered by custom 4th Generation Intel Xeon Scalable processors. R7i instances offer larger instance sizes, up to 48xlarge and features an 8:1 ratio of memory to vCPU, and the latest DDR5 memory. These instances are now available in the following AWS Regions: US East (N. Virginia, Ohio), US West (N. California, Oregon), Asi [...]

Published Monday, 18. November 2024 18:00 • 1 months ago

Unleashing Query Power: Advanced Multi-Column Index Optimization in TiDB ^{(from PingCAP Blog)}

pIn today’s data-driven world, efficiently handling complex queries on large datasets is critical to keeping applications responsive and performant. For TiDB, a distributed SQL database designed to manage high-scale, high-demand environments, optimizing data access paths is essential to delivering smooth, efficient queries. This post dives into TiDB’s advanced approach to optimizing multi-column in [...]

Published Monday, 18. November 2024 16:43 • 1 months ago

Ensuring High Availability and Fault Tolerance for Business-Critical Workloads ^{(from Continuent Blog)}

In the current MySQL ecosystem, organizations must focus on high availability and fault tolerance to ensure business continuity and maintain customer trust. A recent inquiry to prominent tech executives identified five key themes for achieving this: multi-region deployment to prevent single points of failure, automated self-healing for quick issue resolution, redundancy through system duplication, [...]

Published Monday, 18. November 2024 12:48 • 1 months ago

MySQL 8 utf8mb4_0900_ai_ci collation confusion ^{(from Kedar MySQL Blog)}

pRecently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL…/p The post MySQL 8 utf8mb4_0900_ai_ci collation confusion first appeared on Change Is Inevitable. [...]

Published Monday, 18. November 2024 07:45 • 1 months ago

Enhancing Security and Compliance in Financial Services with MySQL Enterprise Edition ^{(from The Oracle MySQL Blog)}

This blog highlights how MySQL Enterprise Edition helps financial services companies enhance security and comply with regulations. [...]

Published Monday, 18. November 2024 06:05 • 1 months ago

SQL Calculations #1 ^{(from MacLochlainns Weblog)}

This was principally written for my SQL students but I thought it might be useful to others. SQL calculation are performed row-by-row in the SELECT-list. In its simplest form without even touching a table, you can add two literal numbers like this: SELECT 2 + 2 AS result; It will display the result of the […] [...]

Published Monday, 18. November 2024 01:47 • 1 months ago

JSON Showdown: Dolt vs Sqlite ^{(from DoltHub Blog)}

Dolt was created to be the world's first truly version controlled database. We think it does a great job at that. And in the process of… [...]

Published Monday, 18. November 2024 00:00 • 1 months ago

Simplifying Replication with Tagged GTID in MySQL 8.4 ^{(from Mydbops Blog)}

Learn how Tagged GTID in MySQL 8.4 enhances replication with selective transactions, conflict resolution, and seamless data flow in complex setups. [...]

Published Saturday, 16. November 2024 06:14 • 1 months ago

Unlocking Modern SaaS Platforms: How Distributed SQL Delivers Multi-Tenancy at Scale ^{(from PingCAP Blog)}

pAt HTAP Summit 2024, Dave Burgess, an industry veteran, angel investor, and ex-VP of Data Engineering at Pinterest, walked through why distributed SQL has emerged as a key component of modern SaaS platforms. As Burgess explained during his keynote, traditional databases like MySQL and PostgreSQL may serve startups initially. However, as businesses scale and encounter […]/p pThe post Unlockin [...]

Published Friday, 15. November 2024 21:50 • 1 months ago

MariaDB Python Connector 1.1.11 now available ^{(from MariaDB Corporation Blog)}

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

Published Friday, 15. November 2024 17:56 • 1 months ago

Protect your data with MariaDB Server and Intel® TDX ^{(from MariaDB Foundation Blog)}

pIn 2023, Intel launched Intel® Trust Domain Extensions (Intel® TDX), their latest Confidential Computing technology that ensures data in use protection for hardware-isolated virtual machines and verified hardware and software integrity through attestation. … /p pContinue reading \"Protect your data with MariaDB Server and Intel® TDX\"/p pThe post Protect your data with MariaDB Serv [...]

Published Friday, 15. November 2024 13:25 • 2 months ago

Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

Monday, 30. December 2024

Multitenant data management with TiDB (from InfoWorld)

Sunday, 29. December 2024

Speedb vs RocksDB on a large server (from Small Datum)

Monitoring Multi-threaded Replication Lag With Performance Schema (from Hack MySQL)

Saturday, 28. December 2024

What do you expect from vector storage in databases? (from MariaDB Foundation Blog)

Friday, 27. December 2024

IBM upgrading Gold to Platinum (from MariaDB Foundation Blog)

Dolphie Works with Dolt (from DoltHub Blog)

Thursday, 26. December 2024

Thoughts on ScyllaDB License Change (from Peter Zaitsev)

Host Database Serverlessly On AWS Fargate - Just Like Your Applications (from WeSQL Blog)

Tuesday, 24. December 2024

A Message From the Community Team (from The Oracle MySQL Blog)

Monday, 23. December 2024

MySQL enters a new decade! (from The Oracle MySQL Blog)

Resolving MySQL Binlog Errors and Reclaiming Disk Space (from Mydbops Blog)

10% Slower Than MySQL (from DoltHub Blog)

Sunday, 22. December 2024

Troubleshooting and Resolving AUTO_INCREMENT Max Value Issues in MySQL and MariaDB (from MinervaDB Blog)

Resource Semaphore Mechanisms in InnoDB (from MinervaDB Blog)

MySQL Blog Revisited - OCI TypeScript SDK (from The Oracle MySQL Blog)

Saturday, 21. December 2024

MySQL Shorts Revisited - DBA Goodies (from The Oracle MySQL Blog)

Friday, 20. December 2024

Resolving MySQL Error 1412 and Understanding Transaction Isolation Levels (from MinervaDB Blog)

Amazon RDS for MariaDB supports minors 11.4.4, 10.11.10, 10.6.20, 10.5.27 (from AWS What's New)

MariaDB Day Sat 1 Feb 2025 in Brussels (from MariaDB Foundation Blog)

MySQL Transaction ERROR 1412 and Isolation Levels (from Percona Database Blog)

Revolutionizing Loyalty Programs: Rakuten’s Journey to Distributed SQL (from PingCAP Blog)

MySQL Retrospective - ISAM & MySAM Log (from The Oracle MySQL Blog)

MySQL Retrospective – ISAM & MyISAM Log (from lefred's blog)

Thursday, 19. December 2024

Transition from AWS DMS to zero-ETL to simplify real-time data integration with Amazon Redshift (from AWS Database Blog)

Releem vs RDS Performance Insights (from Releem Blog)

Amazon RDS Proxy announces caching_sha2_password authentication support for MySQL on Aurora and RDS (from AWS What's New)

Percona XtraBackup 101: Decompress and Decrypt or Decrypt and Decompress? (from Percona Database Blog)

Building for Scale: The Blueprint for Distributed SQL Databases That Meet Modern Demands (from PingCAP Blog)

Indexing code at scale with Glean (from Engineering at Meta)

MariaDB Galera Cluster with MariaDB MaxScale – Getting Started with Read Write Split (from Galera Blog)

Inside MySQL: Sakila Speaks - Season 2 Begins (from The Oracle MySQL Blog)

Wednesday, 18. December 2024

Navigating Business Growth: How TiDB Scales Petabyte-Level Data Volumes (from PingCAP Blog)

Amazon RDS for MySQL supports Innovation Release version 9.1 in Amazon RDS Database Preview Environment (from AWS What's New)

MySQL Telemetry: OpenTelemetry Logging (from The Oracle MySQL Blog)

Optimize Amazon RDS performance with io2 Block Express storage for production workloads (from AWS Database Blog)

How To Deal with a AUTO_INCREMENT Max Value Problem in MySQL and MariaDB (from Percona Database Blog)

MySQL Retrospective - MySQL 3.20 (from The Oracle MySQL Blog)

MySQL Retrospective – MySQL 3.20 (from lefred's blog)

Tuesday, 17. December 2024

Dublin MySQL Meetup, Thu, January 16, 20254pm GMT (UTC+0) (from ODBMS.org)

Belfast MySQL Meetup,Wed. January 15, 2025 6pm GMT (UTC+0) (from ODBMS.org)

How Mercari Scaled Its SaaS Platform with Distributed SQL (from PingCAP Blog)

MySQL Shorts Episode 80 Is Available (from The Oracle MySQL Blog)

January MySQL Meetups - Belfast & Dublin, Ireland (from The Oracle MySQL Blog)

JavaScript is still number one – JetBrains report (from InfoWorld)

WeSQL Outperforms AWS RDS MySQL Single AZ -- 4-6x the Speed, 1/2 the cost (from WeSQL Blog)

Monday, 16. December 2024

Shrink storage volumes for your RDS databases and optimize your infrastructure costs (from AWS Database Blog)

Best practices for creating a VPC for Amazon RDS for Db2 (from AWS Database Blog)

MariaDB Point In Time Recovery (from MariaDB Corporation Blog)

Rapyd Enhances Performance and Security by Migrating from Amazon RDS to MySQL Enterprise Edition (from The Oracle MySQL Blog)

Best practices for safely performing schema changes in Azure Database for MySQL (from Azure for MySQL Blog)

MySQL Blog Revisited - MySQL Shell (from The Oracle MySQL Blog)

Sunday, 15. December 2024

DBAs not dead ( punk ) ! (from The consistent voice)

Releem vs EverSQL (from Releem Blog)

MySQL Shorts Revisited - SQL Commands (from The Oracle MySQL Blog)

AWS re:Invent2024 Aurora 发布了啥 – DSQL 篇 (from Chen Zongzhi's GitHub blog)

Saturday, 14. December 2024

MySQL Retrospective - Certifications (from The Oracle MySQL Blog)

Friday, 13. December 2024

Ma Madeleine de Proust (from The consistent voice)

HeatWave Japan User Group. Q&A with Masataka Narita and Tatsuya Naito (from ODBMS.org)

The Mystery of ProxySQL Galera Writer Switchover! (from Vettabase)

Running Drupal using Always Free Resources in Oracle Cloud (from The Oracle MySQL Blog)

Mydumper Works with Dolt (from DoltHub Blog)