In recent years, both MySQL and MariaDB have changed their replication wordings. Slave has become Replica.
But to make the situation more complex: #MariaDB only changed the replication commands but kept the output field names while #MySQL changed the wording in the output, too.
The newest version of the check_mysql_slavestatus #opensource #monitoring plugin now supports all these cases and auto-detects which commands to use and which fields to parse.
Migrate MySQL to MariaDB on Ubuntu 24.04
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.https://geekrewind.com/migrate-mysql-to-mariadb-on-ubuntu-24-04/
Secure MySQL with Self-Signed SSL Certificate on Ubuntu 24.04
This article discusses the implementation of MySQL self-signed SSL certificates on Ubuntu 24.04 to enhance database security. It covers generating certificates, configuring SSL connections, and enforcing SSL usage for users. Key points include improved encryption, automatic SSL configuration, user restrictions, and validation of SSL setups for a secure database environment.https://geekrewind.com/secure-mysql-with-self-signed-ssl-on-ubuntu-24-04/
Backup and Restore MySQL database with mysqldump
This article outlines the process of backing up and restoring MySQL databases using the mysqldump tool on Ubuntu 24.04. It details commands for backing up all databases or specific ones, advises on using table locking or transactions for data integrity, and emphasizes regular backups, effective monitoring, and testing restore processes to prevent data loss.https://geekrewind.com/backup-and-restore-mysql-database-with-mysqldump/
Tengo publicado en YouTube un tutorial de instalación de la base de datos MySQL en Docker (conocida por facilidad de uso y la alta disponibilidad).
#MySQL #BBDD #Gratis #Free #SiguemeYTeSigo #followback
Nota: imagen generada con IA.
Mal eine Frage ins Blaue: Wenn ich eine Wordpressseite, die auf einem Server mit PHP 8.2.7 läuft und Mariadb 10.5 auf einen Server umziehe mit PHP 8.3 und Mariadb 10.6 , kriege ich dann eher wahrscheinlich Probleme oder nicht? Ich würde die Daten rüberkopieren und die Datenbank aus einem SQL-Export importieren in eine frisch angelegte Datenbank.
Die Updates auf dem alten Server könnte ich zwar auch machen und erst dann migrieren, aber gings auch ohne?
Linux DevOps eBook Bundle by Bobby Iliev is the featured bundle on Leanpub!
Link: https://leanpub.com/b/linux-devops-ebook-bundle
#Databases #Mysql #Postgresql #ComputerProgramming #Devops #CloudComputing #Git #VersionControl #ComputerSecurity #ProgrammingCookbooks #SoftwareEngineering #Terraform
Welcome to this comprehensive collection of essential tech guides. Each book in this bundle serves as a stepping stone into the vast world of technology, from the foundational layers of Linux systems to the nuanced art of infrastructure management with Terraform. Whether you're a seasoned professional or a passionate enthusiast looking to expand your horizons, this bundle caters to your thirst for knowledge without overwhelming you. By selecting this bundle, you're not just acquiring texts; you're embarking on a journey. A journey that has been charted by someone who believes in the power of sharing knowledge, the importance of understanding core principles, and the joy of learning. Thank you for allowing these works to be a part of your educational journey. Dive in, explore, and let the world of technology unfold before you. Suggested order of reading the books would be: 1. Introduction to Linux: - Provides foundational knowledge on which many of the other topics will be built upon, especially for those who are new to the Linux environment. 2. Introduction to Bash Scripting: - After gaining familiarity with the Linux environment, users can delve into automating tasks within that environment using Bash scripting. 3. Introduction to Git and GitHub: - Version control is essential for any serious coding or infrastructure project. Knowing Git and GitHub early will be beneficial as the reader progresses to other topics. 4. Introduction to SQL: - Databases are ubiquitous in software and system design. SQL is foundational for understanding how to interact with relational databases. 5. Introduction to Docker: - With a foundation in Linux, scripting, version control, and databases, readers can move on to understanding containerization, a key concept in modern development and deployment practices. 6. Introduction to Terraform: - After grasping the basics of Docker, users can further their knowledge in infrastructure automation and Infrastructure as Code (IaC) with Terraform. If you're into DevOps, you'll love DevOps Daily: it has free bite-sized exercises, tools, and guides to level up fast.
FreePixel
Hans-Cees 🌳🌳🤢🦋🐈🐈🍋🍋🐝🐜
ck 👨💻
Geek Rewind
fortrabbit
El laboratorio de Rafa
irgendlink
Leanpub