Jump to content
Froxlor Forum
  • 0

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


lanbo

Question

Posted

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!

1 answer to this question

Recommended Posts

Posted

it holds sessions and does not need long-term storage, that's why it's HEAP/MEMORY - you can safely skip it fr replication

Archived

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



×
×
  • Create New...