Jump to content
Froxlor Forum
  • 0

Table panel_sessions, MEMORY engine, bad for replication, can it be skipped?


lanbo

Question

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:

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?

Thanks!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...