Author: MySQL Planet

Feed: Planet MySQL; Author: Daniel Nichter; Chapter 5 May 20, 2022 Chapter 5 of Efficient MySQL Performance addresses sharding, and it was difficult to write but not for technical reasons. Let me say a little more on the matter. This blog post is the sixth of eleven: one for the preface and ten for each chapter of my book Efficient MySQL Performance. The full list is tags/efficient-mysql-performance. But First: Fipar Says… Here’s a paragraph and footnote that I removed from chapter 5: However, scaling out is not intrinsic relational data stores. The reason is historical: the relational data model was ... Read More

Feed: Planet MySQL; Author: Codership; The Galera Cluster Enterprise Edition Codership is pleased to announce Galera Cluster Enterprise Edition. Galera Cluster Enterprise Edition consists of an enhanced GaleraCluster server, Galera Manager and Galera Load Balancer. The enhanced Galera Cluster Server includes 1) A new Online Schema Upgrade method called Non Blocking Operations (NBO), adds more high availability to your cluster while performing schema changes. Schema changes made on all cluster nodes in the same total order sequence, with much more efficient locking compared to the Total Order Isolation (TOI) method. SET GLOBAL wsrep_OSU_method=’NBO’ Read Non Blocking Operations documentation 2) XA transactions is a standard for coordinating distributed transactions, allowing multiple databases to participate in a transaction ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; Almost a Ripley’s Believe It or Not. An prior data science student told me that his new IT department setup a Windows component that let him connect his Excel Spreadsheets to their production MySQL database without a password. Intrigued, I asked if it was a MySQL Connector/ODBC Data Source Configuration, or DSN (Data Source Name)? He wasn’t sure, so I asked him to connect to PowerShell and run the following command: Get-Item -Path Registry::HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INIMySQL It returned something like this (substituting output from one of my test systems): Hive: HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INI     Name Property ---- ... Read More

Feed: Planet MySQL; Author: Lenz Grimmer; As you are probably aware, Red Hat Enterprise Linux 6 (RHEL 6 or EL 6 in short) officially reached “End of Life” (EOL) on 2020-11-30 and is now in the so-called Extended Life Phase, which basically means that Red Hat will no longer provide bug fixes or security fixes. Even though EL 6 and its compatible derivatives like CentOS 6 had reached EOL some time ago already, we continued providing binary builds for selected MySQL-related products for this platform. However, this became increasingly difficult, as the MySQL code base continued to evolve and now ... Read More

Feed: Planet MySQL; Author: Marcelo Altmann; Earlier last week, Oracle released their Q2 releases series. Unlike previous releases, backward compatibility has now been broken with previous versions of MySQL. MySQL 8.0.29 extended the support for the online DDL algorithm INSTANT. Prior to 8.0.29 only adding columns to the end of the table was supported. In 8.0.29, this functionality was extended to allow the INSTANT algorithm the ability to add columns in any position of the table as well to drop columns. This new functionality required the redo log version to increase and new redo log types to be added, thus ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; I’m always updating VMs, and I was gratified to notice that there’s a Fedora arm64 ISO. If you’re interested in it, you can download the Live Workstation from here or the Fedora Server from here. Unfortunately, I only have macOS running on i7 and i9 Intel Processors. It would be great to hear back how it goes for somebody one of the new Apple M1 chip. I typically install the workstation version because it meets my needs to run MySQL and other native Linux development tools. However, the server version is also available. Fedora ... Read More

Feed: Planet MySQL; Author: ScaleGrid.io; In this blog post, we will show you a step-by-step guide on how to install and set up a MySQL server both manually on the Ubuntu 20.04 operating system, as well as by using ScaleGrid’s managed database service. In the following sections of this tutorial, we will help you through every step to successfully set up your very own MySQL server and configure it properly. A bit about MySQL & Ubuntu MySQL is an open-source relational database management system (DBMS). It runs on Windows and Linux Servers, and it is commonly installed as part of ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; We had an interesting set of questions regarding the REGEXP comparison operator in MySQL today in both sections of Database Design and Development. They wanted to know the default behavior. For example, we built a little movie table so that we didn’t change their default sakila example database. The movie table was like this: CREATE TABLE movie ( movie_id int unsigned primary key auto_increment , movie_title archer(60)) auto_increment=1001; Then, I inserted the following rows: INSERT INTO movie ( movie_title ) VALUES ('The King and I') ,('I') ,('The I Inside') ,('I am Legend'); Querying all ... Read More

Feed: Planet MySQL; Author: David Stokes; Oracle released MySQL Server 8.0.29 on April 26th and this is a quick review of the release notes.  I have put my own comments in italics. So what is in the ’29 release of MySQL Server?  Does it come festooned with new, neat features or is it a big bug-fix bonanza? The TL;DR While this server release has some interesting stuff, there is no compelling feature that will necessitate an immediate upgrade.  Read through the release notes to see if anything in there that is a must for you but for most of us, ... Read More

Feed: Planet MySQL; Author: Dave Stokes; Percona Live's schedule has very interesting MySQL talks.  This is an in person event in Austin Texas and one of the rooms will be livestreamed.  Please note there are TWO rooms to chose from.Room 1  Tuesday, May 17 11:30am CDTUsing Roles and Partial Revokes To Improve Security in MySQL 8.01:30pm CDTRocksDB Performance and Reliability Practices2:30pm CDTVitess VReplication: Standing on the Shoulders of a MySQL Giant4:00pm CDTBig Data. Or Just Too Much Data?5:00pm CDTBetter MySQL With Percona Monitoring and Management Wednesday, May 18 9:30am CDTBest Practices for MySQL High Availability in 202210:50am CDTMySQL Failover for Asynchronous replication with Orchestrator, ... Read More