No, you shouldn't be doing that :)
I'll respond earlier in the thread on the other points... but on this
specific one, MogileFS makes heavy use (for the moment!) of GET_LOCK and
RELEASE_LOCK so the different processes and trackers don't step on each
other's feet and horrifically corrupt things.
So, you may actually do master:master setups with auto_increment_offset
fine (this works okay, I have a few cluster's DBs doing it). But the
trackers may _only_ point to one of them. If you have a high DB load you
should post your tracker configuration here... Presently having too many
idle replicators/deleters/etc will increase DB load more than they should.
Otherwise you may use read only slaves by adding them with the mogadm
slave command, and that should offload the bulk of the DB traffic if you
don't have more replicators/deleters/etc than you need.
-Dormando
Clinton Goudie-Nice wrote:
Additionally, is there any way to make the trackers config connect to
both db masters? I saw some discussion earlier on the list about how to
have the trackers query mysql slaves, but I didn't see how the config
file needs to be structured to determine if I could use it for
multimaster as well.
Thanks!
Clint
On Thu, 2008-01-31 at 10:35 -0700, Clinton Goudie-Nice wrote:
Greetings everyone,
I'm wondering how to perform the setup of a second tracker. Do I start
the second tracker the same as the first tracker, or do I need to do
some configuration on both trackers so that they know about eachother?
Also, I want to set this up in a mysql multimaster situation, probably
having each tracker talk to the mysql instance on the machine it's on.
From what I know about mogile, that shouldn't be a problem. Is there
anything I should know about setting mogile up in this way?
Thanks for the help!
Clint
Twelve Horses <http://web.twelvehorses.com/> Mobile
<http://web.twelvehorses.com/info_center/whitepaper/> Social
<http://web.twelvehorses.com/solutions/blogging_for_business/> Web
<http://web.twelvehorses.com/solutions/website_design/> Email
<http://web.twelvehorses.com/technology/>
*Clinton Goudie-Nice*
Architect / Senior Software Engineer
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Phone: +1.801.571.2665 ext 3264
Mobile: +1.801.915.0629
Fax: +1.801.571.2669
LinkedIn: http://www.linkedin.com/in/cgoudie
*Twelve Horses*
13961 Minuteman Drive
Suite 125
Draper, UT 84020
*www.twelvehorses.com <http://www.twelvehorses.com>*