Ludy: Tiny, as Bachinski ***umed. mysqldump as above
Anderton: What commands make one scenario better suited than another?
Cauley: Or rather, scenario make a command better suited
Decoux: Obiano: maybe because of the I_S
Obiano: Decoux on my dumpspeed issue from earlyer? ios? its all-ssd, blazing fast – dumping the actual data afterwards is 16 GB in less than 10 minutes.
Decoux: Obiano: the I_S isn’t IO bound.
Astle: Anyone? reasons to use one method over another?
Obiano: Hm google is bad in telling me what they are other than “related to schema info” what makes sense 😛
Pyette: Geo: you seem to be after an entire tutorial of the pros/cons of every backup mechanism possible. Thanks beyond what I have time for and what others have too I ***ume.
Morillo: Geo: No, we will not spoonfeed you. We’ll give you pointers, man pages, general guidelines, even web pages that you *actually* have to read. But don’t expect use to spoonfeed you. You can allways employ a MySQL Consultant for that.
Novinger: Technically, you did spoonfeed me when you just told me to use mysqldump over anything else
Decoux: It was a hint of sorts.
Mammo: You have something simple and small.
Bushard: I kinda thought you might like someone who is interested in learning more about the why, and not just copy pasting
Decoux: Logical backups are fine for small data sets.
Dicaprio: I think its a bit dramatic to translate a ‘why’ to ‘you want to know everything about everything’
Skahan: Geo: maybe another time. not now however.
Decoux: They are impractical for larger sets.
Obiano: Replicator that acts as hot spare and is used to make consistent so with locking backups — this and only this is “neat”
Obiano: Dumpt your backup, daily dump a “init dump” – to have a point to “start a new slave on him”
Bachinski: Geo: when’s the last time you did alvm shapshot never. used xtrabackup? never set up replication? never mysqldump is a good place to start
Obiano: Then can even be used to change to ROW replication, do schema changes on the slave, and then trannsistion over your app to him, to then make old-master the new slave afterwards 3
Bachinski: Geo: anyway, try it and see
Mclauren: Decoux: is a there a main difference in moving data with one of these other sets? at the end of the day, you still need to move X amount of data, right?
Loson: So how are there speed efficiencies found between the methods?
Decoux: Geo: how long do you think a logical backup will take, if say, you had 10GB of data to export?
Decoux: Geo: what about the import process?
Tur: So it has to do with how mysql reads in the data once its moved?
Culligan: Ingesting it, vs just sticking in a database, I guess?
Decoux: Geo: what does “sticking in a database” mean?
Obiano: Imports are a ***. im running two slaves that “switch each hour” with replication stoped, so “in case” i can go from there and not need 5 hours of import+index building 😀
Seacrist: Decoux: *shrug* moving a binary file over, I guess. I don’t really know, I’m just trying to get an idea of the different concepts involved
Decoux: Geo: what is a logical backup?
Rubarts: Geo: hint 2. its all about the impact to the business operations. how long can you go without writing/reading from a database.
Handren: I’m ***uming its a dump of all the database contents/schema to a text/binary format
Rogstad: All the data in one file
Decoux: Geo: time to read about it, then.
Berenson: So yes, its a dump of all the contents
Swiler: Versus just moving the database file
Bachinski: Geo: there is no “database file”. that’s MS Access
Broyles: Decoux: any other thoughts?
Decoux: Geo: you need to get a better picture first.