PURL Server

From NCBO Wiki
Jump to: navigation, search

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

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox