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

APRIL 9, 2024

He is also active in the open source community and was recognized as a MySQL Rock Star in 2023.In In the previous interview with Vinicius, we discussed the upcoming End of Life (EOL) for MySQL 5.7. Now that MySQL 5.7 has reached EOL, MySQL 8 […] We met with Vinicius Grippa, a Senior Support Engineer at Percona.

Open Source 99

Open Source Engineering Software Software 99

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 78

Database Open Source Availability Software 78

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

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 88

Servers 88

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 124

Open Source Database Architecture Design 124

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 138

Tuning Cache Servers Benchmarking 138

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 113

Open Source Database Servers Scalability 113

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

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

102

102

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 124

Games Latency Traffic Cache 124

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 122

Database Transportation Servers Cloud 122

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 124

Social Media Database Servers Cache 124

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

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 90

Database Servers Open Source Systems 90

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 101

Code Benchmarking Servers Development 101

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++ 120

C++ Database Servers Testing 120

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

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 122

Servers Database Monitoring Testing 122

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

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

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

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 121

Servers Open Source Tuning C++ 121

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

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 125

Open Source AWS Scalability Servers 125

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 119

Open Source Database Servers Scalability 119

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 85

Servers Open Source Tuning Cache 85

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

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

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 86

Servers Database Open Source Scalability 86

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

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 106

Performance Monitoring Traffic Database 106