Announcement Module
No announcement yet.

MySQL 4.1.13: replication and myisampack

Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL 4.1.13: replication and myisampack

    Dear Folks,

    We have a master with slaves. The disks are all getting full, and I'd like to compress some historical data with myisampack. All are running MySQL 4.1.13. Turning off the master for more than a very short time is not an option.
    1. Can I use myisampack on the master safely?
    2. Will this compression be replicated in any way to the slaves?
    3. Would it be better to run myisampack on one of the slaves and then netcat the result to the master and other slaves? Can you suggest any safety precautions?

  • #2
    1. Yes.
    2. No.
    3. I don't think so.
    4. Never change the data content on the slave; myisampack just changes the packaging, not the content. Okay to pack the historical data, since it is not being written to any more.