Replikwando/Installation

From ISoft Wiki
< Replikwando
Revision as of 13:53, 29 January 2009 by Daytonlowell (talk | contribs) (New page: ==Setting Up Replikwando== # Setup the server side (Fonseca) ## Create a database where its name equals the customer's product code ## Create a '''MySQL user''' for the customer ## Setup p...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Setting Up Replikwando

  1. Setup the server side (Fonseca)
    1. Create a database where its name equals the customer's product code
    2. Create a MySQL user for the customer
    3. Setup 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
  2. Setup the client side
    1. Turn on bin 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:\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
  3. Start Replikwando
    1. Check the service side database to confirm things are getting replicated
  4. Make sure Replikwando is set to run when the user logs into Windows
    1. Create a Replikwando shortcut in C:\Documents and Settings\All Users\Start Menu\Programs\Startup