Tag: mysql

All the articles with the tag "mysql".

• MySQL Primary-Replica Replication: Detailed Setup and Troubleshooting Replicas That Stop Synchronizing

  1 Mar, 2020

  Sets up primary-replica replication using multiple local MySQL instances and introduces replication threads, binlog formats, and configuration steps. Based on actual errors, it covers authentication failures and replicas that stop synchronizing, and discusses asynchronous and semisynchronous replication and common replication topologies.

• Migrating SQL Server Data to MySQL: Connection Troubleshooting and Bulk Imports

  15 Feb, 2020

  This article records a SQL Server-to-MySQL migration with Navicat and troubleshooting when the server refuses connections. It also covers MySQL file imports and exports, directory permissions, delimiters, duplicate handling, and default field values during bulk imports.