Message boards :
Technical News :
Hocket (Aug 05 2010)
Message board moderation
Previous · 1 · 2
Author | Message |
---|---|
![]() Send message Joined: 25 Nov 01 Posts: 21567 Credit: 7,508,002 RAC: 20 ![]() ![]() |
One of the rea[s]ons for the new 3 day downtime. I did wonder at one time whether they were pushing the Informix database to its limits but it appears not, there are larger ones out there. Except that Boinc (s@h) uses the one database for all of the data AND all of the system state changes for all users... I still wonder if the processing speed of Boinc for a project is limited by the (single threaded) serial updates maximum write speed of the one database log file... Hang in there Matt and gang! Happy crunchin', Martin See new freedom: Mageia Linux Take a look for yourself: Linux Format The Future is what We all make IT (GPLv3) |
Josef W. Segur Send message Joined: 30 Oct 99 Posts: 4504 Credit: 1,414,761 RAC: 0 ![]() |
One of the rea[s]ons for the new 3 day downtime. I did wonder at one time whether they were pushing the Informix database to its limits but it appears not, there are larger ones out there. The BOINC database is MYSQL, and does cover a lot of territory: all of the infrastructure which BOINC provides. The S@H science database, and probably the Astropulse science database, are Informix (though one of the rare Berkeley SETI blog entries mentioned that Eric was thinking of converting to MYSQL for that too). Joe |
Swibby Bear Send message Joined: 1 Aug 01 Posts: 246 Credit: 7,945,093 RAC: 0 ![]() |
The Server Status Page describes Mork as the Primary BOINC database, with Jocelyn being the replica. But many posts from the admins say that "the replica is down", or "the replica is recovering", yet Mork is said to be the problem child with many untimely crashes (there is never a timely crash, of course). So, for clarification, is Mork being used as the Primary or the Replica? Thanks |
![]() ![]() Send message Joined: 1 Mar 99 Posts: 1444 Credit: 957,058 RAC: 0 ![]() |
Good question. When mork crashes, its relay logs are then in a funny/inconsistent state, which means the replica is unable to work with these relay logs. The easiest way to fix that is to dump the whole database on mork and "recover" the replica from that dump - then everything is consistent again. - Matt The Server Status Page describes Mork as the Primary BOINC database, with Jocelyn being the replica. But many posts from the admins say that "the replica is down", or "the replica is recovering", yet Mork is said to be the problem child with many untimely crashes (there is never a timely crash, of course). So, for clarification, is Mork being used as the Primary or the Replica? -- BOINC/SETI@home network/web/science/development person -- "Any idiot can have a good idea. What is hard is to do it." - Jeanne-Claude |
DJStarfox Send message Joined: 23 May 01 Posts: 1066 Credit: 1,226,053 RAC: 2 ![]() |
Good question. When mork crashes, its relay logs are then in a funny/inconsistent state, which means the replica is unable to work with these relay logs. The easiest way to fix that is to dump the whole database on mork and "recover" the replica from that dump - then everything is consistent again. Gosh, Matt, I remember having this problem with MSSQL Server 2k, back in the day. Basically, the company didn't want to buy the enterprise license, so I wrote scripts to perform log shipping manually. After the first catastrophic failure, I changed the scripts to backup the logs to a separate (fast) file server instead. That way, the log backup (on master) and log restore (on replica) can happen asynchronously. Even in the event of master failing, I can resume the logs from the standby from the point of failure. Not sure of the details of MySQL, but this should be possible if you have said file server available. Point is, reading logs from the master directly from the replica has never been robust for me. |
©2025 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.