Yandex.Cloud
  • Services
  • Why Yandex.Cloud
  • Pricing
  • Documentation
  • Contact us
Get started
Yandex Managed Service for MySQL
  • Getting started
  • Step-by-step instructions
    • All instructions
    • Information about existing clusters
    • Creating clusters
    • Connecting to databases
    • Stopping and starting clusters
    • Changing clusters
    • Connecting to DataLens
    • How to manage MySQL hosts
    • Database management
    • Database setup
    • Managing database users
    • Managing backups
    • Deleting clusters
    • Database migration to the Cloud
  • Concepts
    • Relationship between service resources
    • Host classes
    • Network in Managed Service for MySQL
    • Quotas and limits
    • Storage types
    • Backups
    • Replication
  • Access management
  • Pricing policy
    • Current pricing policy
    • Archive
      • Before February 1, 2020
  • API reference
    • Authentication in the API
    • gRPC
      • Overview
      • BackupService
      • ClusterService
      • DatabaseService
      • ResourcePresetService
      • UserService
      • OperationService
    • REST
      • Overview
      • Backup
        • Overview
        • get
        • list
      • Cluster
        • Overview
        • addHosts
        • backup
        • create
        • delete
        • deleteHosts
        • get
        • list
        • listBackups
        • listHosts
        • listLogs
        • listOperations
        • restore
        • start
        • stop
        • update
      • Database
        • Overview
        • create
        • delete
        • get
        • list
      • ResourcePreset
        • Overview
        • get
        • list
      • User
        • Overview
        • create
        • delete
        • get
        • grantPermission
        • list
        • revokePermission
        • update
      • Operation
        • Overview
        • get
  • Questions and answers
    • General questions
    • Questions about MySQL
    • All questions on the same page
  1. Concepts
  2. Replication

Replication

  • Replication specifics in Managed Service for MySQL

Managed Service for MySQL clusters use semi-sync replication: by default, the master waits for a transaction to complete in at least one replica. The difference between Managed Service for MySQL semi-sync replication and standard replication is that if all semi-sync replicas are down, the cluster doesn't switch to asynchronous replication. Instead, it disables replication altogether until at least one replica is available.

Replication in Managed Service for MySQL uses global transaction identifiers (GTID), too. They help maintain the data consistency across cluster hosts.

Due to limited resources, the b1.nano, b1.micro, b2.nano, and b2.micro class hosts are not replicated.

Replication specifics in Managed Service for MySQL

If a cluster is single-host or if all replicas, except for the master, are completely unavailable (the status of the hosts is DEAD), replication doesn't work. As soon as a replica appears or becomes available in the cluster, semi-sync replication is performed in stages:

  1. When a replica becomes available, asynchronous replication is immediately enabled from the master. The master remains fully available for reads and writes and replica lag is gradually reduced.
  2. As soon as the lag is less than 100 MB, synchronous replication is enabled. The master becomes unavailable for writes until the data is fully synced with the replica: this process can take from one to tens of seconds depending on network performance.
  3. Once data on the master and replica is fully synced, the hosts are made fully available again and replicated synchronously.
Language
Careers
Privacy policy
Terms of use
© 2021 Yandex.Cloud LLC