Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- abkoemmlinge_von_mysql_-_meine_favoriten [2021-10-26 14:18:09] – [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 10: / Zeile 17: @@
   * [[http://www.percona.com/doc/percona-xtrabackup/2.1/installation/apt_repo.html]]
+PXC-Repository (8.0):
+  > 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 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-server percona-xtrabackup-80
-=== Repository für PXC (8.0) einbinden ===
+oder so:
+  > apt install wget gnupg2 lsb-release curl qpress
-  echo "deb http://repo.percona.com/ps-80/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-ps-80-release.list
+  > wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
-  echo "#deb-src http://repo.percona.com/ps-80/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-ps-80-release.list
+  > dpkg -i percona-release_latest.generic_all.deb
-Apt mit neuem Repo bekanntmachen
+  > cat /etc/apt/sources.list.d/percona-pxc-80-release.list
-  apt update
+  #
+  # 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 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]]
+<file bash PERCONA-PACKAGING-KEY.txt>
+-----BEGIN PGP PUBLIC KEY BLOCK-----
+Version: GnuPG v1
-=== Repository für Percona-Server einbinden ===
+mQINBFd0veABEADyFa8jPHXhhX1XS9W7Og4p+jLxB0aowElk4Kt6lb/mYjwKmQ77
+ZKUAvb1xRYFU1/NEaykEl/jxE7RA/fqlqheZzBblB3WLIPM0sMfh/D4fyFCaKKF
+k2CSwXtYfhk9DOsBP2K+ZEg0PoLqMbLIBUxPl61ZIy2tnF3G+gCfGu6pMHK7WTtI
+nnruMKk51s9Itc9vUeUvRGDcFIiEEq0xJhEX/7J/WAReD5Am/kD4CvkkunSqbhhu
+B6DV9tAeEFtDppEHdFDzfHfTOwlHLgTvgVETDgLgTRXzztgBVKl7Gdvc3ulbtowB
+uBtbuRr49+QIlcBdFZmM6gA4V5P9/qrkUaarvuIkXWQYs9/8oCd3SRluhdxXs3xX
+/gQQXYHUhcdAWrqS56txncXf0cnO2v5kO5rlOX1ovpNQsc69R52LJKOLA1Kmjca
+JNtC+4e+SF2upK14gtXK384z7owXYUA4NRZOEu+UAw7wAoiIWPUfzMEHYi8I3Rsz
+EtpVyOQC5YyYgwzIdt4YxlVJ0CUoinvtIygies8LkA5GQvaGJHYG1aQ3i9WDddCX
+wtoV1uA4EZlEWjTXlSRc92jhSKut/EWbmYHEUhmvcfFErrxUPqirpVZHSaXY5Rdh
+KVFyx9JcRuIQ0SJxeHQPlaEkyhKpTDN5Cw7USLwoXfIu2w0w0W06LdXZ7wARAQAB
+tEZQZXJjb25hIE15U1FMIERldmVsb3BtZW50IFRlYW0gKFBhY2thZ2luZyBrZXkp
+IDxteXNxbC1kZXZAcGVyY29uYS5jb20+iQI3BBMBCgAhBQJXdL3gAhsDBQsJCAcD
+BRUKCQgLBRYCAwEAAh4BAheAAAoJEJM0ol+FB++l4koQAKkrRP+K/p/TGlnqlbNy
+S5gdSIB1hxT3iFwIdF9EPZq0U+msh8OY7omV/82rJp4T5cIJFvivtWQpEwpUjJtq
+BzVrQlF+12D1RFPSoXkmk6t4opAmCsAmAtRHaXIzU9WGJETaHl57Trv5IPMv15X3
+TmLnk1mDMSImJoxWJMyUHzA37BlPjvqQZv5meuweLCbL4qJS015s7Uz+1f/FsiDL
+srlE0iYCAScfBeRSKF4MSnk5huIGgncaltKJPnNYppXUb2wt+4X2dpY3/V0BoiG8
+YBxV6N7sA7lC/OoYF6+H3DMlSxGBQEb1i9b6ypwZIbG6CnM2abLqO67D3XGx559/
+FtAgxrDBX1f63MQKlu+tQ9mOrCvSbt+bMGT6frFopgH6XiSOhOiMmjUazVRBsXRK
+/HM5qIk5MK0tGPSgpc5tr9NbMDmp58OQZYQscslKhx0EDDYHQyHfYFS2qoduRwQG
+BgpZm2xjGM/auCvdZ+pxjqy7dnEXvMVf0i1BylkyW4p+oK5nEwY3KHljsRxuJ0+
+gjfyj64ihNMSqDX5k38T2GPSXm5XAN+/iazlIuiqPQKLZWUjTOwr2/AA6AztU/fm
+sXV2swz8WekqT2fphvWKUOISr3tEGG+HF1iIY43BoAMHYYOcdSI1ZODZq3Wic+zl
+N1WzPshDB+d3acxeV5JhstvPuQINBFd0veABEACfuHVbey5qG5P6rRhAX2pdd/f7
+iwHdcW1+evxCfCR5fHzsO1LRwlHM9GRqlztKzgxzAIfgUXqdMXUs6vW8agfku553
+h8gBqrhdq9NH65/YenzV/Sv9c/EGzsBQurau1RC4gfJ4jgAedu4FQKZvVr//0NTW
+uJm3el3orYYz4rLq79avSgD7Q/uK8/j71zgCJixsFzjC8ehRlOtMdetPTY36zc2L
+jQSMTSpE7SvEbrk6yDKpQvZabl3dmkEkBvoFpat7x+i3ZtBCzRFTx2rH/9DWKCO+
+SuGVBXs8vhLtAvKKjbWGGU9LrmESZcahI6fliH5w28NvpOuJlr8Rn/6jQmJDDPKO
+XKM8hpT6DBqIE99YqYLUzXAKf4Y88FyHvlO6kiVbXaOYz1OTqCWVqjaMYFbiPW
+NgDX0hyE9uG0lfNA9P5edqyPSEaTN+kpD9OVqG6R0uPBCFY8u25NrNRhMqIFQdv
+I54eEtN0ktFP0FrlFFkg6S+l+3Qsr9sMDKCUVTJ/BkKwqkdhTv5XY4KiIEJQjvMK
+r0vH5lYiPDGX/3KsJL+rxJjA++4Wh40WBLYDSDWSAfCPSokg1lRjOaMDhnH5YnUe
+Ek6Mhy61DQRsH+xEpeL/F1L06u0Wh+0iXqKXJA4jvU4XwGSkzg3yaablkYnun5my
+hIQYswIdCyEH4Wl3SQARAQABiQIfBBgBCgAJBQJXdL3gAhsMAAoJEJM0ol+FB++l
+xqkQAIC7jz1CWt+tbKgutLRFcxexNQZoTAAPTk3OjqqeCLWO1cmHtmjNSXTc5rpX
+vPEYQjzQpAARZxAppAdeJHBzm9Qrfiyo7TW8P0Gf9c9p1mPUtl2g0BNvRU7zYz
+gCF1aIwKtS+XO2UdTT56Gy5vaxd1BiTg8J9ytkIGSkuSXSOASeGC5RmN3SaD6yom
+Va483k9kVhhSOUzKwYK9f2WgGhI1xxpVF5LbbRhCoEz4ia/TqJoWdH/agul34AGW
+OgPRhMu+FEpb/nons73XTwQtcXiZAe9z4ZltVsSciolgRzPwkXxMmWVMme9YymVC
+PTrzxPi6nc6npSZzE275m02u86V2htwD2MbSuGmcTdmAPPfXgQ5XM57ELElDbNA1
+eN1jZAhzYBLv63X+nNOy6ysuac5Q7ozyBOIpNksLleA0+FzsnYmPlGqzYtnD6nFg
+lDn898jk/LWkwitL472fh8RRbDYffsXealiy6W2TYKrQl52ajLV7D5PUUS9xSlAP
+cdPSuXAzh7GhOKDommWwLfPo0uYN3Xja+AkW135ctz4evCpvZjkBTfog07FGlumd
+uUK5fHvJYiSyV1P5SKr4722C8jWCo2YcS+IsZgVFFuY1bG6HtiImpP75IM0G3g1u
+yd2OhF9nGDSxjp4kKWnUoGdV0P1bUXaAbvXRzlIcx7dOD7tZ
+=9ABW
+-----END PGP PUBLIC KEY BLOCK-----
+</file>
-      - ''apt install wget gnupg2 lsb-release curl''
+  > gpg --import PERCONA-PACKAGING-KEY.txt
-      - ''wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb''
+  > gpg -a --export 9334A25F8507EFA5 | apt-key add -
-      - ''dpkg -i percona-release_latest.generic_all.deb''
-      - ''apt update''
-      - ''apt install percona-release''
-      - ''percona-release setup ps80''
-      - ''apt update''
-      - ''apt install percona-xtradb-cluster''
-===== 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.