Hi, I create a database for each instance because its easier and safer to manage.
Paul On Fri, 2007-10-19 at 17:24 -0600, James Reynolds wrote: > I'm looking at the instructions on: > > http://www.magnolia.info/wiki/Wiki.jsp? > page=SettingUpMySQLRepositoryWithMagnolia3.1 > > And I am thinking that it is designed for one mysql database for both > author and public instances. Is that what people are doing? Storing > them in the same database? I'm thinking this because of the schema > appends author_ to all the tables: > > <param name="schemaObjectPrefix" value="author_${wsp.name}_"/> > > I was thinking it would be better to have: > > <param name="schemaObjectPrefix" value="${wsp.name}_"/> > > and just have a database for author and public. That way the table > names would be the same for both databases. But I really have no > experience with this. Does anyone know better? > > James > > ---------------------------------------------------------------- > for list details see > http://documentation.magnolia.info/docs/en/editor/stayupdated.html > ---------------------------------------------------------------- -- Paul Worrall INTERITION - Java Open Source Software Services Keep informed with the JOSS4BIZ Podcast at http://joss4biz.interition.net w: www.interition.net m: +44 (0)7711330213 t: +44 (0)8707661627 ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ----------------------------------------------------------------
