Installation guidelines RepServer 15.7.1
This page describes how to install and configure a Sybase Replication Server version 15.7.1. You will also learn how to connect to the server, stop and restart it.
- 1 Get the software
- 2 Storage requirements
- 3 Memory requirements
- 4 Prepare the operating system
- 5 Installation of the software
- 6 Setup your environment
- 7 Create the Replication Server
- 8 Basic Replication server tasks
- 9 Recommended settings
- 10 All done
Get the software
First download the software for Replication Server.
For a licensed version you need to go here: http://sybase.subscribenet.com (account required) or to the eShop at sybase.com: http://eshop.sybase.com/eshop/buy?id=22574 Downloads are also available at the Sybase download center at http://downloads.sybase.com/swd/base.do?client=support. Once registered you can download the latest EBF (patch) for the desired platform. An EBF can sometimes also be used for a full installation.
Make sure that the filesystem for the Sybase software is big enough. A full installation needs approx. 570 Mb so 2 Gb should give you enough room to handle upgrades too. In this case we install the software in /opt/sybase/rep1571.
Replication server partitions (stable devices) will be stored /var/sybase. The mininum size of the initial partition is 20 Mb. Additional partitions that may be needed to queue up data must be taken into account as well. The requirements vary per environment and usage. When you run out of space in partitions you can always add more.
The partitions can be created on raw devices or on filesystem files (opened with Direct I/O).
When running replication server on a virtualized environment, you need 300 Mb of RAM as a bare minimum. Increase memory when needed.
Prepare the operating system
Become root and add a group "sybase" and a user "sybase" to the system. Also create the needed directories. Strictly spoken, the usage of the username and groupname called "sybase" is not needed, any username is fine.
mkdir -p /opt/sybase mkdir -p /var/sybase groupadd sybase useradd -g sybase -d /opt/sybase sybase passwd sybase chown sybase:sybase /opt/sybase chown sybase:sybase /var/sybase
Installation of the software
Now, switch to the newly created user:
su - sybase
You should now be in the directory /opt/sybase. Make a work directory and put the downloaded Sybase software in it.
mkdir install cd install <put the software in this directory> tar -xf <software-distro>
Start the installation (when using an EBF download as installation file you may need to go into a subdirectory)
Use /opt/sybase/rep1571 as the destination directory, do a full installation, and continue installation without a license key, no e-mail alerts. Do not start the sample replication server as we will do a manual configuration.
When the installation has finished successful you can safely remove the work directory and the installation package.
Errors when running setup.bin
java not found
When you get an error like this
exec: 2508: /tmp/install.dir.527/Linux/resource/jre/bin/java: not found
you need to install software to run 32 bit binaries on a 64 bit machine. Become root again and install the required packages.
apt-get install ia32-libs
yum install glibc-devel.i386
Ignore the error "Fontconfig error: Cannot load default config file" if you get it.
Setup your environment
In /opt/sybase/rep1571 you will find files like SYBASE.csh, SYBASE.sh and SYBASE.env. Depending on the type of shell you use you need to source in one of these. For instance, when your default shell is bash you should do this:
it should return /opt/sybase/rep1571. Is is fairly common to activate the SYBASE.sh script (or similar one) from your login script.
When you have generated a licence file through http://sybase.subscribenet.com install it in the directory $SYBASE/SYSAM-2_0/licenses
You can run without a license for 30 days (grace period).
Create the Replication Server
A Replication Server needs an system database (RSSD) to store its definitions. You can choose between a Sybase ASE (RSSD) or an embedded SQL Anywhere database (ERSSD). The choice between them depends on licensing costs, availabity of hardware or personal preference. After configuring replication server with either RSSD or ERSSD you cannot switch between them.
When you select an ERSSD you do not need to manage it, it is all handled automatically. When choosing an RSSD (Sybase ASE) there is an extra layer of software that you need to install, manage and probably pay for as well.
In this document an ERSSD server will be used for the Replication Server System Database.
Create the directories for these servers:
cd /opt/sybase mkdir admin mkdir admin/REP1 mkdir admin/REP1_ERSSD mkdir /var/sybase/REP1 mkdir -p /var/sybase/REP1_ERSSD/database mkdir /var/sybase/REP1_ERSSD/translog mkdir /var/sybase/REP1_ERSSD/backup
Now go to the "/opt/sybase/admin/REP1" directory and create a resource file. Use the following template as an example, call it REP1.rs. You can also use the Sybase supplied resource file, it's $SYBASE/$SYBASE_REP/init/rs/install.rs
sybinit.product: rs rs.rs_operation: rs_install rs.rs_idserver_name: REP1 rs.rs_id_server_is_rs_server: yes # Password for rs_REP1_id_user (RS to RS connectivity) rs.rs_idserver_pass: secret123 rs.rs_name: REP1 # Password for "sa" user rs.rs_rs_sa_pass: secret123 rs.rs_needs_repagent: yes rs.rs_rs_errorlog: /opt/sybase/admin/REP1/REP1.errorlog rs.rs_rs_cfg_file: /opt/sybase/admin/REP1/REP1.cfg rs.rs_rssd_embedded: yes rs.rs_erssd_name: REP1_ERSSD rs.rs_erssd_database_dir: /var/sybase/REP1_ERSSD/database rs.rs_erssd_translog_dir: /var/sybase/REP1_ERSSD/translog rs.rs_erssd_backup_dir: /var/sybase/REP1_ERSSD/backup rs.rs_erssd_errorlog_dir: /opt/sybase/admin/REP1_ERSSD # Password for REP1_RSSD_prim rs.rs_rssd_prim_pass: secret123 # Password for REP1_RSSD_maint rs.rs_rssd_maint_pass: secret123 rs.rs_diskp_name: /var/sybase/REP1/part1.dat rs.rs_diskp_lname: part1 # Password for REP1_rsi rs.rs_rs_pass: secret123 # Password for REP1_ltm rs.rs_ltm_rs_pass: secret123 rs.rs_id_server_network_protocol_list: tcp rs.rs_idserver_hostname: <put your hostname here> rs.rs_idserver_port: 5000 rs.rs_rs_port: 5000
When the partition as defined by "rs.rs_diskp_name" is on filesystem, you need to create the file with the "touch" command.
Add the entries for repserver and ERSSD to $SYBASE/interfaces
REP1 master tcp ether <put your hostname here> 5000 query tcp ether <put your hostname here> 5000 REP1_ERSSD query tcp ether <put your hostname here> 5001
Now build the server with the command:
$SYBASE/$SYBASE_REP/install/rs_init -r REP1.rs
After a successful creation you can connect to the replication server using the command line tool isql. The login “sa" has been created, with the password that was specified in REP1.rs file. At the prompt of isql you can type a command or type exit to exit.
isql -Usa -Psecret123 -SREP1 admin who go exit
To connect to the ERSSD server cou can use the REP1_RSSD_prim login.
isql -UREP1_RSSD_prim -Psecret123 -SREP1_ERSSD sa_conn_info go exit
Basic Replication server tasks
To shutdown Replication Server
isql -Usa -Psecret123 -SREP1 shutdown go
To start Replication Server
cd /opt/sybase/admin/REP1 nohup ./RUN_REP1 &
When replication server has been started you can check if the status is ok by running the "admin health" command. It should return "HEALTHY". When the status is not healthy check the errorlog file (at /opt/sybase/admin/REP1/REP1.errorlog) for the cause. Please note that immediately after a start of replication server it may take a couple of minutes before all processes are up and running.
isql -Usa -Psecret123 -SREP1 admin health go exit
The following settings are recommended to improve stability and performance. To change a setting, use isql and log on with the sa account
isql -Usa -Psecret123 -SREP1
Enable direct i/o
Set sqm_write_flush to dio to enable direct I/O on the partitions. A reboot is needed to activate the setting.
configure replication server set sqm_write_flush to 'dio' go shutdown go
Increase sqt_max_cache_size when the following message is shown the errorlog:
WARNING #24068 SQT(105:1 DIST PRIM.tpcc) - t/sqtint.c(1333) SQT cache size is too low to load more than one transaction into the cache.
As a rule of thumb you can double the value (default is 1048576 for 32 bit, 20971520 for 64 bit) but don't overdo it. Retrieve the current value with
admin config,sqt_max_cache_size go
configure replication server set sqt_max_cache_size to '41943040' go
Increasing the value may require that you increase the allocated amount of memory for replication server (setting memory_limit).
Increase the value for sts_cachesize when this message is printed in the errorlog:
I. 2013/01/12 15:39:53. A cached row for system table ‘rs_columns’ was swapped out of the cache in order to accomodate another row.
configure replication server set sts_cachesize to '2000' go
You can retrieve the current value with
admin config,sts_cachesize go
Happy Sybase-ing with your new server!!
Installation guide for Unix http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32237.1571/doc/html/title.html