Difference between revisions of "Replikwando/Installation"

From ISoft Wiki
Jump to: navigation, search
(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...)
 
(Broke into sections, cleaned up a bit, added to "Replikwando" category)
Line 1: Line 1:
==Setting Up Replikwando==
+
== Setting Up Replikwando ==
# Setup the server side (Fonseca)
+
 
## Create a database where its name equals the customer's product code
+
=== Server Side ===
## Create a '''MySQL user''' for the customer
+
# Create a database on Fonseca where the database name equals the customer's product code
## Setup privileges for that user to access the the database just created
+
# Create a '''MySQL user''' for the customer
## Go to the '''mysql''' database and give the user '''"Super" privileges''' in the '''user table'''
+
# Setup full privileges for that user to access the the database just created
# Setup the client side
+
# Go to the '''mysql''' database and give the user '''"Super" privileges''' in the '''user table'''
## Turn on '''bin logging'''
+
 
### Open the my.ini and enter '''log-bin''' under the '''mysqld''' section
+
=== Client Side ===
### Restart the mysql service
+
# Turn on '''binary logging'''
## Download Replikwando from dl.isoftdata.com
+
## Open the my.ini and enter '''log-bin''' under the '''mysqld''' section
## Place the files in '''"C:\Replikwando\"'''
+
## Restart the mysql service
## Open '''Replication.ini''' and change '''binologpath''' and '''mysqlbinpath''' if needed.
+
# Download Replikwando from [http://dl.isoftdata.com dl.isoftdata.com]
## Setup the '''[todatabase1]''' section to correspond to the server side setting just setup (host should be '''backup.isoftdata.com''', '''port: 3306''')
+
# Place the files in '''"C:\Replikwando\"'''
## Save '''replication.ini'''
+
# Open '''Replication.ini''' and change '''binologpath''' and '''mysqlbinpath''' if needed.
# Start Replikwando
+
# Setup the '''[todatabase1]''' section to correspond to the server side setting just setup (host should be '''backup.isoftdata.com''', '''port: 3306''')
## Check the service side database to confirm things are getting replicated
+
# Save '''replication.ini'''
 
# Make sure Replikwando is set to run when the user logs into Windows
 
# Make sure Replikwando is set to run when the user logs into Windows
## Create a Replikwando shortcut in '''C:\Documents and Settings\All Users\Start Menu\Programs\Startup'''
+
# 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
 +
 
 +
[[Category:Replikwando]]

Revision as of 16:30, 29 January 2009

Setting Up Replikwando

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:\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