I am replicating the froxlor db (with many other DBs) to a SLAVE mysql server that is used to make backups.
I've found an error in the SLAVE:
Could not execute Delete_rows event on table froxlor.panel_sessions; Can't find record in 'panel_sessions', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000350, end_log_pos 6002396
This is probably because panel_sessions is using a HEAP/MEMORY engine and the SLAVE was rebooted.
Being a MEMORY table, I guess it's not a very important table and it is safe to skip panel_sessions from the replication to avoid such errors.
What is it used this table for? Do you think it's safe to skip replicating it?
Question
lanbo
Hi!
I am replicating the froxlor db (with many other DBs) to a SLAVE mysql server that is used to make backups.
I've found an error in the SLAVE:
This is probably because panel_sessions is using a HEAP/MEMORY engine and the SLAVE was rebooted.
Being a MEMORY table, I guess it's not a very important table and it is safe to skip panel_sessions from the replication to avoid such errors.
What is it used this table for? Do you think it's safe to skip replicating it?
Thanks!
1 answer to this question
Recommended Posts
Archived
This topic is now archived and is closed to further replies.