Message boards :
Technical News :
Fall Cleaning (Oct 25 2007)
Message board moderation
Author | Message |
---|---|
Matt Lebofsky Send message Joined: 1 Mar 99 Posts: 1444 Credit: 957,058 RAC: 0 |
For some reason I'm in the "deal with boring, nagging sysadmin tasks" zone this week, so that's mostly what I've been working on. Gotta ride the wave when it happens, you know? Nothing really interesting there to report. Writing scripts, updating our UPS plans, cleaning up and improving our internal alert system... stuff like that. Last night the logical log on our primary science database filled up. This is the log that is used by the secondary to keep in sync with the primary. When the log is full, the primary halts all connections as a protective measure, as the secondary will lose track of future updates. What does all this mean for you? Well, with the primary effectively offline the assimilators and splitters were blocked, and we ran out of work to send this morning. We spotted this quickly enough, but apparently we need better alerts and some automatic logical log rotation system. We're still getting the feel of this informix database replication stuff. - Matt -- BOINC/SETI@home network/web/science/development person -- "Any idiot can have a good idea. What is hard is to do it." - Jeanne-Claude |
Dr. C.E.T.I. Send message Joined: 29 Feb 00 Posts: 16019 Credit: 794,685 RAC: 0 |
For some reason I'm in the "deal with boring, nagging sysadmin tasks" zone this week, so that's mostly what I've been working on. Gotta ride the wave when it happens, you know? Nothing really interesting there to report. Writing scripts, updating our UPS plans, cleaning up and improving our internal alert system... stuff like that. Thank You Matt - and to the Rest of the Berkeley Staff - Thanks BOINC Wiki . . . Science Status Page . . . |
DJStarfox Send message Joined: 23 May 01 Posts: 1066 Credit: 1,226,053 RAC: 2 |
Any good DBA managing a busy, replicated database is always watching his transaction log files. It's amazing how fast they can fill up; I've seen 8 GB disappear in 5 minutes when a certain user is connected! Unfortunately, I've never worked with Informix, so I couldn't offer any strategies to help. |
JLDun Send message Joined: 21 Apr 06 Posts: 573 Credit: 196,101 RAC: 0 |
Any good DBA managing a busy, replicated database is always watching his transaction log files. It's amazing how fast they can fill up; I've seen 8 GB disappear in 5 minutes when a certain user is connected! Unfortunately, I've never worked with Informix, so I couldn't offer any strategies to help. Would that be NEZ? ;-p |
ML1 Send message Joined: 25 Nov 01 Posts: 20147 Credit: 7,508,002 RAC: 20 |
Any good DBA managing a busy, replicated database is always watching his transaction log files. ... An even better one is elsewhere doing useful work whilst a check script (eg logwatch?) is doing the checking, ready to send an alert for anything 'unusual'... Regards, Martin See new freedom: Mageia Linux Take a look for yourself: Linux Format The Future is what We all make IT (GPLv3) |
Matt Lebofsky Send message Joined: 1 Mar 99 Posts: 1444 Credit: 957,058 RAC: 0 |
I think the issue is that we are still getting a feel for informix replication, such as it is. Documentation isn't so great. And having done it easily and relatively seamlessly with mysql, there's still an "astonishment" factor with informix replication. So things are going up and down as we test, and logs filling up isn't exactly the main thing on our radar yet. - Matt Any good DBA managing a busy, replicated database is always watching his transaction log files. ... -- BOINC/SETI@home network/web/science/development person -- "Any idiot can have a good idea. What is hard is to do it." - Jeanne-Claude |
ML1 Send message Joined: 25 Nov 01 Posts: 20147 Credit: 7,508,002 RAC: 20 |
I think the issue is that we are still getting a feel for informix replication, such as it is. Documentation isn't so great. And having done it easily and relatively seamlessly with mysql, there's still an "astonishment" factor with informix... There's always more to learn. I'm very glad that I'm not the one on the sharp end of a million on-line remote 'experts'! (Matt alias "Neo"? ;-) ) (And I fully expect a few 'giggles' for myself when I build a mere six server system soonish. A weekend is likely not long enough... And neither will be the patch leads... :-( All good fun! ) Happy crunchin', Regards, Martin See new freedom: Mageia Linux Take a look for yourself: Linux Format The Future is what We all make IT (GPLv3) |
©2024 University of California
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.