Difference between revisions of "Replikwando/Installation"

From ISoft Wiki
Jump to navigationJump to search
m (Don't need to echo the page title!)
Line 10: Line 10:
## Restart the mysql service
## Restart the mysql service
# Download Replikwando from [http://dl.isoftdata.com dl.isoftdata.com]
# Download Replikwando from [http://dl.isoftdata.com dl.isoftdata.com]
# Place the files in '''"C:\Replikwando\"'''
# Place the files in '''"C:\ISoft Data Systems\Replikwando\"'''
# Open '''Replication.ini''' and change '''binologpath''' and '''mysqlbinpath''' if needed.
# Open '''Replication.ini''' and change '''binologpath''' and '''mysqlbinpath''' if needed.
# Setup the '''[todatabase1]''' section to correspond to the server side setting just setup (host should be '''backup.isoftdata.com''', '''port: 3306''')
# Setup the '''[todatabase1]''' section to correspond to the server side setting just setup (host should be '''backup.isoftdata.com''', '''port: 3306''')

Revision as of 12:09, 11 February 2009

Server Side

  1. Create a database on Fonseca where the database name equals the customer's product code
  2. Create a MySQL user for the customer
  3. Setup full privileges for that user to access the the database just created
  4. Go to the mysql database and give the user "Super" privileges in the user table

Client Side

  1. Turn on binary logging
    1. Open the my.ini and enter log-bin under the mysqld section
    2. Restart the mysql service
  2. Download Replikwando from dl.isoftdata.com
  3. Place the files in "C:\ISoft Data Systems\Replikwando\"
  4. Open Replication.ini and change binologpath and mysqlbinpath if needed.
  5. Setup the [todatabase1] section to correspond to the server side setting just setup (host should be backup.isoftdata.com, port: 3306)
  6. Save replication.ini
  7. Make sure Replikwando is set to run when the user logs into Windows
  8. Create a Replikwando shortcut in C:\Documents and Settings\All Users\Start Menu\Programs\Startup

Finishing Up

  • Check the server side database to confirm things are getting replicated