jpablo

no profile record

comments

il y a 21 joursdiscuss

The power to send mass messages to a whole country is the worst thing google/apple have given to governments across the world.

jpablo

il y a 2 moisdiscuss

Darn. I don't know if I have been living in the wrong places but I never see drug-addicted homeless people in my western country at night.

jpablo

il y a 3 moisdiscuss

If you want a consistent backup that you can use to setup a replica you need to block writes while the backup is taken, take the backup while the database is shutdown OR use xtrabackup.

jpablo

il y a 3 moisdiscuss

The "making it catch up" is the tricky part. You need an initial backup for that. xtrabackup can take that backup "hot" without blocking read/writes. mysqldumper will block writes for whatever time that initial backup takes, for 2TB of data that's going to be hours.

Once you have that initial back up you can set your replica and make it catch up , then you switch. I choose to take the few seconds of downtime doing the switch because for my use case that was acceptable.

jpablo

il y a 3 moisdiscuss

  If you’re migrating a large MySQL database and you’re not 
  using mydumper/myloader, you’re doing it the hard way.

If you aren't using xtrabackup you are doing it wrong. I recently migrated a database with 2TB of data from 5.7 to 8.4 with about 15 seconds of down time. It wouldn't have been possible without xtrabackup. Mysqldumper requires a global write block, I wouldn't call blocking writes for hours a "zero downtime migration".

jpablo

il y a 3 moisdiscuss

https://en.wikipedia.org/wiki/Stalemate#History_of_the_stale...

jpablo

il y a 3 moisdiscuss

So basically VOIP?

jpablo

il y a 4 moisdiscuss

Yeah... that's way, way, way more complex than npm run dev

jpablo

il y a 6 moisdiscuss

You will be surprised of The Unreasonable Effectiveness of opencv.calcOpticalFlowPyrLK