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, 18. September 2020

MySQL: Encoding fields for great profit. (from Die wunderbare Welt von Isotopp)

pIterating schemas over time is not an uncommon thing. Often requirements emerge only after you have data, and then directed action is possible. Consequently, working on existing data, and structuring and cleaning it up is a common task./p pIn todays example we work with a log table that logged state transitions of things in freeform codeVARCHAR/code fields. After some time the log table grew quit [...]
Published Friday, 18. September 2020 15:39 • 11 hours ago

Recover Table Structure From InnoDB Dictionary (from TwinDB Blog)

When a table gets dropped, MySQL removes the respective .frm file. This post explains how to recover the table structure if the table was dropped. You need the table structure to recover a dropped table from the InnoDB tablespace. The B+tree structure of the InnoDB index doesn’t contain any information about field types. MySQL needs … pContinue reading "Recover Table Structure From InnoDB Dic [...]
Published Friday, 18. September 2020 15:34 • 11 hours ago

A Guide to MySQL Indexes (from SeveralNines Open Source Database Blog)

pWhen MySQL query optimization is mentioned, indexes are one of the first things that get covered. Today, we will try to see why they are so important./p What are Indexes? pIn general, an index is an alphabetical list of records with references to the pages on which they are mentioned. In MySQL, an index is a data structure used to quickly find rows. Indexes are also called keys and those keys ar [...]
Published Friday, 18. September 2020 15:24 • 12 hours ago

Watch The Replay: High Volume MySQL HA Use Case Webinar - SaaS Continuous Operations with Terabytes of Data (from Continuent Blog)

pYou can now watch the replay of our High Volume MySQL HA Use Case Webinar: SaaS Continuous Operations with Terabytes of Data; and learn how to guarantee continuous operations for a SaaS provider with billions of daily transaction and terabytes of data with Tungsten MySQL Clusters./p Tags: WebinarMySQLuse casetungsten clusteringmysql clustermarketoHigh Availabilitymysql haSaaS [...]
Published Friday, 18. September 2020 07:19 • 20 hours ago

Thursday, 17. September 2020

Orchestrator failure detection and recovery: New Beginnings (from PlanetScale Blog)

Shlomi Noach, author of orchestrator, a powerful MySQL high availability solution, discusses its integration into Vitess. [...]
Published Thursday, 17. September 2020 20:17 • a day ago

Performance results and DBMS experts (from Small Datum)

pI used to assume that many performance results couldn't be trusted because the people sharing the results lacked expertise in the system(s) under test. I am still wary of results in conference papers that have results for too many DBMS and my wariness is a function of the number of DBMS considered. /ppBut my opinion on this has changed. Now I prefer to focus on the results that the typical pe [...]
Published Thursday, 17. September 2020 19:20 • a day ago | Updated Thursday, 17. September 2020 19:20 • a day ago

Blog series: Consensus Algorithms at Scale - Part 2 (from PlanetScale Blog)

The Rules of Consensus [...]
Published Thursday, 17. September 2020 18:11 • a day ago

Blog series: Consensus Algorithms at Scale - Part 1 (from PlanetScale Blog)

Breaking down consensus algorithms: building a new set of rules and principles using a variety of more flexible algorithms and achieving objectives with Vitess. [...]
Published Thursday, 17. September 2020 18:11 • a day ago

Easily Achieve Continuous MySQL Operations In The AWS Cloud: Introducing the New Continuent Tungsten Cluster (AMI) (from Continuent Blog)

pContinuent is pleased to announce the availability of our new Tungsten Cluster (AMI) - the complete continuous operations solution for MySQL database clusters - on the AWS Marketplace./p Tags: tungsten clusterAWSamazon marketplacetungsten clusteringMySQLmysql high availabilitymysql disaster recoverygeo-clusteringGeo-Distributedmysql clusteraws cloudCloud [...]
Published Thursday, 17. September 2020 10:28 • a day ago

Auditing Selection of Classified Data Stored in MySQL 8.0 (from MySQL Server Blog)

The Challenge Often with sensitive information, you need to have an audit log. Not just that a table had a select run, but that specific cells within the table were accessed.  Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc.… [...]
Published Thursday, 17. September 2020 06:46 • 2 days ago

Wednesday, 16. September 2020

Percona Customer Portal and Your New, Free User Account (from Percona Database Performance Blog)

♦Google, Microsoft, and Apple have it. So do open source organizations like MongoDB, Red Hat, and SUSE. What do all these companies provide? A customer portal that enables anyone to create an identity with the company. To date, Percona hasn’t had a customer portal with a free user account –  but that’s about to change. […] [...]
Published Wednesday, 16. September 2020 14:25 • 3 days ago

Basic Data Analysis with MySQL Shell Python mode (from Digital Owl's Prose)

pI recently watched a fantastic Python Pandas library tutorial series on YouTube. Without a doubt, Pandas is great for all sorts of data stuff. On the same token, MySQL Shell in Python mode is quite powerful in the sense that Python and the MySQL Shell (version >= 8.0) are somewhat united in the same environment. […]/p pThe post Basic Data Analysis with MySQL Shell Python mode appeared fi [...]
Published Wednesday, 16. September 2020 11:00 • 3 days ago

Cost Performance Model (to evaluate MySQL on ARM) (from MySQL On ARM)

ARM processors are fast gaining popularity in the High Performance Computing (HPC) space with multiple cloud providers providing powerful and flexible variants of ARM instances to boot. Users are still in a dilemma about whether running MySQL on ARM is really effective? To help ease this out we introduce a Cost-Performance-Model (#cpm). Model is generic in nature to help normalize computing configu [...]
Published Wednesday, 16. September 2020 00:00 • 3 days ago

Tuesday, 15. September 2020

MySQL Master High Availability and Failover: more thoughts (from J-F Gagné's MySQL Blog)

Some months ago, Shlomi Noach published a series about Service Discovery.  In his posts, Shlomi describes many ways for an application to find the master.  He also gives detail on how these solutions cope with failing-over to a slave, including their integration with Orchestrator. This is a great series, and I recommend its reading for everybody implementing master failover, with or without [...]
Published Tuesday, 26. February 2019 06:00 • over a year ago | Updated Tuesday, 15. September 2020 19:24 • 3 days ago

Database Load Balancing: Distributed vs Centralized Setups (from SeveralNines Open Source Database Blog)

pA database load balancer, or database reverse proxy, distributes the incoming database workload across multiple database servers running behind it. The goals of having database load balancers are to provide a single database endpoint to applications to connect to, increase queries throughput, minimize latency, and maximize resource utilization of the database servers. /p pThere can be two ways of [...]
Published Tuesday, 15. September 2020 18:23 • 3 days ago

How To Inject an Empty XA Transaction in MySQL (from Percona Database Performance Blog)

♦If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction. [crayon-5f6574411f7ed296252711/] What Does it Mean? It means that replication has tried […] [...]
Published Tuesday, 15. September 2020 16:28 • 3 days ago

Benchmark: MariaDB vs MySQL on Commodity Cloud Hardware (from MariaDB Corporation Blog)

Relative performance benchmark of MariaDB vs MySQL on Amazon AWS EC2 and RDS. [...]
Published Tuesday, 15. September 2020 15:00 • 4 days ago

My MariaDB Playbook (from MariaDB Corporation Blog)

In celebration of National Online Learning Day, Rob Hedgpeth shares the top resources he relied on to learn about and get started with MariaDB. [...]
Published Tuesday, 15. September 2020 12:00 • 4 days ago

Testing MySQL Database Service without VPN – part 2 (from lefred's blog)

In a recent article, I explained how to test MySQL Database Service (aka MDS) on OCI without having to setup a VPN. A VPN is the recommended way and of course using some man-in-the-middle exposing the MySQL Classic and X Protocol port is something you should absolutely avoid ! So, in this article we will see another way to test ... Read More [...]
Published Tuesday, 15. September 2020 09:45 • 4 days ago

Simple shell script is bad idea (from TwinDB Blog)

Internet is full of simple shell backup scripts. Every DBA and system administrators (including myself) has written one. Bash is a bad tool for this job and in this post I will explain why. Let’s find out why the need to write anything arises at first place. There is a lot of great backup tools … pContinue reading "Simple shell script is bad idea"/p [...]
Published Tuesday, 15. September 2020 00:26 • 4 days ago

How We Build an HTAP Database That Simplifies Your Data Platform (from TiDB and TiKV Blog)

This post talks about why HTAP matters in a database platform, how TiDB implements HTAP, and how you can apply TiDB in different scenarios. [...]
Published Tuesday, 15. September 2020 00:00 • 4 days ago

Monday, 14. September 2020

Recovering A Corrupt MySQL Database (from TwinDB Blog)

Author Andriy Lysyuk. The unDROP for InnoDB tool can be used to recover corrupt MySQL databases. In this post, we will show how to repair a MySQL database if its files got corrupted and even innodb_force_recovery=6 doesn’t help. The corruption of InnoDB tablespace may be caused by many reasons. A dying hard drive can write … pContinue reading "Recovering A Corrupt MySQL Database"/p [...]
Published Monday, 14. September 2020 23:48 • 4 days ago

How to Upgrade to MySQL 8.0 – Free Course at Percona University Online (from Percona Database Performance Blog)

♦MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.0 advantages, so a lot of databases have been successfully upgraded to the new version. But many of […] [...]
Published Monday, 14. September 2020 14:11 • 5 days ago

How to Migrate On-premises MySQL Database to MySQL Database ServiceMDS ? (from MySQL Solutions - On Premises & Cloud)

Guide to Migrate Production MySQL Database running on On-premises to Oracle Cloud MySQL Database Service(MDS) ?pI have one production database which i would like to migrate into Oracle Cloud PaaS model i.e MySQL Database Service , we will walk through on how to migrate customerDB database from On-premises to Oracle Cloud MySQL Database Service(MDS)./ppNote:- Recommended is to have MySQL DB On-Premi [...]
Published Monday, 14. September 2020 10:03 • 5 days ago | Updated Monday, 14. September 2020 10:48 • 5 days ago

How to Launch MySQL Database Service ? (from MySQL Solutions - On Premises & Cloud)

p Launching Your First MySQL DB System/pp♦/pp/pStep 1 - Pre-requisitesp!--[if !supportLists]--1.    1.     Create a compartment and user group to organize the resources and access. In this example, we create a compartment named as codeMySQL_Sandbox/code, and a group MySQL_Test_Group. Log-in the Console as an Admini [...]
Published Monday, 14. September 2020 10:14 • 5 days ago | Updated Monday, 14. September 2020 10:14 • 5 days ago

How to access MDS by using MySQL Enterprise Workbench (from MySQL Solutions - On Premises & Cloud)

 Using MySQL Enterprise Workbench to write SQL statements against MDSpAssume that you wanted to access/write sql statements on MDS from MySQL Workbench Running on On-premises (Windows OS)/p pHow? Below are steps you needed to follow./p pTo connect with MySQL Workbench ,you require below details handy :-/p Prerequisite:- p!--[if !supportLists]--1.       !--[en [...]
Published Monday, 14. September 2020 10:08 • 5 days ago | Updated Monday, 14. September 2020 10:11 • 5 days ago

Sunday, 13. September 2020

Show Differences Found by pt-table-checksum (from TwinDB Blog)

First of all, pt-table-checksum is perfect for checking if the master and its slaves are in-sync. It answers the question “Are the slaves consistent with the master?”. However, if they’re not, pt-table-checksum doesn’t actually tell you what exactly is wrong. master# pt-table-checksum -q TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE 09-03T22:21:10 0 1 2 1 0 … pContinue reading "Sho [...]
Published Sunday, 13. September 2020 22:35 • 5 days ago

ProxySQL participando en ESLibre 2020 (from ProxySQL Blog)

pProxySQL participará en la próxima edición del evento open source “ESLIBRE”, que tendrá lugar los días 18th & 19th de Septiembre. La fecha coincidirá con el “Software Freedom Day”, día que celebra el Free Software en el mundo entero. El desarrollador senior de ProxySQL, Javier Jaramago Fernández, expondrá “Introducción a ProxySQL”, haciendo hincapié en [...]/p pThe post ProxySQL participando e [...]
Published Sunday, 13. September 2020 20:09 • 5 days ago

ProxySQL Speaking at EsLibre 2020 (from ProxySQL Blog)

pProxySQL will be taking part in the upcoming EsLibre, open source event on the 18th & 19th of September. The date also coincides with ‘Software Freedom Day’ which celebrates Free Software, all over the world. ProxySQL’s Senior Developer, Javier Jaramango Fernandez, will be discussing ‘Introduction to ProxySQL’, focusing on the importance of limiting downtime [...]/p pThe post ProxySQL Speaking [...]
Published Sunday, 13. September 2020 18:41 • 5 days ago

Efficient Use Of Indexes In MySQL (from TwinDB Blog)

These are the slides of the “Efficient Use Of Indexes In MySQL” talk we delivered on the SFMySQL Meetup. This is an introductory talk for developers on MySQL indexes. In my opinion, it’s quite important to understand how InnoDB organizes data. If you know how MySQL accesses data, it’s easier to write optimal queries. When working … pContinue reading "Efficient Use Of Indexes In MySQL"/p [...]
Published Sunday, 13. September 2020 17:41 • 5 days ago

BCC Tools for disk I/O Analysis and More (from MySQL Entomologist (former?) Blog)

pA lot of time passed since I had written about bcc tools in my dynamic tracing series. That post was mostly about building bcc tools from GitHub source on Ubuntu 16.04 and using trace utility to add dynamic probe to MariaDB server. Other that that I had presented tplist and mysql_qslower with a couple of slides at several events, but that's all. There are many more tools useful for DBAs in the bun [...]
Published Sunday, 13. September 2020 15:25 • 5 days ago | Updated Sunday, 13. September 2020 15:25 • 5 days ago

Dockerizing MySQL step by step. (from Mydbops Blog)

As a Database Engineer in Mydbops. We tend to solve multiple complex problems for our esteemed customers. To control the System resources and scale up /down based on needed we are evaluating Dockers and Kubernetes. Docker is a set of platform as a service products that uses OS-level virtualization to deliver software in packages called … Continue reading Dockerizing MySQL step by step. & [...]
Published Sunday, 13. September 2020 07:52 • 6 days ago

Saturday, 12. September 2020

InnoDB Dictionary (from TwinDB Blog)

Why Does InnoDB Need A Dictionary An InnoDB dictionary is a set of internal tables InnoDB uses to maintain various information about user tables. It serves as API between a human and the database. While the humans refer to tables by their names, InnoDB works with integer identifiers. The dictionary stores correspondence between table name … pContinue reading "InnoDB Dictionary"/p [...]
Published Saturday, 12. September 2020 21:23 • 6 days ago

Change read more symbol in WordPress (from Geeky Hacker - Coding, Tech & Linux)

pRead more symbol is shown at the end of each post excerpt on WordPress. Of course, this is the case if you configure your WordPress instance to show post excerpts [...]/p pThe post Change read more symbol in WordPress appeared first on Geeky Hacker./p [...]
Published Saturday, 12. September 2020 16:30 • 6 days ago

Friday, 11. September 2020

Data Consistency for RDS for MySQL: The 8.0 Version (from Percona Database Performance Blog)

♦In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency. Starting with 8.0.1, MySQL introduced something called “Dynamic Privileges” which is a solution to grant […] [...]
Published Friday, 11. September 2020 16:11 • 7 days ago

How Much Memory Does the Process Really Take on Linux? (from Percona Database Performance Blog)

♦One of the questions you often will be faced with operating a Linux-based system is managing memory budget. If a program uses more memory than available you may get swapping to happen, oftentimes with a terrible performance impact, or have Out of Memory (OOM) Killer activated, killing process altogether. Before adjusting memory usage, either by […] [...]
Published Friday, 11. September 2020 14:36 • 8 days ago

Watch The Replay: Geo-Scale MySQL Use Case Webinar - Guaranteed Global Game Access for Hundreds of Millions of Players Worldwide (from Continuent Blog)

pWatch the replay of our Geo-Scale MySQL webinar: Guaranteed Global Game Access for Hundreds of Millions of Players Worldwide - Cloud-Based Active/Passive Tungsten MySQL Clusters @ Riot Games./p Tags: WebinarMySQLuse casetungsten clusteringmysql clustergeo-scalegeo-distributed MySQLRiot Gamesactive/passive MySQL [...]
Published Friday, 11. September 2020 07:05 • 8 days ago

Thursday, 10. September 2020

A GSoC internship with the MariaDB Foundation (from MariaDB Foundation Blog)

pIntroductionbr Hi, my name is Kartik Soneji, and I am a second year student at Thadomal Shahani Engineering College, Mumbai. I have been programming since the age of 13. […]/p pThe post A GSoC internship with the MariaDB Foundation appeared first on MariaDB.org./p [...]
Published Thursday, 10. September 2020 16:41 • 8 days ago

Wednesday, 09. September 2020

Testing MySQL Database Service without VPN (from lefred's blog)

Please note that this is not recommended for any production purpose, don’t expose MySQL traffic to the Internet ! MySQL Database Service is now available, take a look at this nice introduction video: It is usually a very bad idea to expose a database on a public IP (MySQL or any other database 😉 ). MDS doesn’t allow you to ... Read More [...]
Published Wednesday, 09. September 2020 18:40 • 9 days ago

Correlated Updates (from MacLochlainns Weblog)

It’s always interesting when I answer questions. This question was how to you perform a correlated UPDATE statement. My answer was assuming you’re updating the rating_id foreign key column in the rating table with the value from an item_rating column in the item table where on or another column value in the rating table match […] [...]
Published Wednesday, 09. September 2020 18:24 • 9 days ago

Feeds tagged, and a MySQL feed (from Die wunderbare Welt von Isotopp)

pI have made changes to the RSS Feed of this blog:/p ol liEach code<item/>/code does now contain a container code<tags/>/code, inside a sequence of code<tag/>/code containers, with each posts tags./li liThere is now a second RSS feed for posts tagged code#mysql/code, because of demand. You can find it at blog.koehntopp.info/feed_mysql.xml./li /ol pExample for the tags:/p pr [...]
Published Wednesday, 09. September 2020 15:34 • 9 days ago

MySQL 5.6 End of Life Is Less Than Six Months Away (from PHP With MySQL)

p     If you are running MySQL 5.6 please note that it will hit support End of Life status in February 2021!  MySQL 5.7 has been Generally Available for almost five years and MySQL 8.0 has been out for over two  years.   You need to upgrade as soon as possible.  /p♦p/pp    Upgrading to 5.7 is pretty easy. And I heartily suggest that a [...]
Published Wednesday, 09. September 2020 15:30 • 9 days ago | Updated Wednesday, 09. September 2020 15:30 • 9 days ago

MySQL DROP statement using phpMyAdmin (from Digital Owl's Prose)

pThe MySQL DROP statement is one of many powerful DDL commands. Be it ALTER TABLE some_table DROP some_column or DROP some_table, this type of command can drastically change your data landscape because in executing MySQL DROP, you are completely removing objects from the database! If you are using the phpMyAdmin web interface, you can execute […]/p pThe post MySQL DROP statement using phpMyAd [...]
Published Wednesday, 09. September 2020 11:00 • 10 days ago

WarpSQL BETA 2 based on 8.0.21 now available for testing (from WarpSQL Blog)

I have been working very hard on WarpSQL beta 2, since announcing the first beta in July. It has been just over 60 days since beta 1 was released, and beta 2 has a whole slew of improvements and bug fixes, and a few things were removed that will be added back into later releases.Continue reading "WarpSQL BETA 2 based on 8.0.21 now available for testing" [...]
Published Wednesday, 09. September 2020 04:00 • 10 days ago

Tuesday, 08. September 2020

Scaling up or scaling down Azure Database for MySQL for cost optimization (from Serge Frezefond's blog)

In the previous test we looked at what happened when we scaleup an Azure Database for MySQL server to sustain an heavy workload. We saw that the service interruption was minimal. Azure Database for MySQL being a fully managed DBaaS being able to scale up the service only when required by the workload is a ...continue reading "Scaling up or scaling down Azure Database for MySQL for cost optimizatio [...]
Published Tuesday, 08. September 2020 17:53 • 10 days ago

Checking Data Consistency for RDS for MySQL (from Percona Database Performance Blog)

♦MySQL for RDS and DBaaS, in general, are very controlled environments by the vendors, meaning that there are missing things like a SUPER grant for the root user (and any user in general). This has some implications on operations, one of them being the impossibility of running pt-table-checksum to verify data consistency between a primary […] [...]
Published Tuesday, 08. September 2020 16:07 • 10 days ago

Releasing ProxySQL 2.0.14 (from ProxySQL Blog)

pProxySQL is proud to announce the release of the latest stable version of ProxySQL 2.0.14 on the 8th of September 2020 ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, and freely usable [...]/p pThe post Releasing ProxySQL 2.0.14 appeared first on ProxySQL./p [...]
Published Tuesday, 08. September 2020 13:14 • 11 days ago

Announcing HTAP support in TiDB Cloud (from TiDB and TiKV Blog)

Today, we're glad to announce that TiDB Cloud, our fully managed database service powered by TiDB, now supports Hybrid Transactional/Analytical Processing (HTAP) workloads. [...]
Published Tuesday, 08. September 2020 00:00 • 11 days ago

Monday, 07. September 2020

MySQL: Generated Columns and virtual indexes (from Die wunderbare Welt von Isotopp)

pWe have had a look at how MySQL 8 handles JSON recently, but with all those JSON functions and expressions it is clear that many JSON accesses cannot be fast. To grab data from a JSON column, you will use a lot of code$->>field/code expressions and similar, and without indexes nothing of this will be fast./p pJSON cannot be indexed./p pBut MySQL 8 offers another feature that comes in handy [...]
Published Monday, 07. September 2020 16:52 • 11 days ago

Azure Database for MySQL failover impact on availability (from Serge Frezefond's blog)

In that test I would like to measure the impact of a failover of an Azure Database for MySQL. Unfortunately there is no mechanism to force the crash of the Azure Database for MySQL instance. So how can I test how long it takes to failover and what is the impact on a server activity. ...continue reading "Azure Database for MySQL failover impact on availability" [...]
Published Monday, 07. September 2020 15:06 • 11 days ago

Google Summer of Code Refactor PMM Framework Project with Percona (from Percona Community Blog)

pI am Meet Patel, 2nd year undergraduate at DAIICT, Gandhinagar, India; pursuing a bachelor’s degree in Information and Communication Technology with a minor in Computational Science. I am proud to be selected for the Google Summer of Code program under an open source organization as big and impactful as Percona. As we head towards the […]/p pThe post Google Summer of Code Refactor PMM Framew [...]
Published Monday, 07. September 2020 11:08 • 12 days ago

Scaling Out the Moodle Database (from SeveralNines Open Source Database Blog)

pMoodle is a very popular platform to run online courses. With the situation we see in 2020, Moodle, along with communicators like Zoom forms the backbone of the services that allow online learning and stay-at-home education. The demand put on Moodle platforms significantly increased compared to previous years. New platforms have been built, additional load has been put on the platforms that, histo [...]
Published Monday, 07. September 2020 09:45 • 12 days ago

Author on Oracle MySQL Blog (from lefred's blog)

You may have noticed, I started to blog also on the official Oracle MySQL Blog. When I will do so, I will also publish my articles on lefred.be after a short delay. I really invite you to follow the official Oracle MySQL Blog where you will find information related to MySQL Community but also about our webinars. Currently, we put ... Read More [...]
Published Monday, 07. September 2020 09:40 • 12 days ago

MySQL from a Developers Perspective (from Die wunderbare Welt von Isotopp)

pSo this has turned into a small series, explaining how to work with MYSQL from a developers perspective. This post is intended as a directory for the individual articles. It will be amended and re-dated as necessary./p pThe code for the series is also available in isotopp/mysql-dev-examples on GitHub./p pThe Tag #mysqldev will reference all articles from this series./p ul li pMySQL Transa [...]
Published Monday, 07. September 2020 07:18 • 12 days ago

Sunday, 06. September 2020

Updates for the insert benchmark (from Small Datum)

I continue to run and improve the insert benchmark. Eventually I will even share results. I also have scripts that generate charts, graphs and tables all combined into an HTML-formatted report. This is an update to the overview of the insert benchmark and details on how I share performance results is here.brbrPer interval resultsbrbrThe first change is that the benchmark client displays per-se [...]
Published Monday, 13. July 2020 18:23 • 2 months ago | Updated Sunday, 06. September 2020 23:33 • 12 days ago

Percona MongoDB incremental backup and PITR feature (from The Fellowship Of Data)

pPercona released Percona Backup MongoDB version 1.3.1 and it brings a feature that was hugely expected by the community. It’s the ability to perform consistent incremental backups. This allows us .../p pThe post Percona MongoDB incremental backup and PITR feature appeared first on The Fellowship Of Data./p [...]
Published Sunday, 06. September 2020 00:02 • 13 days ago

Saturday, 05. September 2020

How to remove smiley from the bottom of a WordPress (from Geeky Hacker - Coding, Tech & Linux)

pIf you use WordPress with Jetpack, you may notice a little smiley icon after the footer on the bottom of your WordPress. This smiley is pretty harmless, yet can be [...]/p pThe post How to remove smiley from the bottom of a WordPress appeared first on Geeky Hacker./p [...]
Published Saturday, 05. September 2020 19:58 • 13 days ago

Friday, 04. September 2020

When is it OK to lose a commit? (from Small Datum)

pI am thrilled that OSS DBMS are better at avoiding the loss of commits thanks to replication that can do more than async. But there are good reasons for some workloads to not pay the cost (in latency) from such features.brbrBy losing a commit here I mean the loss of the most recent N commits, not the lost of any commit from the past. By workload I mean one of the applications using the DBMS and th [...]
Published Friday, 04. September 2020 14:42 • 15 days ago | Updated Friday, 04. September 2020 20:26 • 14 days ago

Watch The MySQL HA/DR Webinar Replay: Online Shop Guarantees Store Access With Multi-Site Active/Active Clusters (from Continuent Blog)

pWatch the replay of this use case webinar to learn about the high availability & disaster recovery challenges companies face when managing single sign-on, large-scale e-commerce portals; and/or sign up for one of our other upcoming use case webinars in this series./p Tags: WebinarMySQLuse casetungsten clusteringmysql clustermysql hamysql high availabilityglobal mysqlmulti-region awsSaaSec [...]
Published Friday, 04. September 2020 10:26 • 15 days ago

Two weeks to MariaDB Server Fest (from Percona Community Blog)

pThere is still time to register for the MariaDB Server Fest 2020! Our Fest is the opportunity to have live interactions with the key players on MariaDB Server: the developers of MariaDB Server, the service providers, the experts, the system integrators, and – perhaps most importantly – your fellow users! Interactivity happens all the time, […]/p pThe post Two weeks to MariaDB Server Fest app [...]
Published Friday, 04. September 2020 09:34 • 15 days ago

InnoDB Data Locking – Part 1 “Introduction” (from MySQL Server Blog)

pIn this blog series, I’d like to introduce you gently to the topic on which I was working last 2 years, which is improving how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, while in reality there is a lot of concurrency.…/p [...]
Published Friday, 04. September 2020 05:17 • 15 days ago

How to Migrate Data from Amazon Aurora MySQL to TiDB Cloud (from TiDB and TiKV Blog)

This post introduces how to smoothly migrate data from Amazon Aurora MySQL to TiDB Cloud using Dumpling and TiDB Lightning. [...]
Published Friday, 04. September 2020 00:00 • 15 days ago

Thursday, 03. September 2020

MySQL: Basic usage of the JSON data type (from Die wunderbare Welt von Isotopp)

pMySQL 8 provides solid support for the JSON data type. The manual has an overview of the data type, a JSON function reference, an an overview on generated column indexes, and explains multi-values indexes./p Creating JSON columns pCreating JSON columns is easy: Make the column of the JSON data type, fill in valid JSON data./p precodemysql> create table t ( id integer not null primary key aut [...]
Published Thursday, 03. September 2020 20:57 • 15 days ago

IoT Performance Bottlenecks & Open Source Databases (from Percona Community Blog)

pThe Internet of Things (IoT), in essence, is all about everyday devices that are readable, recognizable, trackable, and/or controllable via the Internet, regardless of the communication means — RFID, wireless LAN, and so on.  The total installed base of IoT connected devices is projected to amount to 21.5 billion units worldwide by 2025. Thanks to […]/p pThe post IoT Performance Bottlenecks [...]
Published Thursday, 03. September 2020 17:35 • 15 days ago

MinervaDB Database Platforms Virtual Conference 2020: Call For Papers (from MinervaDB Blog)

pMinervaDB Database Platforms Virtual Conference 2020: Call For Papers Friday, 11 December 2020 (09:00 AM PST to 07:00 PM PST) We are super excited to announce the Call for Papers for MinervaDB Database Platforms Virtual Conference [...]/p pThe post MinervaDB Database Platforms Virtual Conference 2020: Call For Papers appeared first on The WebScale Database Infrastructure Operations Experts./p [...]
Published Thursday, 03. September 2020 16:16 • 15 days ago

Beijing and Singapore MariaDB Server Fests (from MariaDB Foundation Blog)

pMariaDB Server Fest is coming to Asia Pacific! Beijing and Singapore are the two symbols for the timezones, much like Paris for the Server Fest in Europe, Middle East and Africa, and New York for the Server Fest in the Americas. […]/p pThe post Beijing and Singapore MariaDB Server Fests appeared first on MariaDB.org./p [...]
Published Thursday, 03. September 2020 08:42 • 16 days ago

ProxySQL Query Rules: Notes From Production (from Pythian Blog - MySQL Track)

After spending four years working with ProxySQL in production, I’ve learned a few interesting lessons about interpreting and processing query rules. I hope to save you some time (and avoid wrong turns) with this summary of ProxySQL query rules. ProxySQL... [...]
Published Thursday, 03. September 2020 00:04 • 16 days ago

Wednesday, 02. September 2020

Lift and Shift to MariaDB SkySQL (from MariaDB Corporation Blog)

Follow these simple steps to migrate from an on-prem MariaDB Server deployment to MariaDB's cloud database, SkySQL. [...]
Published Wednesday, 02. September 2020 18:12 • 16 days ago

Building a Highly Available Database for Moodle Using MySQL Replication (from SeveralNines Open Source Database Blog)

pMoodle is an open source learning management system, widely used by schools and universities around the world. The project started in 2002 by Martin Dougiamas, with the aim to provide learners, teachers, educators a secure, robust, open and free platform for learning environments./p pThe software itself  is written in PHP, and supports various RDBMS, such as: Oracle, MySQL, PostgreSQL, MariaDB, e [...]
Published Wednesday, 02. September 2020 17:05 • 16 days ago

MinervaDB Database Platforms Virtual Conference 2020 (from MinervaDB Blog)

pMinervaDB Database Platforms Virtual Conference 2020 Friday, 11 December 2020 (09:00 AM PST to 07:00 PM PST) MinervaDB is excited to announce an full-stack Open Source Database Systems Conference – MinervaDB Database Platforms Virtual Conference [...]/p pThe post MinervaDB Database Platforms Virtual Conference 2020 appeared first on The WebScale Database Infrastructure Operations Experts./p [...]
Published Wednesday, 02. September 2020 16:36 • 16 days ago

MySQL Shell Python mode blog posts compilation (from Digital Owl's Prose)

pOver the last few months, I have written numerous blog posts on different features of the MySQL Shell ranging from basic CRUD to aggregate functions and DDL. As a part of the MySQL version 8 release, MySQL Shell is a powerful and alternative environment that you can manage and work with your data in using […]/p pThe post MySQL Shell Python mode blog posts compilation appeared first on Digita [...]
Published Wednesday, 02. September 2020 11:00 • 17 days ago

On joining PlanetScale and the vision of open source database infrastructure (from PlanetScale Blog)

Shlomi Noach on why he joined PlanetScale to work on Vitess and PlanetScaleDB, and what he perceives Vitess can become in the MySQL open source ecosystem. [...]
Published Wednesday, 02. September 2020 04:30 • 17 days ago

Celebrate TiKV Graduation within CNCF (from TiDB and TiKV Blog)

The Cloud Native Computing Foundation (CNCF) today just announced that TiKV has become the twelfth project to graduate, joining other graduated projects such as Kubernetes, Jaeger, Harbor, etc. [...]
Published Wednesday, 02. September 2020 00:00 • 17 days ago

Tuesday, 01. September 2020

Building a Highly Available Database for Moodle Using MariaDB (Replication & MariaDB Cluster) (from SeveralNines Open Source Database Blog)

pFace-to-face meetings, nowadays, are limited to the bare minimum, online activities have taken over as the main way for teacher - student interaction. It increased the stress on the existing online “meeting” platforms (is there anyone who does not know what Zoom is nowadays?) but also on online learning platforms. The high availability of the online tools is more important than ever and the operat [...]
Published Tuesday, 01. September 2020 19:14 • 17 days ago

How to do selective schema Restore Using “Load Dump” Features Introduced in MySQL 8.0.21 ? (from MySQL Solutions - On Premises & Cloud)

 How to do selective schema Restore Using “Load Dump” Features Introduced in MySQL 8.0.21 ?pIn this Blog I will cover below topic:-/p p!--[if !supportLists]--1.      What is Dump Load features all about./p p!--[if !supportLists]--2.      How to take Restore particular database from Complete Backup?/p p!--[if !supportLists]--3.     [...]
Published Tuesday, 01. September 2020 15:31 • 17 days ago | Updated Tuesday, 01. September 2020 15:31 • 17 days ago

How to take MySQL Enterprise Edition backup using Instance Dump Features Introduced in MySQL 8.0.21? (from MySQL Solutions - On Premises & Cloud)

 Using Instance Dump and Schema Dump features introduced in MySQL 8.0.21 Version.pIn this Blog I will cover below topic:-/p p!--[if !supportLists]--1.       !--[endif]--What is Instance Dump/Schema Dump features all about?/p p!--[if !supportLists]--2.       !--[endif]--What are advantage?/p p!--[if !supportLists]--3.    [...]
Published Tuesday, 01. September 2020 15:16 • 17 days ago | Updated Tuesday, 01. September 2020 15:16 • 17 days ago

Streaming backups in parallel using tee (from DBA Dojo)

So you need to build a new set of databases, perhaps in a new location or geographical zone. Management wants it done yesterday cause the newly updated service hit the front page of reddit and your website and its back-end … Continue reading → [...]
Published Tuesday, 01. September 2020 14:15 • 18 days ago

Monday, 31. August 2020

Three Bad MySQL Query Types You May Be Writing (from PHP With MySQL)

p    One of the problems with Structured Query Language as opposed to languages like C++, Java, Python, or PHP is that it is hard to tell if a query is good or bad just by looking at it.  A programmer with a few months of coding experience can be shown a snippet of code from a project and have a pretty good chance of telling if that code is good or not.  Some call this a 'c [...]
Published Monday, 31. August 2020 18:01 • 18 days ago | Updated Monday, 31. August 2020 18:01 • 18 days ago

How to Migrate On-premises MySQL Enterprise Database to OCI Compute Instance MySQL Enterprise Database ? (from MySQL Solutions - On Premises & Cloud)

pMigrating On-premises MySQL Enterprise Database to OCI Compute Instance MySQL Enterprise Database ?/ppIn this post , we will walk through steps needed to migrate particular database(example - Sales database) from local Instance(On-premises) to Oracle Cloud Infrastructure Compute Instance./pWe will use two new features introduced with latest release of MySQL 8.0.21.p!--[if !supportLists]--1. & [...]
Published Monday, 31. August 2020 16:40 • 18 days ago | Updated Monday, 31. August 2020 16:52 • 18 days ago

Percona Monthly Bug Report: August 2020 (from Percona Database Performance Blog)

♦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 you might encounter […] [...]
Published Monday, 31. August 2020 13:23 • 19 days ago

How To Ask For Help and How To Help (from The Fellowship Of Data)

pWe as homo sapiens own our great success as a specie due to our capacity of collaboration in a group rather than being individualists. For example, a simple pencil requires .../p pThe post How To Ask For Help and How To Help appeared first on The Fellowship Of Data./p [...]
Published Monday, 31. August 2020 02:13 • 19 days ago

PingCAPers Make Their Debut at VLDB (from TiDB and TiKV Blog)

The 46th VLDB conference will be broadcast online from August 31st to September 4th. PingCAP is honored to attend this conference, and we will share two papers with you TiDB: A Raft-based HTAP Database and Interleaved Multi-Vectorizing. [...]
Published Monday, 31. August 2020 00:00 • 19 days ago

Saturday, 29. August 2020

Integrating MariaDB Audit plugin in MySQL 5.7 (from Mydbops Blog)

Basically, Auditing is the process of monitoring and recording the activity happening inside the Server. MariaDB Audit Plugin works with MariaDB, MySQL and Percona Servers. It is used to log the database Operations like, SQL Statements, User informations, Connections. The information is stored in a user defined log file or in Syslog. Available audit plugins … Continue reading Integrating Mari [...]
Published Saturday, 29. August 2020 21:55 • 20 days ago

MongoDB Transaction a walk through (from Mydbops Blog)

In this blog I will walk through the Transaction in MongoDB. It’s quite an interesting topic to discuss, nowadays most of the NoSQL technology adopting transactions in their database system and MongoDB also not an exception in this. The WiredTiger storage engine plays a very vital role in accomplishing the transaction in MongoDB. The interesting … Continue reading MongoDB Transaction a [...]
Published Saturday, 29. August 2020 21:07 • 20 days ago

Friday, 28. August 2020

ProxySQL Binary Search Solution for Rules (from Percona Database Performance Blog)

♦We sometimes receive challenging requests… this is a story about one of those times. The customer has implemented a sharding solution and would like us to review alternatives or improvements. We analyzed the possibility of using ProxySQL as it looked to be a simple implementation. However, as we had 200 shards we had to implement […] [...]
Published Friday, 28. August 2020 16:05 • 21 days ago

Dropping database objects in a safe way (from Vettabase)

pRunning DROP statements in production is always dangerous. But there are some measures we can take to make them safer. Continue reading Dropping database objects in a safe way→/p pThe post Dropping database objects in a safe way appeared first on Vettabase./p [...]
Published Friday, 28. August 2020 15:24 • 21 days ago

ProxySQL Overhead — Explained and Measured (from Percona Database Performance Blog)

♦ProxySQL brings a lot of value to your MySQL infrastructures such as Caching or Connection Multiplexing but it does not come free — your database needs to go through additional processing traffic which adds some overhead. In this blog post, we’re going to discuss where this overhead comes from and measure such overhead.  Types of […] [...]
Published Friday, 28. August 2020 15:06 • 21 days ago

Watch The Replay: SaaS Cloud Contact Center Secures Continuous Operations in Multi-Region AWS (from Continuent Blog)

pwww.continuent.com/resources/webinars/global-mysql-availability-saas-cloud-contact-center-secures-continuous-operationsWatch the replay of this webinar with Eero Teerikorpi, CEO at Continuent, for a walk-through (including a live demo) of how the Continuent Team helped Vonage build a multi-region active/active MySQL Tungsten Cluster in AWS Cloud serving a global high-volume Cloud Contact Center./p [...]
Published Friday, 28. August 2020 10:51 • 22 days ago

PingCAP Successfully Completes SOC 2 Type 1 Examination for TiDB Cloud (from TiDB and TiKV Blog)

PingCAP, provider of the cloud-native hybrid transactional/analytical processing (HTAP) TiDB database, successfully completes an SOC 2 Type 1 examination for TiDB Cloud. [...]
Published Friday, 28. August 2020 00:00 • 22 days ago

Thursday, 27. August 2020

Learn Horizontal Scaling on PlanetScaleDB with Vitess — Rate Puppies in a Rust app with Sharded MySQL Database (from PlanetScale Blog)

PlanetScaleDB is a sharded database built on Vitess. Learn key sharding concepts and apply them using our quickstart demo and sample app for rating puppies written in Rust. [...]
Published Thursday, 27. August 2020 22:42 • 22 days ago

Demo: Multi-Cloud on PlanetScaleDB (from PlanetScale Blog)

Software engineer Abhi Vaidyanatha walks us through a live deployment of a true multi-cloud Vitess cluster on PlanetScaleDB [...]
Published Thursday, 27. August 2020 21:08 • 22 days ago

More on Checkpoints in InnoDB MySQL 8 (from Percona Database Performance Blog)

♦Recently I posted about checkpointing in MySQL, where MySQL showed interesting “wave” behavior. Soon after Dimitri posted a solution with how to fix “waves,” and I would like to dig a little more into proposed suggestions, as there are some materials to process. This post will be very heavy on InnoDB configuration, so let’s start […] [...]
Published Thursday, 27. August 2020 19:31 • 22 days ago

MySQL 8.0 joins Google Cloud SQL (from gabi.dev)

Today we are making available MySQL 8.0 on Cloud SQL. It’s not just a new version inside our managed databases portfolio, but it also comes with all Cloud SQL capabilities such as Automatic Storage Increase, High Availability, Cross-region Replication and PITR (point in time recovery). And best yet: It’s not a beta, it’s a GA launch! See the announcement. [...]
Published Thursday, 27. August 2020 16:48 • 22 days ago

MySQL 8.0.19 InnoDB ReplicaSet Configuration and Manual Switchover (from Percona Database Performance Blog)

♦InnoDB ReplicaSet was introduced from MySQL 8.0.19. It works based on the MySQL asynchronous replication. Generally, InnoDB ReplicaSet does not provide high availability on its own like InnoDB Cluster, because with InnoDB ReplicaSet we need to perform the manual failover. AdminAPI includes the support for the InnoDB ReplicaSet. We can operate the InnoDB ReplicaSet using […] [...]
Published Thursday, 27. August 2020 14:00 • 23 days ago

MySQL 8.0.21 New Features Summary (from MySQL expert Diary)

pPresentation of some of the new features of MySQL 8.0.21 released on July 13th, 2020./p pThe post MySQL 8.0.21 New Features Summary first appeared on dasini.net - Diary of a MySQL expert./p [...]
Published Thursday, 27. August 2020 09:05 • 23 days ago

Adding Your RDS Fleet to PMM2 Using the API (from Pythian Blog - MySQL Track)

PMM (Percona Monitoring and Management) is a great community tool for monitoring your OSDB (MySQL, PostgreSQL, MongoDB) fleet. It’s feature rich, and it’s built and distributed as open-source based on several de-facto industry standard tools such as Grafana and Prometheus.... [...]
Published Thursday, 27. August 2020 05:00 • 23 days ago

Wednesday, 26. August 2020

Creating an External Replica of AWS Aurora MySQL with Mydumper (from Percona Database Performance Blog)

♦Oftentimes, we need to replicate between Amazon Aurora and an external MySQL server. The idea is to start by taking a point-in-time copy of the dataset. Next, we can configure MySQL replication to roll it forward and keep the data up-to-date. This process is documented by Amazon, however, it relies on the mysqldump method to […] [...]
Published Wednesday, 26. August 2020 18:31 • 23 days ago

Better VIEWs with the WITH CHECK OPTION (from PHP With MySQL)

p     VIEWs have been a handy feature of MySQL for many years but do you know about the WITH CHECK OPTION clause?  The WITH CHECK OPTION clause is used for a updatable views to prohibit the changes to those views that would produce rows which are not included in the defining query./p    VIEW Definition    Since a lot of SQL novices read my blog, I'd [...]
Published Wednesday, 26. August 2020 17:51 • 23 days ago | Updated Wednesday, 26. August 2020 17:51 • 23 days ago

PHP PDO lastInsertId() method with examples in MySQL (from Digital Owl's Prose)

pMySQL has an AUTO_INCREMENT column attribute which automatically generates a consistent integer value upon a successful (or not) INSERT. Oftentimes, this attribute is set on a column deemed the PRIMARY KEY. Therefore, providing a unique value for the column and ensuring each rows’ individual identity. The LAST_INSERT_ID() function returns the most recently generated value for [… [...]
Published Wednesday, 26. August 2020 11:00 • 24 days ago

Streaming backups in parallel using pssh (from DBA Dojo)

So you need to build a new set of databases, perhaps in a new location or geographical zone and the business wants it done yesterday cause the newly launched product hit the front page of hacker news and your website … Continue reading → [...]
Published Wednesday, 26. August 2020 08:33 • 24 days ago