Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- abkoemmlinge_von_mysql_-_meine_favoriten [2021-10-26 15:28:55] – manfred
+++ abkoemmlinge_von_mysql_-_meine_favoriten [2021-10-29 09:57:12] (aktuell) – manfred
@@ Zeile 2: / Zeile 2: @@
-===== 2021 =====
+===== MySQL =====
+[[::MySQL]]
+==== 2021 ====
   * **[[https://www.percona.com/downloads/Percona-XtraDB-Cluster-LATEST/#]]**
@@ Zeile 12: / Zeile 17: @@
   * [[http://www.percona.com/doc/percona-xtrabackup/2.1/installation/apt_repo.html]]
-alternative Einrichtung vom PXC-Repository (8.0):
+PXC-Repository (8.0):
-  > echo "deb http://repo.percona.com/pxc-80/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-ps-80-release.list
+  > echo "deb http://repo.percona.com/ps-80/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-ps-80-release.list
-  > echo "#deb-src http://repo.percona.com/ps-80/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-ps-80-release.list
+  > echo "deb http://repo.percona.com/pxc-80/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-pxc-80-release.list
-  > echo "deb http://repo.percona.com/pxb-80/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-ps-80-release.list
+  > echo "deb http://repo.percona.com/pxb-80/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-pxb-80-release.list
+  > echo "deb http://repo.percona.com/tools/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-tools-80-release.list
   > apt update
-  > apt install percona-xtradb-cluster-server
+  > apt install percona-xtradb-cluster-server percona-xtrabackup-80
-offiziell empfohlene Einrichtung vom PXC-Repository (8.0):
+oder so:
-  > apt install wget gnupg2 lsb-release curl
+  > apt install wget gnupg2 lsb-release curl qpress
   > wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
   > dpkg -i percona-release_latest.generic_all.deb
+  > cat /etc/apt/sources.list.d/percona-pxc-80-release.list
+  #
+  # This repo is managed by "percona-release" utility, do not edit!
+  #
+  deb http://repo.percona.com/pxc-80/apt focal main
+  deb-src http://repo.percona.com/pxc-80/apt focal main
   > apt update
   > apt install percona-release
-  > percona-release setup pxc-80
-  oder
   > percona-release enable pxc-80 release
-  oder
+  > percona-release enable pxb-80 release
-  > percona-release enable-only pxc-80 release
-  oder
   > percona-release enable tools release
@@ Zeile 38: / Zeile 48: @@
   aptrelease
   pxb-80 - release
-  ps-80 - release
+  pxc-80 - release
+  tools - release
   <*> All done!
   > apt update
-  > apt install percona-xtradb-cluster-server
+  > apt install percona-xtradb-cluster-server percona-xtrabackup-80
 [[https://repo.percona.com/yum/PERCONA-PACKAGING-KEY]]
@@ Zeile 104: / Zeile 115: @@
-===== 2019 =====
+==== 2019 ====
 [[https://www.informatik-aktuell.de/betrieb/datenbanken/mariadb-und-mysql-vergleich-der-features.html|MySQL]] in der Version ''5.7'', ältere haben Probleme mit Fremdschlüssel und der Geschwindigkeit, neuere bieten z.Z. noch keinen nutzbaren Vorteil.