Yandex.Cloud
  • Services
  • Why Yandex.Cloud
  • Solutions
  • Pricing
  • Documentation
  • Contact us
Get started
Yandex Data Transfer
  • Getting started
  • Step-by-step instructions
    • All instructions
    • Managing a source endpoint
      • Creating a source endpoint
      • Updating a source endpoint
      • Deleting a source endpoint
    • Managing a target endpoint
      • Creating a target endpoint
      • Updating a target endpoint
      • Deleting a target endpoint
    • Managing the transfer process
      • Creating a transfer
      • Updating a transfer
      • Deleting a transfer
  • Concepts
    • Relationship between service resources
    • What tasks is the service used for?
    • Service specifics
      • Overview
      • MySQL specifics
      • PostgreSQL specifics
    • Monitoring transfers
    • Quotas and limits
  • Access management
  • Pricing policy
  • Questions and answers
  1. Concepts
  2. Service specifics
  3. MySQL specifics

MySQL specifics

    We can't guarantee data migration scenarios between major versions with a minor version.

    1. Make sure that full binary log mode is enabled for the source database.
    2. Working with constraints (CONSTRAINT).
      • Constraints (CONSTRAINT) are enabled on the target by default. This is taken into account during the transfer. For large databases, this can significantly affect replication performance.
      • At the transfer level, you can disable CONSTRAINT to regain performance. However, the behavior may vary depending on the low-level data storage subsystem: unlike MyISAM, we can't guarantee cascade delete for InnoDB.
    3. Only the MyISAM and InnoDB low-level storage subsystems are tested regularly. We don't guarantee that the other low-level storage subsystems will behave properly.
    4. Running the ALTER operators:
      • In some cases, such operators may slow down replication, but the performance usually recovers after a while.
      • If you perform complex manipulations that involve changing the schema on the source, run explicit checks on the target database.
    5. You can change the limit on the size of the chunk sent using the max_allowed_packet parameter.
    6. SQL mode must be the same on the source and target.

    The transfer checks this requirement and, if any discrepancy is found, requests administrator intervention.

    Language / Region
    Careers
    Privacy policy
    Terms of use
    Brandbook
    © 2021 Yandex.Cloud LLC