Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen der Seite angezeigt.

--- freebsd:server:install [2026/02/12 23:14] – [MariaDB] hwehrs
+++ freebsd:server:install [2026/02/13 00:47] (aktuell) – [MariaDB] hwehrs
@@ Zeile 115: / Zeile 115: @@
 Message from galera26-26.4.25:
---
+Find the Galera Cluster documentation at https://galeracluster.com/library/documentation/index.html
-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
-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
+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
-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.
+WSREP\\
-%%WSREP%%Copy /usr/local/etc/mysql/conf.d/wsrep.cnf.sample to
+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.
-%%WSREP%%/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
-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
+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
-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>
-Using wsrep clustering requires adding a configuration file.
+<WRAP info round centeralign 60%><wrap em>zfs list</wrap>\\
-Copy /usr/local/etc/mysql/conf.d/wsrep.cnf.sample to
+<code>
-/usr/local/etc/mysql/conf.d/wsrep.cnf and change what you need there.
+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>
@@ Zeile 162: / Zeile 169: @@
 <WRAP group>
-<WRAP right 10%>dd dd dd</WRAP>
+<WRAP right 10%>xx yy zz</WRAP>
 <WRAP left 85%>
-==== ZFS-Dataset für die Daten ====
+==== 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>