The latest from the MySQL community

If you are a mobile app, frontend, backend, or game developer, you use data types such as string, numeric, or DateTime. You also know that since the advent of non-relational databases (NoSQL) such as MongoDB, which, by not being tied to a traditional SQL schema, do reading and writing on databases much faster. But MySQL showed that storing the JSON (JavaScript Object Notation) data type could also improve the speed of reading and writing relational databases.

This post will explore the JSON Data type in Percona Server for MySQL.

One of the key features of Percona Server is support for JSON data type, which allows for the storage of JSON documents within MySQL. It allows for more flexible and efficient storage of semi-structured data (​​which is more …

For a long time, I never encountered any system using FEDERATED tables. But recently, there seems to be more interest for FEDERATED tables. Is this related to the increase of microservices? In a microservices architecture, services are typically designed to be small, loosely coupled, and independently deployable. Each service may have its own database, which […]

For a long time, I never encountered any system using FEDERATED tables. But recently, there seems to be more interest for FEDERATED tables. This article illustrates how to use FEDERATED tables in MySQL.

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.40 (release notes, download) and MySQL-wsrep 8.0.31 (release notes, download) with Galera replication library 4.14 (release notes, download) implementing wsrep API version 26. …

Basic Usage

mysqldump is a client utility that can be used for doing logical backups. It will generate the necessary SQL statements to reproduce the original database.

Backup by Nick Youngson CC BY-SA 3.0 Pix4free

The following statements are some common uses of mysqldump:

1. mysqldump -u username -p database_name [table_name] > dump.sql
2. mysqldump -u username -p --databases db1_name db2_name > dump.sql
3. mysqldump -u username -p --all-databases > dump.sql

The first example is for backing up a single database. If you need to back up some specific tables instead of the whole database, write their names, space-separated.

With the --databases option, you can back up two or more databases, their names …

This blog gives details of the new feature introduced in MySQL 8.0.29 using which column(s) can be added/dropped to/from a table with ALGORITHM=INSTANT.

MySQL Summit 2023 is right around the corner. If you consider yourself a *true* fan of the Dolphin, but haven’t made plans to attend this free event either in-person (Redwood Shores, CA) or online, you’ll be missing out on a critical chance to hone your MySQL skills by learning best practices directly from MySQL engineers. […]

Free MySQL Summit Day - March 23rd, in-person and virtual. See main reasons to attend and agenda.

In this tutorial, we’ll be going over every step of how to install MySQL on AlmaLinux. Database servers are the ...

Read More

The post How to Install MySQL on AlmaLinux appeared first on RoseHosting.

While Galera Manager is ideal for deploying on Amazon AWS or DigitalOcean, or even on your own on-premise hosts, there is a third option that exists, that allows you to monitor an existing cluster that you already have installed. While we won’t go thru installing a Galera Cluster in this post, we will show you how to get Galera Manager to function for this purpose.

Obtain Galera Manager via filling in the form. Once you have the gm-installer on your Galera Manager host, remember to execute: chmod +x gm-installer. We recommend also …