Migração MySQL: Como migrar do AWS Amazon Aurora MYSQL para OCI HeatWave MYSQL com mínimo downtime.

Carlos Furushima
março 25, 2025
OCI

Neste artigo vamos demonstrar, de maneira clara e prática, como realizar uma migração entre bancos de dados MySQL com o mínimo possível de downtime (indisponibilidade). Para este exemplo, nosso ambiente de origem (source) será o Amazon Aurora MySQL 8.0.39, e o ambiente de destino (target) será o OCI HeatWave MySQL 8.4.4.

Antes de iniciarmos o procedimento de migração, é necessário garantir que alguns pré-requisitos de infraestrutura estejam devidamente configurados e operacionais:

Infraestrutura AWS e OCI já instaladas, configuradas e operacionais.
Cluster Amazon Aurora MySQL já existente e atualmente em operação como banco de produção (ambiente de origem ou source).
Cluster OCI HeatWave MySQL já criado e configurado, pronto para receber os dados migrados do Amazon Aurora. Este será o novo ambiente de produção (ambiente de destino ou target).
Conectividade devidamente configurada entre o Amazon Aurora MySQL e o OCI HeatWave MySQL, especificamente na porta padrão do MySQL (3306).

Os detalhes sobre a configuração dos pré-requisitos não serão abordados neste artigo. Caso você tenha dificuldades durante essa etapa, ou deseje compreender melhor cada passo mencionado, recomenda-se consultar a documentação oficial, cujo link está disponível abaixo:

https://www.oracle.com/a/ocom/docs/mysql/amazon-aurora-to-mysql-heatwave-on-aws-migration.pdf

Este documento é um guia completo que aborda desde a criação das infraestruturas AWS e OCI até os procedimentos que serão resumidamente demonstrados neste artigo. Lá você encontrará explicações detalhadas sobre conceitos que aqui serão simplificados, a fim de manter este artigo objetivo e direto.

A seguir apresentamos um fluxograma macro detalhando como será realizado o processo de migração de um banco de dados MySQL que atualmente está hospedado na infraestrutura AWS Amazon Aurora MySQL para a infraestrutura OCI HeatWave MySQL.

O objetivo principal dessa abordagem é realizar a migração com o menor downtime possível. Para alcançar esse objetivo, utilizaremos uma técnica que consiste basicamente em duas etapas principais:

Migração inicial dos dados (Baseline)
Nesta fase inicial, o banco de dados completo (ou seja, a base integral) é migrado da origem (AWS Amazon Aurora MySQL) para o destino (OCI HeatWave MySQL). Este procedimento será realizado com o auxílio do MySQL Shell, uma ferramenta robusta que garante consistência e integridade na transferência dos dados.
Replicação contínua dos dados diferenciais (Delta)
Após a migração inicial, haverá uma replicação contínua das alterações que ocorrerem na origem enquanto a migração final não é concluída. Essa replicação diferencial é realizada por meio dos binlogs (binary logs), arquivos que registram todas as transações realizadas no banco de dados de origem.

Para viabilizar essa replicação em tempo real entre os ambientes AWS Aurora e OCI HeatWave, será utilizado o recurso conhecido como OCI HeatWave MySQL Channel, que estabelece uma conexão direta e confiável entre os ambientes, tornando o OCI HeatWave MySQL uma réplica ativa (também conhecida como réplica read/write) do Amazon Aurora MySQL.

Na prática, durante o processo, o ambiente OCI HeatWave MySQL funcionará temporariamente como um banco de dados replicado (Slave) que acompanhará fielmente as alterações feitas no ambiente Master (Amazon Aurora). Quando todas as replicações diferenciais estiverem em sincronia, restará apenas apontar os servidores de aplicação (servidores web, appservers, middlewares etc.) para o novo ambiente de produção OCI HeatWave MySQL. Dessa forma, o único tempo de indisponibilidade (downtime) será o necessário para realizar os ajustes desses apontamentos nos servidores de aplicação, garantindo uma transição rápida, segura e com mínimo impacto para os usuários finais.

O resultado final será um ambiente totalmente migrado e operacional na infraestrutura OCI HeatWave, mantendo-se fiel às características e dados originais do Amazon Aurora, com ganhos adicionais em desempenho e escalabilidade proporcionados pela tecnologia HeatWave.

Neste artigo, dividiremos o conteúdo em duas partes principais, com o objetivo de tornar mais clara a compreensão das etapas necessárias para realizar uma migração eficiente entre os ambientes AWS Amazon Aurora MySQL e OCI MySQL HeatWave, mantendo o mínimo de indisponibilidade possível.

Parte 1: Exportação (AWS Aurora MySQL) e Importação (OCI MySQL HeatWave)
Na primeira parte deste artigo, explicaremos detalhadamente como realizar o processo de exportação dos dados do banco de dados AWS Amazon Aurora MySQL (ambiente de origem) utilizando o MySQL Shell, uma ferramenta poderosa e prática que permite exportações rápidas, seguras e consistentes dos dados.

Após a exportação, demonstraremos passo a passo como realizar o processo inverso, ou seja, a importação dos dados extraídos para o ambiente destino (OCI MySQL HeatWave). Nesta etapa, abordaremos também as melhores práticas e recomendações para garantir uma importação bem-sucedida, além dos cuidados necessários para garantir a integridade dos dados importados.

Parte 2: Implementação do OCI HeatWave MySQL Channel (Replicação MASTER-SLAVE em tempo real)
Na segunda parte do artigo, abordaremos de forma detalhada como implementar o OCI HeatWave MySQL Channel, que permitirá estabelecer uma replicação em tempo real no modelo MASTER-SLAVE entre os bancos de dados AWS Aurora MySQL (MASTER) e OCI MySQL HeatWave (SLAVE).

Esse método garante que todas as transações realizadas no ambiente AWS Aurora MySQL sejam replicadas automaticamente e em tempo real para o ambiente OCI MySQL HeatWave, utilizando para isso os binlogs (binary logs). Dessa forma, o OCI MySQL HeatWave se manterá sempre atualizado com o ambiente de origem, permitindo que a migração final ocorra com o mínimo de downtime possível.

Além disso, vamos apresentar orientações sobre a configuração do canal de replicação, monitoramento do status e solução de possíveis problemas de sincronização durante a replicação.

Dessa maneira, ao final deste artigo, você terá todas as informações necessárias para realizar a migração segura, consistente e com mínimo impacto operacional entre AWS Amazon Aurora MySQL e OCI MySQL HeatWave.

Para facilitar o entendimento, apresentamos abaixo um fluxograma que ilustra claramente as etapas que serão demonstradas na prática ao longo deste artigo.

Antes de iniciarmos o procedimento prático de exportação e importação utilizando o MySQL Shell, é fundamental garantir que os seguintes parâmetros estejam devidamente configurados e ativados no ambiente de origem (SOURCE), ou seja, no AWS Amazon Aurora MySQL:


gtid_mode = ON
enforce-gtid-consistency = ON
log_bin = ON
binlog_format = ROW
log_slave_updates = ON

Esses parâmetros são obrigatórios para assegurar que a replicação baseada em GTID (Global Transaction Identifiers) e os logs binários estejam corretamente habilitados, garantindo uma migração confiável, consistente e adequada ao ambiente OCI HeatWave MySQL.

Para mais detalhes consulte a documentação abaixo :

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_LogAccess.MySQL.BinaryFormat.html

EXPORTAÇÃO – EXPORT – util.dumpschemas

Exportação: Nesta etapa realizaremos a exportação (dump) do banco de dados npx. O arquivo gerado será armazenado no diretório /DUMP/NPX/. Além disso, serão utilizados parâmetros específicos que garantem total compatibilidade do dump com o ambiente de destino, o OCI MySQL HeatWave.

util.dumpSchemas(
  ["npx"],
  "/DUMP/NPX/",
  {
    threads: 60,
    ocimds: true,
    compatibility: [
      "skip_invalid_accounts",
      "strip_restricted_grants",
      "ignore_wildcard_grants",
      "strip_definers",
      "strip_invalid_grants",
      "create_invisible_pks"    ],
    consistent: true
  }
);

Explicação dos parâmetros utilizados no comando util.dumpSchemas:

util.dumpSchemas
Comando do MySQL Shell usado para gerar um dump (exportação dos dados).
["npx"]
Indica o nome do banco de dados que será exportado.
"/DUMP/NPX/"
Diretório (pasta) onde serão armazenados os arquivos do dump gerado.
threads: 60
Número de threads simultâneas usadas na exportação. Neste caso, serão usados 60 processos paralelos para acelerar a geração do dump.
ocimds: true
Otimiza automaticamente a exportação para garantir total compatibilidade com o ambiente OCI MySQL Database Service (MDS) ou OCI MySQL HeatWave.
Parâmetros do campo compatibility:
- skip_invalid_accounts
  Ignora contas de usuários inválidas ou não compatíveis com o destino.
- strip_restricted_grants
  Remove permissões restritas que não são suportadas pelo banco de dados de destino.
- ignore_wildcard_grants
  Ignora permissões de usuários criadas com curingas (%), aumentando a segurança e evitando problemas no destino.
- strip_definers
  Remove definições específicas de usuários (DEFINER) em objetos como views, stored procedures e triggers, evitando erros caso esses usuários não existam no destino.
- strip_invalid_grants
  Remove permissões inválidas ou incompatíveis com o destino.
- create_invisible_pks
  Cria automaticamente chaves primárias invisíveis nas tabelas que não possuem chave primária, garantindo compatibilidade com ambientes como OCI HeatWave.
consistent: true
Garante que o dump seja consistente, refletindo exatamente o estado do banco de dados em um único momento específico, evitando inconsistências durante a exportação.

IMPORTAÇÃO – IMPORT – util.loadDump

Importação: Nesta etapa será realizada a importação do dump previamente gerado para o banco de dados npx. Os arquivos a serem importados estão localizados no diretório /DUMP/NPX/. Para acelerar esse processo, utilizaremos 60 threads em paralelo e o parâmetro ignoreVersion, permitindo a importação mesmo em versões diferentes do MySQL. O banco de dados de destino será explicitamente definido pelo parâmetro schema, que neste caso também se chama npx. Vale lembrar que no MySQL, o termo schema representa o nome do banco de dados.

util.loadDump(
  "/DUMP/NPX",
  {
    threads: 60,
    ignoreVersion: true,
	  schema: 'npx'
  }
);

Explicação dos parâmetros utilizados no comando util.loadDump:

util.loadDump
Comando do MySQL Shell utilizado para carregar (importar) um dump previamente exportado para o banco de dados.
"/DUMP/NPX"
Diretório (pasta) onde estão armazenados os arquivos do dump que será importado.
threads: 60
Número de processos paralelos utilizados durante a importação. Neste exemplo, 60 threads serão usadas para acelerar o carregamento dos dados.
ignoreVersion: true
Ignora diferenças de versão entre o banco de dados original (onde o dump foi gerado) e o banco de dados de destino. Isso permite importar o dump mesmo se houver pequenas diferenças de versão.
schema: 'npx'
Define explicitamente o nome do banco de dados (schema) onde os dados serão importados. Nesse caso, o schema destino será npx.

Agora que já entendemos como realizar o processo de exportação e importação do banco de dados, vamos acompanhar, na prática, a execução desses procedimentos em um ambiente real de laboratório.

Execução do export – util.dumpschemas

  MySQL  XXXXXXXXX-producao-clone.c4xlg1kbktwa.us-west-2.rds.amazonaws.com:3306 ssl  JS > util.dumpSchemas(
                                             ->   ["npx"],
                                             ->   "/DUMP/NPX/",
                                             ->   {
                                             ->     threads: 60,
                                             ->     ocimds: true,
                                             ->     compatibility: [
                                             ->       "skip_invalid_accounts",
                                             ->       "strip_restricted_grants",
                                             ->       "ignore_wildcard_grants","strip_definers",
                                             ->       "strip_invalid_grants","create_invisible_pks"    ],
                                             ->     consistent: true
                                             ->   }
                                             -> );
                                             ->
NOTE: The 'targetVersion' option is set to 9.1.0. This version supports the SET_ANY_DEFINER privilege, using the 'strip_definers' compatibility option is unnecessary.
NOTE: Backup lock is not available to the account 'tksmaster'@'%' and DDL changes will not be blocked. The dump may fail with an error if schema changes are made while dumping.
Acquiring global read lock
WARNING: The current user lacks privileges to acquire a global read lock using 'FLUSH TABLES WITH READ LOCK'. Falling back to LOCK TABLES...
Table locks acquired
Initializing - done
1 schemas will be dumped and within them 276 tables, 0 views, 5 routines.
Gathering information - done
All transactions have been started
Global read lock has been released
NOTE: When migrating to MySQL HeatWave Service, please always use the latest available version of MySQL Shell.
Checking for compatibility with MySQL HeatWave Service 9.1.0
Checking for potential upgrade issues.
The MySQL server at
beecare-producao-clone.c4xlg1kbktwa.us-west-2.rds.amazonaws.com:3306, version
8.0.39 - 2f855dc7, will now be checked for compatibility issues for upgrade to
MySQL 9.1.0.

WARNING: Upgrading MySQL Server from version 8.0.39 to 9.1.0 is not supported.
Please consider running the check using the following option: targetVersion=8.4

1) Checks for foreign keys not referencing a full unique index
(foreignKeyReferences)
   No issues found

2) Checks for errors in column definitions (columnDefinition)
   No issues found

3) Checks for partitions by key using columns with prefix key indexes
(partitionsWithPrefixKeys)
   No issues found
Errors:   0
Warnings: 0
Notices:  0

No known compatibility errors or issues were found.
NOTE: Database `npx` had unsupported ENCRYPTION option commented out
NOTE: Function `npx`.`available_date` had definer clause removed
NOTE: Function `npx`.`available_date` had SQL SECURITY characteristic set to INVOKER
NOTE: Procedure `npx`.`GetEligibilityRecords` had definer clause removed
NOTE: Procedure `npx`.`GetEligibilityRecords` had SQL SECURITY characteristic set to INVOKER
NOTE: Procedure `npx`.`available_date_procedure` had definer clause removed
NOTE: Procedure `npx`.`available_date_procedure` had SQL SECURITY characteristic set to INVOKER
NOTE: Procedure `npx`.`SP_INSERT_PAYMENT_ADVICES` had definer clause removed
NOTE: Procedure `npx`.`SP_INSERT_PAYMENT_ADVICES` had SQL SECURITY characteristic set to INVOKER
NOTE: Procedure `npx`.`cadastar_payment_advice_partners` had definer clause removed
NOTE: Procedure `npx`.`cadastar_payment_advice_partners` had SQL SECURITY characteristic set to INVOKER
NOTE: Table `npx`.`migrations` does not have a Primary Key, this will be fixed when the dump is loaded
NOTE: Table `npx`.`password_resets` does not have a Primary Key, this will be fixed when the dump is loaded
NOTE: Table `npx`.`message_organization` does not have a Primary Key, this will be fixed when the dump is loaded
NOTE: Table `npx`.`message_menu` does not have a Primary Key, this will be fixed when the dump is loaded
Validating MySQL HeatWave Service compatibility - done

NOTE: One or more tables without Primary Keys were found.

      Missing Primary Keys will be created automatically when this dump is loaded.
      This will make it possible to enable High Availability in MySQL HeatWave Service DB System instance without application impact and without changes to the source database.
      Inbound Replication into a DB System HA instance will also be possible, as long as the instance has version 8.0.32 or newer. For more information, see https://docs.oracle.com/en-us/iaas/mysql-database/doc/creating-replication-channel.html.

Compatibility issues with MySQL HeatWave Service 9.1.0 were found and repaired. Please review the changes made before loading them.
Writing global DDL files
Writing schema metadata - done
Running data dump using 60 threads.
NOTE: Progress information uses estimated values and may not be accurate.
NOTE: Table statistics not available for `npx`.`password_securities`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `npx`.`password_securities`;' first.
Writing DDL - done
Writing table metadata - done
Starting data dump
NOTE: Table statistics not available for `npx`.`incident_types`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `npx`.`incident_types`;' first.
NOTE: Backup lock is not available to the account 'tksmaster'@'%' and DDL changes were not blocked. The DDL is consistent, the world may resume now.
NOTE: Table statistics not available for `npx`.`comercial_contracts`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `npx`.`comercial_contracts`;' first.
NOTE: Table statistics not available for `npx`.`comercial_negotiations`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `npx`.`comercial_negotiations`;' first.
NOTE: Table statistics not available for `npx`.`procedure_info_files`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `npx`.`procedure_info_files`;' first.
NOTE: Table statistics not available for `npx`.`refute_approval_levels`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `npx`.`refute_approval_levels`;' first.
NOTE: Table statistics not available for `npx`.`modules`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `npx`.`modules`;' first.
NOTE: Table statistics not available for `npx`.`organization_payment_types`, chunking operation may be not optimal. Please consider running 'ANALYZE TABLE `npx`.`organization_payment_types`;' first.
110% (3.60G rows / ~3.26G rows), 33.50K rows/s, 25.84 MB/s uncompressed, 1.17 MB/s compressed
Dump duration: 03:17:25s
Total duration: 03:24:46s
Schemas dumped: 1
Tables dumped: 276
Uncompressed data size: 1.45 TB
Compressed data size: 413.88 GB
Compression ratio: 3.5
Rows written: 3597220261
Bytes written: 413.88 GB
Average uncompressed throughput: 122.12 MB/s
Average compressed throughput: 34.94 MB/s

Execução do import – util.loadDump

MySQL  10.27.2.35:3306 ssl  JS > util.loadDump(
                               ->   "/DUMP/NPX",
                               ->   {
                               ->     threads: 60,
                               ->     ignoreVersion: true,
                               -> schema: 'npx'
                               ->   }
                               -> );
                               ->
Loading DDL and Data from '/DUMP/NPX' using 60 threads.
Opening dump - done
Target is MySQL 8.4.4-u3-cloud (MySQL HeatWave Service). Dump was produced from MySQL 8.0.39
WARNING: Destination MySQL version is different than the value of the 'targetVersion' option set when the dump was created: 9.1.0
Scanning metadata - done
Checking for pre-existing objects - done
NOTE: The dump contains tables without Primary Keys and it is loaded with the 'createInvisiblePKs' option set to true, Inbound Replication into an MySQL HeatWave Service DB System instance with High Availability can be used with this dump.
Executing common preamble SQL - done
NOTE: [Worker017]: Error processing table `npx`.`comercial_auditor_tables`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker050]: Error processing table `npx`.`comercial_procedures`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker023]: Error processing table `npx`.`comercial_volumes`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker022]: Error processing table `npx`.`users`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker017]: Error processing table `npx`.`comercial_auditor_tables`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker022]: Error processing table `npx`.`users`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker046]: Error processing table `npx`.`payment_advice_partners`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker039]: Error processing table `npx`.`billing_headers`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker022]: Error processing table `npx`.`users`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker057]: Error processing table `npx`.`tax_records`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker006]: Error processing table `npx`.`statements`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker051]: Error processing table `npx`.`statement_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker014]: Error processing table `npx`.`partner_password_addresses`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker022]: Error processing table `npx`.`users`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker039]: Error processing table `npx`.`billing_headers`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker057]: Error processing table `npx`.`tax_records`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker006]: Error processing table `npx`.`statements`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker049]: Error processing table `npx`.`payment_glosa_insight_tmps`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker051]: Error processing table `npx`.`statement_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker014]: Error processing table `npx`.`partner_password_addresses`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker043]: Error processing table `npx`.`payment_glosa_insights`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker039]: Error processing table `npx`.`billing_headers`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker006]: Error processing table `npx`.`statements`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker057]: Error processing table `npx`.`tax_records`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker038]: Error processing table `npx`.`partner_configurations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker023]: Error processing table `npx`.`comercial_volumes`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker017]: Error processing table `npx`.`comercial_auditor_procedure_reference_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker021]: Error processing table `npx`.`partner_integration_windows`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker051]: Error processing table `npx`.`statement_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker014]: Error processing table `npx`.`partner_password_addresses`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker009]: Error processing table `npx`.`procedure_glosa_insights`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker053]: Error processing table `npx`.`glosas`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker037]: Error processing table `npx`.`protocol_payments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker025]: Error processing table `npx`.`document_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker032]: Error processing table `npx`.`erp_refute_glosa_integrations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker054]: Error processing table `npx`.`mass_import_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker029]: Error processing table `npx`.`document_paperless_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker059]: Error processing table `npx`.`rpa_tasks`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker045]: Error processing table `npx`.`refute_glosa_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker056]: Error processing table `npx`.`authorization_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker012]: Error processing table `npx`.`protocol_payment_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker001]: Error processing table `npx`.`authorization_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker027]: Error processing table `npx`.`partner_passwords`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker003]: Error processing table `npx`.`authorizations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker036]: Error processing table `npx`.`refute_glosas`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker030]: Error processing table `npx`.`partners`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker022]: Error processing table `npx`.`users`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker015]: Error processing table `npx`.`comercial_contracts`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker035]: Error processing table `npx`.`reconcile_statement_index_data_tmps`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker021]: Error processing table `npx`.`partner_integration_windows`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker019]: Error processing table `npx`.`resubmission_details`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker038]: Error processing table `npx`.`partner_connections`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker057]: Error processing table `npx`.`tax_records`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker039]: Error processing table `npx`.`billing_headers`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker006]: Error processing table `npx`.`statements`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker023]: Error processing table `npx`.`comercial_volumes`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker011]: Error processing table `npx`.`partner_integration_window_audits`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker013]: Error processing table `npx`.`procedure_glosa_insight_tmps`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker017]: Error processing table `npx`.`comercial_auditor_procedure_reference_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker044]: Error processing table `npx`.`related_glosas`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker051]: Error processing table `npx`.`statement_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker058]: Error processing table `npx`.`procedure_info_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker002]: Error processing table `npx`.`integration_window_logs`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker014]: Error processing table `npx`.`partner_password_addresses`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker049]: Error processing table `npx`.`payment_glosa_insight_tmps`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker025]: Error processing table `npx`.`document_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker040]: Error processing table `npx`.`partner_status_relations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker027]: Error processing table `npx`.`partner_passwords`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker007]: Error processing table `npx`.`guide_payments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker004]: Error processing table `npx`.`document_paperless`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker048]: Error processing table `npx`.`refute_glosa_replies`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker029]: Error processing table `npx`.`document_paperless_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker054]: Error processing table `npx`.`mass_import_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker032]: Error processing table `npx`.`erp_refute_glosa_integrations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker045]: Error processing table `npx`.`refute_glosa_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker056]: Error processing table `npx`.`authorization_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker031]: Error processing table `npx`.`organization_from_to_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker012]: Error processing table `npx`.`protocol_payment_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker001]: Error processing table `npx`.`authorization_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker059]: Error processing table `npx`.`rpa_tasks`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker036]: Error processing table `npx`.`refute_glosas`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker030]: Error processing table `npx`.`partners`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker030]: Error processing table `npx`.`partners`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker043]: Error processing table `npx`.`payment_glosa_insights`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker019]: Error processing table `npx`.`resubmission_details`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker037]: Error processing table `npx`.`protocol_payments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker003]: Error processing table `npx`.`authorizations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker009]: Error processing table `npx`.`procedure_glosa_insights`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker048]: Error processing table `npx`.`refute_glosa_replies`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker053]: Error processing table `npx`.`glosas`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker035]: Error processing table `npx`.`reconcile_statement_index_data_tmps`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker007]: Error processing table `npx`.`guide_payments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker013]: Error processing table `npx`.`procedure_glosa_insight_tmps`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker030]: Error processing table `npx`.`partners`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker019]: Error processing table `npx`.`resubmission_details`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker037]: Error processing table `npx`.`protocol_payments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker057]: Error processing table `npx`.`tax_records`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker011]: Error processing table `npx`.`erp_reconcile_integrations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker025]: Error processing table `npx`.`document_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker045]: Error processing table `npx`.`refute_glosa_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker029]: Error processing table `npx`.`document_paperless_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker027]: Error processing table `npx`.`partner_passwords`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker056]: Error processing table `npx`.`authorization_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker032]: Error processing table `npx`.`erp_refute_glosa_integrations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker031]: Error processing table `npx`.`organization_from_to_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker012]: Error processing table `npx`.`protocol_payment_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker001]: Error processing table `npx`.`authorization_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker054]: Error processing table `npx`.`mass_import_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker053]: Error processing table `npx`.`glosas`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker048]: Error processing table `npx`.`refute_glosa_replies`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker036]: Error processing table `npx`.`refute_glosas`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker019]: Error processing table `npx`.`resubmission_details`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker007]: Error processing table `npx`.`guide_payments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker022]: Error processing table `npx`.`users`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker002]: Error processing table `npx`.`organizations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker048]: Error processing table `npx`.`refute_glosa_replies`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker045]: Error processing table `npx`.`refute_glosa_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker029]: Error processing table `npx`.`document_paperless_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker032]: Error processing table `npx`.`erp_refute_glosa_integrations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker001]: Error processing table `npx`.`authorization_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker012]: Error processing table `npx`.`protocol_payment_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker056]: Error processing table `npx`.`authorization_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker054]: Error processing table `npx`.`mass_import_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker036]: Error processing table `npx`.`refute_glosas`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker027]: Error processing table `npx`.`partner_passwords`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker030]: Error processing table `npx`.`partners`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker045]: Error processing table `npx`.`refute_glosa_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker001]: Error processing table `npx`.`authorization_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker054]: Error processing table `npx`.`mass_import_files`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker056]: Error processing table `npx`.`authorization_attachments`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker029]: Error processing table `npx`.`document_paperless_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker012]: Error processing table `npx`.`protocol_payment_histories`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker032]: Error processing table `npx`.`erp_refute_glosa_integrations`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
NOTE: [Worker027]: Error processing table `npx`.`partner_passwords`, will retry after delay: MySQL Error 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
Executing DDL - done
Executing view DDL - done
Starting data load
2 thds indexing - 100% (1.45 TB / 1.45 TB), 0.00 B/s (15.64K rows/s), 276 / 276 tables done
Building indexes - done
Executing common postamble SQL - done
43064 chunks (3.60G rows, 1.45 TB) for 276 tables in 1 schemas were loaded in 7 hours 44 min 26 sec (avg throughput 51.91 MB/s, 129.09K rows/s)
277 DDL files were executed in 16 sec.
Data load duration: 7 hours 44 min 26 sec
2 indexes were built in 1 min 21 sec.
Total duration: 7 hours 45 min 54 sec
0 warnings were reported during the load.

Neste ponto do artigo, temos o seguinte cenário consolidado: já realizamos uma exportação do banco de dados utilizando o comando util.dumpSchemas no ambiente de origem (AWS Amazon Aurora MySQL) e uma importação desses dados no ambiente de destino (OCI HeatWave MySQL) utilizando o comando util.loadDump.

Com isso, partiremos agora para a segunda parte do nosso artigo, onde faremos passo a passo a configuração do OCI HeatWave MySQL Channel. Essa configuração permitirá criar uma replicação no modelo MASTER/SLAVE entre os dois ambientes mencionados, transformando o AWS Amazon Aurora MySQL no banco de dados MASTER e o OCI HeatWave MySQL em sua réplica (SLAVE). Assim, todas as transações realizadas no Aurora MySQL serão automaticamente replicadas em tempo real para o OCI HeatWave MySQL.

Nesta etapa, é importante garantir que o usuário específico para replicação já tenha sido criado no ambiente SOURCE (origem), ou seja, no banco de dados AWS Amazon Aurora MySQL. Caso ainda não tenha sido feito, utilize os comandos abaixo para criar o usuário e conceder as permissões necessárias para replicação:

CREATE USER 'repuser'@'%' IDENTIFIED BY 'minha_senha_forte';
GRANT REPLICATION SLAVE ON *.* TO 'repuser'@'%';

Certificando que GTID esta no ponto correto

Ao realizar um dump (exportação) utilizando o comando util.dumpSchemas, será gerado automaticamente um arquivo especial chamado @.json no diretório escolhido para armazenar o dump.

Este arquivo @.json é um arquivo de metadados contendo diversas informações essenciais sobre o dump realizado. Entre as informações mais relevantes presentes neste arquivo está o conjunto GTID (Global Transaction ID), que é crucial para garantir consistência e rastreamento correto das transações replicadas.

Recomenda-se sempre verificar e consultar esse arquivo antes da importação (load), pois o GTID ali informado será utilizado posteriormente para configuração correta da replicação e execução do comando SET_GTID_PURGED.

Ignorar ou não utilizar corretamente o arquivo @.json pode levar a erros comuns e sérios problemas de consistência na migração e replicação do banco de dados.

[root@gateway-furushima-linux ~]# cd /DUMP/NPX/
[root@gateway-furushima-linux NPX]# pwd
/DUMP/NPX
[root@gateway-furushima-linux NPX]# cat @.json | grep -i '"gtidExecuted"'
    "gtidExecuted": "415d143e-3653-30b3-980b-657ad05d72bd:1-44171859",

[root@gateway-furushima-linux NPX]# mysql -u sys -p'#SENHA_DO_MYSQL#' -h 192.168.1.35  -P 3306
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 886
Server version: 8.4.4-u4-cloud MySQL Enterprise - Cloud

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>  call sys.SET_GTID_PURGED("+415d143e-3653-30b3-980b-657ad05d72bd:1-44171859");
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'gtid_executed';
+---------------+-----------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                         |
+---------------+-----------------------------------------------------------------------------------------------+
| gtid_executed | 415d143e-3653-30b3-980b-657ad05d72bd:1-49842480,
df21fd43-067a-11f0-b189-020017028ccd:1-44462 |
+---------------+-----------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Ao utilizar o comando SET_GTID_PURGED, siga rigorosamente o modelo abaixo para garantir que não ocorram erros na replicação dos dados:

CALL sys.SET_GTID_PURGED("+<gtidSet>");

Veja um exemplo prático:

CALL sys.SET_GTID_PURGED("+415d143e-3653-30b3-980b-657ad05d72bd:1-44171859");

Atenção especial ao sinal “+”:
Note que é obrigatório utilizar o sinal “+” antes do conjunto GTID (<gtidSet>). Esse sinal indica ao MySQL que o GTID fornecido deve ser adicionado (“append”) ao conjunto já existente, em vez de substituir completamente os valores atuais.

Essa pequena particularidade é extremamente importante e frequentemente ignorada ou esquecida, sendo um dos principais motivos de erros durante a migração e replicação dos dados utilizando GTIDs. Sempre verifique cuidadosamente a presença do sinal “+” ao executar este comando.

Como identificar problemas de replicação no MySQL?

A forma mais eficaz de identificar problemas relacionados à replicação no MySQL é conectar diretamente na instância réplica do MySQL DB System e executar comandos específicos de diagnóstico. Para realizar esses comandos, recomendamos o uso da ferramenta MySQL Shell, que oferece uma interface prática e robusta para administração do MySQL.

Normalmente, os problemas relacionados à replicação são reportados em quatro locais diferentes:

Comando SHOW REPLICA STATUS\G
Este é o método mais utilizado, porém não é o mais completo. Ele oferece uma visão geral do status da replicação, apresentando rapidamente se há algum problema com os threads (SQL_thread ou IO_thread).
Tabela performance_schema.replication_connection_status
Esta tabela deve ser consultada quando o IO_thread (responsável pela comunicação entre Master e Replica) não estiver funcionando corretamente. Nela estarão disponíveis detalhes sobre possíveis falhas de conexão com o servidor mestre (Master).
Tabelas performance_schema.replication_applier_status_by_coordinator e performance_schema.replication_applier_status_by_worker
Estas duas tabelas fornecem informações detalhadas sobre problemas relacionados ao SQL_thread, responsável pela aplicação dos eventos recebidos do servidor mestre (Master). São extremamente úteis quando há falha ou travamento do processo que aplica os comandos SQL.
Arquivo de log de erros do MySQL (error log)
Os erros mais críticos ou detalhados são registrados diretamente no arquivo de log de erros do MySQL, acessível também através da tabela performance_schema.error_log.
Esse método é especialmente útil em ambientes na nuvem, como no serviço MySQL HeatWave Database Service, permitindo uma fácil análise e acompanhamento detalhado dos problemas de replicação.

Utilizando esses métodos em conjunto, é possível identificar rapidamente e com precisão qualquer problema de replicação que esteja ocorrendo no seu ambiente MySQL, agilizando assim a correção e restabelecendo rapidamente o funcionamento correto da replicação.


SELECT logged,
       prio,
       error_code,
       data
FROM   performance_schema.error_log
WHERE  subsystem = 'Repl'
       AND prio = 'Error'
ORDER  BY 1 DESC;

mysql> select LOGGED , PRIO, ERROR_CODE, DATA  from performance_schema.error_log where SUBSYSTEM = 'Repl' and PRIO = 'Error' order by 1 desc ;
+----------------------------+-------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| LOGGED                     | PRIO  | ERROR_CODE | DATA                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
+----------------------------+-------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 2025-03-24 20:48:35.415561 | Error | MY-010586  | Error running query, replica SQL thread aborted. Fix the problem, and restart the replica SQL thread with "START REPLICA". We stopped at log 'mysql-bin-changelog.001714' position 79540834                                                                                                                                                                                                                                                           |
| 2025-03-24 20:48:35.414871 | Error | MY-010584  | Replica SQL for channel 'replication_channel': Worker 1 failed executing transaction '415d143e-3653-30b3-980b-657ad05d72bd:49842481' at source log mysql-bin-changelog.001714, end_log_pos 81453887; Error 'Plugin 'mysql_native_password' is not loaded' on query. Default database: 'npx'. Query: 'ALTER USER 'replication_user'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*102732A660139466B3EC305AF2DB488933474F4A'', Error_code: MY-001524 |
| 2025-03-24 16:14:25.868055 | Error | MY-010569  | Replica I/O thread aborted while waiting for relay log space                                                                                                                                                                                                                                                                                                                                                                                          |
| 2025-03-24 08:50:37.531874 | Error | MY-010586  | Error running query, replica SQL thread aborted. Fix the problem, and restart the replica SQL thread with "START REPLICA". We stopped at log 'INVALID' position 0                                                                                                                                                                                                                                                                                     |
| 2025-03-24 08:50:37.531007 | Error | MY-013146  | Replica SQL for channel 'replication_channel': Worker 1 failed executing transaction '415d143e-3653-30b3-980b-657ad05d72bd:1' at source log mysql-bin-changelog.000002, end_log_pos 3163; Column 32 of table 'npx.authorizations' cannot be converted from type 'blob' to type 'mediumblob', Error_code: MY-013146                                                                                                                                    |
| 2025-03-24 08:31:17.961232 | Error | MY-010569  | Replica I/O thread aborted while waiting for relay log space                                                                                                                                                                                                                                                                                                                                                                                          |
+----------------------------+-------+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
6 rows in set (0.00 sec)

-- Check Replication Channel
SELECT 
  concat(
    conn_status.channel_name, ' (', worker_id, 
    ')'
  ) AS channel, 
  conn_status.service_state AS io_state, 
  applier_status.service_state AS sql_state, 
  format_pico_time(
    if(
      GTID_SUBTRACT(
        LAST_QUEUED_TRANSACTION, LAST_APPLIED_TRANSACTION
      ) = "", 
      "0", 
      abs(
        time_to_sec(
          if(
            time_to_sec(
              APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
            )= 0, 
            0, 
            timediff(
              APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP, 
              now()
            )
          )
        )
      )
    ) * 1000000000000
  ) latency, 
  format_pico_time(
    (
      LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP - LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
    ) * 100000000000
  ) transport_time, 
  format_pico_time(
    (
      LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP - LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP
    ) * 1000000000000
  ) time_to_relay_log, 
  format_pico_time(
    (
      LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP - LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP
    ) * 1000000000000
  ) apply_time, 
  conn_status.LAST_QUEUED_TRANSACTION AS last_queued_transaction, 
  applier_status.LAST_APPLIED_TRANSACTION AS last_applied_transaction 
FROM 
  performance_schema.replication_connection_status AS conn_status 
  JOIN performance_schema.replication_applier_status_by_worker AS applier_status ON applier_status.channel_name = conn_status.channel_name;

+---------------------------+----------+-----------+---------+----------------+-------------------+------------+-----------------------------------------------+-----------------------------------------------+
| channel                   | io_state | sql_state | latency | transport_time | time_to_relay_log | apply_time | last_queued_transaction                       | last_applied_transaction                      |
+---------------------------+----------+-----------+---------+----------------+-------------------+------------+-----------------------------------------------+-----------------------------------------------+
| replication_channel (1)   | ON       | ON        | 2.56 d  | 2.36 d         | 20.00 us          | 1.86 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:50002732 |
| replication_channel (2)   | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 2.54 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:50002601 |
| replication_channel (3)   | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 3.85 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:50001734 |
| replication_channel (4)   | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 3.63 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:50001736 |
| replication_channel (5)   | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 3.45 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:50001727 |
| replication_channel (6)   | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 9.59 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49998021 |
| replication_channel (7)   | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 3.18 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49992586 |
| replication_channel (8)   | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.18 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49959713 |
| replication_channel (9)   | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.19 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49959714 |
| replication_channel (10)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.19 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49959715 |
| replication_channel (11)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 4.34 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49959717 |
| replication_channel (12)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 4.52 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49907064 |
| replication_channel (13)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 4.48 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49907065 |
| replication_channel (14)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.25 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866179 |
| replication_channel (15)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.21 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866180 |
| replication_channel (16)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.18 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866181 |
| replication_channel (17)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.17 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866182 |
| replication_channel (18)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.15 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866183 |
| replication_channel (19)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.13 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866184 |
| replication_channel (20)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.10 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866185 |
| replication_channel (21)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.09 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866186 |
| replication_channel (22)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.06 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866187 |
| replication_channel (23)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.04 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866188 |
| replication_channel (24)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 5.02 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866189 |
| replication_channel (25)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 4.98 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49866190 |
| replication_channel (26)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 6.01 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49850471 |
| replication_channel (27)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          | 6.01 ms    | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 | 415d143e-3653-30b3-980b-657ad05d72bd:49850472 |
| replication_channel (28)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (29)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (30)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (31)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (32)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (33)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (34)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (35)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (36)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (37)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (38)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (39)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (40)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (41)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (42)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (43)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (44)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (45)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (46)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (47)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (48)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (49)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (50)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (51)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (52)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (53)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (54)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (55)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (56)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (57)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (58)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (59)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (60)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (61)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (62)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (63)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (64)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (65)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (66)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (67)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (68)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (69)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (70)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (71)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (72)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (73)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (74)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (75)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (76)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (77)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (78)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (79)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (80)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (81)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (82)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (83)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (84)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (85)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (86)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (87)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (88)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (89)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (90)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (91)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (92)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (93)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (94)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (95)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (96)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (97)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (98)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (99)  | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (100) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (101) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (102) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (103) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (104) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (105) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (106) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (107) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (108) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (109) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (110) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (111) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (112) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (113) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (114) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (115) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (116) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (117) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (118) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (119) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (120) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (121) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (122) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (123) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (124) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (125) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (126) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (127) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (128) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (129) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (130) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (131) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (132) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (133) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (134) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (135) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (136) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (137) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (138) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (139) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (140) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (141) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (142) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (143) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (144) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (145) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (146) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (147) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (148) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (149) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (150) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (151) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (152) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (153) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (154) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (155) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (156) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (157) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (158) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (159) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (160) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (161) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (162) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (163) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (164) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (165) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (166) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (167) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (168) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (169) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (170) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (171) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (172) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (173) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (174) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (175) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (176) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (177) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (178) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (179) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (180) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (181) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (182) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (183) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (184) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (185) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (186) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (187) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (188) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (189) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (190) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (191) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (192) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (193) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (194) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (195) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (196) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (197) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (198) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (199) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (200) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (201) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (202) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (203) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (204) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (205) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (206) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (207) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (208) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (209) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (210) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (211) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (212) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (213) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (214) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (215) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (216) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (217) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (218) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (219) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (220) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (221) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (222) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (223) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (224) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (225) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (226) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (227) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (228) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (229) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (230) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (231) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (232) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (233) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (234) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (235) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (236) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (237) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (238) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (239) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (240) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (241) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (242) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (243) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (244) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (245) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (246) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (247) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (248) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (249) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (250) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (251) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (252) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (253) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (254) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (255) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
| replication_channel (256) | ON       | ON        |   0 ps  | 2.36 d         | 20.00 us          |   0 ps     | 415d143e-3653-30b3-980b-657ad05d72bd:50467766 |                                               |
+---------------------------+----------+-----------+---------+----------------+-------------------+------------+-----------------------------------------------+-----------------------------------------------+
256 rows in set (0.01 sec)

🔸 channel:

Identifica o nome do canal de replicação junto com o número específico da thread ou worker.
Ex.: replication_channel (1)

🔸 io_state:

Estado do canal relacionado à conexão e transferência de binlogs (I/O Thread).
Valores possíveis:
- ON → A conexão está ativa e funcionando normalmente.
- OFF → A conexão não está funcionando ou desconectada.

🔸 sql_state:

Estado do canal relacionado à aplicação das transações recebidas (SQL Thread).
Valores possíveis:
- ON → Transações estão sendo aplicadas normalmente.
- OFF → Aplicação de transações está parada ou com problemas.

🔸 latency:

Latência total da replicação.
Representa o atraso entre o último registro (GTID) recebido no Slave e o último registro efetivamente aplicado.
No exemplo acima: 2.56 d significa que o canal (1) está com 2,56 dias de atraso.

🔸 time_to_relay_log:

Tempo gasto pelo Slave para colocar os dados recebidos no relay log.
Normalmente é muito pequeno (no caso é cerca de 20.00 us, ou seja, 20 microssegundos, tempo aceitável e rápido).

🔸 apply_time:

Tempo que o Slave gastou para aplicar a última transação recebida no seu banco.
No exemplo: 1.86 ms, 5.18 ms são valores bons e aceitáveis.

🔸 last_queued_transaction:

Indica o último GTID recebido (enfileirado) do Master.

🔸 last_applied_transaction:

Indica o último GTID aplicado pelo Slave.
Diferença entre este GTID e o “last_queued_transaction” representa o tamanho do atraso na aplicação.

mysql> show replica status \G ;
*************************** 1. row ***************************
             Replica_IO_State: Waiting for source to send event
                  Source_Host: 100.22.20.186
                  Source_User: replication_user
                  Source_Port: 3306
                Connect_Retry: 60
              Source_Log_File: mysql-bin-changelog.001778
          Read_Source_Log_Pos: 66207953
               Relay_Log_File: relay-log-replication_channel.000006
                Relay_Log_Pos: 70856500
        Relay_Source_Log_File: mysql-bin-changelog.001716
           Replica_IO_Running: Yes
          Replica_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Source_Log_Pos: 70856263
              Relay_Log_Space: 8521164737
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Source_SSL_Allowed: Yes
           Source_SSL_CA_File:
           Source_SSL_CA_Path:
              Source_SSL_Cert:
            Source_SSL_Cipher:
               Source_SSL_Key:
        Seconds_Behind_Source: 232722
Source_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Source_Server_Id: 925869836
                  Source_UUID: 415d143e-3653-30b3-980b-657ad05d72bd
             Source_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
    Replica_SQL_Running_State: Waiting for dependent transaction to commit
           Source_Retry_Count: 0
                  Source_Bind: 10.27.2.35
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Source_SSL_Crl:
           Source_SSL_Crlpath:
           Retrieved_Gtid_Set: 415d143e-3653-30b3-980b-657ad05d72bd:49842481-50356353
            Executed_Gtid_Set: 415d143e-3653-30b3-980b-657ad05d72bd:1-49854029,
df21fd43-067a-11f0-b189-020017028ccd:1-44464
                Auto_Position: 1
         Replicate_Rewrite_DB:
                 Channel_Name: replication_channel
           Source_TLS_Version: TLSv1.2,TLSv1.3
       Source_public_key_path:
        Get_Source_public_key: 1
            Network_Namespace: mysql
1 row in set (0.01 sec)

Monitoramento da Replicação em MySQL

Estado da Replicação

Replica_IO_Running e Replica_SQL_Running: Indicam se os threads de I/O e SQL estão ativos, essencial para verificar a operacionalidade da replicação.
Replica_IO_State: Exibe o estado do thread de I/O, como “Waiting for source to send event”, mostrando que a réplica está pronta para receber eventos.

Conexão com o Servidor Fonte

Source_Host, Source_User, e Source_Port: Informações do host, usuário e porta do servidor fonte, cruciais para confirmar a conexão da réplica.
Connect_Retry: Define o tempo de espera antes de tentar reconectar ao servidor fonte, refletindo a resiliência da conexão.

Posicionamento nos Logs

Source_Log_File e Read_Source_Log_Pos: Indicam o arquivo de log atual no servidor fonte e a posição lida, úteis para acompanhar o progresso da replicação.
Relay_Log_File e Relay_Log_Pos: Apontam para o arquivo de log de retransmissão e a posição correspondente na réplica, importantes para o processamento de eventos.
Exec_Source_Log_Pos: Posição até onde o SQL foi executado, crucial para entender até onde as transações foram aplicadas.

Performance e Atraso

Seconds_Behind_Source: Mostra o atraso da réplica em relação ao servidor fonte, um indicador vital de performance e estabilidade.

Segurança

Source_SSL_Allowed e Source_SSL_Verify_Server_Cert: Confirmam se a conexão utiliza criptografia SSL e se a verificação do certificado do servidor está ativa, assegurando a segurança dos dados.

Global Transaction Identifiers (GTIDs)

Auto_Position: Usa posições automáticas baseadas em GTIDs, facilitando o gerenciamento da replicação.
Retrieved_Gtid_Set e Executed_Gtid_Set: Conjuntos de GTIDs que foram recuperados e executados, respectivamente, essenciais para monitorar a integridade e a consistência.

Erros

Last_IO_Errno, Last_IO_Error, Last_SQL_Errno, Last_SQL_Error: Informam sobre os erros recentes dos threads de I/O e SQL, fundamentais para diagnóstico e resolução de problemas.

mysql> select * from performance_schema.replication_connection_status\G
*************************** 1. row ***************************
                                      CHANNEL_NAME: replication_channel
                                        GROUP_NAME:
                                       SOURCE_UUID: 415d143e-3653-30b3-980b-657ad05d72bd
                                         THREAD_ID: 1651
                                     SERVICE_STATE: ON
                         COUNT_RECEIVED_HEARTBEATS: 3
                          LAST_HEARTBEAT_TIMESTAMP: 2025-03-25 15:16:16.930055
                          RECEIVED_TRANSACTION_SET: 415d143e-3653-30b3-980b-657ad05d72bd:49842481-50396683
                                 LAST_ERROR_NUMBER: 0
                                LAST_ERROR_MESSAGE:
                              LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00.000000
                           LAST_QUEUED_TRANSACTION: 415d143e-3653-30b3-980b-657ad05d72bd:50396683
 LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP: 2025-03-23 09:16:47.013504
LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP: 2025-03-23 09:16:47.013504
     LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP: 2025-03-25 15:18:35.587187
       LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP: 2025-03-25 15:18:35.587199
                              QUEUEING_TRANSACTION: 415d143e-3653-30b3-980b-657ad05d72bd:50396684
    QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP: 2025-03-23 09:16:47.201468
   QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP: 2025-03-23 09:16:47.201468
        QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP: 2025-03-25 15:18:35.587203
1 row in set (0.00 sec)

O MySQL oferece a tabela performance_schema.replication_connection_status para monitorar o status atual da thread de I/O que gerencia a conexão da réplica com o servidor de origem. Essa tabela fornece informações detalhadas sobre a conexão de replicação, incluindo o estado do serviço, transações recebidas e possíveis erros. A seguir, destacam-se os principais pontos para monitoramento eficaz da replicação:

Estado da Conexão de Replicação

SERVICE_STATE: Indica o estado atual da thread de I/O da réplica. Os valores possíveis são:
- ON:
- OFF:
- CONNECTING:

Identificação da Conexão

CHANNEL_NAME: Nome do canal de replicação associado a esta conexão.
SOURCE_UUID: Identificador único universal (UUID) do servidor de origem, útil para identificar a fonte da replicação.

Informações sobre Transações

RECEIVED_TRANSACTION_SET: Conjunto de IDs de transações globais (GTIDs) correspondentes a todas as transações recebidas pela réplica.
LAST_QUEUED_TRANSACTION: GTID da última transação enfileirada no log de retransmissão.
LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP: Timestamp que indica quando a última transação enfileirada foi confirmada no servidor de origem original.
LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP: Timestamp que indica quando a última transação enfileirada foi confirmada no servidor de origem imediato.
LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP: Timestamp que indica quando a última transação foi colocada na fila pelo thread de I/O.
LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP: Timestamp que indica quando a última transação foi enfileirada nos arquivos de log de retransmissão.

Heartbeats da Replicação

LAST_HEARTBEAT_TIMESTAMP: Timestamp do último sinal de heartbeat recebido do servidor de origem, indicando que a conexão está ativa mesmo na ausência de eventos recentes.
COUNT_RECEIVED_HEARTBEATS: Número total de sinais de heartbeat recebidos desde a última reinicialização ou redefinição da réplica.

Informações sobre Erros

LAST_ERROR_NUMBER: Número do erro mais recente que causou a interrupção da thread de I/O. Um valor de 0 indica ausência de erros.
LAST_ERROR_MESSAGE: Mensagem descritiva do erro mais recente. Se vazia, indica que não houve erros recentes.
LAST_ERROR_TIMESTAMP: Timestamp indicando quando ocorreu o erro mais recente na thread de I/O.

Timestamps das Transações Atuais

QUEUEING_TRANSACTION: GTID da transação atualmente sendo enfileirada no log de retransmissão.
QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP: Timestamp que indica quando a transação atualmente enfileirada foi confirmada no servidor de origem original.
QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP: Timestamp que indica quando a transação atualmente enfileirada foi confirmada no servidor de origem imediato.
QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP: Timestamp que indica quando o primeiro evento da transação atualmente enfileirada foi escrito no log de retransmissão pelo thread de I/O.

Para concluir este artigo, apresentamos um checklist detalhado e prático com os principais passos para realizar com sucesso uma migração do AWS Amazon Aurora MySQL para OCI HeatWave MySQL, com o mínimo downtime possível. Abaixo você encontra uma visão macro de todo o processo, de maneira clara e explicativa, permitindo rápida consulta ou revisão para leitores com diferentes níveis de interesse ou pressa.

Checklist Final – Migração AWS Aurora MySQL para OCI HeatWave MySQL

Foram abordadas diversas maneiras práticas e objetivas de monitoramento para garantir uma interpretação clara e precisa das situações críticas durante o processo.

1. Validação dos Pré-requisitos:

Certifique-se que as infraestruturas de banco de dados em AWS e OCI estejam devidamente provisionadas.

Garanta conectividade entre AWS (Aurora MySQL) e OCI (HeatWave MySQL), especialmente liberando a porta padrão MySQL 3306.

Utilize um servidor intermediário (servidor ponte) com MySQL Shell instalado, garantindo conectividade bidirecional total entre AWS e OCI.

Consulte a documentação completa para validação detalhada dos pré-requisitos: Documentação Oficial Oracle.

2. Configurações Obrigatórias no AWS Aurora MySQL (Source):

Habilite e verifique rigorosamente os seguintes parâmetros:

gtid_mode = ON
enforce-gtid-consistency = ON
log_bin = ON
binlog_format = ROW
log_slave_updates = ON

Esses parâmetros garantem a viabilidade técnica e a integridade dos dados durante a replicação.

Mais detalhes sobre essas configurações estão disponíveis na Documentação Oficial AWS.

3. Exportação e Importação com MySQL Shell:

Utilize o MySQL Shell como ferramenta principal para exportação/importação.

Garanta que o processo seja executado seguindo boas práticas indicadas no decorrer do artigo, incluindo geração e manipulação correta dos arquivos JSON para GTID.

4. Configuração do Usuário de Replicação:

Confirme que o usuário de replicação está criado corretamente no AWS Aurora MySQL (origem) e possui as permissões adequadas.

Um exemplo prático para criação do usuário repuser foi detalhado ao longo deste artigo, fornecendo um guia completo para evitar problemas de permissão.

5. Implementação do Canal de Replicação OCI HeatWave MySQL:

Neste passo crucial, verifique a congruência dos GTIDs entre origem e destino utilizando o arquivo .json gerado durante o export.

Caso necessário, ajuste o GTID utilizando o comando SET_GTID_PURGED, garantindo que a replicação delta inicie no ponto correto.

Atenção especial ao detalhado passo a passo fornecido anteriormente para implementação eficaz e segura do canal de replicação HeatWave na OCI.

6. Troubleshooting e Monitoramento:

O artigo forneceu insights valiosos para solucionar problemas comuns durante a migração.

Utilize os scripts e exemplos fornecidos para identificar rapidamente qualquer desvio ou problema.

Referências :