Add mysql replication

[perso/Immae/Config/Nix.git] / modules / private / databases / utils.nix

diff --git a/modules/private/databases/utils.nix b/modules/private/databases/utils.nix
new file mode 100644 (file)
index 0000000..c296f49
--- /dev/null
+++ b/modules/private/databases/utils.nix
@@ -0,0 +1,30 @@
+{ pkgs }:
+{
+  keepLastNDumps = backupDir: n: ''
+    #!${pkgs.stdenv.shell}
+
+    cd ${backupDir}
+    ${pkgs.coreutils}/bin/rm -f \
+      $(${pkgs.coreutils}/bin/ls -1 *.sql \
+        | ${pkgs.coreutils}/bin/sort -r \
+        | ${pkgs.gnused}/bin/sed -e '1,${builtins.toString n}d')
+    '';
+  exponentialDumps = backupDir: let
+    log2rotateSrc = builtins.fetchGit {
+      url = "https://github.com/avian2/pylog2rotate";
+      ref = "master";
+      rev = "061f0564757289d3bea553b16f8fd5c4a0319c5e";
+    };
+    log2rotate = pkgs.writeScript "log2rotate" ''
+      #!${pkgs.python3}/bin/python
+
+      ${builtins.readFile "${log2rotateSrc}/log2rotate.py"}
+    '';
+  in ''
+    #!${pkgs.stdenv.shell}
+
+    cd ${backupDir}
+    ${pkgs.coreutils}/bin/rm -f $(ls -1 *.sql | grep -v 'T22:' | sort -r | sed -e '1,12d')
+    ${pkgs.coreutils}/bin/rm -f $(ls -1 *T22*.sql | ${log2rotate} --skip 7 --fuzz 7 --delete --format='%Y-%m-%dT%H:%M:%S+00:00.sql')
+    '';
+}