Google CloudSQL - Point In Time Recovery with Multiple Binary Log Files
0
This question related to 2nd Gen instances of Google CloudSQL. When you perform point in time recovery on Google's CloudSQL platform, you must actually clone the instance, then specify the binary log file name and position to roll forward on. I am unsure how this actually works internally, does it work out which backup needs to be first restored then which binary log files, if any, preclude the one you have selected? Or it does it clone the current state of the instance and roll back to the desired binary log file/position? What if you have multiple binary log files in your chain since the last backup, i.e. because you have manually flushed logs? Let's say you have a chain that looks like this in CloudSQL: Full Backup > mysql-binlog.000001 > mysql-binlog.000002 > mysql-binlog.000003 ...