> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-parallel-read-in-order-multi-part.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Pausing and resuming a MySQL ClickPipe

> Pausing and resuming a MySQL ClickPipe

export const Image = ({img, alt, size = "lg", background}) => {
  const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
  const backgroundColor = background === "white" ? "white" : background === "black" ? "rgb(31 31 28)" : undefined;
  return <div className={`ch-image-${normalizedSize}`}>
      <Frame>
        <img src={img} alt={alt} style={{
    backgroundColor
  }} />
      </Frame>
    </div>;
};

There are scenarios where it would be useful to pause a MySQL ClickPipe. For example, you may want to run some analytics on existing data in a static state. Or, you might be performing upgrades on MySQL. Here is how you can pause and resume a MySQL ClickPipe.

<h2 id="pause-clickpipe-steps">
  Steps to pause a MySQL ClickPipe
</h2>

1. In the Data Sources tab, click on the MySQL ClickPipe you wish to pause.
2. Head over to the **Settings** tab.
3. Click on the **Pause** button.

<Image img="https://mintcdn.com/private-7c7dfe99-parallel-read-in-order-multi-part/K228OGf-egI2RGpt/images/integrations/data-ingestion/clickpipes/postgres/pause_button.webp?fit=max&auto=format&n=K228OGf-egI2RGpt&q=85&s=f8611880a271feadda13155029c28d59" border size="md" width="769" height="217" data-path="images/integrations/data-ingestion/clickpipes/postgres/pause_button.webp" />

4. A dialog box should appear for confirmation. Click on Pause again.

<Image img="https://mintcdn.com/private-7c7dfe99-parallel-read-in-order-multi-part/K228OGf-egI2RGpt/images/integrations/data-ingestion/clickpipes/postgres/pause_dialog.webp?fit=max&auto=format&n=K228OGf-egI2RGpt&q=85&s=ca0676fb287d4d6972f38e6aa224f6d3" border size="md" width="768" height="288" data-path="images/integrations/data-ingestion/clickpipes/postgres/pause_dialog.webp" />

4. Head over to the **Metrics** tab.
5. In around 5 seconds (and also on page refresh), the status of the pipe should be **Paused**.

<Image img="https://mintcdn.com/private-7c7dfe99-parallel-read-in-order-multi-part/K228OGf-egI2RGpt/images/integrations/data-ingestion/clickpipes/postgres/pause_status.webp?fit=max&auto=format&n=K228OGf-egI2RGpt&q=85&s=119ac8c7b80ce03e047de5eeb7b02a99" border size="md" width="1437" height="256" data-path="images/integrations/data-ingestion/clickpipes/postgres/pause_status.webp" />

<h2 id="resume-clickpipe-steps">
  Steps to resume a MySQL ClickPipe
</h2>

1. In the Data Sources tab, click on the MySQL ClickPipe you wish to resume. The status of the mirror should be **Paused** initially.
2. Head over to the **Settings** tab.
3. Click on the **Resume** button.

<Image img="https://mintcdn.com/private-7c7dfe99-parallel-read-in-order-multi-part/K228OGf-egI2RGpt/images/integrations/data-ingestion/clickpipes/postgres/resume_button.webp?fit=max&auto=format&n=K228OGf-egI2RGpt&q=85&s=ca3377807921987d02d411b26e30f1e2" border size="md" width="1258" height="202" data-path="images/integrations/data-ingestion/clickpipes/postgres/resume_button.webp" />

4. A dialog box should appear for confirmation. Click on Resume again.

<Image img="https://mintcdn.com/private-7c7dfe99-parallel-read-in-order-multi-part/K228OGf-egI2RGpt/images/integrations/data-ingestion/clickpipes/postgres/resume_dialog.webp?fit=max&auto=format&n=K228OGf-egI2RGpt&q=85&s=32f42cbf6fa17fb6a90183e445956be4" border size="md" width="879" height="365" data-path="images/integrations/data-ingestion/clickpipes/postgres/resume_dialog.webp" />

5. Head over to the **Metrics** tab.
6. In around 5 seconds (and also on page refresh), the status of the pipe should be **Running**.
