One thing mentioned in quite a few of your presentations is using more than one mysql server as the "master" because switching from slaves takes too long and the cluster product being too unstable to work with, not to mention having multiple slaves slows things down exponentially. Is there anything you can point me to that explains how you this, or is it something as simple as duplicating all writing queries to each master?
<br><br>Thanks again!<br><br><div><span class="gmail_quote">
On 1/9/06, <b class="gmail_sendername">Brad Fitzpatrick</b> <<a href="mailto:brad@danga.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">brad@danga.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
That's exactly what LiveJournal's products do, so we don't store<br>duplicated contents in MogileFS.<br><br><br>On Mon, 9 Jan 2006, Justin Azoff wrote:<br><br>> max goldberg wrote:<br>> > Hello all,<br>> [ snip :-) ]
<br>> > Currently I use an MD5 hash for the file name and a database back end to<br>> > try and keep track of all the files. One of the really nice things about<br>> > this system is that on my site file assets are duplicated a lot. Some
<br>> > assets are duplicated up to a thousand times. Using the MD5 setup, I can<br>> > create `symbolic links` of sorts in the database to keep from having to<br>> > duplicate on file space (and in turn cause more I/O to my web server).
<br>> ><br>> > Is this sort of thing possible with Mogile? I haven't been able to find<br>> > much documentation on the structure of the DB, so I can't tell if this<br>> > is a standard operation or more of a "hack".
<br>> ><br>> > Can anyone provide any insight?<br>><br>> I'd say that it isn't possible using only mogilefs, but you should still<br>> be able to use it.. You could keep your existing database of filename
<br>> -> md5sums and then add files to mogilefs with the md5sum as the key.<br>> This way mogilefs only knows about the unique files, and your other<br>> database takes care of the filename mappings.<br>><br>
> If you use memcached to cache the file -> md5sum and md5sum -> mogstored<br>> path mappings your app should run nice and fast.<br>><br>> --<br>> - Justin<br>><br>><br></blockquote></div><br>