Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen der Seite angezeigt.

--- freebsd:server:install [2026/02/12 22:48] – [SSH-Key kopieren und SSHD_CONFIG anpassen] hwehrs
+++ freebsd:server:install [2026/02/13 00:47] (aktuell) – [MariaDB] hwehrs
@@ Zeile 23: / Zeile 23: @@
 ----
-==== Erste Anpassungen ====
+===== Erste Anpassungen =====
 <WRAP group>
 <WRAP right 10%>{{ :freebsd:server:bsd_first_0001.png?direct&200|}}\\ {{ :freebsd:server:bsd_first_0002.png?direct&200|}}\\ {{ :freebsd:server:bsd_first_0003.png?direct&200|}}</WRAP>
 <WRAP left 85%>
-=== Paketverwaltung umstellen ===
+==== Paketverwaltung umstellen ====
 Paketverwaltung von vierteljährlichen Updates auf Aktuell umstellen.
@@ Zeile 44: / Zeile 44: @@
 <WRAP right 10%>{{ :freebsd:server:bsd_first_0004.png?direct&200|}}</WRAP>
 <WRAP left 85%>
-=== Installation vim ===
+==== Installation vim ====
 <code bash>
 pkg install -y vim
@@ Zeile 56: / Zeile 56: @@
 <WRAP right 10%>{{ :freebsd:server:bsd_first_0005.png?direct&200|}}</WRAP>
 <WRAP left 85%>
-=== Aliasse und Environment ===
+==== Aliasse und Environment ====
 <code bash>
 vim /etc/profile.d/local.sh
@@ Zeile 78: / Zeile 78: @@
 <WRAP right 10%>{{ :freebsd:server:bsd_first_0006.png?direct&200|}}\\ {{ :freebsd:server:bsd_first_0007.png?direct&200|}}</WRAP>
 <WRAP left 85%>
-=== ZFS-Pool auf die HDDs legen ===
+==== ZFS-Pool auf die HDDs legen ====
 Bei BSD gibt es die Verzeichnisstruktur **''/dev/disk/by-id''** nicht wie in Linux. Die Festplatten werden mit ihren regulären Laufwerksbezeichnungen (hier **''da0''**, **''da1''** und **''da2''** angegeben.
 <code bash>
@@ 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>