MariaDB restore from binary log and relay log on master master setup
Hi Guys,
i have setup a mariadb master master setup and i am testing recovery.
i have a question if both servers are down and i have last good full backup and the binary log and relay log how do i recover. till now i can play the binary log and the changes take place but when i play the relay log it does not add the changes:
[root@db1 mysql]# mysqlbinlog mariadb-bin.000014 | mysql -u root -p
mysqlbinlog --start-position=485214 --stop-position=485594 relay-bin.000002 | mysql -u root -p
MariaDB [test]> select * from test1; +----+-------+---------------------+
| id | name | datum |
+----+-------+---------------------+
| 1 | test1 | 2019-09-25 13:06:36 |
| 2 | test2 | 2019-09-25 13:06:58 |
| 3 | test3 | 2019-09-25 13:07:04 |
| 5 | test3 | 2019-09-25 13:16:45 |
+----+-------+---------------------+ 4 rows in set (0.000 sec)
MariaDB [test]>
the third row should not be there as from the relay log it has been deleted.
Please help i am stuck :(
