Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- percona_xtradb_cluster_pxc [2020-03-20 17:18:30] – [Mit xtrabackup ein Backup zurückspielen] manfred
+++ percona_xtradb_cluster_pxc [2021-10-26 16:21:28] (aktuell) – manfred
@@ Zeile 1: / Zeile 1: @@
 ====== Percona XtraDB Cluster (PXC) ======
+  * [[https://www.percona.com/doc/percona-repo-config/percona-release.html#deb-based-gnu-linux-distributions|Installing Percona XtraDB Cluster on Debian or Ubuntu]] -> direkt von Percona //(mit den Percona-Paketen ist der Admin-Aufwand am geringsten)//
+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/pxb-80/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-ps-80-release.list
+  > echo "deb http://repo.percona.com/tools/apt $(lsb_release -cs) main" >> /etc/apt/sources.list.d/percona-ps-80-release.list
+  > apt update
+  > apt install percona-xtradb-cluster-server percona-xtrabackup-80
+oder so:
+  > 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 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
+<file bash /etc/mysql/conf.d/max_flushing.cnf>
+[mysqld]
+# https://www.percona.com/blog/2020/05/07/prepare-mysql-for-a-safe-shutdown/
+# 4. Configure InnoDB for Max Flushing.
+# SET GLOBAL innodb_fast_shutdown=0; SET GLOBAL innodb_max_dirty_pages_pct=0; SET GLOBAL innodb_change_buffering='none';
+# SHOW VARIABLES LIKE 'innodb_fast_shutdown'; SHOW VARIABLES LIKE 'innodb_max_dirty_pages_pct'; SHOW VARIABLES LIKE 'innodb_change_buffering';
+innodb_fast_shutdown=0
+innodb_max_dirty_pages_pct=0
+innodb_change_buffering='none'
+</file>