Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- abkoemmlinge_von_mysql_-_meine_favoriten [2021-10-26 15:04:37] – 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 12: / 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
-  apt install wget gnupg2 lsb-release curl
+oder so:
-  wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
+  > apt install wget gnupg2 lsb-release curl qpress
-  dpkg -i percona-release_latest.generic_all.deb
+  > wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
-  apt update
+  > dpkg -i percona-release_latest.generic_all.deb
-  apt install percona-release
-  percona-release setup ps80
+  > cat /etc/apt/sources.list.d/percona-pxc-80-release.list
-  oder
+  #
-  percona-release enable-only ps-80 release
+  # 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 update
-  apt install percona-xtradb-cluster
+  > 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 91: / 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.