Sorry all your data is gone, have a nice day ^_^

emgh · May 2

My im deep lovage mariadb

My im ok lovage postgres

My im no lovage 1.5 million files for savage memory

plumberg · May 2

@emgh said:
My im deep lovage mariadb

My im ok lovage postgres

My im no lovage 1.5 million files for savage memory

My loveage db saved in RAM
Every day fresh db

TimboJones · May 2

@angstrom said:

@davide said:

@angstrom said:

Sorry all your data is gone, have a nice day ^_^

@davide

Is this title accurate?

No, move it to offtopic @angstrom, hide it from view, and rename it to "I'm stupid and I don't know what I'm doing ^_^".

Minimally, you have a sense of humor, I'll give you that

That wasn't a joke. The current title is stupid and should be changed to the new one quoted but without the stupid emoji thing.

davide · May 3

MOLY FUCKAROLY JESUS CHRISTAROLY

-- WE DID IT --

Thru an afternoon and good part of the night, the whole ZFS binary blob was dd across SSH and got a successful boot with working network over the replacement VPS:

Rpool data and metadata were transferred as-is, by cloning the whole block device agnostically of its content; it contains 54 GB of data compressed down to 23 GB with a compression ratio of 2.4x:

CPU models differ across the VPSs but binary compatibility is the same so no recompilations were required.

Overall experience: 10 out of 10 would do it again

🤌

Now @NDTN see to make it last for a while!

davide · May 3

@raindog308 said:
That sounds like a lot of work for microseconds. You could keep the entire dataset in memory with Pg and use various indexing strategies and I am skeptical you'd really see a huge difference. Pg may even be faster. In a world where a 4GB VPS is $5/month, how critical really is "wasting memory"?

The difference is ~500 ms per query between MariaDB and µDB++ (the database used by VPS Price Tracker), I benchmarked them side by side across January / February while writing the database software; there are several factors contributing to the performance gain, the primary ones are:

µDB++ inlines the filtering algorithms in the ELF executable segments, and the DB data is structured to maximize the cache efficiency for how those algorithms access the data; on the other hand MariaDB executes SQL stored procedures against data structures with general-purpose encoding;
MariaDB has no direct way to control the order of the data stored in memory, and every query has to pass thru a sorting stage (the order by clause), while µDB++ pre-sorts the data in multiple orders and avoids the sorting stage at query time.

I don't have the MariaDB data from February but this is what µDB++ is currently logging on file from real-time queries:

zed · May 3

Glad it worked out, I enjoyed tracking the adventure!

AlteredParadox · May 3

Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

stable_genius · May 3

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

davide · May 3

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

GreenCloud is one of the best providers among the whole of the low-end, it is a match for the high-end too, I wouldn't be comparing it to AWS otherwise, which is where VPS Price Tracker is backed up now, and I'm not moving away to some other provider just for this one-off incident. It's been one of the most reliable machines I had in a decade, more so than Oracle (both free tier and paid, I discussed plenty of times their problems). But what got me guts from GreenCloud was this "you have 3 days to backup your data", their CP migration problem was dumped on me on a 3-day notice with no flexibility to reschedule or to pay to have the problem sorted out by the staff; I keep incremental backups of all services so I can restore from any point in time thru the past two months, but doing a full restoration of this particular ZFS setup sinks a lot of time that I'd prefer to budget for more interesting work. It's definitely a provocative title but fuck it, I was one step close from losing the server had I missed the deadline.

BTW I'm wondering why no one else seems to have been affected. It's like I'm doing something wrong with their VPS :D

totally_not_banned · May 3

@stable_genius said:

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

Are you somehow trying to claim this nonsense to be more important than the title of an LET post? Jeez, people need to get their priorities in order...

network · May 3

@davide said: difference is ~500 ms per query

What kind of query is taking 500ms on MariaDB?

@davide said: MariaDB has no direct way to control the order of the data stored in memory, and every query has to pass thru a sorting stage (the order by clause), while µDB++ pre-sorts the data in multiple orders and avoids the sorting stage at query time.

You can create indexes in MariaDB.

stable_genius · May 3

@totally_not_banned said:

@stable_genius said:

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

Are you somehow trying to claim this nonsense to be more important than the title of an LET post? Jeez, people need to get their priorities in order...

Exactly my point, we can't take any risks.

Those VPSs must be kept at all costs, only God knows what could happen if otherwise.

totally_not_banned · May 3

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

Are you somehow trying to claim this nonsense to be more important than the title of an LET post? Jeez, people need to get their priorities in order...

Exactly my point, we can't take any risks.

Those servers must be kept at all costs, only God knows what could happen if otherwise.

jsg · May 3

FWIW I got a very similar email (automatic transfer of my VPS to virtfusion not possible, so it must be done manually).

OK, granted, I do not - and will never - have a "DB" consisting of a gazillion inodes, but not only did everything work smoothly but also quickly in part thanks to GreenCloud / @NDTN support responding and acting quickly and professionally.

Everything, incl. a full backup, was done within an afternoon and that more as a side-job.

TLDR; my experience with that confirmed and emphasized my sympathy for GreenCloud. They performed very well, kudos to them!

stable_genius · May 3

@totally_not_banned said:

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

Are you somehow trying to claim this nonsense to be more important than the title of an LET post? Jeez, people need to get their priorities in order...

Exactly my point, we can't take any risks.

Those servers must be kept at all costs, only God knows what could happen if otherwise.

You shouldn't, it's not that big a deal.

There are so many more important things to worry about.

jsg · May 3

@totally_not_banned said:

@stable_genius said:

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

Are you somehow trying to claim this nonsense to be more important than the title of an LET post? Jeez, people need to get their priorities in order...

(emphasis mine)

I would agree, if no kittens were in danger! That's the point where fun stops!
Call me a heretic if you want, but kittens are more important than LET thread titles!

totally_not_banned · May 3

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

Are you somehow trying to claim this nonsense to be more important than the title of an LET post? Jeez, people need to get their priorities in order...

Exactly my point, we can't take any risks.

Those servers must be kept at all costs, only God knows what could happen if otherwise.

You shouldn't, it's not that big a deal.

There are so many more important things to worry about.

Like what? No, please don't answer. I already know that it will be something silly like "solving world hunger", "survival of the human species" or whatever...

stable_genius · May 3

@totally_not_banned said:

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

Are you somehow trying to claim this nonsense to be more important than the title of an LET post? Jeez, people need to get their priorities in order...

Exactly my point, we can't take any risks.

Those servers must be kept at all costs, only God knows what could happen if otherwise.

You shouldn't, it's not that big a deal.

There are so many more important things to worry about.

Like what? No, please don't answer. I already know that it will be something silly like "solving world hunger", "survival of the human species" or whatever...

Wrong again!

There's no shortage of important things out there and you don't need to leave LET to find some more serious things to discuss, take the following one as a good example

The Dos and Dont's of Shitting in a Bucket (Composting Toilet)

davide · May 3

@jsg said:
FWIW I got a very similar email (automatic transfer of my VPS to virtfusion not possible, so it must be done manually).

OK, granted, I do not - and will never - have a "DB" consisting of a gazillion inodes, but not only did everything work smoothly but also quickly in part thanks to GreenCloud / @NDTN support responding and acting quickly and professionally.

Everything, incl. a full backup, was done within an afternoon and that more as a side-job.

TLDR; my experience with that confirmed and emphasized my sympathy for GreenCloud. They performed very well, kudos to them!

Did you figure out why your migration couldn't be handled automatically? The new CP seems to rely on the Qemu guest agent being present on the VPS, to do things like setting the DNS resolver and configuring the IP addresses. I manage these configs manually and since I don't need the guest agent I removed it years ago, but I suspect this may have been the culprit, the staff might have received some generic error from the new CP and dropped the sponge.

totally_not_banned · May 3

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

Are you somehow trying to claim this nonsense to be more important than the title of an LET post? Jeez, people need to get their priorities in order...

Exactly my point, we can't take any risks.

Those servers must be kept at all costs, only God knows what could happen if otherwise.

You shouldn't, it's not that big a deal.

There are so many more important things to worry about.

Like what? No, please don't answer. I already know that it will be something silly like "solving world hunger", "survival of the human species" or whatever...

Wrong again!

There's no shortage of important things out there and you don't need to leave LET to find some more serious things to discuss, take the following one as a good example

The Dos and Dont's of Shitting in a Bucket (Composting Toilet)

Okay. I didn't think that i would say this but actually i am pleasantly surprised. Shitting in buckets very much is serious business. Still quite odd you would put this ahead of LET thread titles but you certainly aren't a monster..

jsg · May 3

@davide said:

@jsg said:
FWIW I got a very similar email (automatic transfer of my VPS to virtfusion not possible, so it must be done manually).

OK, granted, I do not - and will never - have a "DB" consisting of a gazillion inodes, but not only did everything work smoothly but also quickly in part thanks to GreenCloud / @NDTN support responding and acting quickly and professionally.

Everything, incl. a full backup, was done within an afternoon and that more as a side-job.

TLDR; my experience with that confirmed and emphasized my sympathy for GreenCloud. They performed very well, kudos to them!

Did you figure out why your migration couldn't be handled automatically? The new CP seems to rely on the Qemu guest agent being present on the VPS, to do things like setting the DNS resolver and configuring the IP addresses. I manage these configs manually and since I don't need the guest agent I removed it years ago, but I suspect this may have being the culprit, the staff might have received some generic error from the new CP and dropped the sponge.

Honestly, I didn't care about why.

stable_genius · May 3

@totally_not_banned said:

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@totally_not_banned said:

@stable_genius said:

@AlteredParadox said:
Now please delete both servers so your data is lost and the title is no longer a lie! 🤣

Nooooooo, don't, that would be too much of a loss.

Kittens would die, cure for cancer would get postponed by several years, a huge risk!

Some might even be driven to suicide. Too much of a loss.

Are you somehow trying to claim this nonsense to be more important than the title of an LET post? Jeez, people need to get their priorities in order...

Exactly my point, we can't take any risks.

Those servers must be kept at all costs, only God knows what could happen if otherwise.

You shouldn't, it's not that big a deal.

There are so many more important things to worry about.

Like what? No, please don't answer. I already know that it will be something silly like "solving world hunger", "survival of the human species" or whatever...

Wrong again!

There's no shortage of important things out there and you don't need to leave LET to find some more serious things to discuss, take the following one as a good example

The Dos and Dont's of Shitting in a Bucket (Composting Toilet)

Okay. I didn't think that i would say this but actually i am pleasantly surprised. Shitting in buckets very much is serious business. Still quite odd you would put this ahead of LET thread titles but you certainly aren't a monster.

See, I told you!

All your data is NOT GONE, have a nice day!

ITChristian · May 3

What kind of internet is this...

I personally had some similar problems with the connectivity in my area, and solved them using a LTE Router instead of using a local ISP. I am using a ZTE MF289F (after testing lots of routers) and I now constantly get around 90mbps download.

davide · May 3

@ITChristian said:
What kind of internet is this...

I personally had some similar problems with the connectivity in my area, and solved them using a LTE Router instead of using a local ISP. I am using a ZTE MF289F (after testing lots of routers) and I now constantly get around 90mbps download.

It's a... an ISP owned by the Italian ministry of the interior. Curiously the only alternative service is from the ex-state monopoly ISP which runs on DSL twisted pair cable.

Don't worry for me, I'm used to it, it doesn't hurt anymore.

budi1413 · May 4

so much for your happy ending

Howdy, Stranger!

Categories

In this Discussion

Sorry all your data is gone, have a nice day ^_^

Comments

Howdy, Stranger!

Quick Links

Categories

In this Discussion

Sorry all your data is gone, have a nice day ^_^

Comments