Hi Will, I have never really benchmarked performance, but I am running all projects (including one very large project) configured like this in the last 4 years. I don't know if the problem has been solved, but in Magnolia 4.1 when you saved the dialog of an asset, the whole asset including binary content was duplicated in the database. This datastore uses a MD5 checksum and solves the issue.
Cheers, Roland (freelancer, Munich) -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Ulrich Scheidegger Gesendet: Sonntag, 7. September 2014 21:42 An: Magnolia User-List Betreff: Re: [magnolia-user] Re: Backup your Magnolia MySQL database in 5 minutes using Google Drive Yes, of course, if you modified the jackrabbit repository settings, then you're fine. I was referring to the default settings. I have not tested the DbDataStore yet. Does it perform well enough? -will On 07.09.2014, at 13:34, Roland Polzer (via Magnolia Forums) <[email protected]> wrote: > Hello Will, > > Why also mess with the filesystem? I put everything into the database. This > is in my jackrabbit-bundle-mysql-search.xml: > [code] > <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore"> > <param name="url" value="jdbc:mysql://localhost:3306/magnolia_author"/> > <param name="user" value="myuser"/> > <param name="password" value="mypassword"/> > <param name="databaseType" value="mysql"/> > <param name="driver" value="com.mysql.jdbc.Driver"/> > <param name="minRecordLength" value="1024"/> > <param name="copyWhenReading" value="true"/> > <param name="tablePrefix" value=""/> </DataStore> [/code] > > Also you should set max_allowed_packet to an appropriate value in the > mysql, mysqld, and mysqldump sections of your /etc/mysql/my.cnf file. > Otherwise you cannot restore the database when you store large object > like movies > > Cheers, > Roland (freelancer, Munich) > > -- > Context is everything: > http://forum.magnolia-cms.com/forum/thread.html?threadId=2292fa3b-4fbf > -4a3d-999f-122037db0f09 > > > ---------------------------------------------------------------- > For list details, see > http://www.magnolia-cms.com/community/mailing-lists.html > Alternatively, use our forums: http://forum.magnolia-cms.com/ To > unsubscribe, E-mail to: <[email protected]> > ---------------------------------------------------------------- > ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ---------------------------------------------------------------- ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
