[Building Sakai] for mysql configuration

[Steve Swinsburg]

Hi,

For 300 users you could keep it all local.

But yes, for scaling to multiple nodes you could put your db external to the application servers that run Sakai. In that situation, you adjust the db connection string to point to the external server where MySQL is running.

cheers,
Steve

On 26/01/2011, at 7:08 PM, Regimantas Maciulskis wrote:

> Hello,
> Now while i'm trying Sakai i using all (database and tomcat) in one server. 
> According to https://confluence.sakaiproject.org/display/DOC/Sakai+2.7 Load balancing and scaling paragraph in real situation i must use load balancer and 3 or more servers. 
> It's really bad use standalone server (for example if it would be about 300 users at all) ?  
> Thanks
> 
> 2011/1/26 Steve Swinsburg <steve.swinsburg at gmail.com>
> Hi,
> 
> Do you mean you want your database to be on a different server to where Sakai is installed? If so, yes, just update the connection URL. You also need to make sure the database is configured to accept external connections and the firewall is opened for the Sakai server.
> 
> cheers,
> Steve
> 
> On 26/01/2011, at 5:31 AM, Regimantas Maciulskis wrote:
> 
>> Hello,
>> I would like to ask, what changes i must do if i would like to have mysql in other server than application component of Sakai.
>> It would be enough to change url at javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8 to my server location or i must do something more?
>> Thank you.
>> Regimantas
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> 
>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110126/41d51b97/attachment.html