---
title: "Differences between MySQL semi-sync and MySQL sync"
sidebar_label: "Differences between MySQL semi-sync and MySQL sync"
sidebar_position: 1
description: "Differences between MySQL semi-sync and MySQL sync DBMSs"
---

import Formbricks from '@theme/MDXComponents/Formbricks'
import {CustomTable} from '@selectel/docux/components'

# Differences between MySQL semi-sync and MySQL sync

[MySQL sync](/managed-databases/mysql-sync/) and [MySQL semi-sync](/managed-databases/mysql-semi-sync/) DBMSs are available in Managed Databases. The table below shows the differences between them.

<CustomTable>
  <table data-sticky>
    <thead>
      <tr>
        <th />

        <th>MySQL replication</th><th>MySQL semi-synchronous replication</th>
      </tr>
    </thead>

    <tbody>
      <tr>
        <th>Replication</th><td>Multi-master (synchronous) — requires all replicas to receive data for a write to be confirmed</td>

        <td>
          Master-replica (semi-synchronous) — requires at least one of the replicas to receive data for a write to be confirmed
        </td>
      </tr>

      <tr>
        <th>Fault tolerance</th><td>You can create a cluster without replicas or with only two replicas</td><td>You can create a cluster without replicas, with one, or with two replicas</td>
      </tr>

      <tr>
        <th>Limitations</th>

        <td>
          Fault-tolerant clusters with replicas are subject to [limitations](/managed-databases/mysql-sync/limitations.mdx)
        </td>

        <td>No limitations</td>
      </tr>

      <tr>
        <th>Connecting to the cluster</th><td>Port 6033 is used to connect to ProxySQL</td><td>Port 3306 is used to connect to the cluster</td>
      </tr>
    </tbody>
  </table>
</CustomTable>

<Formbricks />