Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- abkoemmlinge_von_mysql_-_meine_favoriten [2021-10-26 14:43:08] – [2021] 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/#]]**
+  * **[[https://www.percona.com/doc/percona-repo-config/percona-release.html#deb-based-gnu-linux-distributions|Installing Percona XtraDB Cluster on Debian or Ubuntu]]**
   * [[https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/apt.html#apt]]
     * [[https://www.percona.com/doc/percona-repo-config/index.html]]
@@ Zeile 11: / Zeile 18: @@
 PXC-Repository (8.0):
-  > 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/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-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
+  > apt install percona-xtradb-cluster-server percona-xtrabackup-80
-  * PXC 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''
+  > wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
-    - ''dpkg -i percona-release_latest.generic_all.deb''
+  > dpkg -i percona-release_latest.generic_all.deb
-    - ''apt update''
-    - ''apt install percona-release''
+  > cat /etc/apt/sources.list.d/percona-pxc-80-release.list
-    - ''percona-release setup ps80''
+  #
-    - ''apt update''
+  # This repo is managed by "percona-release" utility, do not edit!
-    - ''apt install percona-xtradb-cluster''
+  #
+  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 enable pxc-80 release
+  > percona-release enable pxb-80 release
+  > percona-release enable tools release
+  > percona-release show
+  The following repositories are enabled on your system:
+  aptrelease
+  pxb-80 - release
+  pxc-80 - release
+  tools - release
+  <*> All done!
+  > apt update
+  > apt install percona-xtradb-cluster-server percona-xtrabackup-80
 [[https://repo.percona.com/yum/PERCONA-PACKAGING-KEY]]
@@ Zeile 87: / 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.