The article outlines the process of migrating from MySQL to MariaDB on Ubuntu 24.04. It emphasizes the importance of backing up databases, checking compatibility, uninstalling MySQL, installing MariaDB, and restoring backups. Following these steps ensures a smooth transition, allowing users to benefit from MariaDB’s additional features and optimizations.
This article details the process of creating and configuring a self-signed SSL certificate for MariaDB on Ubuntu 24.04. It enhances security by enabling encrypted connections. Steps include generating the certificate, configuring MariaDB settings, validating SSL installation, and ensuring users connect via SSL, thus safeguarding sensitive data.
This content provides a step-by-step guide to resetting or changing MySQL or MariaDB passwords on Ubuntu Linux. The tutorial addresses scenarios such as forgetting the root password in these databases and guides users through various command line instructions for password recovery, depending on the MySQL or MariaDB server's version being used. Additionally, it covers using the auth_socket plugin and explains how to restart the database servers after performing the necessary actions.
This guide provides detailed instructions on how to install MySQL or on Ubuntu Linux for students or new users. Both MySQL and MariaDB are open-source, multi-threaded relational database management systems, with MariaDB being a backward-compatible replacement for MySQL. The post outlines steps on installing default and latest versions, and securing MariaDB and MySQL databases. The MariaDB Foundation maintains MariaDB, while Oracle owns MySQL. The servers are accessed through the auth_socket method.
This tutorial guides users through the process of backing up and restoring MariaDB databases and data files on Ubuntu using Mariabackup. Mariabackup, an open-source tool introduced in MariaDB 10.1, does "hot online" backups of InnoDB tables and other files. The tutorial includes step-by-step instructions on installing Mariabackup, creating backups, and restoring data from these backups.
The tutorial explains how to setup remote access connections to MariaDB database servers on Ubuntu 18.04 systems. It involves installing MariaDB, enabling the service to always start up when the server boots, and configuring the server to allow remote access. The article also provides the necessary commands for enabling this on the Ubuntu Firewall. Care is advised when connecting to the internet and every IP needs to be explicitly configured for database access.
The tutorial provides step-by-step instructions on setting up MySQL/MariaDB master and slave replication on Ubuntu 16.04 and 18.04 servers, which is crucial for security, fault tolerance, and scalability. The process involves setting server details, installing MariaDB on both servers, creating and configuring master and slave servers, and testing the setup. Changes made on the master server get automatically replicated on the slave servers.
