Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen der Seite angezeigt.

--- freebsd:server:install [2026/02/12 22:48] – [Erste Anpassungen] hwehrs
+++ freebsd:server:install [2026/02/13 00:47] (aktuell) – [MariaDB] hwehrs
@@ Zeile 101: / Zeile 101: @@
 </WRAP>
 ----
+===== MariaDB =====
+<WRAP group>
+<WRAP right 10%>{{ :freebsd:server:bsd_maria_0001.png?direct&200|}}</WRAP>
+<WRAP left 85%>
+==== Installation ====
+<code bash>
+pkg install -y mariadb1011-server mariadb1011-client
+</code>
+<WRAP info round justify><wrap em>Schlußmeldung nach der Installation</wrap>\\ \\
+Message from galera26-26.4.25:
+Find the Galera Cluster documentation at https://galeracluster.com/library/documentation/index.html
+----
+Message from mariadb1011-client-10.11.16:
+MariaDB respects hier(7) and doesn't check /etc and /etc/mysql for my.cnf. Please move existing my.cnf files from those paths to /usr/local/etc/mysql or /usr/local/etc. Sample configuration files are provided in /usr/local/etc/mysql and /usr/local/etc/mysql/conf.d. The rc(8) script no longer uses /var/db/mysql/my.cnf for configuration
+nor /var/db/mysql for logs and PID-file.
+This port does NOT include the mytop perl script, this is included in the MariaDB tarball but the most recent version can be found in the databases/mytop port
+WSREP\\
+Using wsrep clustering requires adding a configuration file. Copy /usr/local/etc/mysql/conf.d/wsrep.cnf.sample to /usr/local/etc/mysql/conf.d/wsrep.cnf and change what you need there.
+----
+Message from mariadb1011-server-10.11.16:
+MariaDB respects hier(7) and doesn't check /etc and /etc/mysql for my.cnf. Please move existing my.cnf files from those paths to /usr/local/etc/mysql or /usr/local/etc. Sample configuration files are provided in /usr/local/etc/mysql and /usr/local/etc/mysql/conf.d. The rc(8) script no longer uses /var/db/mysql/my.cnf for configuration
+nor /var/db/mysql for logs and PID-file.
+This port does NOT include the mytop perl script, this is included in the MariaDB tarball but the most recent version can be found in the databases/mytop port
+Using wsrep clustering requires adding a configuration file. Copy /usr/local/etc/mysql/conf.d/wsrep.cnf.sample to /usr/local/etc/mysql/conf.d/wsrep.cnf and change what you need there.
+</WRAP>
+dddddd
+ddddd
+ddddd
+</WRAP>
+</WRAP>
+----
+<WRAP group>
+<WRAP right 10%>{{ :freebsd:server:bsd_maria_0002.png?direct&200|}}{{ :freebsd:server:bsd_first_0001.png?direct&200|{{ :freebsd:server:bsd_maria_0003.png?direct&200|}}</WRAP>
+<WRAP left 85%>
+==== ZFS-Dataset für das Datenverzeichnis erstellen ====
+<code bash>
+zfs create -o mountpoint=/var/db/mysql zfshdd/mariadb
+zfs create -o recordsize=16k zfshdd/mariadb/data
+zfs create -o recordsize=128k -o atime=off zfshdd/mariadb/log
+chown -Rv mysql:mysql /var/db/mysql
+chmod 700 /var/db/mysql/data
+</code>
+<WRAP info round centeralign 60%><wrap em>zfs list</wrap>\\
+<code>
+NAME                   USED  AVAIL  REFER  MOUNTPOINT
+zfshdd                1.01M  1.75T   128K  /zfshdd
+zfshdd/mariadb         394K  1.75T   139K  /var/db/mysql
+zfshdd/mariadb/daten   128K  1.75T   128K  /var/db/mysql/daten
+zfshdd/mariadb/log     128K  1.75T   128K  /var/db/mysql/log
+</code>
+</WRAP>
+</WRAP>
+</WRAP>
+----
+<WRAP group>
+<WRAP right 10%>xx yy zz</WRAP>
+<WRAP left 85%>
+==== MariaDB Datendateien erstellen & Zugänge sichern ====
+<code bash>
+mysql_install_db --defaultsfile=/usr/local/etc/mysql/conf.d/server.cnf
+</code>
+Nachdem die Datendateien erstellt sind, die User-Accounts sichern.
+<code bash>
+mysql_secure_installation
+</code>
+</WRAP>
+</WRAP>
+----
+<WRAP group>
+<WRAP right 10%>dd dd dd</WRAP>
+<WRAP left 85%>
+==== MariaDB Konfiguration ====
+</WRAP>
+</WRAP>