89505

89505



Setting the Replication Master Configuration

On a replication master, you mustenable binary logging and establish a unique server ID. If this has

not already been done, this part of master setup reąuires a server restart.

Binary logging must be enabled on the master because the binary log is the basis for sending data

changes from the master to its slaves. If binary logging is not enabled, replication will not be possible.

Each server within a replication group must be configured with a unique server ID. This ID is used to

identify individual servers within the group, and must be a positive integer between 1 and (232)—1. How

you organize and selectthe numbers is entirely up to you.

To configure the binary log and server ID options, you will need to shut down your MySQL server and

edit the my. cnf or my. ini file. Add the following options to the configuration file within the [mysqld]

section. If these options already exist, but are commented out, uncommentthe options and alter them

according to your needs. For example, to enable binary logging using a log file name prefix of mysąlbin,

and configure a server ID of 1, use these lines:

[mysqld]

log-bin-mysąl-bin



Wyszukiwarka

Podobne podstrony:
Shutting Down and Starting Up Using the Windows Services Program On Microsoft Windows, you can also
Obtaining the Replication Master Binary Log Coordinates To configure replication on the slave you mu
start. 6.    Configure the slave with the replication coordinates from the master. Th
Creating a User for Replication Each slave must connect to the master using a MySQL user name and pa
Direct the slave to use the master. Instruct the slave to use the master as the replication data sou
Using Replication with Different Master and Slave Storage Engines It does not matter for the replica
Setting Up Replication Using GTlDs This section describes a process for configuring and starting GTI
Simple replication. This is the easiest way to reproduce all identifiers and transactions on a new s
image002 New Collected Works byIOBBT A.HEINLEIN and IMbutes to the Grand Master Edifted by Yoji Kond
SOM134 Illustraiive master plan Computer rendering: lakę and island features Computer rendering: acr
goalthecorporatemasters G O A L The Corporate Masters Any Corporate group wtth a Power oł 4 or
Oracle Net Listener Configuration On the database host, the Oracle Net listener (the listener), is a
Replication and Binary Logging Options and Variables The next fewsections contain information about
Chapter 4 - Configuration The web-based configuration tool lets you change advanced settings for the
image002 New Collected Works byIOBBT A.HEINLEIN and IMbutes to the Grand Master Edifted by Yoji Kond
IMG12 (10) Również Rosabeth Moss Kamer z Uniwersytetu Yale w książce The Change Masters wyodrębnia
451127 001 BASIC LINES Bloclcing in the Head Master the basie techni-que of blocking in parts be-for

więcej podobnych podstron