From: Ismaël Bouya <ismael.bouya@normalesup.org>
Date: Fri, 13 Oct 2023 11:56:21 +0000 (+0200)
Subject: Bump MariaDB to latest stable version
X-Git-Url: https://git.immae.eu/?p=perso%2FImmae%2FConfig%2FNix.git;a=commitdiff_plain;h=670d287ee1dc24437ecdd030ccacd2cb5d55109a

Bump MariaDB to latest stable version
---

diff --git a/flakes/private/system/flake.nix b/flakes/private/system/flake.nix
index 3e48358..4a83e36 100644
--- a/flakes/private/system/flake.nix
+++ b/flakes/private/system/flake.nix
@@ -38,7 +38,7 @@
             [
               (self: super: {
                 postgresql = self.postgresql_pam;
-                mariadb = self.mariadb_106.overrideAttrs(old: {
+                mariadb = self.mariadb_1011.overrideAttrs(old: {
                   passthru = old.passthru // { mysqlVersion = "5.7"; };
                 });
               }) # don’t put them as generic overlay because of home-manager
diff --git a/systems/backup-2/databases/mariadb_replication.nix b/systems/backup-2/databases/mariadb_replication.nix
index 8d2b457..6616de0 100644
--- a/systems/backup-2/databases/mariadb_replication.nix
+++ b/systems/backup-2/databases/mariadb_replication.nix
@@ -195,6 +195,14 @@ in
       }
     ) cfg.hosts;
 
+    environment.systemPackages = lib.mapAttrsToList (name: hcfg:
+      pkgs.writeScriptBin "mysql_backup_${name}" ''
+        #!${pkgs.stdenv.shell}
+
+        exec ${hcfg.package}/bin/mysql -S /run/mysqld_${name}/mysqld.sock "$@"
+      ''
+    ) cfg.hosts;
+
     systemd.services = lib.attrsets.mapAttrs' (name: hcfg:
       let
         dataDir = "${cfg.base}/${name}/mysql";