4 ms·
MySQL has some robust tooling in this space. Some of the tools use triggers to copy to a new table. GitHub's gh-ost[1] is probably the state of the art, and use
by antoncohen 4y ago
MySQL has some robust tooling in this space. Some of the tools use triggers to copy to a new table. GitHub's gh-ost[1] is probably the state of the art, and uses the binary log stream to replicate the data.
[1] https://github.com/github/gh-ost https://github.com/github/gh-ost
- taspeotis 4y agoPostgres has some less robust tooling, at least both of these carry the "experimental" tag: https://news.ycombinator.com/item?id=29825520 https://news.ycombinator.com/item?id=29825520 https://github.com/shayonj/pg-osc https://github.com/shayonj/pg-osc But, still, they do it for you.