MariaDB Replikation (Ubuntu) - Versionsgeschichte

Martin Kirner: /* Synchronen Status wiederherstellen */

2023-06-02T14:46:43Z

Synchronen Status wiederherstellen

← Nächstältere Version		Version vom 2. Juni 2023, 16:46 Uhr
Zeile 263:		Zeile 263:

	== Synchronen Status wiederherstellen ==		== Synchronen Status wiederherstellen ==

	~~{{note\|Noch in Bearbeitung}}~~

	=== Server B - Teil 1 ===		=== Server B - Teil 1 ===

Martin Kirner: /* Server A - Teil 2 */

2023-06-02T14:46:28Z

Server A - Teil 2

← Nächstältere Version		Version vom 2. Juni 2023, 16:46 Uhr
Zeile 314:		Zeile 314:

	==== Slave neu konifgurieren ====		==== Slave neu konifgurieren ====

			Daten aus <code>mysql> SHOW MASTER STATUS;</code> auf Server B verwenden:

	<pre>		<pre>

Martin Kirner: /* Slave neu konifgurieren */

2023-06-02T14:46:11Z

Slave neu konifgurieren

← Nächstältere Version		Version vom 2. Juni 2023, 16:46 Uhr
Zeile 301:		Zeile 301:

	==== Slave neu konifgurieren ====		==== Slave neu konifgurieren ====

			Daten aus <code>mysql> SHOW MASTER STATUS;</code> auf Server A verwenden:

	<pre>		<pre>

Martin Kirner: /* Synchronen Status wiederherstellen */

2023-06-02T14:44:39Z

Synchronen Status wiederherstellen

← Nächstältere Version		Version vom 2. Juni 2023, 16:44 Uhr
Zeile 265:		Zeile 265:

	{{note\|Noch in Bearbeitung}}		{{note\|Noch in Bearbeitung}}

			=== Server B - Teil 1 ===

			<pre>
			mysql> STOP SLAVE;
			</pre>

	=== Server A - Teil 1 ===		=== Server A - Teil 1 ===

	==== Datenbanken exportieren ====		==== Datenbanken exportieren ====

			<pre>
			mysql> RESET MASTER;
			mysql> FLUSH TABLES WITH READ LOCK;
			</pre>

	<pre>		<pre>
Zeile 274:		Zeile 285:
	mysqldump -u root -p powerdns > powerdns-dump.sql		mysqldump -u root -p powerdns > powerdns-dump.sql
	</pre>		</pre>

	~~=== Server B - Teil 1 ===~~

	<pre>		<pre>
	~~STOP SLAVE~~;		mysql> UNLOCK TABLES;
			mysql> SHOW MASTER STATUS;
	</pre>		</pre>

			=== Server B - Teil 2 ===

	==== Datenbanken importieren ====		==== Datenbanken importieren ====
Zeile 287:		Zeile 299:
	mysqldump -u root -p powerdns < powerdns-dump.sql		mysqldump -u root -p powerdns < powerdns-dump.sql
	</pre>		</pre>

			==== Slave neu konifgurieren ====

	<pre>		<pre>
	CHANGE MASTER TO MASTER_LOG_FILE = 'master1-bin.000001', MASTER_LOG_POS = 330;		mysql> RESET SLAVE;
			mysql> CHANGE MASTER TO MASTER_LOG_FILE = 'master1-bin.000001', MASTER_LOG_POS = 330;
			mysql> START SLAVE;
			mysql> SHOW MASTER STATUS;
	</pre>		</pre>

			=== Server A - Teil 2 ===

			==== Slave neu konifgurieren ====

			<pre>
			mysql> STOP SLAVE;
			mysql> RESET SLAVE;
			mysql> CHANGE MASTER TO MASTER_LOG_FILE = 'master2-bin.000026', MASTER_LOG_POS = 15048;
			mysql> START SLAVE;
			</pre>

			=== Slave-Status kontrollieren ===

			Auf beiden Servern den Status kontrollieren:

	<pre>		<pre>
	~~CHANGE MASTER TO MASTER_LOG_FILE = 'master2-bin.000026', MASTER_LOG_POS = 15048;~~		mysql> show slave status \G
	</pre>		</pre>

Martin Kirner: /* Synchronen Status wiederherstellen */

2023-06-02T14:27:04Z

Synchronen Status wiederherstellen

← Nächstältere Version		Version vom 2. Juni 2023, 16:27 Uhr
Zeile 265:		Zeile 265:

	{{note\|Noch in Bearbeitung}}		{{note\|Noch in Bearbeitung}}

			=== Server A - Teil 1 ===

			==== Datenbanken exportieren ====

	<pre>		<pre>
	mysqldump -u root -p ddns > ddns-dump.sql		mysqldump -u root -p ddns > ddns-dump.sql
	mysqldump -u root -p powerdns > powerdns-dump.sql		mysqldump -u root -p powerdns > powerdns-dump.sql
			</pre>

			=== Server B - Teil 1 ===

			<pre>
			STOP SLAVE;
			</pre>

			==== Datenbanken importieren ====

			<pre>
			mysqldump -u root -p ddns < ddns-dump.sql
			mysqldump -u root -p powerdns < powerdns-dump.sql
	</pre>		</pre>

	<pre>		<pre>
	CHANGE MASTER TO MASTER_LOG_FILE = 'master1-bin.000001', MASTER_LOG_POS = 330;		CHANGE MASTER TO MASTER_LOG_FILE = 'master1-bin.000001', MASTER_LOG_POS = 330;
			</pre>

			<pre>
	CHANGE MASTER TO MASTER_LOG_FILE = 'master2-bin.000026', MASTER_LOG_POS = 15048;		CHANGE MASTER TO MASTER_LOG_FILE = 'master2-bin.000026', MASTER_LOG_POS = 15048;
	</pre>		</pre>

Martin Kirner: /* Server B (10.0.0.167) */

2023-06-02T14:21:32Z

Server B (10.0.0.167)

← Nächstältere Version		Version vom 2. Juni 2023, 16:21 Uhr
Zeile 113:		Zeile 113:
	</pre>		</pre>

	Als ~~nächsten~~ den Slave stoppen:		Als nächstes den Slave stoppen:

	<pre>		<pre>

Martin Kirner: /* Synchronen Status wiederherstellen */

2023-05-29T15:15:54Z

Synchronen Status wiederherstellen

← Nächstältere Version		Version vom 29. Mai 2023, 17:15 Uhr
Zeile 265:		Zeile 265:

	{{note\|Noch in Bearbeitung}}		{{note\|Noch in Bearbeitung}}

			<pre>
			mysqldump -u root -p ddns > ddns-dump.sql
			mysqldump -u root -p powerdns > powerdns-dump.sql
			</pre>

			<pre>
			CHANGE MASTER TO MASTER_LOG_FILE = 'master1-bin.000001', MASTER_LOG_POS = 330;
			CHANGE MASTER TO MASTER_LOG_FILE = 'master2-bin.000026', MASTER_LOG_POS = 15048;
			</pre>

			== Links ==

	[https://tecadmin.net/reset-re-sync-mysql-master-slave-replication/ https://tecadmin.net/reset-re-sync-mysql-master-slave-replication/]		[https://tecadmin.net/reset-re-sync-mysql-master-slave-replication/ https://tecadmin.net/reset-re-sync-mysql-master-slave-replication/]

Martin Kirner: /* Probleme */

2023-05-15T22:34:56Z

Probleme

← Nächstältere Version		Version vom 16. Mai 2023, 00:34 Uhr
Zeile 261:		Zeile 261:
	+---------------------------------------------+------------------------+		+---------------------------------------------+------------------------+
	</pre>		</pre>

			== Synchronen Status wiederherstellen ==

			{{note\|Noch in Bearbeitung}}

			[https://tecadmin.net/reset-re-sync-mysql-master-slave-replication/ https://tecadmin.net/reset-re-sync-mysql-master-slave-replication/]

			[https://stackoverflow.com/questions/2366018/how-to-re-sync-the-mysql-db-if-master-and-slave-have-different-database-incase-o https://stackoverflow.com/questions/2366018/how-to-re-sync-the-mysql-db-if-master-and-slave-have-different-database-incase-o]

	== Probleme ==		== Probleme ==

Martin Kirner: /* Server A (10.0.0.157) - Teil 1 */

2020-04-02T12:24:02Z

Server A (10.0.0.157) - Teil 1

← Nächstältere Version		Version vom 2. April 2020, 14:24 Uhr
Zeile 20:		Zeile 20:
	replicate-do-db = powerdns		replicate-do-db = powerdns
	replicate-do-db = ddns		replicate-do-db = ddns
			# Basename for all log files and the .pid file. This sets all log file names
			# at once (in 'datadir') and is normally the only option you need for specifying
			# log files. This is especially recommended to be set if you are using
			# replication as it ensures that your log file names are not dependent on your
			# host name.
	log-basename = master1		log-basename = master1
	</pre>		</pre>

Martin Kirner: /* Server B (10.0.0.167) */

2020-04-02T12:23:35Z

Server B (10.0.0.167)

← Nächstältere Version		Version vom 2. April 2020, 14:23 Uhr
Zeile 82:		Zeile 82:
	replicate-do-db = powerdns		replicate-do-db = powerdns
	replicate-do-db = ddns		replicate-do-db = ddns
			# Basename for all log files and the .pid file. This sets all log file names
			# at once (in 'datadir') and is normally the only option you need for specifying
			# log files. This is especially recommended to be set if you are using
			# replication as it ensures that your log file names are not dependent on your
			# host name.
	log-basename = master2		log-basename = master2
	</pre>		</pre>