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.

Saturday, 16. October 2021

Learning MySQL – What you will find when you read it (from The Fellowship Of Data)

Recently, I and my colleague Sergey Kuzmichev published a book about Learning MySQL. So, what people will find in case they are considering using the book? The book has 16 ... [...]

Friday, 15. October 2021

Best way to start a thread when looking for MySQL Help and more (from lefred's blog)

I’m active on multiple platforms (mail, slack, forums, …) and often, when people are looking for help, the first 5 or 10 questions are always the same: which version of MySQL are you running ? which OS ? is it in the cloud ? which provider ? are you using replication ? GTIDs ? …. I’ve added to MySQL Shell Plugin repository and plugin called support which provides an output that user can share when [...]

Comparing Graviton (ARM) Performance to Intel and AMD for MySQL (from Percona Database Performance Blog)

♦Recently, AWS presented its own CPU on ARM architecture for server solutions. It was Graviton. As a result, they update some lines of their EC2 instances with new postfix “g” (e.g. m6g.small, r5g.nano, etc.). In their review and presentation, AWS showed impressive results that it is faster in some benchmarks up to 20 percent. On […] [...]

Compatible with MySQL or Postgres? (from Small Datum)

pOpen and closed source scale-out DBMS that are compatible with MySQL and Postgres have emerged on the market. This is great for the community but there will be much confusion about the meaning of compatible. /ppThis post has yet to have anything on the cloud vendors in China. They are doing impressive work but I don't know enough about it. I am happy to update this post when I learn more./ppB [...]

Thursday, 14. October 2021

Custom Percona Monitoring and Management Metrics in MySQL and PostgreSQL (from Percona Database Performance Blog)

♦A few weeks ago we did a live stream talking about Percona Monitoring and Management (PMM) and showcased some of the fun things we were doing at the OSS Summit.  During the live stream, we tried to enable some custom queries to track the number of comments being added to our movie database example.  We […] [...]

Downtime with Coffee, not MySQL (from Continuent Blog)

pMySQL High Availability (HA) is typically what architects and technologists look for in building business-critical and mission-critical applications, and they aspire to measure MySQL uptime in 4 or preferably more “nines.” This blog explores the new world of continuous MySQL operations - cross-region, global, hybrid-cloud, and multi-cloud./p Tags: MySQLMariaDBbusiness-criticalmission-critical [...]

Wednesday, 13. October 2021

Aurora MySQL Parallel query Performance and its gains (from Mydbops Blog)

As a continuation to my previous blog , I have made benchmarking to find the performance improvement using parallel query.Before starting the testing, we will go through the monitoring stats variables and query analysis (explain). Monitoring Aurora Parallel Query stats S:No Parameter Purpose 1 Aurora_pq_request_attempted No of attempt that query tried to use parallel query … Continue reading [...]

Zero Downtime Upgrades Made Easy with ClusterControl (from SeveralNines Open Source Database Blog)

p“Keep your database upgraded to the latest version - it’s for your safety” is something you may frequently hear as sound advice and best practice when it comes to database management. On the other hand, upgrading your database can be a time-consuming task. Even a minor version upgrade requires that you thoroughly test the upgrade in a staging environment before upgrading your production setup. So [...]

MySQL Table DDL file with phpMyAdmin (from Digital Owl's Prose)

pIf you need a structure only .sql file of a MySQL tables’ Data Definition Language (DDL), phpMyAdmin makes this super-easy with just a few clicks. Continue reading and learn how… Why use a DDL file? Why would you need a structure-only .sql DDL file anyway? Maybe you want to build out a tables’ structure on […]/p pThe post MySQL Table DDL file with phpMyAdmin appeared first [...]

MySQL on Kubernetes demystified (from TusaCentral - MySQL Blogs)

Why♦ pMarco, why did you write this long article?/p pYes, it is long, and I know most of the people will not read it in full, but my hope is that at least someone will, and I count on them to make the wave of sanity. /p pWhy I wrote it is simple. We write articles to share something we discover, or to share new approaches or as in this case to try to demystify and put in the right perspective [...]

Tuesday, 12. October 2021

ProxySQL 2.3.0: Enhanced Support for MySQL Group Replication (from Percona Database Performance Blog)

♦ProxySQL 2.3.0 was recently released and when I was reading the release notes, I was really impressed with the Group Replication enhancements and features. I thought of experimenting with those things and was interested to write a blog about them. Here, I have focused on the following two topics: When the replication lag threshold is […] [...]

PingCAP's TiDB Cloud Attains GDPR Certification, Solidifying Its Position as a Trusted Global Database Provider (from TiDB and TiKV Blog)

We are proud to announce that TiDB Cloud now holds the highest level of data privacy with full GDPR certification. [...]

Monday, 11. October 2021

TiDB Community joins Hacktoberfest 2021! (from TiDB and TiKV Blog)

TiDB is proud to be back at Hacktoberfest, a global celebration of open-source and technology. Join us and make contributions, whoever you are, whatever your experience, to the ever-growing TiDB community! [...]

Saturday, 09. October 2021

Compare Percona Distribution for MySQL Operator VS AWS Aurora and standard RDS (from TusaCentral - MySQL Blogs)

pI decided to write this article after a discussion with other colleagues.  We were wondering how and if the Percona Distribution for MySQL Operator(PDMO) could help a starting bu♦siness or a new project inside an enterprise.  We were also wondering how it behaves in relation to already well established solutions, like Amazon RDS or Google SQL. /p pIn fact, we often see analysis and [...]

10.7 preview feature: InnoDB Bulk Insert (from MariaDB Foundation Blog)

pEveryone wants performance. Speeding up the insert into empty InnoDB tables and partitions is a common enough use case to optimize. Thirunarayanan Balathandayuthapani from the MariaDB Corporation wrote this improvement to the bulk inserting into InnoDB tables that is available as a preview for testing. … /p pContinue reading \"10.7 preview feature: InnoDB Bulk Insert\"/p pThe post 10.7 previ [...]

Friday, 08. October 2021

MySQL Terminology Updates (from Hack MySQL)

MySQL Terminology Updates This page reproduces the blog post “MySQL Terminology Updates” from the defunct web site The original page—written by Kenny Gryp on July 1, 2020—is quoted below. It’s been 20 years since MySQL Replication was introduced in MySQL 3.23.15 (Released in May 2000). Since then, virtually every MySQL Database depl [...]

MySQL 8: Random Password Generator (from Percona Database Performance Blog)

♦As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how using the new dual passwords feature can reduce the overall DBA workload and streamline the management process. I’ve also covered how the new password failure tracking features can enable the locking of an account with too many failed password […] [...]

Thursday, 07. October 2021

Getting Started with ProxySQL in Kubernetes (from Percona Database Performance Blog)

♦There are plenty of ways to run ProxySQL in Kubernetes (K8S). For example, we can deploy sidecar containers on the application pods, or run a dedicated ProxySQL service with its own pods. We are going to discuss the latter approach, which is more likely to be used when dealing with a large number of application […] [...]

The Benefits of a Hybrid Transactional and Analytical Processing Database (from TiDB and TiKV Blog)

Hybrid Transactional and Analytical Processing, or HTAP, is a defining feature of TiDB. It means that you can run both transactional and analytical queries from within the same database. TiDB provides HTAP, ensuring that your queries are always running against the most current data available. [...]

Wednesday, 06. October 2021

How to Hide Credentials from Percona Monitoring and Management Client Commands (from Percona Database Performance Blog)

♦In this short blog post, we are going to review how to avoid using credentials in the Percona Monitoring and Management (PMM) client command line when adding new exporters. We will use an example with the MySQL exporter, but it is extensible to others (PostgreSQL, MongoDB, etc.). In the online documentation we can see the […] [...]

Reminder: TokuDB Storage Engine Will Be Disabled by Default in Percona Server for MySQL 8.0.26 (from Percona Database Performance Blog)

♦As we’ve communicated in our blog post in May, the TokuDB Storage Engine has been marked as “deprecated” in Percona Server for MySQL 8.0. It will be removed in a future version (Percona Server for MySQL 8.0.28, expected to ship in Q1 2022). With the release of Percona Server for MySQL 8.0.26, the storage engine will […] [...]

Medium Cross Post – CodeIgniter 4 CRUD: Delete (from Digital Owl's Prose)

pWhen the time comes that you no longer have a need for specific data, use DELETE to remove it completely from your table. CodeIgniter 4 Models have a delete() method that is super-easy to use. Continue reading for more information… CodeIgniter 4 CRUD Series with MySQL I have written a now complete 4-part series over […]/p pThe post Medium Cross Post – CodeIgniter 4 CRUD: Delete a [...]

Tuesday, 05. October 2021

Setup Redis in (Much) Less Than 60 seconds! (from MySQL Support Blogs)

I have been away for some time from this blog, but that was for a reason, I got a new job at Redis (and I can’t hide I am truly enthusiastic about my new position as Technical Enablement Architect!), and taking some time to onboard and extend my knowledge of the awesome Redis server, the popular in-memory key-value storage. So my future posts will likely be about Redis and the infinite chances to “ [...]

Contemplation on Programming Languages (from Continuent Blog)

pA short contemplation about the current state of the programming languages. What language to choose for a new project? What are the differences between them? Is there a best language for everything?/p Tags: languagesprogrammingpythonrustclojureJavafacebookgooglelinuxMySQLClusteringreplicationkuberneteschromium [...]

MySQL 8: Account Locking (from Percona Database Performance Blog)

♦As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how the new dual passwords feature can reduce the overall DBA workload and streamline the management process (see MySQL 8: Dual Passwords). This wasn’t the only change to user/password management in MySQL 8; one of the more security-focused changes was […] [...]

Monday, 04. October 2021

MariaDB / MySQL Advanced training end of October 2021 (from Shinguz's Blog)

pFrom 25 to 29 October 2021 (calendar week 43) we will have another MariaDB / MySQL advanced training in the Linuxhotel in Essen (Germany). The training is in German and will take place on-site (3G!). There are still some places free!/p pMore details about the training you can find here./p [...]

Do You Believe in the Future of Open Source Databases? Tell Us Your Views! (from Percona Database Performance Blog)

♦Complete the 2021 Open Source Data Management Software Survey to share your knowledge and experience, and help inform the open source database community. In 2020 we ran our second Open Source Data Management Software Survey. This resulted in some interesting data on the state of the open source database market.  Some key statistics: 41% of […] [...]

MySQL SQL Filters (from MacLochlainns Weblog)

An interesting outcome of teaching SQL is discovering what skills new users require. One that I continuously rediscover is how to build a test case for various elements of SQL. This is a small article on querying with filters in the WHERE clause. There are several of the exercises in Alan Beaulieu’s Learning SQL, 3rd […] [...]

Sunday, 03. October 2021

bpftrace as a code/function coverage tool for MariaDB server (from MySQL Entomologist (former?) Blog)

pI am going to speak about bpftrace again soon, this time at MariaDB Server Fest 2021. Among other useful applications of bpftrace I mention using it as a code coverage (or, more precisely, function coverage) tool to check if some test executes all/specific functions in MariaDB server source code. In this blog post I am going to present some related tests in more details./ppFor testing I use new en [...]

Friday, 01. October 2021

The other way to compress InnoDB: outsource it (from Small Datum)

pThere are at least three ways to do compression for InnoDB - classic, holepunch and outsource. /ppThe classic approach (table compression) was used and enhanced by the FB MySQL team. It might not have been widely used elsewhere. While it works, even for read/write workloads, the implementation is complicated and it isn't clear that it has a bright future./ppThe holepunch approach (p [...]

Have an Hour or So And Want To Learn MySQL? (from PHP With MySQL)

p Want to learn MySQL? Have an hour or so?  Go to Oracle's Learning Explorer and sign up for the FREE MySQL Explorer learning path.  It begins with an overview of MySQL, discusses the client/server model, and then leads you through the use of MySQL.  You do not need previous MySQL or database experience./p♦p/ppMySQL is the most-used opensource database and over the yea [...]

GCC vs Clang - with MariaDB on ARM (from MySQL On ARM)

It is a well-known fact that a good compiler can emit an optimal code thereby allowing software to produce better throughput. Clang compiler popularity continues to grow and since I am working mostly on performance issues I am often asked if I have tried MariaDB-on-Arm with clang compiled binaries. Finally, I got some time and decided to try it out. [...]

Thursday, 30. September 2021

Ignored Indexes (from MariaDB Corporation Blog)

In this blog, we use IGNORED indexes, a new feature in MariaDB Server 10.6, to test specific indexes for their utility and effect on query performance. [...]

Power Up Your Rails Apps with a NewSQL Database (from TiDB and TiKV Blog)

This post helps Ruby on Rails developers get started with TiDB and use it as the backend storage layer of Rails applications. [...]

Wednesday, 29. September 2021

Automating memory management in a DBMS (from Small Datum)

pI recently read two papers on automating memory management - one for DB2, one for Oracle. While the papers aren't new (~2005), they are definitely worth reading. AFAIK both made it into the products, I have no idea how that turned out but the outcome doesn't change my opinion that the papers were excellent. Disclaimer - I worked on query execution for Oracle at the time and made a few changes to t [...]

Percona Monthly Bug Report: September 2021 (from Percona Database Performance Blog)

♦Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open source form, report back on any issues or bugs […] [...]

Get Some REST With The New Tungsten API (from Continuent Blog)

pStandards allow modern systems to advance, and the REST specification is one very important example. /p pSince this post is about the Tungsten API in specific, let me simply say this - a RESTful API adheres to six principles: Client-server, stateless, cacheable, uniform interface, layered system and optionally code on demand. As part of the watchability/monitoring goal, our upcoming version 7.0.0 [...]

Tuesday, 28. September 2021

Developer experience, what about the other stakeholders? (from Small Datum)

pWhile developer experience gets a lot of press, there are four stakeholders when you provide a database service. So we can call these DX, UX, MX and OX for developer, user, management and operations experience:br/pullidevelopers want the DBMS to stay out of their way. Schema is one example because waiting for a schema change gets in the way. Note that NoSQL databases have less schema rather t [...]

Dave's Quiz 3 -- Change schemas (from PHP With MySQL)

p     This weeks quiz is a little different.  Many of you grew up with MySQL's sample world database but have not used the world_x database (see for details) and may be shocked to find that there is now a forth table to the database and some of the information is now stored in a JSON [...]

Horizontal Scaling in MySQL – Sharding Followup (from Percona Database Performance Blog)

♦In a previous post, A Horizontal Scalability Mindset for MySQL, I discussed the concerns around growing individual MySQL instances too large and some basic strategies: Optimizing/minimizing size with proper data types Removing unused/duplicate indexes Keeping your Primary Keys small Pruning data Finally, if those methods have been exhausted, I touched on horizontal sharding as the […] [...]

Percona Software Recognized with Product Awards (from Percona Database Performance Blog)

♦It’s been a while since Percona started to develop its own software products, but collecting reviews is a new experience for us. We started this activity about a year ago, and the results we got are stunning. Your reviews said more about us than we ever could imagine. From everyone at Percona, we’d like to […] [...]

Memory Management in RonDB (from Mikael Ronstrom)

p Most of the memory allocated in RonDB is handled by the global memory manager. Exceptions are architecture objects and some fixed size data structures. In this presentation we will focus on the parts handled by the global memory manager./ppIn the global memory manager we have 13 different memory regions as shown in the figure below:/p♦brpbr/pp- DataMemory/pp- DiskPageBufferCache/pp- RedoBuff [...]

10.7 feature preview: Miscellaneous features (from MariaDB Foundation Blog)

pThe “Misc features” preview includes all the other features that did not make it into a separate dedicated preview MariaDB Server 10.7 includes the JSON_EQUALS function, which compares inputs as JSON objects, regardless of whitespace, key order, or number format. … /p pContinue reading \"10.7 feature preview: Miscellaneous features\"/p pThe post 10.7 feature preview: Mi [...]

Best Practices for TiDB Load Balancing (from TiDB and TiKV Blog)

Load balancing helps you distribute application connections over multiple servers and reroute connections if a TiDB instance becomes unavailable. This article talks about the best practices for TiDB load balancing. [...]

Monday, 27. September 2021

10.7 preview feature: Password Reuse Check plugin (from MariaDB Foundation Blog)

pBy default, MariaDB does not check if a user reuses a password. Some security policies require users to choose a new password each time, and the Password Reuse Check plugin, available in a MariaDB 10.7.0 preview, enables this functionality. … /p pContinue reading \"10.7 preview feature: Password Reuse Check plugin\"/p pThe post 10.7 preview feature: Password Reuse Check plugin appeared first [...]

MySQL: Our MySQL in 2010, a hiring interview question (from Die wunderbare Welt von Isotopp)

pI ranted about hiring interviews, and the canned questions that people have to answer. One of the interviews we do is a systems design interview, where we want to see how (senior) people use components and patterns to design a system for reliability and scaleout./p pA sample question (based on a Twitter thread in German):/p blockquote pIt is 2010, and the company has a database structure where [...]

A Horizontal Scalability Mindset for MySQL (from Percona Database Performance Blog)

♦As a Technical Account Manager at Percona, I get to work with many of our largest clients. While the industry verticals vary, one main core challenge generally remains the same – what do I do with all this data? Dealing with massive data sets in MySQL isn’t a new challenge, but the best approach still […] [...]

Synopsis of Mydbops 9th 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 9th 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 9th edition of&# [...]

Friday, 24. September 2021

Automatic Memory Management in RonDB (from Mikael Ronstrom)

pRonDB has now grown up to the same level of memory management as you find in expensive commercial DBMSs like Oracle, IBM DB2 and Microsoft SQL Server./ppToday I made the last development steps in this large project. This project started with a prototype effort by Jonas Oreland already in 2013 after being discussed for a long time before that. After he left for Google the project was taken over by [...]

Replication Filters in MySQL an Overview (from Mydbops Blog)

What are Replication Filters in MySQL? A replication filter is used to filter out the necessary databases and tables that will be replicated in the replica. The replication filter can be set either in my. cnf or the command line. The change made in those databases will be logged in binary log files. The filter … Continue reading Replication Filters in MySQL an Overview → [...]

Thursday, 23. September 2021

10.7 preview feature: CONVERT PARTITION (from MariaDB Foundation Blog)

pIf you are using table partitioning, you have likely heard of the ALTER TABLE ... EXCHANGE PARTITION ... WITH TABLE ... command. It existed in MariaDB since forever. … /p pContinue reading \"10.7 preview feature: CONVERT PARTITION\"/p pThe post 10.7 preview feature: CONVERT PARTITION appeared first on [...]

10.7 preview feature: Python-like string formatting (from MariaDB Foundation Blog)

pSometimes there is a need to combine data from different columns into one string. For example,br This doesn’t look too bad, but can quickly get out of hand, if you need to do something more complex than that. … /p pContinue reading \"10.7 preview feature: Python-like string formatting\"/p pThe post 10.7 preview feature: Python-like string formatting appeared first on [...]

MySQL Upgrade Checker, Review the Report, Before you Upgrade. (from Select All From MySQL)

MySQL introduced the MySQL “Upgrade Checker” initially to support upgrades from MySQL 5.7 to 8.0 series. However, the continuous development initiative in the MySQL 8.0 release series has continued this tools usefulness as it can also report on continuous delivered features throughout the MySQL 8.0 release life. Additionally, “Yes”, bug fixes are always part of that developm [...]

Wednesday, 22. September 2021

Enhanced Password Management Systems in MySQL 8: Part 1 (from Percona Database Performance Blog)

♦MySQL 8 comes with a lot of good features, and recently I explored its password management systems. I wanted to put together a series of blogs about it, and this is the first part. In this post, I am going to explain the following topics in detail. Password Reuse Policy Random Password Generation Password Reuse […] [...]

Mydbops MyWebinar 9th 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 [...]

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

pIn some applications, data may never change. Yet, in others, data changes numerous times in its lifecycle. In SQL the UPDATE command changes existing rows of data. CodeIgniter 4 Models have 2 methods available for update operations: update() and save(). Continue reading and learn more about update()… CodeIgniter 4 CRUD Series with MySQL This post […]/p pThe post Medium Cross-post ̵ [...]

10.7 preview feature JSON Histograms (from MariaDB Foundation Blog)

pMariaDB has had support for histograms as part of Engine Independent Table Statistics since 10.0. As part of Google Summer of Code (MDEV-21130), Michael Okoko, together with his mentor Sergey Petrunia, have implemented a new format (using JSON) for histograms that significantly improves the accuracy and flexibility of histograms. … /p pContinue reading \"10.7 preview feature JSON Histograms\ [...]

Tuesday, 21. September 2021

Review of DiffKV (from Small Datum)

pThis is a review of Differentiated Key-Value Storage Management for Balanced I/O Performance that was published in ATC 2021. This is a wonderful paper that resolves several of my concerns about key-value separation (here and here). The authors have experience with key-value separation via Titan which is part of TiDB./ppThe key idea in the paper is to use leveled compaction for keys and tiered [...]

Geo-Distributed Oracle MySQL InnoDB Clusters (from Continuent Blog)

pOracle MySQL InnoDB Cluster provides high availability and scalability for MySQL. An InnoDB Cluster consists of 3 or more MySQL instances in a local network with group replication enabled, MySQL Shell which is used for management of the cluster, and optionally MySQL Router to provide basic routing from applications to the cluster. While this provides high availability in a local region or site, it [...]

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

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

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

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