Didn't get a response....

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Didn't get a response....

Cory Robin
Any way to move the site DB to external SQL source?  (Lasso 7.x)

Cory.


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Didn't get a response....

Fletcher Sandbeck
On 6/6/05 at 1:42 PM by [hidden email] (Cory Robin):

>Any way to move the site DB to external SQL source?  (Lasso 7.x)

No, you can move the sessions table to an external source, but you can't move the entire site database.  Why do you want to?

[fletcher]
--
Fletcher Sandbeck                         [hidden email]
Lasso Product Specialist              [hidden email]
OmniPilot Software, Inc.                http://www.omnipilot.com

--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Didn't get a response....

Eric Browning
In reply to this post by Cory Robin
We want to cluster our database servers using MySQL cluster running  
on linux boxes and we'd like to keep all the sessions stuff on the  
fastest database server.  We need our solution to be N+1, fault  
tolerant and having a single box be the sole sessions database server  
is the biggest single point of failure in this system.  If sessions  
is on a fault tolerant cluster then if any of the lasso boxes go  
down, no biggie.

----
Eric Browning
CIO SkyVantage
www.skyvantage.com
----
This e-mail is confidential and may also be privileged.  If you are  
not the
intended recipient, please notify us immediately. You should not copy  
or use it for any purpose, nor disclose its contents to any other  
person.

On Jun 6, 2005, at 2:39 PM, Fletcher Sandbeck wrote:

> On 6/6/05 at 1:42 PM by [hidden email] (Cory Robin):
>
>
>> Any way to move the site DB to external SQL source?  (Lasso 7.x)
>>
>
> No, you can move the sessions table to an external source, but you  
> can't move the entire site database.  Why do you want to?
>
> [fletcher]
> --
> Fletcher Sandbeck                         [hidden email]
> Lasso Product Specialist              [hidden email]
> OmniPilot Software, Inc.                http://www.omnipilot.com
>
> --
> ------------------------------
> Lasso Support: http://support.omnipilot.com/
> Search the list archives: http://www.listsearch.com/lassotalk.lasso
> Manage your list subscription:
> http://www.listsearch.com/lassotalk.lasso?manage
>


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Didn't get a response....

Fletcher Sandbeck
In reply to this post by Cory Robin
On 6/6/05 at 2:51 PM by [hidden email] (Eric Browning):

>We want to cluster our database servers using MySQL cluster running  
>on linux boxes and we'd like to keep all the sessions stuff on the  
>fastest database server.  We need our solution to be N+1, fault  
>tolerant and having a single box be the sole sessions database server  
>is the biggest single point of failure in this system.  If sessions  
>is on a fault tolerant cluster then if any of the lasso boxes go  
>down, no biggie.

You can move the sessions table to your MySQL cluster.  The controls are in the Setup > Site/Global > Sessions section of Lasso Site Administration.  This will allow you to use the same sessions table for each of your Lasso machines.  The other site tables like email and scheduled events will still be distinct on each Lasso machine.

[fletcher]
--
Fletcher Sandbeck                         [hidden email]
Lasso Product Specialist              [hidden email]
OmniPilot Software, Inc.                http://www.omnipilot.com

--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Didn't get a response....

Eric Browning
In reply to this post by Cory Robin
That's great, thanks Fletcher!
----
Eric Browning
CIO SkyVantage
www.skyvantage.com
----
This e-mail is confidential and may also be privileged.  If you are  
not the
intended recipient, please notify us immediately. You should not copy  
or use it for any purpose, nor disclose its contents to any other  
person.

On Jun 6, 2005, at 2:58 PM, Fletcher Sandbeck wrote:

> On 6/6/05 at 2:51 PM by [hidden email] (Eric Browning):
>
>
>> We want to cluster our database servers using MySQL cluster running
>> on linux boxes and we'd like to keep all the sessions stuff on the
>> fastest database server.  We need our solution to be N+1, fault
>> tolerant and having a single box be the sole sessions database server
>> is the biggest single point of failure in this system.  If sessions
>> is on a fault tolerant cluster then if any of the lasso boxes go
>> down, no biggie.
>>
>
> You can move the sessions table to your MySQL cluster.  The  
> controls are in the Setup > Site/Global > Sessions section of Lasso  
> Site Administration.  This will allow you to use the same sessions  
> table for each of your Lasso machines.  The other site tables like  
> email and scheduled events will still be distinct on each Lasso  
> machine.
>
> [fletcher]
> --
> Fletcher Sandbeck                         [hidden email]
> Lasso Product Specialist              [hidden email]
> OmniPilot Software, Inc.                http://www.omnipilot.com
>
> --
> ------------------------------
> Lasso Support: http://support.omnipilot.com/
> Search the list archives: http://www.listsearch.com/lassotalk.lasso
> Manage your list subscription:
> http://www.listsearch.com/lassotalk.lasso?manage
>


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage