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.

Friday, 11. June 2021

Dealing With MySQL Replication Issues Using ClusterControl (from SeveralNines Open Source Database Blog)

pOne of the most popular ways in achieving high availability for MySQL is replication. Replication has been around for many years, and became much more stable with the introduction of GTIDs. But even with these improvements, the replication process can break due to various reasons - for instance, when master and slave are out of sync because writes were sent directly to the slave. How do you troubl [...]

Thursday, 10. June 2021

MariaDB Connector C 3.2.0 beta now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/C 3.2.0 Beta. See the release notes and changelog for... Read more » [...]

Self-Healing Feature in Percona Distribution for MySQL Operator (from Percona Database Performance Blog)

♦In the previous release of our Percona Distribution for MySQL Operator, we implemented one interesting feature, which can be seen as “self-healing”: jira.percona.com/browse/K8SPXC-564. I do not think it got enough attention, so I want to write more about this. As it is well known, a 3-node cluster can survive a crash of one node (or […] [...]

MySQL Replication Best Practices (from SeveralNines Open Source Database Blog)

pMySQL Replication has been the most common and widely used solution for high availability by huge organizations such as Github, Twitter, Facebook, etc. Although easy to setup, there are ultimate challenges that are faced when using this solution from doing maintenance such as software upgrades, data drift or data inconsistency across the replica nodes, topology changes, failover, and recovery. Whe [...]

Managing Your Data Lifecycle with Time to Live Tables (from TiDB and TiKV Blog)

Time to live, or TTL, is a mechanism to manage the data lifecycle in a system. At TiDB Hackathon 2020, a team introduced TTL tables into TiDB to enable automatic management of the data lifecycle. [...]

Wednesday, 09. June 2021

Use Window Functions to Speed Up Correlated Subqueries (from Øystein on MySQL Optimizer)

p In my previous blog post, I discussed different ways to rewrite correlated scalar subqueries to improve performance. In this blog post, I will discuss how we can use window functions for a subset of these queries. Window functions was introduced in MySQL 8.0. /pUse casep Often we run queries to find rows within a table with values that are, e.g., smaller, greater, or equal to some metric c [...]

Tuesday, 08. June 2021

Tungsten Connector - The Secret to SmartScale Success (from Continuent Blog)

pSmartScale is a special mode of the Tungsten Connector (aka Tungsten Proxy), which allows read requests to be intelligently routed to either a replica or the primary to ensure that the data returned is not stale. This feature is available when the Connector is running in the application-layer Proxy mode. Learn more about the behavior of SmartScale in this blog./p Tags: MySQLMariaDBTungsten Co [...]

Super-Charging Parallel Apply in Tungsten Cluster (from Continuent Blog)

pApplication performance and MySQL database responsiveness is always high priority for highly-available, business-critical use cases. That’s why Tungsten Clustering offers features and options to tune for maximum performance, such as Parallel Apply. When does Parallel Apply work best? What are the limitations? To find out, read this blog from MySQL industry vet, Eric M. Stone, the COO of Continuent [...]

MySQL Group on Linkedin.Com passes 20,000 Members (from PHP With MySQL)

p     A few weeks ago the MySQL Group on Linked.in passed 20,000 members. For those of you who do not know about Linked.in, it is a business and employment oriented online platform that is mainly used for professional networking, and allows job seekers to post their resumes and employers to post jobs./pp    You can find job positing, announcements, relevant blog posts, [...]

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

MariaDB is pleased to announce the immediate availability of MariaDB Connector/Python 1.0.7. See the release notes and changelog for details... Read more » [...]

Restore Strategies with MyDumper (from Percona Database Performance Blog)

♦In my previous post Back From a Long Sleep, MyDumper Lives!, I told you that Fast Index Creation was in the queue and (after fixing several bugs) it will package in release 0.10.7 next month. But why am I so excited about it? Well, this feature opens new opportunities, what I’m going to call Restore […] [...]

Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL (from Vettabase)

pHaving many indexes in our databases comes with a cost. It is good to periodically eliminate duplicate and unused indexes. Continue reading Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL→/p pThe post Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL appeared first on Vettabase./p [...]

Monday, 07. June 2021

MariaDB Connector ODBC 3.1.13 now available (from MariaDB Corporation Blog)

MariaDB is pleased to announce the immediate availability of MariaDB Connector/ODBC 3.1.13. See the release notes and changelogs for details... Read more » [...]

Releasing ProxySQL 2.2.0 (from ProxySQL Blog)

pWe are proud to announce the latest release of ProxySQL version 2.2.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 2.2.0 appeared first on ProxySQL./p [...]

Saturday, 05. June 2021

MySQL Time Zone Support (with examples) (from MySQL Support Blogs)

Time zone handling can sometimes generate confusion, especially when dealing with data migrations to different host running on a different time zone, or when switching to a Daylight Saving Time (DST) time zone or when leap seconds are introduced. Will the stored date still make sense after changing a system-wide configuration? What happens when you migrate a server to another host? What is actually [...]

Friday, 04. June 2021

Dutch PHP Conference -- Learn about using indexes versus histograms with MySQL (from PHP With MySQL)

p The Dutch PHP Conference is June 17th and 18th and I am lucky enough to be presenting again this years.  This is an amazing event to attend but this year it is virtual. At 10:00 to 13:00 CEST on the 17th I will be presenting on MySQL 8.0 Indexes, Histograms, and Other Ways to Speed Up Your Queries.  This talk starts with assuming you are new to adding indexes or histograms, do [...]

Need a quick row number on your query output? (from PHP With MySQL)

p    Recently on Reddit someone asked how to automatically get a row number generated in front of the output from a query.  There is a ROW_NUMBER() function and it very simple to use with Windowing Functions./pp    The sample data for this example is very simple./p> SELECT name, qty FROM sample;br+------+-----+br| name | qty |br+------+-----+br| a  &n [...]

Inspecting MySQL Servers Part 4: An Engine in Motion (from Percona Database Performance Blog)

♦The combination of the information obtained from the “pt-summaries” discussed in the previous posts of this series (Part 1: The Percona Support Way, Part 2: Knowing the Server, Part 3: What MySQL?) helps us come up with the first impression of a MySQL server. However, apart from the quick glance we get at two samples […] [...]

Managing Multiple Database Technologies with ClusterControl (from SeveralNines Open Source Database Blog)

pManaging multiple open source database technologies in any environment can be a daunting task, especially if you have fewer resources. The scenario could be worse if deployment, monitoring and other database management task is done manually. If this sound scenario sounds familiar, this blog can help you automate open source heterogeneous databases management using database automation tools like Cl [...]

Thursday, 03. June 2021

A new Protocol Buffers generator for Go (from Vitess)

Although the main interface between applications and a Vitess database is through the MySQL protocol, Vitess is a large and complex distributed system, and all the communication between the different services in a Vitess cluster is performed through GRPC. Because of this, all service boundaries and messages between Vitess' systems are specified using Protocol Buffers. The history of Vitess' integra [...]

Query performance comparison between MariaDB Column Store and other Storage Engines (from Shinguz's Blog)

pStorage Engines like InnoDB, Aria and MyISAM are Row Stores. They store rows one after the other in blocks or even directly in a single file (MyISAM). On the other hand a Column Store like MariaDB Column Store stores all the same attributes (columns) of the rows together in chunks./p pThis is how the table codesales_fact/code looks like:/p preCREATE TABLE `sales_fact` ( `product_id` int(11) NO [...]

Inspecting MySQL Servers Part 3: What MySQL? (from Percona Database Performance Blog)

♦In the previous post of this series, we looked at the hardware specifications and operating system settings of the host server through the lenses of a pt-summary report. Now that we know the foundation on which the database is running, we can turn our focus to MySQL itself. The second of our triad of tools […] [...]

Using your FRM file to get Schema and then import idb files.. (from Another MySQL DBA)

p This is a topic that overall you never should have to do... Why? Because you created backups right... You have tested and know the backups work so you can just restore those backups and get your lost schema and related data... /ppHowever that one instance in the corner office.. you never got around to setting up.. it not that important... just crashed and now you realize how you actuall [...]

MySQL mysql_config_editor & expect (from Another MySQL DBA)

pThis is just a note to help out anyone that might want to use the mysql_config_editor command in their automation tools. /ppthe mysql_config_editor does not take a password argument so automation tools that might have before set your password in the .my.cnf file trying to use mysql_config_editor fails. /ppIt is possible and quite simple though with the expect tool. /p [...]

TiDB 5.0: A One-Stop HTAP Database Solution (from TiDB and TiKV Blog)

TiDB 5.0 features a comprehensive HTAP solution enhanced by an MPP analytical query engine. This article introduces the new TiDB 5.0 HTAP architecture and how TiDB 5.0 serves various transactional & analytical hybrid workload scenarios. [...]

Wednesday, 02. June 2021

Word from the CEO: Galera, XtraDB Cluster, and The Color of Open Source Money (from Continuent Blog)

pThis blog is about open source MySQL clustering software, specifically Codership’s Galera Cluster and Percona’s fork of that, XtraDB Cluster. If you are considering using Galera, please use the original version, or please use the version by MariaDB, which is actively supporting the Galera team./p Tags: MySQLMariaDBGaleraxtradb cluster [...]

Inspecting MySQL Servers Part 2: Knowing the Server (from Percona Database Performance Blog)

♦In part 1 of this series, we introduced you to the approach used by the Percona Support team to inspect MySQL servers, which is based on a triad of tools from the Percona Toolkit used to gather diagnostic information. In this article, we will be focusing on the first of these tools, the pt-summary. pt-summary […] [...]

Migrating Users from Aurora to MDS (from lefred's blog)

If you decided to move your data from Amazon Aurora to the real MySQL Database Service on OCI you can use the nice MySQL Shell Dump & Load utility to dump the data or the full instance. This is the recommended way. However, I recently saw many people migrating only the data using the dump but skipping the users and deal with the users on a second time. This is also true because many Aurora users ar [...]

Tuesday, 01. June 2021

Getting Started with Connector/Node.js (from MariaDB Corporation Blog)

An introduction to MariaDB/Node.js with simple examples demonstrating create, read, update, and delete (CRUD) interactions with data stored in MariaDB. [...]

260 (Thousands) thanks (from TusaCentral - MySQL Blogs)

pPercona live is over, and we finally get some feedback about our presentations./p pInitially I had 3 presentations to give:/p ul liComparing High Available Solutions With Percona XtraDB Cluster and Percona Server With Group Replication./li liComparing Hash Join solution, the good, the bad and the worse. The New version 2021./li liBoosting MySQL NDB cluster & MySQL Innodb Cluster with PrxySQL V [...]

Skipping Percona Server for MySQL Version 8.0.24 and Releasing 8.0.25 Next (from Percona Database Performance Blog)

♦After Oracle released MySQL version 8.0.24 on April 20, 2021, our engineering team got started right away with merging our enhancements to prepare the corresponding 8.0.24 version of Percona Server for MySQL. However, Oracle released MySQL version 8.0.25 shortly afterward on May 11, 2021, to fix a critical bug that we also observed during our […] [...]

Inspecting MySQL Servers Part 1: The Percona Support Way (from Percona Database Performance Blog)

♦When I joined the Percona Support team in early 2013, MySQL 5.6 was being launched. I remember all the buzz and euphoria surrounding its release: it was a big step from the 5.5 series, carrying important changes in the MySQL architecture and internals that brought highly anticipated features such as the (still incipient) multi-threaded replication […] [...]

Six Critical Components of Successful Data Governance (from SeveralNines Open Source Database Blog)

What is Data Governance? pFor large organizations or companies that are into data management, data governance possesses the key to success in managing, controlling, or governing the data that has been owned or collected. It is fundamental for any organization or companies. Your business benefits from consistent, common processes and responsibilities if your data governance strategy works according [...]

Integrating ClusterControl with SNMP : Part Two (from SeveralNines Open Source Database Blog)

pThis blog post is a continuation of the previous part 1, where we have covered the basics of SNMP integration with ClusterControl./p pIn this blog post, we are going to focus on SNMP traps and alerting. SNMP traps are the most frequently used alert messages sent from a remote SNMP-enabled device (an agent) to a central collector, the “SNMP manager.” In the case of ClusterControl, a trap could be [...]

Why run MariaDB on ARM? (from MySQL On ARM)

MariaDB has been releasing packages for the MariaDB Server on ARM for quite some time now. Infact, it was first in mysql space to get ported and optimize the server for ARM. It continues to evaluate its new performance features/releases/regression by testing them on ARM through community support. [...]

Monday, 31. May 2021

Skills you may excel at if you know how to code (from Geeky Hacker - Coding, Tech & Linux)

pThe ability to write computer code is an incredibly valuable skill in and of itself. It opens the door for limitless creative projects, and can in many cases lead to [...]/p pThe post Skills you may excel at if you know how to code appeared first on Geeky Hacker./p [...]

Friday, 28. May 2021

Deploy your own PHP application on OCI and MDS (from lefred's blog)

Recently, I wrote several articles about how to deploy popular Open Source applications on Oracle Cloud Infrastructure and MySQL Database Service. Today we will see how you can deploy your own LAMP stack application using the same technique where L will stand for a compute instance (and why not the Ampere always free trier?), A stays Apache and will run in that compute instance. M stands for MySQL [...]

Thursday, 27. May 2021

The Key Reasons To Upgrade Tungsten And How To Get It Done (from Continuent Blog)

pUpgrades are a normal, expected part of all software lifecycles, and Tungsten is no exception. Keep your software up-to-date to ensure compatibility, supportability and the lowest risk possible to your operation./p Tags: Tungsten upgradeMySQLMariaDBbest practices [...]

How InnoDB Handles TEXT/BLOB Columns (from Percona Database Performance Blog)

♦Recently we had a debate in the consulting team about how InnoDB handles TEXT/BLOB columns. More specifically, the argument was around the Barracuda file format with dynamic rows. In the InnoDB official documentation, you can find this extract: When a table is created with ROW_FORMAT=DYNAMIC, InnoDB can store long variable-length column values (for VARCHAR, VARBINARY, […] [...]

Integrating ClusterControl with SNMP - A Proof of Concept : Part One (from SeveralNines Open Source Database Blog)

pClusterControl comes with a number of distinctive alerts (or alarms) which you won't find in other monitoring systems. ClusterControl understands a database cluster topology as a whole - all database nodes and the relation between them, including the dependent nodes or clusters like slave cluster, reverse-proxy and arbitrator nodes. For example, ClusterControl is able to detect and report a partit [...]

MariaDB Cloud MiniFest Wed 9 June 2021 (from MariaDB Foundation Blog)

pTime for another MariaDB Server MiniFest! It will be on Wednesday 9 June 2021, so do mark your calendars. Our topic is the MariaDB in the Cloud. … /p pContinue reading \"MariaDB Cloud MiniFest Wed 9 June 2021\"/p pThe post MariaDB Cloud MiniFest Wed 9 June 2021 appeared first on MariaDB.org./p [...]

Use Matomo Website Analytics on OCI with MDS (from lefred's blog)

Matomo is a Google Analytics alternative for your websites. If you follow my blog, you know how easy it’s to deploy popular Open Source web solutions like WordPress, Joomla!, Drupal, Moodle, Magento on OCI. If this is not yet your case, please check this page: deploy on OCI. All these solutions are using MySQL Database Service to store their data. I’ve recently added a new stack to also deploy Mato [...]

TiDB Operator Source Code Reading (II): Operator Pattern (from TiDB and TiKV Blog)

Learn about Kubernetes's Operator pattern and TiDB Operator's major reconcile loop. [...]

Wednesday, 26. May 2021

What You Must Know about Data Security (from Continuent Blog)

pIt goes without saying that database security is top priority at Continuent; Tungsten Clustering customers in financial and healthcare organizations among others implement the strictest standards of data security, and so we have always kept it a mandate to not only support HIPPA and PII compliance, and maintain strict boundaries and protocols in design of our software solution and when providing s [...]

Deploy on OCI using Ampere Compute Instances ! (from lefred's blog)

Yesterday, Oracle announced a new range of Arm compute instances based on Ampere’s ARM processors This is a very nice announcement ![1], [2] and something also very cool is that you are eligible for an Always Free instance up to 4 OCPUs, 24GB of RAM and 4Gbps network bandwidth !! This is the max you can have and you define it during the shape selection: I have already updated all the Stacks I propo [...]

Tuesday, 25. May 2021

What Does This Query Really Do? (from PHP With MySQL)

pComputers are dumb. And they will do exactly what you ask them to do.  The trick often is to think as dumb as the computer. Sadly it is all to easy to assume that the computer is 'thinking' like you are and blunder into a head scratching puzzle.  Recently there was a post on MySQL Community Space Groundbreakers Developer Community site that shows that sometimes what is intended is not wh [...]

Using SQLAlchemy with MariaDB Connector/Python: Part 2 (from MariaDB Corporation Blog)

Learn how to create and manage model relationships using SQLAlchemy and MariaDB Connector/Python! [...]

HA vs AlwaysOn (from Mikael Ronstrom)

p In the 1990s I spent a few years studying requirements on databases used in 3G telecom networks. The main requirement was centered around three keywords, Latency, Throughput and Availability. In this blog post I will focus on Availability./pbrpIf a telecom database is down it means that no phone calls can be made, internet connections will not work and your app on your smartphone will cease [...]

MariaDB Cluster (Multi-Master) Peformance on ARM (from MySQL On ARM)

During our last blog post we explored the mariadb on arm cluster performance in master-slave mode. In this blog post, we will explore mariadb on arm cluster performance in multi-master mode. MariaDB Server has an in-built support for Multi-Master setup using galera synchronous replication. Users who can’t afford slave lag continue to opt for multi-master solution that can also help aid write-scalab [...]

Monday, 24. May 2021

MySQL INSERT-SET (from MacLochlainns Weblog)

I found myself explaining the nuances of INSERT statements and whether you should use named or positional notation. While the class was on Zoom, I could imagine the blank stares in the silence of my headphones. Then, I had to remind them about mandatory (NOT NULL constrained) and optional (nullable) columns in tables and how […] [...]

Best Practices in Scaling Databases: Part Two (from SeveralNines Open Source Database Blog)

pIn the previous blog post, we have covered the basics of scaling - what it is, what are the types, what is a must-have if we want to scale. This blog post will focus on the challenges and the ways in which we can scale out./p Challenging of Scaling Out pScaling databases is not the easiest task for multiple reasons. Let’s focus a little bit on the challenges related to scaling out your database [...]

Amazon Aurora Replication: How to Make it Work Securely & in Real-Time (from Continuent Blog)

pThis blog post looks at the ins and outs of Amazon Aurora replication and how to best go about that; including all the details you need to replicate to and from Aurora with the Tungsten Replicator AMI./p Tags: MySQL ReplicationMySQLamazon auroraaurora replicationreal-timetungsten replicatoraws marketing [...]

TiFS, a TiKV-Based Partition Tolerant, Strictly Consistent File System (from TiDB and TiKV Blog)

TiFS is a distributed file system built upon TiKV. It is partition tolerant, strictly consistent, and most efficient for reading and writing small files or other complicated file system operations. [...]

Sunday, 23. May 2021

Enable https to our Moodle (from lefred's blog)

Yesterday, we saw how to easily deploy Moodle to OCI with MDS. Today we will see how to enable https to that new created Web site. In this post we use Moodle but it is exactly the same process for other solutions. First thing to do is to register a dns name for the moodle instance that will point to the public IP of the Moodle Compute Instance: For this example, I will use moodle.lefred.be. The nex [...]

Saturday, 22. May 2021

Deploy Moodle on OCI with MDS (from lefred's blog)

Moodle is the world’s most popular learning management system. Moodle is Open Source and of course it’s compatible with the most popular Open Source Database : MySQL ! I’ve already posted an article on how to install Moodle on OCI before we released MySQL Database Service. In this article we will see how to deploy Moodle very easily in OCI and using MDS. Once again we will use the easiest way to de [...]

MySQL Connect Dialog (from MacLochlainns Weblog)

About a month ago, I published how you can connect to MySQL with a small form. One suggestion, or lets promote it to a request, from that post was: “Nice, but how do you create a reusable library for the MySQL Connection Dialog box?” That was a good question but I couldn’t get back until […] [...]

How to run MySQL Enterprise Edition on Oracle Cloud Infrastructure from Marketplace ? (from MySQL Solutions - On Premises & Cloud)

 Deploy MySQL Enterprise Edition with OCI Market Place ApplicationIn this blog we will look into the process to deploy MySQL Enterprise Edition in to Oracle Cloud Infrastructure.brIn this blog we will discuss the below agenda1. Introduction about MySQL EE and OCI Market placebr2. Deploy MySQL EE into Oracle Cloud Infrastructurebr3. Accessing MySQL database from On-premises.br4. Licensing/Purch [...]

Friday, 21. May 2021

MariaDB 10.6.1 now available (from MariaDB Foundation Blog)

pThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.6.1, the first beta release in the new MariaDB 10.6 development series. … /p pContinue reading \"MariaDB 10.6.1 now available\"/p pThe post MariaDB 10.6.1 now available appeared first on MariaDB.org./p [...]

Announcing MariaDB Server 10.6.1 Beta (from MariaDB Corporation Blog)

The beta release of MariaDB Server 10.6 is now available for download. This release includes several internal optimizations and feature enhancements. [...]

Migrate from Galera to Tungsten Clustering without Downtime (from Continuent Blog)

pMigrating from Galera to Tungsten Clustering is easy with the tools provided by Tungsten Clustering. Because replication happens in the background, applications can stay online with a quick cutover to Tungsten Clustering when ready./p Tags: GaleramigrationDeploymentMySQL [...]

How to enable MySQL query logging (from Geeky Hacker - Coding, Tech & Linux)

pTo see what queries are sent to MySQL, it’s useful to enable query logging and piping the output to a file or even a table to inspect later. In this [...]/p pThe post How to enable MySQL query logging appeared first on Geeky Hacker./p [...]

Thursday, 20. May 2021

Manage MySQL Users with Kubernetes (from Percona Database Performance Blog)

♦Quite a common request that we receive from the community and customers is to provide a way to manage database users with Operators – both MongoDB and MySQL. Even though we see it as an interesting task, our Operators are mainly a tool to simplify the deployment and management of our software on Kubernetes. Our […] [...]

Non-Blocking Schema Changes (from PlanetScale Blog)

Non-blocking schema changes let you push updates to your database without fear of blocking your databases, locking individual tables, or slowing down production during schema migrations.pRead the full story/p [...]

Extending the MySQL Shell with Python (from PHP With MySQL)

pOne of the problems that comes with age is that there is so much 'baggage' filling valuable brain area that it sometimes requires a mental sweeping before trying to learn a new skill. I am still getting rid of FORTRAN and COBOL factoids but need to come up to speed on extending MySQL for some talks I am giving.  So away with the PROCEDURE DIVISION stuff... /ppThe MySQL Shell or Mysqlsh i [...]

New Features in Percona Server for MySQL 8.0.23-14 (from Percona Database Performance Blog)

♦Percona Server for MySQL 8.0.23-14 was released last week and I wanted to take a minute to call out some of the interesting new features that we have introduced in this release. These are included in addition to the features and improvements in MySQL 8.0.23 that were introduced by the Oracle MySQL team (and to […] [...]

Asynchronous Replication Connection Failover – Automatic source list (from MySQL High Availability)

pIn our last blog post about the Automatic Asynchronous Replication Connection Failover feature which was released in MySQL 8.0.22, we showed you its usage and benefits. We now present here additional changes we added in MySQL 8.0.23 to further enhance this feature by making the receiver aware of the source’s group membership changes.…/p [...]

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

pJoin us for this webinar on Tips to Drive MariaDB Galera Cluster Performance for Nextcloud. The webinar features Björn Schiessle, Co-Founder and Pre-sales lead at Nextcloud, and Ashraf Sharif, senior support engineer at Severalnines. They will give you a deep dive into designing and optimising MariaDB Galera Cluster for Nextcloud and sharing tips on improving performance and stability significantl [...]

Wednesday, 19. May 2021

Percona Monitoring and Management DBaaS Overview and Technical Details (from Percona Database Performance Blog)

♦Database-as-a-Service (DBaaS) is a managed database that doesn’t need to be installed and maintained but is instead provided as a service to the user. The Percona Monitoring and Management (PMM) DBaaS component allows users to CRUD (Create, Read, Update, Delete) Percona XtraDB Cluster (PXC) and Percona Server for MongoDB (PSMDB) managed databases in Kubernetes clusters. […] [...]

Create a single-node MariaDB ColumnStore test installation (from Shinguz's Blog)

Table of Contents ulliHardware requirements/li liO/S (Linux) settings/li liInstallation/li liConfiguration/li liCross Engine Join User/li liStart ColumnStore/li liCreate the Cross Engine Join User in the database/li liMariaDB ColumnStore schemas/li liServer System Variables and Server Status Variables/li liMariaDB Column Store on the file system/li liCreating our first table/li [...]

How to Manage Large Databases Effectively (from SeveralNines Open Source Database Blog)

pOne of the biggest concerns when dealing with and managing databases is its data and size complexity. Often, organizations get concerned about how to deal with growth and manage growth impact because the database management fails off. Complexity comes with concerns that were not addressed initially and were not seen, or could be overlooked because the technology being currently used shall be able [...]

Using Sidecars with Percona Kubernetes Operators (from Percona Database Performance Blog)

♦Our recent releases of Percona XtraDB Cluster Operator 1.8 and Percona Server for MongoDB Operator 1.7 come with a new interesting feature: Support of custom sidecars. What is special about this? There is often a need to customize the default installation, for example, one popular request is to support your favorite monitoring system, which is […] [...]

5.5M Key Lookups per second on 16 VCPU VMs (from Mikael Ronstrom)

p As introduced in a previous blog RonDB enables us to easily execute benchmarks on RonDB using the Sysbench benchmark./pbrpIn this blog I will present some results where the RonDB cluster had 2 data nodes, each using a r5.4xlarge VM in AWS that has 16 VCPUs and 128 GB memory. The Sysbench test uses SQL to access RonDB./pbrpIn this particular test case we wanted to test the Key-Lookup performa [...]

Tuesday, 18. May 2021

Announcing PlanetScale: The database for developers. (from PlanetScale Blog)

PlanetScale is the first database designed for developer workflows, on top of the technology of the hyperscalers.pRead the full story/p [...]

Understanding Indexes in MySQL: Part Three (from SeveralNines Open Source Database Blog)

pThis blog post is the third part of the series of blogs about indexes in MySQL. In the second part of the blog post series about MySQL indexes, we covered indexes and storage engines and touched upon some PRIMARY KEY considerations. The discussion included how to match a column prefix, some FULLTEXT index considerations, and how you should use B-Tree indexes with wildcards and how to use ClusterCo [...]

Async Commit, the Accelerator for Transaction Commit in TiDB 5.0 (from TiDB and TiKV Blog)

As a major new feature introduced in TiDB 5.0, Async Commit can greatly reduce the latency of transaction commits. This post describes Async Commit's design ideas and its key implementation details. [...]

A configuration that can double MySQL write performance (from MySQL On ARM)

MySQL is heavily tunable and some of the configuration can have significant impact on its performance. During my experiment for numa scalability I encountered one such configuration. Default configuration tends to suggest heavy contention for write workload but once tuned it helps scale MySQL by more than 2x. [...]

Monday, 17. May 2021

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

pFromDual has the pleasure to announce the release of the new version 1.1.0 of its popular FromDual Ops Center focmm, a Graphical User Interface (GUI) for MariaDB, MySQL and compatible databases./p pThe FromDual Ops Center for MariaDB and MySQL (focmm) helps DBA's and System Administrators to better manage their MariaDB, MySQL and compatible databases farms. Ops Center makes DBA and Admins life ea [...]

Understanding Indexes in MySQL: Part Two (from SeveralNines Open Source Database Blog)

pThis blog post is the second part of the series of blogs about indexes in MySQL. In the first part of the blog post series about MySQL indexes, we have covered quite many things, including what they are, what they do, what their types are, how to choose optimal data types, and MySQL character sets for indexes that you use. We went through the benefits and drawbacks of using indexes in MySQL; we to [...]

Saturday, 15. May 2021

MySQL Transaction Unit (from MacLochlainns Weblog)

Many of my students wanted to know how to write a simple PSM (Persistent Stored Module) for MySQL that saved the writes to all table as a group. So, to that end here’s simple example. Create four sample tables in a re-runnable script file: /* Drop and create four tables. */ DROP TABLE IF EXISTS […] [...]

Friday, 14. May 2021

Understanding Indexes in MySQL: Part One (from SeveralNines Open Source Database Blog)

pIndexes in MySQL are a very complex beast. We have covered MySQL indexes in the past, but we have never taken a deeper dive into them - we will do that in these series of blog posts. This blog post should act as a very general guide to indexes while the other parts of these series will dive a little bit deeper into these subjects. /p What are Indexes? pIn general, as already noted in a previous [...]

Thursday, 13. May 2021

JSON Validation and ALGORITHM = Instant (from PHP With MySQL)

pToday I was presenting on JSON Schema validation and covering how MySQL implemented the JSON-Schema.org ideas on making sure JSON data meets criteria before being allowed into the database.  I was asked by Percona Live attendee Nickolay Ihalainin if the JSON_SCHEMA_VALID function worked with ALTER TABLE's ALGORITHM = INSTANT option./ppI admitted that I did not know as a I had not tested. Whil [...]

Cloning MySQL InnoDB Cluster data-at-rest encrypted tables (from MySQL Support Blogs)

MySQL Server offers, among the different security features, encryption at rest (or Transparent Data Encryption, TDE) in the commercial release (find the differences with Community here). While testing TDE with MySQL InnoDB Cluster, I was wondering what inner mechanism was implemented to deal with TDE, master keys and keyrings, and the clone plugin. If I need to clone an instance, how would ever [...]

ClusterControl - High Noon with Tungsten Clustering for MySQL High Availability (HA), Disaster Recovery (DR) and Geographic Distribution (from Continuent Blog)

pThis is the next blog in our competitor comparison series in which we look at the main solutions for MySQL high availability, disaster recovery and geographic distribution. Here we focus on highly available, geo-scale, multi-region MySQL for mission-critical sites and apps with ClusterControl as compared to MySQL clusters with Continuent Tungsten, the only complete, fully-integrated clustering sol [...]

TiDE: Developing a Distributed Database in a Breeze (from TiDB and TiKV Blog)

TiDE is a VS Code extension for developing TiDB. It offers IDE, debugging, log search, Kubernetes integration, and VM management for TiDB clusters. [...]

Wednesday, 12. May 2021

MySQL Track (from PHP With MySQL)

pMay 13th is the day for the MySQL Tracks at the Percona Live  conference. /ppBesides an announcement for an exciting new product, you will find sessions on:/p♦brp/pp/pulliMySQL Server Component Manifest Files/liliInsights into the new Oracle MySQL Database Service/liliOracle MySQL Database Service with HeatWave for Real-Time Analytics/liliMySQL Architectures in a Nutshell/liliSuccessfull [...]

Best Practices in Scaling Databases: Part 1 (from SeveralNines Open Source Database Blog)

pAll of you have heard about scaling - your architecture should be scalable, you should be able to scale up to meet the demand, so on and so forth. What does it mean when we talk about databases? How does the scaling look like behind the scenes? This topic is vast and there is no way to cover all of the aspects. This two-blog post series is an attempt to give you an insight into the topic of databa [...]

Dynamic Tracing of Memory Allocations in MySQL With bcc Tools (from MySQL Entomologist (former?) Blog)

pLast year I started my lame attempts to apply different Linux dynamic tracing tools and approaches to frequent events like memory allocations. In this blog post I already described how to use perf to add user probe to trace malloc() calls with the number of bytes requested. Unfortunately this approach is not practical for production use for more than several seconds./ppRecently I plan with bpftrac [...]

MySQL Searched CASE Expression – with examples (from Digital Owl's Prose)

pDuring many decision-making phases in programming code (conditional logic), there are times execution depends on several different factors. Multiple conditional tests are powerful and constraining, oftentimes requiring more than one test to be passed in order for program flow to proceed. For MySQL (and standard SQL in general) the CASE expression is used for IF/THEN/ELSE conditional logi [...]

Announcing MySQL Cluster 8.0.25 (from MySQL Release Engineering)

We are pleased to announce the release of MySQL Cluster 8.0.25. MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: In-Memory storage – Real-time performance (with optional checkpointing to disk) Transparent Auto-Sharding – Read & write scalability Active-Active/Multi-Master geographic replication 99.999% High Availability with no single point of fai [...]

Tuesday, 11. May 2021

MariaDB at Percona Live Online (from MariaDB Foundation Blog)

pGood news is that the MariaDB Foundation and members of the MariaDB community are participating in Percona Live Online on the 12th – 13th of May, and we are excited to interact with you there. … /p pContinue reading \"MariaDB at Percona Live Online\"/p pThe post MariaDB at Percona Live Online appeared first on MariaDB.org./p [...]

Deploy Magento on MDS & HeatWave (from lefred's blog)

Magento is an Open-Source e-commerce platform written in PHP using multiple other PHP frameworks such as Laminas and Symphony. Magento source code is distributed under Open Software License v3.0. Deploying Magento is not always easy as it often requires registration. However the source code is also availble on GitHub. Magento supports MySQL 8.0 since version 2.4.0 (July 28th 2020). In Magento’s doc [...]

MySQL Connector/NET 8.0.25 has been released (from InsideMySQL.com)

Dear MySQL users, MySQL Connector/NET 8.0.25 is the latest General Availability releaseof the MySQL Connector/NET 8.0 series. This version supports .NET 5.0and the X DevAPI, which enables application developers to write codethat combines the strengths of the relational and document … Continue reading → [...]

Understanding MySQL’s New Heatwave (from SeveralNines Open Source Database Blog)

pData Analytics is important in any company as you can see what happened in the past to be able to make smart decisions or even predict future actions using the existing data./p pAnalyze a huge amount of data could be hard and you should need to use more than one database engine, to handle OLTP and OLAP workloads. In this blog, we will see what is HeatWave, and how it can help you on this task./p [...]

Announcing MySQL Server 8.0.25 (from MySQL Release Engineering)

MySQL Server 8.0.25, a new version of the popular Open Source Database Management System, has been released. This release is recommended for use on production systems. For an overview of what’s new, please see dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html For information on installing the release on new servers, please see the MySQL installation documentation at dev.mysql.com/doc/refman/8.0/e [...]

MySQL Connector/J 8.0.25 has been released (from InsideMySQL.com)

Dear MySQL users, MySQL Connector/J 8.0.25 is the latest General Availability release of the MySQL Connector/J 8.0 series.  It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6.  It supports the Java Database Connectivity (JDBC) 4.2 API, … Continue reading → [...]

MySQL Connector/Python 8.0.25 has been released (from InsideMySQL.com)

Dear MySQL users, MySQL Connector/Python 8.0.25 is the latest GA release version of the MySQL Connector Python 8.0 series. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a … Continue reading → [...]

MySQL Connector/ODBC 8.0.25 has been released (from InsideMySQL.com)

Dear MySQL users, MySQL Connector/ODBC 8.0.25 is a new version in the MySQL Connector/ODBC 8.0 series, the ODBC driver for the MySQL Server. The available downloads include both a Unicode driver and an ANSI driver based on the same modern … Continue reading → [...]

MySQL Connector/C++ 8.0.25 has been released (from InsideMySQL.com)

Dear MySQL users, MySQL Connector/C++ 8.0.25 is a new release version of the MySQL Connector/C++ 8.0 series. Connector/C++ 8.0 can be used to access MySQL implementing Document Store or in a traditional way, using SQL queries. It allows writing both … Continue reading → [...]

MySQL Shell 8.0.25 for MySQL Server 8.0 and 5.7 has been released (from InsideMySQL.com)

Dear MySQL users, MySQL Shell 8.0.25 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle’s dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server … Continue reading → [...]

MySQL Connector/Node.js 8.0.25 has been released (from InsideMySQL.com)

Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the X DevAPI. This release, v8.0.25, is a maintenance release of the MySQL Connector/Node.js 8.0 series. The X DevAPI enables application developers to write code that combines … Continue reading → [...]