i have to modify primary for partitioning. pt-online-schema-change complaints
about dropping primary.Still i can ignore the warning and proceed.
Thanks
From: Guillaume Lefranc
To: Suresh Rajagopal ; Maria Discuss
Sent: Monday, March 13, 2017 6:08 PM
Subject: Re: [Maria-discuss] Parti
Thanks Peter. I am moving this database to a new datacenter. So i do have a
backup slave. I tried this approach on QA and worked fine. Need to know if
there is any known issues before i migrate the prod.
From: Peter Mclarty
To: Suresh Rajagopal
Cc: Maria Discuss
Sent: Monday, March
Hi Suersh
I would add a second slave as insurance before doing this to provide some
risk mitigation. Make sure you have adequate spare space on your slave as
you will want as much again as the table to make changes. make sure you
have chosen the right approach to your partitioning before doing anyt
Use pt-online-schema-change.
Best regards
GL
Le mar. 14 mars 2017 à 08:35, Suresh Rajagopal a
écrit :
> Hi,
>
> What is the fastest approach to partition a huge table with 2 additional
> columns? How safe its to alter table on slave and promote slave as master?
> It takes 25 hours to alter the
Hi,
What is the fastest approach to partition a huge table with 2 additional
columns? How safe its to alter table on slave and promote slave as master? It
takes 25 hours to alter the table for now on slave.
MariaDB Version : 10.1.18OS : Centos 6
ThanksSuresh__
5 matches
Mail list logo
