[Building Sakai] Sakai Clustering

[Kevin P. Foote]

Given 

This should be a quite simple task.. 

You already have two instances of sakai X up and working so each has its
own sakai.properties file.. 

Within each of your sakai.properties files change the database config
options to point / look for its database on your Server C..  Your
outcome could look something like this..  I use mysql

--> sakai.properties file clip <--
###################################################################
#### DB SETTINGS  #################################################
###################################################################
vendor at org.sakaiproject.db.api.SqlService=mysql
driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver
hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
url at javax.sql.BaseDataSource=jdbc:mysql://your.serverc.edu:3306/sakaitest?useUnicode=true&characterEncoding=UTF-8
validationQuery at javax.sql.BaseDataSource=show variables like 'version'
defaultTransactionIsolationString at javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
--> sakai.properties file clip <--

You will of course need to make sure your DB of choice is listening on
its required port for outside connections .. mysql (use /etc/my.cnf)

Just a note you also need to make sure you have your cluster settings in
your sakai.properties file somewhere :-)


------
thanks
  kevin.foote

On Wed, 16 Sep 2009, Given Shirinda wrote:

-> 
-> 
-> Hi Team. 
-> 
-> 
-> 
-> The questions are as follows. 
-> 
-> 
-> 
-> I have Server A and Server B both are running sakai 2.6 
-> 
-> 
-> 
-> I am using apach2 and mod_jk to load balance my sakai. 
-> 
-> 
-> 
-> 
-> 
-> The apache is delegating well the request to both Server A and Server B. 
-> 
-> 
-> I want both Server A and Server B to use one database which is on Server C  and the file server on Server D. 
-> 
-> 
-> 
-> I don't have any idea to do it. 
-> 
-> 
-> 
-> Please help. 
-> 
-> 
-> 
-> Best Regards 
-> 
-> 
-> 
-> Given 
-> 
->   
-> -- 
-> *********************************************** 
-> STATE INFORMATION TECHNOLOGY AGENCY 
-> *********************************************** 
-> MIYELANI GIVEN SHIRINDA. 
-> 
-> E-LEARNING CONSULTANT [SAKAI] 
-> DEPARTMENT: TECHNOLOGY LAB 
-> _______________________________________________ 
-> Tel :012 470 1526 
-> Cell:0730133879 
-> E-Mail 1:given.shirinda at sita.co.za 
-> E-Mail 2:mgshirinda at webmail.co.za 
-> _______________________________________________ 
-> 
-> Failure is simply the opportunity to begin again,this time more intelligently. 
->