Jump to content
Froxlor Forum
  • 0
lanbo

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

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!

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 1

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...





×
×
  • Create New...