Scalegrid

DECEMBER 16, 2020

Mysqldump is a client utility that is used to perform logical backups of the MySQL database. This popular migration tool is useful for various use cases of MySQL such as: Backup and restore of databases. Migrating data across different managed MySQL service providers. Migrating data from one server to another.

Best Practices 290

Best Practices Database Servers Performance 290

Scalegrid

MAY 22, 2020

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. A blog post from Percona, titled MySQL Ripple: The First Impression of a MySQL Binlog Server , gives a very good introduction to deploying and using Ripple. Exploring MySQL Binlog Server - Ripple Click To Tweet.

Servers 262

Servers Transportation Database Availability 262

Scalegrid

AUGUST 26, 2020

MySQL is the number one open source database that’s commonly hosted through Azure instances. While Microsoft offers their own Azure Database product, there are other alternatives available that may be able to help you improve your MySQL performance. MySQL Azure Performance Benchmark. MySQL Read-Intensive Performance.

Azure 299

Azure Benchmarking Database Latency 299

Percona

MARCH 26, 2024

MySQL is a very popular database and a good choice for new projects. Luckily you have several options for this choice.MySQL Community vs. Enterprise EditionsTraditionally, the MySQL Community Edition has been a mainstay in the open source community for decades, and it is available for free. But is it the best choice?Luckily

Database 77

Database Open Source Availability Software 77

Percona

APRIL 16, 2024

We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4.

Servers 82

Servers 82

Percona

SEPTEMBER 12, 2023

With the release of MySQL 8, a notable enhancement was introduced to the auto-increment counter. Compared to MySQL 5.7, In this article, we will look into this enhancement, compare MySQL 5.7 with MySQL 8, and provide practical examples to demonstrate the differences. Auto-increment in MySQL 5.7 In MySQL 5.7,

Servers 113

Servers Storage Database Open Source 113

Percona

DECEMBER 18, 2023

pgLoader can extract data from MySQL, MSSQL, Oracle, and even another PostgreSQL host. Database migration, a POC in action Objective Perform a database migration from MySQL to PostgreSQL. Migration environment The migration environment used for this blog is a production MySQL database, version 5, with several hundred tables.

Open Source 123

Open Source Database Architecture Design 123

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48 MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

Tuning 136

Tuning Cache Servers Benchmarking 136

Percona

DECEMBER 28, 2023

Its functionality has been significantly improved in comparison to Audit Log and currently mirrors the functionality of the MySQL Enterprise Audit plugin. Starting with Percona Server for MySQL 8.0.34-26 Try Percona Distribution for MySQL today! 26 , the Audit Log Filter is available in a technical preview mode.

Open Source 107

Open Source Database Servers Storage 107

Percona

NOVEMBER 6, 2023

Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2. MySQL Router. Group replication relaxation Group Replication gets relaxed as version requirements for groups are relaxed beginning with this release: A server running any MySQL 8.0 A group member running any MySQL 8.0 Remember that 8.2

Open Source 112

Open Source Database Servers Scalability 112

Percona

JANUARY 17, 2024

Oracle recently released MySQL 8.0.36 and MySQL 8.3, and this is a perusal of the release notes to determine what is new, what is in the seventy-three bugs fixed, and what has changed in the three months since the last releases. Comments in italics are my own and do not reflect the view of anyone […]

101

101

Percona

JANUARY 11, 2024

In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in the comparison. From that time to now, we had several MySQL releases and, of course, also some new MySQL Router ones.Most importantly, we also had MySQL Router going back to being a level 7 proxy […]

Performance 92

Performance Benchmarking Availability Servers 92

Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.

Servers 273

Servers Monitoring Availability Programming 273

Scalegrid

FEBRUARY 5, 2021

MySQL is the number one open source relational database management system in the world, and is used by millions of developers across all application types. DigitalOcean, a fast-growing cloud provider that’s increasing in popularity amongst the developer community, is a great host to consider for your MySQL deployments.

Open Source 221

Open Source Database Cloud Systems 221

Percona

MARCH 20, 2023

With a special focus on Percona Operator for MySQL Overview HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last few years, I had to answer multiple times on what proxy to use and in what scenario. Type c5.4xlarge) Three mid-data nodes with several gigabytes of data in with MySQL and Group Replication (Type m5.xlarge)

Games 122

Games Latency Traffic Cache 122

Percona

JUNE 23, 2023

For more than a quarter of a century, people have been discussing “Which is better, MySQL or PostgreSQL?” Both MySQL and PostgreSQL do the basics very well From a high level, one relational database management system is pretty much like every other relational database management system. ” — with no resolution.

Database 121

Database Transportation Servers Cloud 121

Percona

MAY 2, 2023

Let’s look at some questions I did that a MySQL DBA usually needs to answer in an interview process. Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. ChatGPT: The InnoDB buffer pool is used by MySQL to cache frequently accessed data in memory. Q: I have a MySQL server with 10 CPUs.

Social Media 122

Social Media Database Servers Cache 122

Scalegrid

MAY 5, 2022

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

Operating System 305

Operating System Database Servers Systems 305

Percona

FEBRUARY 6, 2024

To be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because from my MySQL memories, I knew that there is not a real difference between the two distributions when talking about the code base.To

Code 100

Code Benchmarking Servers Development 100

Percona

SEPTEMBER 7, 2023

’ Prior to MySQL 8.0.16, it was not possible to grant privileges that apply globally except for certain schemas. As of MySQL 8.0.16, that is possible if the partial_revokes system variable is enabled. For example, it is possible to permit an account to modify any table except those in the MySQL system schema.

Database 89

Database Servers Open Source Systems 89

Percona

JULY 5, 2023

Upgrading to MySQL version 8.0 Long database service downtime Some queries become slow Applications stop working due to incompatibilities Data loss This is what can happen if MySQL’s major upgrade to 8.0 As MySQL does not support downgrades from 8.0, You cannot load a dump of the MySQL system database from MySQL 8.0

C++ 119

C++ Database Servers Testing 119

Percona

DECEMBER 13, 2023

MySQL 8 introduces Error Log Filtering as a mechanism to fine-tune the error log, allowing administrators to focus on the most critical issues. Suppression-list filtering Log_error_suppression_list is a dynamic system variable introduced in MySQL 8, aimed at selectively suppressing specific error messages from being written to the error log.

Database 96

Database Open Source Tuning Traffic 96

Percona

APRIL 2, 2024

Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers looking for talent. One frustrated individual informed me that while it was hard to find a qualified MySQL DBA, it was impossible to find a qualified PostgreSQL DBA. Years later, that same sentiment is still […]

Availability 83

Availability 83

Scalegrid

JUNE 22, 2020

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. MySQL on DigitalOcean is a natural fit, but what’s the best way to deploy your cloud database? ScaleGrid averages almost 40% higher throughput over DigitalOcean for MySQL, with up to 46% higher throughput in write-intensive workloads.

Database 217

Database Benchmarking Latency Performance 217

Percona

SEPTEMBER 26, 2023

This blog post discusses the limitations of the MySQL Clone plugin. The MySQL clone plugin significantly simplifies the process of replica provisioning. Debugging options, such as innodb_force_recovery , could cause clone operation failure at further steps, as reported in MySQL Bug 109035.

Servers 109

Servers Network Cache Processing 109

Percona

OCTOBER 13, 2023

When MySQL generates a core file, the VS code simplifies the process of debugging. Finding the binary file of MySQL To open the core file, the GDB requires the binary file of MySQL. You can use the shell command below to find the path of the default MySQL file. wget [link] tar xf mysql-8.0.34.tar.gz

Code 104

Code C++ Storage Programming 104

Percona

MAY 16, 2023

A brute force attack can be launched against a user account in MySQL. MySQL replies with success or error based on supplied credentials, and the time required for the verification is almost the same in either case. It was introduced in MySQL 8.0 and also back-ported to MySQL 5.7 and MySQL 5.6.

Servers 120

Servers Database Monitoring Testing 120

Percona

OCTOBER 13, 2023

In MySQL 8.0, MySQL writes a.sdi file to accommodate the serialized dictionary information for storage engines that lack support for this functionality. Storage engine compatibility Different MySQL storage engines handle.sdi files in various ways. 1 mysql mysql 18M Apr 15 10:39 transaction_processing_flag.ibd -rw-r --.

Storage 96

Storage Database Engineering Open Source 96

Percona

MARCH 1, 2023

Oracle’s MySQL 5.7 The Era of MySQL 5.x x will be over, and only MySQL 8.0 So if you are running MySQL, you need to consider upgrading to version 8.0 There are many other features that you want to have in MySQL 8.0 But before going with the MySQL Community Edition, you should look at Percona Server for MySQL.

Servers 120

Servers Open Source Tuning C++ 120

Percona

FEBRUARY 9, 2024

Historically, MySQL does not require explicit primary key defined on tables, and it’s like that by default till this day (MySQL version 8.3.0). There are many […]

109

109

Percona

FEBRUARY 15, 2023

Previously, I wrote about our Terraform provider to deploy Percona Server for MySQL ( Percona Server for MySQL: Automatic Cloud Deployment With Terraform ) and Percona Monitoring and Management ( Deploying Percona Monitoring and Management (PMM) With Terraform ). Download Percona Distribution for MySQL Today

Open Source 124

Open Source AWS Scalability Servers 124

Percona

APRIL 4, 2023

The first step for many is looking into the new reserved words in MySQL 8.0. As MySQL gets new functionality or the project matures, there are new additions to the list of reserved words you can not use as column names. It is recommended that you use the util.checkForServerUpgrade() in the MySQL Shell to check for these Reserved Words.

Open Source 118

Open Source Database Servers Scalability 118

Percona

JANUARY 2, 2024

Fortunately, in Percona Server for MySQL , this feature is free to use. The auditing plugin overview has been explained in the blog post Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price. mysql> SET PERSIST audit_log_include_commands = 'drop_db,drop_table'; Query OK, 0 rows affected (0.04

Servers 85

Servers Database Open Source Scalability 85

Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! root@ip-xxx-xx-xx-xx ~]# mysqlsh -uroot -p MySQL Shell 8.0.33

C++ 107

C++ Servers Storage Speed 107

Percona

JULY 27, 2023

This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. The release with the new features will be called the Innovation series, and MySQL 8.1.0 Quick reminder The End of Life for MySQL 8.0

Servers 84

Servers Open Source Tuning Cache 84

Percona

JANUARY 4, 2024

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. What are MySQL general tablespaces? Encryption support : MySQL supports encryption for General Tablespaces, enhancing the security of your data.

Storage 90

Storage Engineering Database Hardware 90

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 115

Servers Best Practices Database Open Source 115