Elektrooptik

Kategorie: Sonstige: Elektrooptik:


http://www.emo-elektronik.de/
Eintrag vom: 24.09.2013.



There are two core types of replication format Statement Based Replication (SBR) which replicates entire SQL statements and Row Based Replication (RBR) which replicates only the changed rows. You can also use a third variety Mixed Based Replication (MBR).
https://dev.mysql.com/doc/refman/8.4/en/replication.html
 MYSQL


In MySQL replication the terms "Master" and "Slave" (more recently referred to as "Primary" and "Replica") are used to describe the relationship between databases in a replication setup.
https://codemia.io/knowledge-hub/path/switch_master_and_slave_role_in_mysql
 HTTPS:/


This article explains how MySQL master?slave replication works covering its role in high?availability and read/write separation the responsibilities of the master and slave servers the IO and SQL threads common replication topologies and the step?by?step data flow from binlog to relay log.
https://www.besthub.dev/articles/understanding-mysql-master-slave-replication-architecture-principles-and-diagrams-a4b42b7ff314
 BESTHUB


In a Master-Slave Architecture the master node controls and coordinates multiple slave nodes. The master receives requests assigns tasks to slave nodes and collects the results after execution.
https://www.geeksforgeeks.org/system-design/master-slave-architecture/
 GEEKSFORGEEKS


Anyone using MySQL Replication is familiar with the terms: ?master? and ?slave?. The origins of these words are negative. That is clear. At MySQL we made the decision to change this terminology.
https://dev.mysql.com/blog-archive/mysql-terminology-updates/
 MYSQL



Wenn die Klügeren nachgeben, regieren die Dummköpfe die Welt.