Re: [ZODB-Dev] RelStorage - How can I set up one database per web site?
Sorry for the confusion
It is a buildout feature to make your variable substitutions which is
what Ive done there.
Replicas are for redundant MySQL servers. I doubt you need that. Just
check the relstorage docs to see what options you need.
Dylan Jay
Technical solution manager
PretaWeb 99552830
On 17/10/2011, at 9:09 PM, Ricardo Dias Marques wrote:
> Hi Dylan,
>
> On Wed, Oct 12, 2011, Dylan Jay wrote:
>
>> It looks a bit like this if you are using zope2instance recipe in buildout
>>
>> zope-conf-additional +=
>> %import relstorage
>>
>>
>>mount-point /www/mnt
>>cache-size 5000
>>
>>blob-dir ${buildout:directory}/var/blobcache-www
>>shared-blob-dir off
>>replica-conf ${mysql-hosts:output}
>>
>>db blah
>> user blah
>> passwd blah
>>
>>
>>
>>
>
> Thanks Dylan! :) Based on your tip and on Darryl Dixon's tip, I'm
> making some progress. I already managed to import one "Data.fs" file
> to a database, using "zodbconvert". Now I have to start experimenting
> with Apache's configuration, so I can test if the import has been
> truly successful.
>
> BTW: I can't find any documentation about the "mysql-hosts:output"
> option in the "replica-conf" directive in the "buildout.cfg" file.
> Where can I read about that?
>
> In my case, for the "replica-conf" and "ro-replica-conf" lines, I have
> the following:
>
> replica-conf ${buildout:directory}/replicas.conf
> ro-replica-conf ${buildout:directory}/ro-replicas.conf
>
>
>
> Cheers,
> Ricardo Dias Marques
> lists AT ricmarques DOT net
> Identi.ca / Twitter: @ricmarques
___
For more information about ZODB, see http://zodb.org/
ZODB-Dev mailing list - ZODB-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] RelStorage - How can I set up one database per web site?
Hi Dylan,
On Wed, Oct 12, 2011, Dylan Jay wrote:
> It looks a bit like this if you are using zope2instance recipe in buildout
>
> zope-conf-additional +=
> %import relstorage
>
>
> mount-point /www/mnt
> cache-size 5000
>
> blob-dir ${buildout:directory}/var/blobcache-www
> shared-blob-dir off
> replica-conf ${mysql-hosts:output}
>
> db blah
> user blah
> passwd blah
>
>
>
>
Thanks Dylan! :) Based on your tip and on Darryl Dixon's tip, I'm
making some progress. I already managed to import one "Data.fs" file
to a database, using "zodbconvert". Now I have to start experimenting
with Apache's configuration, so I can test if the import has been
truly successful.
BTW: I can't find any documentation about the "mysql-hosts:output"
option in the "replica-conf" directive in the "buildout.cfg" file.
Where can I read about that?
In my case, for the "replica-conf" and "ro-replica-conf" lines, I have
the following:
replica-conf ${buildout:directory}/replicas.conf
ro-replica-conf ${buildout:directory}/ro-replicas.conf
Cheers,
Ricardo Dias Marques
lists AT ricmarques DOT net
Identi.ca / Twitter: @ricmarques
___
For more information about ZODB, see http://zodb.org/
ZODB-Dev mailing list - ZODB-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] RelStorage - How can I set up one database per web site?
Hi Darryl, On Wed, Oct 12, 2011, Darryl Dixon - Winterhouse Consulting wrote: > [...snip...] > In essence, [to have one database per web site is] exactly the same > - just that everywhere that you would normally use a > section in your zope.conf you instead use a section. > [...snip...] Thanks Darryl! :) Based on your tip and on Dylan Jay's tip, I'm making some progress. I already managed to import one "Data.fs" file to a database, using "zodbconvert". Now I have to start experimenting with Apache's configuration, so I can test if the import has been truly successful. Cheers, Ricardo Dias Marques lists AT ricmarques DOT net Identi.ca / Twitter: @ricmarques ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] RelStorage - How can I set up one database per web site?
Hi,
It looks a bit like this if you are using zope2instance recipe in
buildout
zope-conf-additional +=
%import relstorage
mount-point /www/mnt
cache-size 5000
blob-dir ${buildout:directory}/var/blobcache-www
shared-blob-dir off
replica-conf ${mysql-hosts:output}
db blah
user blah
passwd blah
---
Dylan Jay
Technical Solutions Manager
PretaWeb: Multisite Performance Support
P: +612 80819071 | M: +61421477460 | twitter.com/djay75 | linkedin.com/
in/djay75
On 12/10/2011, at 9:58 PM, Ricardo Dias Marques wrote:
> Hi all,
>
> I believe this is my First Post in the ZODB-Dev Mailing List, so Hello
> everyone! :)
>
> I have read the following (great) Plone Knowledge Base (KB) article
> about "Scaling Out Plone With RelStorage and Replicated MySQL",
> authored by Shane Hathaway
>
> Scaling Out Plone With RelStorage and Replicated MySQL - Plone CMS:
> Open Source Content Management
> http://plone.org/documentation/kb/scaling-out-plone-with-relstorage-and-replicated-mysql
>
>
> However, I'm not being able to find - in that tutorial or elsewhere -
> information that explains how can I set up one Plone / ZODB database
> for each web site when using RelStorage, in a similar way to having
> one "Data.fs" per web site when using FileStorage:
>
> Multiple Plone sites per zope instance.fs files for each one. — Plone
> CMS: Open Source Content Management
> http://plone.org/documentation/kb/multiple-plone-sites-per-zope-instance-using-separate-data-fs-files-for-each-one
>
>
> Can anyone give me any pointers and/or information, tips, etc...
> regarding this, please?
>
> Thanks in advance! :)
>
> Best wishes,
> Ricardo Dias Marques
> lists AT ricmarques DOT net
> ___
> For more information about ZODB, see http://zodb.org/
>
> ZODB-Dev mailing list - ZODB-Dev@zope.org
> https://mail.zope.org/mailman/listinfo/zodb-dev
___
For more information about ZODB, see http://zodb.org/
ZODB-Dev mailing list - ZODB-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] RelStorage - How can I set up one database per web site?
Hi Ricardo, > Hi all, [...snip...] > > However, I'm not being able to find - in that tutorial or elsewhere - > information that explains how can I set up one Plone / ZODB database > for each web site when using RelStorage, in a similar way to having > one "Data.fs" per web site when using FileStorage: In essence, it is exactly the same - just that everywhere that you would normally use a section in your zope.conf you instead use a section. When using RelStorage with Oracle, for example, each section uses a different username/schema and commit-lock-id. I can't comment on MySQL but I imagine it would be largely the same. It really is that straightforward, Hope this helps, Darryl Dixon Winterhouse Consulting Ltd http://www.winterhouseconsulting.com ___ For more information about ZODB, see http://zodb.org/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
