HackerTrans
TopNewTrendsCommentsPastAskShowJobs

janxgeist

no profile record

Submissions

Ask HN: How do you backup your database?

8 points·by janxgeist·3 года назад·7 comments

comments

janxgeist
·3 года назад·discuss
We had a similiar problem with a label printer.

On some days, exclusively in the morning hours, the printer would fail to detect the start of a new label, printing over several labels.

After connecting remotely and checking the usual (queue, network connection, drivers etc), I asked my colleague to call me, as soon as it happened again.

When I went there, I saw that a ray of sunlight hit the printer. The windows had shutters, but there was a gap.

Label printers detect the gap between labels using a laser. And for some reason, the printer's case had a clear window at the top.

I printed an empty label and stuck it on the little window.
janxgeist
·3 года назад·discuss
For me, it's an example of a company messing up the technical side.

I was a happy customer in the beginning. Until I didn't have an important note that I had prepared for a meeting, because it didn't sync to my phone. A few weeks later, it happened again. I lost trust in the app.

Then the Android App got worse and worse. It sometimes didn't sync at all. Notes would conflict all the time, and I'd lose work.

For some reason, Evernote (both android app and windows client) just seemed to get worse every year.
janxgeist
·3 года назад·discuss
I actually did set up replication to another database, several years ago. But at the time, for some reason the databases would de-sync to easily (often when changing the db scheme).
janxgeist
·3 года назад·discuss
I'm not so much looking for efficiency, but for simplicity. This contraption of scripts that get called by cronjobs, that then access some account on DigitalOcean etc. just seems to complex to me.

If I want to check if everything works, I have to check several places. My own documentation of this backup process is several pages long.

Considering how many people need to backup databases on linux, I was hoping there'd be a better, simpler practice.
janxgeist
·3 года назад·discuss
Bait and switch seems to be widely used by mangers in situations like this.

In your inital negotiation, you informally agree on some conditions.

Then slowly,over the course of weeks or months, most points change to what your manager wanted.