this is an excellent read. I will be attempting to use this process with master-slave replication. Do you know if the partitioning will be replicated or will i have to do it manually on the slave and then restart replication?
Hi chuckvincent, thanks! Luckily for us we don't yet have to use replication so I can't really serve here. Perhaps you've seen this page in the docs?
I'll be happy to hear about your findings and will gladly add some info / link to the articles once you find your way through if you agree!
Regardless of replication, I can tell you that the scripts tend to serve us really well so far, we run them weekly and didn't have to touch them yet, they seem to just work!
after spending several days with the gh-ost docs all my questions were answered. thus RTFM in full. If anyone else is trying this beware of extra bin logs created, I ran out of disk space and crashed a master mysql server because I did not account for extra bin log space, i had enough space to gh-ost my large table (27M rows @ 500GB), but the extra logs that were required to maintain the slave servers put be over the top.
this is an excellent read. I will be attempting to use this process with master-slave replication. Do you know if the partitioning will be replicated or will i have to do it manually on the slave and then restart replication?
Hi chuckvincent, thanks! Luckily for us we don't yet have to use replication so I can't really serve here. Perhaps you've seen this page in the docs?
I'll be happy to hear about your findings and will gladly add some info / link to the articles once you find your way through if you agree!
Regardless of replication, I can tell you that the scripts tend to serve us really well so far, we run them weekly and didn't have to touch them yet, they seem to just work!
after spending several days with the gh-ost docs all my questions were answered. thus RTFM in full. If anyone else is trying this beware of extra bin logs created, I ran out of disk space and crashed a master mysql server because I did not account for extra bin log space, i had enough space to gh-ost my large table (27M rows @ 500GB), but the extra logs that were required to maintain the slave servers put be over the top.
Ah, yeah, I wrote about that too but it's very easy to miss a critical detail like this, among all the info. Hope your server recovered well!