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 …

SQLAlchemy is a popular Python library that gives you many tools to interact with SQL databases. With SQLAlchemy, you can do things like send raw queries to a database, programmatically construct SQL statements, and even map Python classes to database tables with the object-relational mapper (ORM). SQLAlchemy doesn't force you to use any particular features, so it has the flexibility to support many different approaches to working with databases. You can use SQLAlchemy for one-off scripts, web apps, desktop apps, and more. Anywhere that you'd use a SQL database along with Python, you can use SQLAlchemy. This tutorial will cover setting up an engine object in Python SQLAlchemy 2.0, which is the first step to using SQLAlchemy. Then, it will cover two specific ways of interacting with a database: with raw SQL statements and by using the object-relational mapper. This tutorial covers the most recent version of SQLAlchemy, which is 2.0, as of writing …

Learn how to using SQLAlchemy with MySQL by working through an example of creating tables inserting data and querying data with both raw SQL and SQLAlchemy ORM.

InnoDB has been the default storage engine for MySQL since version 5.5 (July 2010!). If you are still using MyISAM as the storage engine for your tables, it might be time to consider migrating to InnoDB. InnoDB offers several advantages over MyISAM: <!– wp:list {"className":"","epStylingOptions":{"columnsResponsiveEnabled":false,"columnsHoverEnabled":false,"itemsSpacingResponsiveEnabled":false,"itemsSpacingHoverEnabled":false,"listStyleResponsiveEnabled":false,"listStyleHoverEnabled":false,"listIconResponsiveEnabled":false,"listIconHoverEnabled":false,"columns":{"target":"","responsive":true,"hover":true,"options":[{"custom":true,"control":"ToggleOptions"},{"label":"Columns","control":"Range","attribute":"columns","css":"grid-template-columns","customValue":"repeat({{value}}, …

It's time to switch all your MyISAM tables to InnoDB. Discover the myths about InnoDB in this blog post.

MySQL uses Redo Logs internally during crash recovery to correct data written by incomplete transactions. But how do you know what the right Redo Log size is? We will walk through how to figure that out in this blog.

We already have a couple of posts related to this topic. “How to calculate a good InnoDB log file size” and “How to Choose the MySQL innodb_log_file_size.” The first one has the formula I’ll mention in this blog, and the second has more details regarding Redo Logs. Most of it is still valid, just replace innodb_log_file_size / innodb_log_files_in_group with innodb_redo_log_capacity.

So in this one, I want to focus on two things:

1. Present the new way of working with Redo Logs (No …

We are happy to announce our presence at those two conferences this week. Please find details about SCALE 20x & OSC Online Spring MySQL Community and MySQL teams are attending:   MySQL is a Silver sponsor of SCALE 20x with a MySQL booth. Do not miss following MySQL accepted talks:   March 10 – 11, […]