Nipunb: New page: ==Set Up== 2 Windows boxes. Machine 1 - Master IP: master.ip Has MySQL 5.1 *Installing PURL using MySQL as the backend on Machine 1. 1. Download PULR 1.4 2. Install specifying My...

2009-05-11T10:44:15Z

New page: ==Set Up== *2 Windows boxes. *Machine 1 - Master *IP: master.ip *Has MySQL 5.1 *Installing PURL using MySQL as the backend on Machine 1. **1. Download PULR 1.4 **2. Install specifying My...

New page

==Set Up==
*2 Windows boxes.
*Machine 1 - Master
*IP: master.ip
*Has MySQL 5.1

*Installing PURL using MySQL as the backend on Machine 1.
**1. Download PULR 1.4
**2. Install specifying MySQL as your backend.Imp Note: You would have a create a database schema'purls' on your MySQL using command line. The PURL installation would not do that for you. In other words, the PURL installation expects you to have a schema called 'purls'. This is will be used as the backend for storing the URLs.
**3. Go to the folder where you installed PURL, by default it is: C:\Program Files\PURLZ-Server-1.4
**4. Navigate to the bin folder, click on startup.bat to start the server. Imp Note: Default username password for the PURL server is: admin/password
**5. Create a backup of purls on Machine 1. On the command line, execute the following command:
mysqldump --user=root --password --opt purls > c:\purls_backup.sql

*Machine 2 - Slave
*IP: slave.ip
*Has MySQL 5.1

==Instructions for creating the replication==

*1. On Machine 1:
**Log on to MySQL
mysql -u root -p

*2. On Machine 1:
**Run the command
grant replication slave, replication client on *.* to 'replicator'@'slave.ip' identified by 'password';

*3. On Machine 1:
**Configure the master:Add the following lines to my.ini file in C:\Program Files\MySQL\MySQL 5.1 folder. Add the lines in the section [mysqld] after the line that specifies the port

server-id=1
log-bin="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/bin.log"
log-error="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/error.log"
log-bin-index="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/log-bin.index"
binlog-do-db=purls

*4.Restart the MySQL service on the master

*5. On Machine 2:
**Create a new empty database 'purls'

*6. On Machine 2:
**Restore the purls database
**On the command promt run the command
mysql -u root -p purls < C:\path_to_purls_backup\purls_backup.sql

*7. On Machine 2: Configure the slave: Add the following lines to my.ini file in C:\Program Files\MySQL\MySQL 5.1 folder. Add the lines in the section [mysqld] after the line that specifies the port

server-id=2
master-host=171.65.32.120
master-port=3306
master-user=replicator
master-password=password
replicate-do-db=purls

log-bin="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/bin.log"
log-bin-index="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/log-bin.index"
log-error="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/error.log"
relay-log="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/relay.log"
relay-log-info-file="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/relay-log.info"
relay-log-index="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/relay-log.index"

*8.Restart the MySQL service on the slave

*9. On the slave, log into MySQl
**i) start slave;
**ii)show slave status\G;
Make sure slave I/O running is yes
Make sure slave_SQL_running is yes

PURL Server - Revision history

Nipunb: New page: ==Set Up== *2 Windows boxes. *Machine 1 - Master *IP: master.ip *Has MySQL 5.1 *Installing PURL using MySQL as the backend on Machine 1. **1. Download PULR 1.4 **2. Install specifying My...

Nipunb: New page: ==Set Up== 2 Windows boxes. Machine 1 - Master IP: master.ip Has MySQL 5.1 *Installing PURL using MySQL as the backend on Machine 1. 1. Download PULR 1.4 2. Install specifying My...