Read-only replica DB deployed

log in

Advanced search

Message boards : News : Read-only replica DB deployed

Author Message
Teemu Mannermaa
Project administrator
Project developer
Project tester
Send message
Joined: 20 Apr 11
Posts: 356
Credit: 743,754,657
RAC: 154,296
Message 1545 - Posted: 30 Nov 2011, 14:34:02 UTC

There's now a replica DB used that's used for certain heavy read-only DB operations (top statistics, server_status, lists of user workunits/tasks etc) and should take a bit load off the main DB and by doing so, help the scheduler and other critical processes do their job.

Please, do let me know if there's something that no longer seem to work. Thanks and happy crunching!

Renato
Send message
Joined: 21 Oct 11
Posts: 8
Credit: 311,157,586
RAC: 28
Message 1553 - Posted: 1 Dec 2011, 7:55:52 UTC
Last modified: 1 Dec 2011, 7:59:17 UTC

Since the last update I have not received more credit. (BOINCstats)

Profile ZydorProject donor
Avatar
Send message
Joined: 5 May 11
Posts: 233
Credit: 351,414,150
RAC: 0
Message 1554 - Posted: 1 Dec 2011, 8:46:38 UTC

Same here - looks like incremental export got turned off during the server update

Regards
Zy

mikey
Avatar
Send message
Joined: 22 Jun 11
Posts: 1971
Credit: 1,000,866,048
RAC: 0
Message 1562 - Posted: 1 Dec 2011, 16:18:04 UTC - in response to Message 1553.

Since the last update I have not received more credit. (BOINCstats)


It doesn't look like ANY of the stats sites are getting the Moo info right now.

NeoMetal*
Send message
Joined: 27 May 11
Posts: 10
Credit: 150,418,811
RAC: 0
Message 1564 - Posted: 1 Dec 2011, 17:17:51 UTC - in response to Message 1562.
Last modified: 1 Dec 2011, 17:22:09 UTC

Seems that Teemu forgot to reenable the cron task that sends the XML updates to the stat sites after he changed things.

Last updates at BoincStats:

Last update user XML 2011-11-30 11:30:07 GMT
Last update host XML 2011-11-30 11:30:23 GMT
Last update team XML 2011-11-30 11:30:23 GMT

Chris SProject donor
Avatar
Send message
Joined: 2 Oct 11
Posts: 232
Credit: 375,070,201
RAC: 1
Message 1566 - Posted: 1 Dec 2011, 17:34:06 UTC
Last modified: 1 Dec 2011, 17:36:09 UTC

I have raised it as a problem in the Number Crunching thread
____________
I iz also got icons!



John Clark
Send message
Joined: 27 Jul 11
Posts: 342
Credit: 252,653,488
RAC: 0
Message 1572 - Posted: 1 Dec 2011, 20:11:31 UTC

I asked this question in the BOINCstatssmall chat room, and 2 pointed to Moo!'s new read only DB.

It looks likwe will get a massive update when Teemu turns the reporting facility on.

I have PMed this issue to Teemu as well.

Teemu Mannermaa
Project administrator
Project developer
Project tester
Send message
Joined: 20 Apr 11
Posts: 356
Credit: 743,754,657
RAC: 154,296
Message 1576 - Posted: 1 Dec 2011, 21:33:36 UTC

Oops, statistic export should work again. I'm sorry about this credit flow outage.

Problem was indeed related to replicate DB, which the export job couldn't access (which also seems to be only C++ based program that uses the replica DB).

mikey
Avatar
Send message
Joined: 22 Jun 11
Posts: 1971
Credit: 1,000,866,048
RAC: 0
Message 1579 - Posted: 1 Dec 2011, 23:02:44 UTC - in response to Message 1576.

Oops, statistic export should work again. I'm sorry about this credit flow outage.

Problem was indeed related to replicate DB, which the export job couldn't access (which also seems to be only C++ based program that uses the replica DB).


I can confirm that it is working again, THANK YOU VERY MUCH!!!

John Clark
Send message
Joined: 27 Jul 11
Posts: 342
Credit: 252,653,488
RAC: 0
Message 1583 - Posted: 2 Dec 2011, 0:40:12 UTC

So can I

Thanks Teemu

Chris SProject donor
Avatar
Send message
Joined: 2 Oct 11
Posts: 232
Credit: 375,070,201
RAC: 1
Message 1587 - Posted: 2 Dec 2011, 8:33:57 UTC

Yep all seems OK, thanks.
____________
I iz also got icons!



Message boards : News : Read-only replica DB deployed


Main page · Your account · Message boards


Copyright © 2011-2017 Moo! Wrapper Project