Planet for the MySQL Community

A blog aggregator for the MySQL Community/Ecosystem

This website is in beta. A description of what it tries to achieve is in the Planet MySQL Community - Requirements RFC.

And a clarification about the MySQL Community/Ecosystem: it is not limited the users of the MySQL Database. In the current context, it also includes people interested in MySQL Variants including MariaDB Server, Percona Server, Galera, Amazon RDS and Aurora, Google Cloud SQL for MySQL, and Azure and Alibaba flavor(s) of MySQL/MariaDB/Percona Servers.

Tuesday, 21. September 2021

Making Aurora Write Latency 15x Higher (or More!) by Choosing a Bad Primary Key (from Percona Database Performance Blog)

♦Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact on performance and also write propagation in databases. When this comes to Aurora, this impact is even worse than you may notice. In short, we consider a poor definition of a Primary Key in InnoDB […] [...]

10.7 preview feature: Compression Provider Plugins (from MariaDB Foundation Blog)

pMariaDB has been using a pluggable storage engine architecture for a long time and whilst this means great flexibility in choosing and managing the right storage engines for specific use cases, it also means they are easier to develop and therefore there’s an expectation that more engines will be created. … /p pContinue reading \"10.7 preview feature: Compression Provider Plugins\"/p p [...]

MyDumper 0.11.1 is Now Available (from Percona Database Performance Blog)

♦The new MyDumper 0.11.1 version, which includes many new features and bug fixes, is now available.  You can download the code from here. For this release, there are three main changes: 1) we added config file functionality which allows users to set session-level variables (one of the most requested features!), 2) we developed a better […] [...]

Adaptive Purge in MariaDB (from MySQL On ARM)

If you are using MariaDB for some time now you may have heard about adaptive flushing. “Adaptive” refers to a behavior where-in the algorithm auto-tunes itself based on certain parameters. In the new-generation world, it is called an “AI-based algorithm”. The same concept is now being applied to purge. Purge is a critical and resource-consuming operation so scheduling of purge along with user workl [...]

Monday, 20. September 2021

10.7 preview feature: Natural sort (from MariaDB Foundation Blog)

pNatural sort order is the ordering of strings in alphabetical order, while numbers are treated as numbers. This understanding of sorting is closer to human comprehension than to a machine. … /p pContinue reading \"10.7 preview feature: Natural sort\"/p pThe post 10.7 preview feature: Natural sort appeared first on MariaDB.org./p [...]

10.7 preview feature: UUID Data Type (from MariaDB Foundation Blog)

pUniversally unique identifiers (UUIDs) have a common place in computing already. A 128-bit value with a text representational value and the prescription of a number of version types to ensure a uniqueness makes it an ideal data type. … /p pContinue reading \"10.7 preview feature: UUID Data Type\"/p pThe post 10.7 preview feature: UUID Data Type appeared first on MariaDB.org./p [...]

Dave's MySQL Quiz Number 2 Answers (from PHP With MySQL)

p    This week's MySQL was a great one for novices looking to level up from beginner level SQL development to a higher level.  /pp    The problem:  Find the customers with more than one unreturned rented movies that are past their return due date.  You might to look at this for the example of finding an overdue rentals. br/pThe answer:pFirst we [...]

PingCAP Announces Collaboration with the Advanced Software Technologies Lab at ETH Zürich to Explore DBMS Testing (from TiDB and TiKV Blog)

PingCAP is proud to announce a collaboration with the Advanced Software Technologies Lab (AST) at ETH Zürich to research DBMS testing based on TiDB. [...]

Saturday, 18. September 2021

How slow is SELECT * ? (from Vettabase)

pThe most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all columns are needed, they should list their names, because more columns could be created in the future. But developers find this really Continue reading How slow is SELECT * ?→/p pThe post How slow is SELECT * ? appeared first on Vettabase./p [...]

Friday, 17. September 2021

Migration of a MySQL Database to a Kubernetes Cluster Using Asynchronous Replication (from Percona Database Performance Blog)

♦Nowadays, more and more companies are thinking about the migration of their infrastructure to Kubernetes. Databases are no exception. There were a lot of k8s operators that were created to simplify the different types of deployments and also perform routine day-to-day tasks like making the backups, renewing certificates, and so on.  If a few years […] [...]

10.7.0 Comes As Preview Releases (from MariaDB Foundation Blog)

pNow is the time to try out the new candidate features of MariaDB Server 10.7, the next release series of MariaDB! This blog describes how the new preview releases work, and where we need your help as a MariaDB user. … /p pContinue reading \"10.7.0 Comes As Preview Releases\"/p pThe post 10.7.0 Comes As Preview Releases appeared first on MariaDB.org./p [...]

Dave's MySQL Quiz #2 (from PHP With MySQL)

p     This week's MySQL uses the Sakila database (details on how to get this data) and this week's quiz is a  great one for those wanting to move from beginner level SQL development to a higher level.  There will be lots of tables to joins./pp    The problem:  Find the customers with more than one unreturned rented movies that are past their return due date.& [...]

Getting Started with JuiceFS Using TiKV (from TiDB and TiKV Blog)

JuiceFS is an open-source, cloud-native distributed file system that allows users to freely choose the backend storage engine. This post introduces how to use TiKV as a metadata engine for JuiceFS. [...]

Thursday, 16. September 2021

New MariaDB Enterprise Server Releases with Backported Features and ARM Support now available (from MariaDB Corporation Blog)

MariaDB Enterprise Server 10.5, 10.4, 10.3 and 10.2 receive important backported features for customers including ARM support & enhanced semi-sync replication. [...]

Testing Time and Test Suites Management: QA for Business-Critical MySQL Clustering (from Continuent Blog)

pThis blog is about testing time and test suites management. “Battle-tested” is the Continuent Tungsten QA (Quality Assurance) guarantee. Continuent Tungsten is a clustering and replication solution for MySQL and MariaDB used by some of the largest MySQL estates to achieve continuous MySQL operations, locally and globally (HA, DR and Geo Distribution). Besides the stellar support team, and fully-in [...]

MySQL: Binding the ORM (from Die wunderbare Welt von Isotopp)

pMy task is to collect performance data about a single query, using codePERFORMANCE_SCHEMA/code (P_S for short) in MySQL, to ship it elsewhere for integration with other data./p pIn a grander scheme of things, I will need to define what performance data from a query I am actually interested in. I will also need to find a way to attribute the query (as seen on the server) to a point in the codebase [...]

Repoint Replica Servers in MySQL/Percona Server for MySQL 8.0 (from Percona Database Performance Blog)

♦When doing migrations or failovers in MySQL, there is usually a need to do a topology change and repoint replica servers to obtain replication data from a different server. For example, given servers {A, B, and C} and the following topology: If you need to repoint C to be a replica of B, i.e: You […] [...]

Wednesday, 15. September 2021

MySQL: Tracing a single query with PERFORMANCE_SCHEMA (from Die wunderbare Welt von Isotopp)

pMy task is to collect performance data about a single query, using codePERFORMANCE_SCHEMA/code (P_S for short) in MySQL, to ship it elsewhere for integration with other data./p pIn a grander scheme of things, I will need to define what performance data from a query I am actually interested in. I will also need to find a way to attribute the query (as seen on the server) to a point in the codebase [...]

ServerFest Two Weeks Later (from MariaDB Foundation Blog)

pUpdate your calendars: The MariaDB ServerFest has moved to be two weeks later, Tue-Wed 5.-6. October 2021. We hope the new dates fit your calendar!br Technical reasonsbr The postponement is due to what is usually called “technical reasons”, which is an expression intended to obscure any underlying facts. … /p pContinue reading \"ServerFest Two Weeks Later\"/p pThe post ServerFest [...]

Medium Cross-post – CodeIgniter 4 CRUD: Read (from Digital Owl's Prose)

pStoring data is but one part of many in application development. Once data is stored, interested parties will likely want to see it. This is the Read aspect of CRUD – reading (or viewing) the data. Continue reading and see examples using CodeIgniter 4 built-in Model methods… In part 1 of this series, CodeIgniter 4 […]/p pThe post Medium Cross-post – CodeIgniter 4 CRUD: Read [...]

Releasing ProxySQL v2.3.0! (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.3.0 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL [...]/p pThe post Releasing ProxySQL v2.3.0! appeared first on ProxySQL./p [...]

Tuesday, 14. September 2021

Change @Table name value on runtime in Hibernate (from Geeky Hacker - Coding, Tech & Linux)

pThere are scenarios that an application needs to access multiple databases with different table names but with the same table structures. One way is to create separate entities, repositories for [...]/p pThe post Change @Table name value on runtime in Hibernate appeared first on Geeky Hacker./p [...]

MySQL: Page compression revisited (from Die wunderbare Welt von Isotopp)

pLike I said, I never had much reason to use table compression, and only recently looked into the topic. MySQL Page Compression looks a lot easier at the database end of things, but relies on hole punching support in the file system. Let’s have a look at what that means./p Files, Inodes and Arrays of Blocks pThe original Unix filesystem saw the disk as a sea of blocks, which were represented in a [...]

Proper Prometheus Plumbing: Watch Your Tungsten Cluster Using Built-In Exporters (from Continuent Blog)

pPrometheus is one of the more popular ways to monitor your resources, and starting with version 7.0.0, Continuent has embedded the Prometheus exporter functionality into our core MySQL and MariaDB clustering products. This blog post covers how to enable the exporters, getting metrics and what metrics are available, along with cli tools, customizing the config, documentation references and a little [...]

How to Run Chaos Experiments on Your Physical Machine (from TiDB and TiKV Blog)

This article describes how to use chaosd to simulate faults on physical machines. You can run chaosd as a command-line tool or as a service. [...]

Monday, 13. September 2021

Quiz #1 Answers (from PHP With MySQL)

pHere are answers to Quiz #1 and please note there are several ways to solve just about any problem so your answer may be different./ppQUIZ #1:   How would you modify the following query on the world database to find only the official languages of each country?  Bonus - list all the official languages for each country on one row./pselect country.name,br       coun [...]

MySQL/ZFS in the Cloud, Leveraging Ephemeral Storage (from Percona Database Performance Blog)

♦Here’s a second post focusing on the performance of MySQL on ZFS in cloud environments. In the first post, MySQL/ZFS Performance Update, we compared the performances of ZFS and ext4. This time we’ll look at the benefits of using ephemeral storage devices. These devices, called ephemeral in AWS, local in Google cloud, and temporary in […] [...]

Friday, 10. September 2021

MySQL: CREATE IF NOT EXISTS TABLE, but CREATE OR REPLACE VIEW (from Die wunderbare Welt von Isotopp)

pFor the MySQL Million Challenge, I was going through the server syntax in order to understand what things can be created in the server. And now my OCD triggered. DDL is a mess./p Creation blockquote pAs a database developer, I want to be able to create server objects using the codeCREATE thing/code syntax./p /blockquote pThe server gives you that for the following things:/p ul liDATABASE/l [...]

MySQL: The Million Challenge (from Die wunderbare Welt von Isotopp)

pA long standing idea that I have is to test the servers limits: How does it fail and break if there are very many of a thing? Previously that was too easy, because many structures were constructed in a way that it was obvious they would not scale. But with MySQL 8 many things were overhauled, so let’s see what we can make many of and see how the server fares./p The Million Challenge pDatabase [...]

Thursday, 09. September 2021

Sample Databases for Learning MySQL and a QUIZ!! (from PHP With MySQL)

p     I frequently see requests on various web sites from MySQL novices looking for example databases with which to practice.  There are several that are highly recommended and we will take a look at them over the next few weeks./pp1. World Data Base -- See dev.mysql.com/doc/world-setup/en//ppThis has been THE database used in MySQL's documentation, classes, examples, and j [...]

MySQL: Two kinds of compression (from Die wunderbare Welt von Isotopp)

pI never had much reason to use table compression, so I largely ignored the topic in MySQL. I knew that MySQL had table compression since 5.1, but I also knew the implementation was horribly complicated and double stored all data. There is also page compression, a feature introduced with 5.7, which replaces table compression and works much better./p Table Compression pTable Compression is availa [...]

MySQL: The table '../tmp/#sql…' is full (from Die wunderbare Welt von Isotopp)

pWe observe a large number of messages of the kind/p precodeThe table '../tmp/#sql…' is full /code/pre Before MySQL 8 pIn older Versions of MySQL, implied temporary tables are being created, whenever your codeEXPLAIN/code contained the phrase codeusing temporary/code./p pIn this case, MySQL would create an in-memory temporary table to materialize an intermediate query result, and then continue [...]

If Continuent Support Was a Cartoon Character... (from Continuent Blog)

pIf Continuent Support was depicted as a cartoon character, who would you choose? I know who I would choose...I’ll give you a clue...Very Fast...Beep Beep…/p pIn this blog we will explore Continuent Support...What we do, how we do it and the tools available to the customer that make all that happen at lightning speed./p Tags: MySQLMariaDBcontinuous operationsexpertise [...]

Q&A on Webinar “Using Open Source Software to Optimize and Troubleshoot Your MySQL Environment” (from Percona Database Performance Blog)

♦Thanks to everyone who attended last week’s webinar on Using Open Source Software to Optimize and Troubleshoot Your MySQL Environment; hopefully you’ve found the time we spent in Percona Monitoring and Management (PMM) useful. We had a record-breaking number of questions during the talk and unfortunately weren’t able to answer them all live, so we […] [...]

Wednesday, 08. September 2021

Capture Java apps heap dumps on Kubernetes (the poor man’s way) (from Geeky Hacker - Coding, Tech & Linux)

pOne of the practices when dealing with memory leak issues is to take a heap dump and analyze it to figure out which part of the code is causing the [...]/p pThe post Capture Java apps heap dumps on Kubernetes (the poor man’s way) appeared first on Geeky Hacker./p [...]

Crash-safe DDL of InnoDB tables in MariaDB Server 10.6 (from MariaDB Corporation Blog)

MariaDB 10.6.1, introduces atomic DDL (Data Definition Language) operations to make them crash-safe, even if the server crashes in the middle of an operation. [...]

Run ANALYZE TABLE — Do Not Rely on InnoDB's Automatic Recalculation of Statistics (from Øystein on MySQL Optimizer)

pThis blog post is inspired by Jesper's recent blog post on how the automatic update of InnoDB persistent statistics may never trigger if servers are restarted frequently. However, the matter is even worse! In this blog post I will show that even when the automatic recalculation is performed, there are no guarantees as to when the server will see the changes. /pMyths about persistent statisticspI [...]

Medium Cross-post: CodeIgniter 4 CRUD – Create (from Digital Owl's Prose)

pI’m studying and beginning to use CodeIgniter 4 in ‘real-world‘ projects and want to share what I learn, as I pick up on concepts of the framework. I’m posting a series of CRUD-related posts over on Medium and resharing them here for any readers who are interested… CodeIgniter 4 CRUD – Create CodeIgniter 4 is […]/p pThe post Medium Cross-post: CodeIgniter [...]

Tuesday, 07. September 2021

How to Manage NoSQL Data with MariaDB (from MariaDB Corporation Blog)

Learn how MariaDB MaxScale, an advanced database proxy, listens for traffic containing NoSQL data that can be stored and managed within a MariaDB database. [...]

We are hiring at ProxySQL for 2021! (from ProxySQL Blog)

pProxySQL is a high performance highly-available protocol aware proxy for MySQL and its forks (Percona Server, MariaDB). ProxySQL is a 100% open source GPL project recognized by the MySQL Community as the ‘Application of the Year’ for two consecutive years in 2017 and 2018. Our company is growing and we are [...]/p pThe post We are hiring at ProxySQL for 2021! appeared first on ProxySQL./p [...]

Product Release Review (from Continuent Blog)

pOn August 20th, 2020 we released v6.1.6 of our Tungsten Clustering and Tungsten Replicator products. On August 17th, 2021, we released v6.1.14. In this blog we take a look back over the last 12 months and highlight some of our key updates and fixes./p Tags: product developmentreleasesMySQLMariaDBeol [...]

Join our Server Fest 21-22 Sep 2021! (from MariaDB Foundation Blog)

pUpdate: MariaDB Server Fest 2021 will be held on the 5th and 6th of October 2021. You can find more information in this blog post. … /p pContinue reading \"Join our Server Fest 21-22 Sep 2021!\"/p pThe post Join our Server Fest 21-22 Sep 2021! appeared first on MariaDB.org./p [...]

Identify useless queries in MariaDB/MySQL (from Vettabase)

pSome queries always fail or never return rows. They should be eliminated to improve database performance. Continue reading Identify useless queries in MariaDB/MySQL→/p pThe post Identify useless queries in MariaDB/MySQL appeared first on Vettabase./p [...]

Easy Local Development with TiDB (from TiDB and TiKV Blog)

This post describes how you can develop your application locally and use the type of database used in production. [...]

Examining query plans in MySQL and Vitess (from Vitess)

Originally posted at Andres’s blog. Traditional query optimizing is mostly about two things: first, in which order and from where to access data, and then how to then combine it. You have probably seen the tree shapes execution plans that are produced from query planning. I’ll use an example from the MySQL docs, using FORMAT=TREE which was introduced in MySQL 8.0: mysql> EXPLAIN FORMAT=TRE [...]

Monday, 06. September 2021

Galera Manager deploying on AWS with Red Hat Enterprise Linux 8 and MySQL 8 (from Galera Blog)

Since we just released Galera Manager, it seemed like a good idea to do a deployment on Amazon Web Services (AWS) using Red Hat Enterprise Linux 8 and MySQL 8. We start by launching an EC2 instance and choosing Red Hat Enterprise Linux 8 (HVM) and most importantly, we only choose the 64-bit (x86) architecture […] [...]

NULL comparisons in MariaDB, PostgreSQL, and SQLite (from Vettabase)

pComparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem. Continue reading NULL comparisons in MariaDB, PostgreSQL, and SQLite→/p pThe post NULL comparisons in MariaDB, PostgreSQL, and SQLite appeared first on Vettabase./p [...]

Saturday, 04. September 2021

Challenges and Visions for MariaDB Server (from MariaDB Foundation Blog)

pAt the MariaDB Foundation, we want MariaDB Server to be a model citizen in the Open Source world. For now, there is a sizeable gap between dreams and reality. … /p pContinue reading \"Challenges and Visions for MariaDB Server\"/p pThe post Challenges and Visions for MariaDB Server appeared first on MariaDB.org./p [...]

Friday, 03. September 2021

Southern California Linux Expo 19x MySQL Track (from PHP With MySQL)

p    There will be a MySQL tract at the Southern California Linux Expo 19x (SCaLE)  March 3-6, 2022 in Pasadena, California.   I will organizing the track and the first part of that is asking you to submit talks for the MySQL track.  We needs talks for novices, we need talks for the advanced, and we need talks for those in between!  November 20th, 2 [...]

Thursday, 02. September 2021

Docker Library – Official MariaDB Image Maintenance (from MariaDB Foundation Blog)

pThe Docker Library official MariaDB image is now maintained by the MariaDB Foundation, and has been for the last six months. If you didn’t notice, we’ll take that as a compliment, as the previous maintainers of Docker Library from Infosiftr were doing a good job already. … /p pContinue reading \"Docker Library – Official MariaDB Image Maintenance\"/p pThe post Docker Librar [...]

MySQL LRU Flushing and I/O Capacity (from Hack MySQL)

pInnoDB background LRU list flushing is not limited by codeinnodb_io_capcity/code or codeinnodb_io_capacity_max/code. I’ll prove it in this blog post, but since MySQL experts disagree (or don’t know for sure), I’d like you to prove me wrong. This is not an intro; you’ll need to know all the InnoDB details wrt page flushing./p [...]

Are my MySQL server connections encrypted and safe? (from SeveralNines Open Source Database Blog)

pOne of the greatest factors and fundamentals of data governance is security. It is a good practice to have database security implemented in place whenever you have your data management involved for enterprise or mass consumption. /p pData security is one of the most significant aspects of administering a database. It plays a critical role for which every database management should implement. When [...]

Introducing xbcloud: Exponential Backoff Feature in Percona XtraBackup (from Percona Database Performance Blog)

♦Storing your data locally can impose security and availability risks. Major cloud providers have object storage services available to allow you to upload and distribute data across different regions using various retention and restore policies. Percona XtraBackup delivers the xbcloud binary – an auxiliary tool to allow users to upload backups to different cloud providers […] [...]

Tungsten Bug Hunting: QA for Business-Critical MySQL Clustering Software (from Continuent Blog)

pThis blog is about Bug Hunting. “Battle-tested” is the Continuent Tungsten QA (Quality Assurance) guarantee. Continuent Tungsten is a clustering and replication solution for MySQL and MariaDB used by some of the largest MySQL estates to achieve continuous MySQL operations, locally and globally (HA, DR and Geo Distribution). Besides the stellar support team, and fully-integrated components, custome [...]

Wednesday, 01. September 2021

Congratulating Marcelo Altmann on his Promotion to Oracle ACE! (from Percona Database Performance Blog)

♦We’re excited to share that Marcelo Altmann from the Percona Server Engineering Team has just been promoted from Oracle ACE Associate to Oracle ACE. Congratulations! The Oracle ACE Program recognizes and rewards community members for their technical contributions to the Oracle community. Marcelo initially joined Percona as a senior support engineer in our global services […] [...]

TiDB 5.2 - Translytical Processing Made Easier and Faster (from TiDB and TiKV Blog)

We are proud to announce our the release of TiDB 5.2. TiDB 5.2 focuses on real-world scenarios, aiming to push the boundaries of transactional and analytical processing even further to meet the demands of massive, real-time data processing. [...]

Raft and High Availability (from TiDB and TiKV Blog)

Raft is a consensus-based method that distributes data in such a way that it creates and maintains a high availability environment for your database. This article introduces the general components and mechanisms of Raft, and how distributed databases such as TiDB and TiKV use Raft to achieve high availability and consistency. [...]

Tuesday, 31. August 2021

The MySQL Shell and the MySQL Config Editor (from PHP With MySQL)

p    One of the things I love about the MySQL Shell is that is saves your authentication credentials (no longer just passwords) in an obfuscated login path file named .mylogin.cnf. You can find that file in the %APPDATA%\MySQL directory on Windows or the current user's home directory on non-Windows systems. The file can be read later by MySQL client programs, such as the MySQL Shell, [...]

Monday, 30. August 2021

Novices and Their SQL Misconceptions (from PHP With MySQL)

p     Do yourself a favor and spend ten minutes watching this video on the CER2021 paper Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud study.  Structured Query Language is hard for many new programmers as it is a declarative language which makes it much different that the object orientated or procedural languages with which they [...]

Codership Releases Galera Manager to easily deploy and manage Galera Clusters on premise and in Amazon Web Services (from Galera Blog)

Codership, the leading MySQL High Availability clustering solutions company behind Galera Cluster™, is pleased to announce the general availability of Galera Manager, a web-based graphical user interface (GUI) tool to easily deploy and manage your Galera Clusters. With today’s release, you can now create fully managed clusters in Amazon Web Services, you can also deploy […] [...]

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

We are merry & galvanized for bestowing seeds of cognizance to our opensource database community. Thank you to all those who attended in our 8th edition of MyWebinar.  We hope our session was able to elevate & seam your workmanship to perfection. We are committed in giving back to our opensource database community by hosting more … Continue reading Synopsis of Mydbops 8th ed [...]

Saturday, 28. August 2021

Introduction to MySQL Parallel query in AWS Aurora (from Mydbops Blog)

Aurora has a salient feature “Parallel query“, Which will be more beneficial for analytical workload environments. Before going to deep dive on this particular feature, let us understand the basis of Aurora. Aurora Archiecture Key feature The key feature of Aurora is simple data synchronisation among the nodes. The sync latency will be too low … Continue reading Introduction to My [...]

Friday, 27. August 2021

Automated MariaDB restore tests (from Shinguz's Blog)

pNearly everybody does backups. But nobody needs backups! What everybody wants and needs is a working restore not a working backup.../p pSo how to make sure that your backup is working for the restore? There are a few things you can do already during your backup:/p ulliCheck that your backup was running fine. For example by checking the return code of your backup./li liCheck the runtime of your [...]

RonDB and Docker Compose (from Mikael Ronstrom)

pAfter publishing the Docker container for RonDB I got a suggestion to simplify it further by using Docker Compose. After a quick learning using Google I came up with a Docker Compose configuration file that will start the entire RonDB cluster and stop it using a single command./ppFirst of all I had to consider networking. I decided that using an external network was the best solution. This makes i [...]

Mydbops MyWebinar 8th edition – Speaker Announcement (from Mydbops Blog)

Mydbops propounds free webinars & meetups about MySQL, MongoDB, and PostgreSQL, the major three opensource databases.  What greater thing can we give to our community than to diversify their skill sets and improve their craftsmanship by providing free Webinars with niche topics, illustrations, Q&A, and, most importantly, more fun as we work together to sharpen our … Continue [...]

Thursday, 26. August 2021

Monitoring Made Easy: Watching Your Tungsten Cluster Using Built-In Tools (from Continuent Blog)

pContinuent provides multiple methods out of the box to monitor the cluster health. It integrates with monitoring and alerting tools like Nagios/NRPE, Zabbix, and Pagerduty. This blog post shows you the thinking behind each included Tungsten Cluster monitoring tool, and when to use which tool./p Tags: MySQLMariaDBNagiosNRPEzabbixpagerduty [...]

What’s New in MariaDB ColumnStore 6 (from MariaDB Corporation Blog)

The latest release of MariaDB ColumnStore is now available and includes disk-based aggregation, LZ4 Compression for faster query results and more. [...]

What’s New in MariaDB MaxScale 6 (from MariaDB Corporation Blog)

The newest version of MariaDB MaxScale is now available and includes new features such as a Query Editor, Kafka Importer and NoSQL Listener. [...]

What’s New in MariaDB Enterprise Server 10.6 (from MariaDB Corporation Blog)

MariaDB Enterprise Server 10.6 includes new compatibility for Sybase SQL Anywhere & Oracle, improved semi-synch replication, engine agnostic Atomic DDL & more. [...]

The Common MySQL error: “Got an error reading communication packet” (from SeveralNines Open Source Database Blog)

pMySQL is the second famous database in the world according to the DB Engine website behind Oracle. What makes MySQL famous is probably because it is a very fast, reliable and flexible Database Management System. MySQL is also one of the supported databases in ClusterControl. You could easily deploy, scale, monitor and do a lot of things with ClusterControl./p pToday we are not going to talk about [...]

Tuesday, 24. August 2021

PHP MySQL Connectors -- MySQLi, PDO, and/or X DevAPI (from PHP With MySQL)

p Help!/ppI am preparing a presentation for the Longhorn PHP conference titled PHP & MySQL -- How do PDO, MySQLi, and X DevAPI do what they do.  This will be a comparison of using PHP with different MySQL Connectors.  As far as I can tell there are no three way comparisons of mysqli, PDO, and the X DevAPI PECL extension.  And much of the PDO versus myqli stuff looks to [...]

Simulating Realistic Conditions: QA for Business-critical MySQL Clustering (from Continuent Blog)

p“Battle-tested” is the Continuent Tungsten QA (Quality Assurance) guarantee. Continuent Tungsten is a clustering and replication solution for MySQL and MariaDB used by some of the largest MySQL estates to achieve continuous MySQL operations and uptime; why? Besides the stellar support team, and fully-integrated components, customers say: “Stability,” and, “It just works.”“Battle-tested” is the Con [...]

Benchmarking databases 101 - part 1 (from SeveralNines Open Source Database Blog)

pBenchmarks are one of the activities that database administrators perform. You run them to see how your hardware behaves, you run them to see how your application and database work together under pressure. You run them in many different situations. Let’s talk a little bit about them, what are the challenges you are going to face, what are the issues you should avoid./p Types of benchmarks pEvery [...]

Securing Online Gaming: Combine Chaos Engineering with DevOps Practices (from TiDB and TiKV Blog)

Tencent Interactive Entertainment Group is known as the publisher of some of the most popular video games. This article shares why and how they use chaos engineering in their DevOps workflow. [...]

Monday, 23. August 2021

FromDual Backup and Recovery Manager for MariaDB and MySQL 2.2.4 has been released (from Shinguz's Blog)

pFromDual has the pleasure to announce the release of the new version 2.2.4 of its popular Backup and Recovery Manager for MariaDB and MySQL (codebrman/code)./p pThe new FromDual Backup and Recovery Manager can be downloaded from here. The FromDual Repositories were updated. How to install and use the Backup and Recovery Manager is described in FromDual Backup and Recovery Manager (brman) installa [...]

myloader Stops Causing Data Fragmentation (from Percona Database Performance Blog)

♦During the development of the myloader –innodb-optimize-keys option, which was released in version 0.10.7, we found several issues and opportunities to improve the process. We had to change the approach, reimplement some of the core functionality and add a couple of data structures. That allowed us to implement, at a really low cost, a feature […] [...]

Sunday, 22. August 2021

Automatic update of InnoDB Persistent Statistics Never Triggers (from Jesper'S MySQL Blog)

pSince MySQL 5.6 InnoDB has supported persistent index statistics. This means that when you restart MySQL, InnoDB does not have to recalculate the statistics for the tables, rather it can read the statistics from its persistent storage. This has several …/p p Automatic update of InnoDB Persistent Statistics Never Triggers Read More »/p pThe post Automatic update of InnoDB Persistent Sta [...]

Friday, 20. August 2021

Storing JSON in Your Databases: Tips and Tricks For MySQL Part Two (from Percona Database Performance Blog)

♦JSON Structure, The Next Generation (Performance, Scale, and Fun) Now you know the basic JSON functionality available to you, as covered in part one of this series.  Let’s look deeper into performance, scale, and oddities that may occur. You can do almost anything you could do in SQL with standard data types and objects, but […] [...]

MySQL Disaster Recovery (DR) with InnoDB Cluster - Really? (from Continuent Blog)

pDoing a search with InnoDB Cluster with DR (Disaster Recovery) yields lots of results, but does it actually work in the enterprise?/p Tags: innodb clustermulti-site clusteringfailoverfailbackMySQLMariaDB [...]

Thursday, 19. August 2021

EXPLAINing the Different EXPLAINS In MySQL (from PHP With MySQL)

p     The main tool for tuning MySQL queries is the EXPLAIN statement (dev.mysql.com/doc/refman/8.0/en/explain.html) and one of the hurdles on the learning curve of the EXPLAIN statement is explaining what EXPLAIN is explaining.  Basically EXPLAIN is prepended to a SELECT, TABLE, DELETE, UPDATE, INSERT or REPLACE statement.  To add to an already steep learning curve is [...]

JavaScript and Friends this Friday (from PHP With MySQL)

p JavaScript and Friends starts tomorrow and I will be speaking on JavaScript and the MySQL Shell.  JavaScript is one of the three modes of input for mysqlsh! /pp♦/ppPlus you see how to register reports with the shell so they will be ready when you are./ppTickets range from $0 to $75./ppbr/ppbr/pAll opinions expressed in this blog are those of Dave Stokes who is actually amazed [...]

Dynamic User Creation with MySQL on Kubernetes and Hashicorp Cloud Platform Vault (from Percona Database Performance Blog)

♦You may have already seen this document which describes the integration between HashiCorp Vault and Percona Distribution for MySQL Operator to enable data-at-rest encryption for self-managed Vault deployments.  In April 2021, HashiCorp announced a fully managed offering, HashiCorp Cloud Platform Vault (HCP Vault), that simplifies deployment and management of the Vault. With that in mind, […] [...]

Storing JSON in Your Databases: Tips and Tricks For MySQL Part One (from Percona Database Performance Blog)

♦Database architecture and design are becoming an increasingly lost art. With new technologies and the push towards faster development cycles, people continue to take shortcuts, often to the detriment of long-term performance, scalability, and security. Designing how your application stores, accesses, and processes data is so fundamentally important, it can not be overlooked. I want […] [...]

Building a Real-Time Data Warehouse with TiDB and Pravega (from TiDB and TiKV Blog)

This article introduces a new solution for real-time data warehouse: Pravega + TiDB. This combination resolves Kafka's data persistence dilemma and provides auto scaling capabilities. [...]

Wednesday, 18. August 2021

DR with InnoDB Cluster - Possible? (from Continuent Blog)

pDoing a search with InnoDB Cluster with DR (Disaster Recovery) yields lots of results, but does it actually work in the enterprise?/p Tags: innodb clustermulti-site clusteringfailoverfailbackMySQLMariaDB [...]

Monday, 16. August 2021

ClusterControl: Intro to the New Query Monitor (from SeveralNines Open Source Database Blog)

pClusterControl 1.9.0 was released on July 16th 2021 with a lot of new features introduced to the system. Those features include Redis Management and Monitoring, a new agent-based Query Monitoring system for MySQL and PostgreSQL, pgBackRest improvements as well as some other improvements listed here. We are quite excited as this is our second major release for 2021 after ClusterControl 1.8.2./p pI [...]

Monitoring your MariaDB database with SNMP (from Shinguz's Blog)

Table of Contents ulliWhat is SNMP?/li liSNMP Agent (snmptrap)/li liSNMP Manager (snmptrapd)/li liTest the SNMP Agent/li liCreating your own MIB/li liSending MariaDB SNMP traps from PHP/li liLiterature/li /ulbrWhat is SNMP? pA customer recently had the question if an how his MariaDB database can be easily monitored with SNMP?/p pSNMP means Simple Network Management Protocol. It is a [...]

Saturday, 14. August 2021

Happy 15th to Percona (from Small Datum)

pI am thrilled to be celebrate Percona's 15th anniversary. My time with MySQL began about the same time as the founding of Percona. Those years, the mid-2000s, were the dark ages for MySQL. There was doubt about the future of MySQL because there were many things that needed to be made better. Fortunately, upstream and the community, with much help from Percona, rallied to fix the problems [...]

Friday, 13. August 2021

How to achieve AlwaysOn (from Mikael Ronstrom)

pWhen discussing how to achieve High Availability most DBMS focus on handling it via replication. Most of the focus has thus been focused on various replication algorithms./ppHowever truly achieving AlwaysOn availability requires more than just a clever replication algorithm./ppRonDB is based on NDB Cluster, NDB has been able to prove in practice that it can deliver capabilities that makes it possi [...]

Get an Amazon Gift Card for a Review! (from Percona Database Performance Blog)

♦Note: This promotion has ended. The next 10 user reviews for Percona Server for MySQL will receive a $10 Amazon gift card from Sourceforge. Add yours now! Why does Percona value honest user reviews? They provide valuable information for engineers to guide product development. They help more users become aware of Percona software.  They help […] [...]

Webinar Replay: Top Five Tips to Drive MariaDB Galera Cluster Performance for Nextcloud (from SeveralNines Open Source Database Blog)

pAre you a MariaDB database administrator that is facing problems regarding your Galera Cluster implementations? Perhaps you even tried to make it work in harmony with Nextcloud? If you have answered “yes” to any of these questions, this webinar replay is for you! This webinar featuring Björn Schiessle, Pre-sales Lead and Co-Founder at Nextcloud, and Ashraf Sharif, Senior Support Engineer at Severa [...]

Chaos Mesh® 2.0 GA: To a Chaos Engineering Ecology (from TiDB and TiKV Blog)

Chaos Mesh 2.0 GA: an exciting release, marking a solid milestone towards the chaos engineering ecology that we hope to build. [...]

Thursday, 12. August 2021

Understanding Consistency (from MariaDB Corporation Blog)

What good is data at scale if it is wrong? This blog reviews isolation and its effects on overall data consistency. [...]

Safely switching MySQL charsets using Skeema (from Skeema Blog)

pConverting your database to a different character set can be a difficult and perilous process. In this post, we’ll cover several ways that Skeema can help simplify this task./p [...]

RonDB and Docker (from Mikael Ronstrom)

There was a request to be able to test RonDB using Docker. This is now working.These commands will set up a RonDB cluster on your local machine that can be used to test RonDB:brStep 1: Download the Docker containers for RonDBbrdocker pull mronstro/rondbbrStep 2: Create a Docker subnetbrdocker network create mynet --subnet=192.168.0.0/16brStep3: Start the RonDB management serverbrdocker run -d \&nbs [...]

Wednesday, 11. August 2021

MariaDB Connector C++ 1.1.0-beta and Connector Java 2.7.4 and 3.0.1-beta now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C++ 1.1.0-beta and Connector/Java 2.7.4 and 3.0.1-beta. Download Now Release … Continued [...]

On storage engines (from Small Datum)

pI wish it were easier to implement new storage engines for MySQL, Postgres and MongoDB and other OSS databases. There is so much innovation that we miss out on - FASTER is one example. All (MySQL, MongoDB, Postgres) have storage engine APIs but there are not many OSS implementations of them. /ppMyRocks, MySQL Aurora and MySQL HeatWave are examples of the benefits. But they also show that it helps [...]

Galera Cluster for MySQL training in September (from Galera Blog)

Codership, the developers of Galera Cluster for MySQL, provides training sessions in September 2021 for EMEA and USA timezone. The Advanced Database Administrator with Galera Cluster training course teaches you how to install and configure in real-time a Galera Cluster for your application use cases. You will participate in interactive hands-on labs. Our expert instructor […] [...]

Proactive MySQL Monitoring (Developer Studio/Advisors Angle) (from SeveralNines Open Source Database Blog)

pMonitoring your MySQL database proactively is imperative nowadays. It plays a crucial and significant part for managing and controlling your database especially for your production-grade clusters. Missing specific information that would be beneficial for improving your database or failing to identif the root cause for problems that can be encountered might produce extreme difficulty to fix or reco [...]

Tuesday, 10. August 2021

A Typical Journey Migrating to MariaDB from Oracle (from MariaDB Corporation Blog)

Use SQL compatibility mode and easy-to-create regex filters that rewrite live queries to simplify migrating to MariaDB. [...]