Am 24. Jul, 2010 schwätzte Alex Dean so:
moin moin,
I think you should consider replicating to multiple slaves. 1 is for backup,
and is totally read-only.
That's my goal. First I need to get all of the DBen going to at least one
slave and make sure we've backing up everything that needs to
Am 24. Jul, 2010 schwätzte Bryan O'Neal so:
I agree with Alex but this just follows logical design of separation.
You dev, qa, prod, ha, and dr environments should be separated and
used for those set purposes. Unfortunately I also know that if this
most elementary step has not been take it is
Am 24. Jul, 2010 schwätzte Bryan O'Neal so:
Sadly Number of physical boxes is usually not the issue with resource
bottle neck; it is that you are always running close to capacity and
can not convince anyone to purchase more equipment because things are
running fine. Double the number of fsyncs
Am 23. Jul, 2010 schwätzte keith smith so:
It is great the Government is using some open source / free software. And they
also released some into the public domain is great.
I would also offer a word of caution - make sure any software the government
released is free from any type of
replication is not always perfect in MySQL - Innodb is less pron to
error but it still happens. Do your best to kill myisam.
What verifying myisam and innodb copies of the same data are exactly the
same? Actually, I want something that will diff them and apply the diff to
the innodb side.
Read only I believe is a server wide var, but again, I am not certain.
Replication should also be server wide , ie. no replication rules,
including which databases should be considered for replication. Just
recently learned what kind of problems it can cause otherwise.
On Sun, Jul 25, 2010 at
moin moin,
we're having an ABLEconf planning meeting Sunday night at 20:00 in the
#ABLEconf IRC channel on Freenode.
www.ABLEconf.com
ciao,
der.hans
--
# http://www.LuftHans.com/Classeshttp://www.TwoGeekTechs.com/
# Director of Engineering, FonWallet Transaction Solutions, Inc.
#
http://www.extremetech.com/article2/0,2845,2366841,00.asp
It's not bad really for just a desktop to get online and type with.
--
A mouse trap, placed on top of your alarm clock, will prevent you from
rolling over and going back to sleep after you hit the snooze button.
Stephen
On Jul 25, 2010, at 3:03 AM, der.hans wrote:
I'm needing to convert a very busy production myisam table that is
somewhat humongous to innodb and the conversion takes longer than the
maintenance windows.
If you have a slave which is capable of becoming a production server,
you can convert
On 7/25/10 3:46 PM, Alex Dean wrote:
On Jul 25, 2010, at 3:03 AM, der.hans wrote:
I'm needing to convert a very busy production myisam table that is
somewhat humongous to innodb and the conversion takes longer than the
maintenance windows.
If you have a slave which is capable of becoming a
10 matches
Mail list logo