{nixCraft Patreon supporters content}
MySQL version 8.0 is a free and open-source database system used by most web applications and sites on the Internet. Typically MySQL is part of the LAMP (Linux, Apache, MySQL, Perl/Python/PHP) stack. MySQL heavily uses popular open-source software such as WordPress, MediaWiki, and others as a database storage engine. Let us see how to install MySQL server version 8.x on Ubuntu 22.04 LTS Linux server, including settings up a new database, users and fine tuning server config.The post How to install MySQL server on Ubuntu 22.04 LTS Linux appeared first on Opensource Flare✨.
{nixCraft Patreon supporters content}
You deployed a perfect firewall and other network security policies preventing unauthorized access to the user's desktop computer over a network. However, you still need to block USB device access. We can configure a Linux desktop security policy to protect your computer against rogue USB devices (a.k.a. BadUSB) by implementing essential allow and blocklisting capabilities based on device attributes. For instance, I can define what kind of USB devices are authorized and how a USB device interacts with the Linux system. For example, I can define policy allowing Yubikey with serial number "XYZ" and USB LTE modem with serial # "ABC." Every other USB device access is denied by default. This guide will cover the following topics:The post How to protect Linux against rogue USB devices using USBGuard appeared first on Opensource Flare✨.
{nixCraft Patreon supporters content}
This guide explains how to set up MariaDB high-availability cluster for the database using the Galera library, which provides a virtual mater-to-master three-node cluster running on Debian or Ubuntu Linux.
The post How to set up Mariadb Galera cluster on Ubuntu or Debian Linux appeared first on Opensource Flare✨.
{nixCraft Patreon supporters content}
This guide explains how to set up Redis sentinel failover cluster for caching database or any other data type in high availability node.All clients (your web app written in Python/PHP/Perl) will send Redis to read and write requests to 172.0.0.5 TCP port 6379. HAproxy will redirect read requests based upon the health status of the Redis server among three servers. The Redis write request will redirect to an active node in the sentinel cluster. Keepalived is used to maintain standby HAPorxy node in case primary HAPorxy node is down for any reason. In addition, Keepalived will provide IP failover based upon the VRRP protocol running on an interface. This in-depth guide will cover the following topics:
The post How to set up Redis sentinel cluster on Ubuntu or Debian Linux appeared first on Opensource Flare✨.
Now that I set up an LXD container, how do I backup and restore LXD containers running on Ubuntu/Debian or Fedora/CentOS Linux server?
The post How to backup and restore LXD containers appeared first on nixCraft.