I wanted to know what is DB Migration and what will this do for us crunchers. Hoping somone out here in the comunity would know.

---

> I wanted to know what is DB Migration and what will this do for us crunchers.
> Hoping somone out here in the comunity would know.

They're going to transfer the database over to newer and faster machine servers so for the meanwhile, they're doing something to slow down the validator. It shouldn't do much more but there's a scheduled window where the project will be taken down in order for them to do the transfer. If anything, when they get things back up and running, there will be a crunch on accessing the server and your connection will probably be screwed for a few hours afterwards.

Anyone else trying and not getting any new work right now? it's 8:08 p.m. Hawaii Standard Time, 1/30/05, and I can't get new WUs to crunch since 5:30 p.m. here.

---

> Anyone else trying and not getting any new work right now? it's 8:08 p.m.
> Hawaii Standard Time, 1/30/05, and I can't get new WUs to crunch since 5:30
> p.m. here.
>

Yep, same here...

Regards Hans

---

> Anyone else trying and not getting any new work right now? it's 8:08 p.m.
> Hawaii Standard Time, 1/30/05, and I can't get new WUs to crunch since 5:30
> p.m. here.
>

Just got some at 22:11PST. Looks like there were problems earlier.

> I wanted to know what is DB Migration and what will this do for us crunchers.
> Hoping somone out here in the comunity would know.

Well with the worst of winter behind us, the database has begun its annual migration from the warmer feeding grounds of the tropics towards the cooler regions where it will settle down and raise its young before next winter. In some parts of the world, people gather with binoculars to watch for random bits as the databases pass through. But watch out! Unexpected I/O bursts can result in random BLOBs being dropped by the database as it is in motion and can result in a rather unpleasant experience for the un-expecting watchdog. Be sure to keep your eye out for various species. The oracle is renowned for its wisdom, speed and stable flight pattern. But it can be very cantankerous at times. Rich people like to keep this type as a pet sometimes. A newer breed, mysql, can be picked up very cheaply but watch out as it has a slight chemical imbalance resulting in very low levels of ACID in its body so it sometimes needs more looking after. Then there is MSsql which a lot of people tend to stay away from, partially due to the company it keeps. The postgress variety tends to be a bit slower than its fellows but at least its bodily levels of ACID are more balanced. There are others but I will let you discover them on your own. So grab a pair of binoculars and head outside to catch these wonderful creatures on their migratory path. They can be spotted easily. Just look for a lot of blinken lights as these seem to be a common occurrence during migration.

Sorry... couldn't resist :) I realize a lot of that probably won't even make sense to a lot of people but I had to do something to pass the time while I wait for my history update script to finish so I can apply some upgrades to my stats site database :)

---

A member of The Knights Who Say NI!
For rankings, history graphs and more, check out:
My BOINC stats site

I love it! Mind if I quote you?

---

@Toby
If you ever find yourself bored/disillusioned with webmastering maybe you could put together a comedy show.

---

Kolch - Crunching for the BOINC@Australia team since July 2004.
Search for your own intelligence...

Must grab the binoculars - was that an Oracle or MySQL at the feeding table?

---

Need help? Check out the excellent Unofficial BOINC-Wiki!
'We are the BOINC. Prepare to be assimilated.'

HI

Matt Lebofsky wrote a few weeks ago that the migration of the DB will be a final step to shut down seti classic when i remember correctly.
They are going to change to hardware raid what results in faster I/O access.
So we will see next few weeks or so.

greetz from Germany
Mike

---

With each crime and every kindness we birth our future.

> HI
>
> Matt Lebofsky wrote a few weeks ago that the migration of the DB will be a
> final step to shut down seti classic when i remember correctly.
> They are going to change to hardware raid what results in faster I/O access.
> So we will see next few weeks or so.
>
> greetz from Germany
> Mike
>
There was a post I read last week or so that said that Classic users will be given a 2 month window in which they have to finish up and migrate over before the project will be closed down.

---

Toby,
that was great! esp the MSsql part.
thank you for brightening my day!

micah

---

S@h Berkeley's Staff Friends Club

> I wanted to know what is DB Migration and what will this do for us crunchers.
> Hoping somone out here in the comunity would know.
>

This is from the technical news page:

In other news: Thanks to random unforseen setbacks (bad CPU that needed to be replaced, jury duty, etc.) the new BOINC database server is still not ready for the prime time, but major progress has been made. The OS is installed, the RAID disk array is working, and the mysql distribution almost completely configured. After at least a week of testing, we'll start migrating data to it.

Meanwhile the current database is being artificially slowed for reasons we have yet to determine. Basically, something internal to mysql caused it to suddenly read 5 megabytes/sec from the data disks. This started last Friday and hasn't stopped since. Even when there are no queries happening there are major amounts of disk I/O. Everything is working, just a little slower than it should.

Presumably, the new database server is now ready for prime time.

Faster, newer hardware is always a good thing.

Remember too that BOINC tolerates outages pretty well. BOINC users don't seem as tolerant.

---