Read-only replica DB deployed

\n studio-striking\n

Message boards : News : Read-only replica DB deployed
Message board moderation

To post messages, you must log in.

AuthorMessage
Profile Teemu Mannermaa
Project administrator
Project developer
Project tester

Send message
Joined: 20 Apr 11
Posts: 388
Credit: 822,356,221
RAC: 0
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!
ID: 1545 · Rating: 0 · rate: Rate + / Rate - Report as offensive
Profile Zydor
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
ID: 1554 · Rating: 0 · rate: Rate + / Rate - Report as offensive
mikey
Avatar

Send message
Joined: 22 Jun 11
Posts: 2080
Credit: 1,826,336,240
RAC: 3,658
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.
ID: 1562 · Rating: 0 · rate: Rate + / Rate - Report as offensive
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
ID: 1564 · Rating: 0 · rate: Rate + / Rate - Report as offensive
Chris S
Avatar

Send message
Joined: 2 Oct 11
Posts: 238
Credit: 383,813,566
RAC: 12,455
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!



ID: 1566 · Rating: 0 · rate: Rate + / Rate - Report as offensive
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.
ID: 1572 · Rating: 0 · rate: Rate + / Rate - Report as offensive
Profile Teemu Mannermaa
Project administrator
Project developer
Project tester

Send message
Joined: 20 Apr 11
Posts: 388
Credit: 822,356,221
RAC: 0
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).
ID: 1576 · Rating: 0 · rate: Rate + / Rate - Report as offensive
mikey
Avatar

Send message
Joined: 22 Jun 11
Posts: 2080
Credit: 1,826,336,240
RAC: 3,658
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!!!
ID: 1579 · Rating: 0 · rate: Rate + / Rate - Report as offensive
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
ID: 1583 · Rating: 0 · rate: Rate + / Rate - Report as offensive
Chris S
Avatar

Send message
Joined: 2 Oct 11
Posts: 238
Credit: 383,813,566
RAC: 12,455
Message 1587 - Posted: 2 Dec 2011, 8:33:57 UTC

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



ID: 1587 · Rating: 0 · rate: Rate + / Rate - Report as offensive

Message boards : News : Read-only replica DB deployed


 
Copyright © 2011-2024 Moo! Wrapper Project