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 alsoObtaining the Replication Master Binary Log Coordinates To configure replication on the slave you mustart. 6. Configure the slave with the replication coordinates from the master. ThCreating a User for Replication Each slave must connect to the master using a MySQL user name and paDirect the slave to use the master. Instruct the slave to use the master as the replication data souUsing Replication with Different Master and Slave Storage Engines It does not matter for the replicaSetting Up Replication Using GTlDs This section describes a process for configuring and starting GTISimple replication. This is the easiest way to reproduce all identifiers and transactions on a new simage002 New Collected Works byIOBBT A.HEINLEIN and IMbutes to the Grand Master Edifted by Yoji KondSOM134 Illustraiive master plan Computer rendering: lakę and island features Computer rendering: acrgoalthecorporatemasters G O A L The Corporate Masters Any Corporate group wtth a Power oł 4 orOracle Net Listener Configuration On the database host, the Oracle Net listener (the listener), is aReplication and Binary Logging Options and Variables The next fewsections contain information aboutChapter 4 - Configuration The web-based configuration tool lets you change advanced settings for theimage002 New Collected Works byIOBBT A.HEINLEIN and IMbutes to the Grand Master Edifted by Yoji KondIMG12 (10) Również Rosabeth Moss Kamer z Uniwersytetu Yale w książce The Change Masters wyodrębnia451127 001 BASIC LINES Bloclcing in the Head Master the basie techni-que of blocking in parts be-forwięcej podobnych podstron