Am 23. Jul, 2010 schwätzte Alex Dean so:
moin moin,
>> Also, how should I sync grants from master to slave when they're out of
>> sync?
>
> Dump the 'mysql' database on the master, and load it on the slave.
>
> If the slave has a different set of user accounts, I think you'll have to
> manually create what you want on the slave. In that case, configure the
> master to not replicate the 'mysql' database so your changes on the master
> won't affect the slave.
Yeah, slave has other stuff on it. As of yesterday, that include my test
DB for fixing all of this :).
Guess I'll write/find an audit script and run it once in a while.
>> In our case, the slave is also getting local changes. I'm pushing to stop
>> that, but haven't yet gotten it worked out. The local changes to the slave
>> didn't drop the missing grants, but since we've had emergency repairs
>> after local changes caused problems, it might be that the repairs did
>> cause the differences.
>
> Hm. Are users on the slave modifying tables which get replicated from the
> master? That's grandma's recipe for data stew. You can't do that if you
Yeah and yeah. I'm going to change that.
> have any interest in data integrity. If the slave has some tables which only
> exist on the slave, that's probably not a huge issue. If you want to
> describe the situation in a little more detail we can help comment further on
> how bad/not-bad it all is. :)
Engineering is doing some reporting off the slave. To do so, they've been
mucking with slave data. There was also some temporary restoral of old
data.
I will be moving all of that do a reporting DB and be moving them to
read-only access to the replicated DB. Had to get back from vacation
before I pushed for the change :).
ciao,
der.hans
--
# http://www.LuftHans.com/Classes http://www.TwoGeekTechs.com/
# Director of Engineering, FonWallet Transaction Solutions, Inc.
# In order to live free and happily, you must sacrifice boredom.
# It is not always an easy sacrifice.
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)