GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Replication and Online DDL

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

  • Replication and Online DDL

    Hello!

    Is it possible to utilize my replication for runnig online DDLs?

    (That is - to allow updates while ALTER TABLE is running)

    My replication:
    ==============
    I'm using MySQL replication for high availability.

    My topology is such:

    1. Two servers.
    2. Bidirectional replication (The two servers acts both as master and as slave to one another).
    3. Failover: One server is active for the application, the other is completly passive (No reads/writes).

    Thanks )

  • #2
    http://www.mysqlperformanceblog.com/2008/03/27/using-mmm-to- alter-huge-tables/

    Comment

    Working...
    X