MySQL Forums :: Partitioning :: Partitioning & Replication


Advanced Search

Partitioning & Replication
Posted by: Robert Gunther ()
Date: April 09, 2015 06:30PM

I started using Partitioning on a table with millions of rows. I delete old data from the table, and removing records with the delete command used to kill performance due to locks while the delete was happening.

The partitioning and dropping the oldest partition has been a life saver.

Now I want to add partitioning to another database, but the database is replicated.

When I setup the partition will those commands replicate to slaves also? I would assume so but just want some verification as I would be doing it on the production table... I can test the partitioning setup in the development environment but that does not have replication.

Options: ReplyQuote


Subject Views Written By Posted
Partitioning & Replication 1386 Robert Gunther 04/09/2015 06:30PM
Re: Partitioning & Replication 754 Rick James 04/12/2015 09:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.