Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: master-slave-replication

MySQL replication works but slave keeps reconnecting to master

By adminPosted on January 17, 2023

Question : I have a master-slave set-up with multiple slaves in different datacenters. One of the slaves stopped working normally […]

What is the maximum latency / distance mysql replication can tolerate without having errors or wrong data?

By adminPosted on January 16, 2023

Question : I have two machines in a master – slave replication. I want to know if they are in […]

Setting connection collation in master for slave replication

By adminPosted on January 14, 2023

Question : I am trying to replicate a MySQL 8 server (master) to MySQL 5.7 (slave) instance. I know it […]

Fix mysql replication crashed due to underlying storage corruption

By adminPosted on January 13, 2023

Question : we have critical database server running on two virtual machines. one virtual machine crashed due to underlying storage […]

replicate-wild-do-table=channel_name:db_name.% doesn’t work in MySQL 8.0 for channel based replication

By adminPosted on January 12, 2023

Question : I am trying to configure a replication topology where there will be one slave which will connect to […]

MariaDB slave replication stopped after slave upgrade to 10.1.41

By adminPosted on January 2, 2023

Question : After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay […]

When queries start executing on standby server the replay lag starts to increase

By adminPosted on December 27, 2022

Question : I have a two servers with following specs: 8 vCPU, 32768 MB RAM, 640 GB SSD The master […]

Row-row based logging in a blackhole replication filter setup?

By adminPosted on December 22, 2022

Question : I am using two MySQL server instances on the same server to filter replication to a third external […]

Howto reliably ship WAL log files between master and slave

By adminPosted on December 20, 2022

Question : I have a replication master and a slave on two different computers. Actually both databases are running in […]

Why has deadlock behaviour changed between MariaDB 10.1.22 and 10.2.14?

By adminPosted on December 14, 2022

Question : Since upgrading MariaDB 10.1.22 to 10.2.14 our MariaDB slaves are encountering deadlocks that are not handled in less […]

  • 1
  • 2
  • 3
  • …
  • 17

Recent Posts

  • Write filename, servername/IP and date+time in spool file
  • Designing a table with multiple null FKs
  • I am trying to get the string between hyphen (-) which is before (+) upto next colon (:)
  • Why would a SELECT INTO cause an arithmetic overflow?
  • Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
  • Login failed for user – Error 18456 – Severity 14, State 38
  • comparing two values in same column with another column using AND condition
  • Slow running aggregate of aggregate query
  • Is it possible to get seek based parallel plan for distinct/group by?
  • PostgreSQL replication: out-of-sequence timeline ID, when former master made slave
  • Autogrowth Analysis in PROD DB based on the trace file data
  • Single versus Multiple databases
  • Does a user who has permissions to select from a view also need select granted to the children entities of that view?
  • Parse a string to find data between delimiters, multiple occurrences
  • Oracle multiple databases on same server [closed]
  • Help to create indexes to improve query performance and reduce report generation time
  • Error while granting select privilege
  • Native checksum table says there’s a difference, pt-table-checksum does not
  • Row count from a certain table in multiple databases
  • postgres table sizing inconsistency

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding