Mastodawn

@derdreschi85 more reason to use #mariadb

Geek Rewind Sep 15, 2021

Install MySQL and MariaDB on Ubuntu: A Step-by-Step Guide

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.

https://geekrewind.com/how-to-install-mysql-or-mariadb-on-ubuntu-linux/

Geek Rewind Oct 10, 2021

How to Reset MySQL or MariaDB Root Password

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.

https://geekrewind.com/how-to-reset-mysql-or-mariadb-root-password/

Geek Rewind Jan 7, 2021

How to Backup and Restore MariaDB on Ubuntu

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.

https://geekrewind.com/how-to-backup-and-restore-mariadb-databases/

Geek Rewind Sep 18, 2019

How to Allow Remote Access to MariaDB in Ubuntu Linux

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.

https://geekrewind.com/allow-remote-access-to-mariadb-database-server-on-ubuntu-18-04/

Geek Rewind Apr 1, 2019

How to Setup MariaDB Master and Slave Replication on Ubuntu Linux

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.

https://geekrewind.com/setup-mariadb-master-slave-replication-on-ubuntu-16-04-18-04/

Shinguz 1d ago

A new #Jepsen report, on #MariaDB #Galera Cluster 12.1.2. Two cases of write loss, along with P4 (Lost Update) and Stale Read in healthy clusters.

https://jepsen.io/analyses/mariadb-galera-cluster-12.1.2

Jepsen: MariaDB Galera Cluster 12.1.2

Rad Web Hosting 1d ago

Install and Configure #Cacti on #AlmaLinux #VPS This article provides a guide demonstrating how to install and configure Cacti on AlmaLinux VPS.

What Is Cacti?
Cacti is an open-source network monitoring and graphing tool built on top of RRDtool. It’s designed to collect, store, and visualize time-series data from networks and systems.
What Cacti Does

Polls data from devices ...
Continued 👉 https://blog.radwebhosting.com/install-and-configure-cacti-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #mariadb #letsencrypt #selfhosted #opensource #selfhosting #rrdtool

N-gated Hacker News 2d ago

🎉 Oh, the wonders of #MariaDB #Galera #Cluster 12.1.2! 🎉 It promises bulletproof safety but instead acts like it’s on a mission to lose your precious data faster than you can say "network partition". 🤦‍♂️ Apparently, transaction consistency is just a suggestion, not a guarantee. 🐢✨
https://jepsen.io/analyses/mariadb-galera-cluster-12.1.2 #DataLoss #NetworkPartition #TransactionConsistency #TechNews #HackerNews #ngated