cluster

commit 6ff94e7b52a5a91641250fd3cc94df06c4417bf6
parent b900f2749744a9bd7fd7c34203367a6cd8d29ff1
Author: MTRNord <MTRNord@users.noreply.github.com>
Date:   Wed, 15 Oct 2025 09:09:02 +0200

tune db

Signed-off-by: MTRNord <MTRNord@users.noreply.github.com>

Diffstat:
M
apps/talos_cluster/blog/mysql-cm.yaml
 | 
18
++++++++++++++++++
M
apps/talos_cluster/blog/mysql.yaml
 | 
9
+++++++--

2 files changed, 25 insertions(+), 2 deletions(-)
diff --git a/apps/talos_cluster/blog/mysql-cm.yaml b/apps/talos_cluster/blog/mysql-cm.yaml
@@ -8,3 +8,21 @@ data:
         CREATE USER '$MYSQL_USER'@'%' IDENTIFIED BY '$MYSQL_PASSWORD';
         GRANT ALL PRIVILEGES ON '$MYSQL_DATABASE'.* TO '$MYSQL_USER'@'%';
         FLUSH PRIVILEGES;
+---
+apiVersion: v1
+kind: ConfigMap
+metadata:
+    name: mysql-config
+    namespace: blog
+data:
+    performance.cnf: |
+        [mysqld]
+        innodb_buffer_pool_size=1G
+        innodb_log_file_size = 512M
+        thread_cache_size = 16
+        query_cache_size = 128M
+        query_cache_type = 1
+        table_open_cache = 4096
+
+        max_connections = 500
+        max_user_connections = 50
diff --git a/apps/talos_cluster/blog/mysql.yaml b/apps/talos_cluster/blog/mysql.yaml
@@ -43,8 +43,10 @@ spec:
                   volumeMounts:
                       - name: mysql-volume
                         mountPath: /var/lib/mysql
-                      - name: mysql-config
+                      - name: mysql-configmap
                         mountPath: /docker-entrypoint-initdb.d
+                      - name: mysql-config
+                        mountPath: /etc/mysql/conf.d
                   resources:
                       requests:
                           memory: "256Mi"
@@ -69,9 +71,12 @@ spec:
                       successThreshold: 1
                       failureThreshold: 3
             volumes:
-                - name: mysql-config
+                - name: mysql-configmap
                   configMap:
                       name: mysql-configmap
+                - name: mysql-config
+                  configMap:
+                      name: mysql-config
     volumeClaimTemplates:
         - metadata:
               name: mysql-volume