Skip to main content
Share Your Experience: Take the 2024 Developer Survey
7 votes

SQL Server Failover strategies

In SQL Server 2014 Standard Edition, your only built-in option for automatic failover without shared storage would be database mirroring. If you upgraded versions to SQL Server 2016 Standard Edition,...
Brent Ozar's user avatar
  • 4,435
3 votes
Accepted

How to change hot_standby_feedback parameter for an existing database replica in RDS

Hi, you must define those parameters not from the DB but from the AWS Web Console, or using AWS CLI. If your Database is using the Default Parameter group you must first create a custom Parameter ...
julian-alarcon's user avatar
3 votes
Accepted

Using Amazon EC2 for postgres_fdw or BDR replication

EC2 provides a self-contained VM. As long as BDR doesn’t require privileged access to hardware (it does not), you’re set. By contrast, RDS provides a managed database service that offers a subset of ...
Corey Quinn's user avatar
3 votes
Accepted

Is it possible to do database replication on aws s3

You cannot do this. No RDBMS allow you to keep data in S3. S3 is just an internet object store, each access need you to download the WHOLE object using particular API. It is only practical if the ...
mootmoot's user avatar
  • 304
2 votes

SQL Server Failover strategies

If you upgrade to SQL Server 2016 Standard Edition, you will be able to use the Basic Availability Group which is a limit version of Always On Availability Group of SQL Server Enterprise Edition. It ...
Chun Liu's user avatar
  • 426
2 votes

repmgr - after a failover switch, both nodes act as a master

Often it's desirable to bring a failed master back into replication as a standby. First, ensure that the master's PostgreSQL server is no longer running; then use repmgr standby clone to re-sync its ...
krish's user avatar
  • 21
1 vote

Is it possible to have MySQL/MariaDB bidirectional replication?

Yes, each server can act as both Primary and Replica. Replicating from a higher version to a lower version may not work. See https://mariadb.com/kb/en/replication-overview/#:~:text=The%20main%...
Rick James's user avatar
  • 2,618
1 vote

Real time synchronization of databases with different data structure

I think the only reasonable option is to abstract all database operations in your application in a way that they update both databases. The database structure is often coupled with the business logic. ...
Tero Kilkanen's user avatar
1 vote

MYSQL: Many slave servers with smaller resources or less with larger resources

It depends. The most likely thing to adjust in hardware is RAM. If you tune innodb_buffer_pool_size to about 70% of RAM and that is bigger than the size of all the data, then there will be very ...
Rick James's user avatar
  • 2,618
1 vote
Accepted

Can't restore master/slave replication from Percona backup (slave server)

I found the solution here https://www.percona.com/doc/percona-xtrabackup/2.3/howtos/setting_up_replication.html I was missing the xtrabackup --move-back command
clarkk's user avatar
  • 2,085
1 vote

Databases "Synchronized / In Recovery" after adding server to SQL Avaylability Group

I found the problem, I was using a newer version of SQL (SQL 2017) on the new replica, but the primery was SQL 2016. After installing SQL 2016 on the new replica, all databases in "Syncronized" and ...
Alberto Medina's user avatar
1 vote
Accepted

MongoDB - Database Profiler does not capture queries sent to secondaries replicas

I found out the answer in the documentation: You can enable and configure profiling for individual databases or for all databases on a mongod instance. Profiler settings affect only a single mongod ...
vyosiura's user avatar
1 vote
Accepted

Mysql Master-Slave replication database duplication issue

This message means that the entry you try to insert is already present on the slave. First of all, look at the master log files if the error exists. If this is the case, the problem is not at the ...
Craft's user avatar
  • 171
1 vote

Using Amazon EC2 for postgres_fdw or BDR replication

We are using postgres_fdw in AWS RDS. There are some issues related with performance, but it works. You just need to use PostgreSQL 9.3 or higher and check that postgres_fdw is in rds.extensions of ...
Viktor Yarmak's user avatar
1 vote

mysql replication fail (no error)

I didn't know why that happened, however i change the replica to row based and it is working. Thanks
user362986's user avatar
1 vote
Accepted

Database server vs NAS for data files

I depends on what software you're dealing with but... Usually (historically speaking) you would not want to put database storage on a NAS, because that would mean using a network filesystem like NFS ...
Ryan Babchishin's user avatar
1 vote

Scheduled copy of production database into test database

Use the Copy Database Wizard. - Right click the source database - Choose Tasks - Copy Database. In the guide You can choose to create a schedule for the job also.
Rolf Sørensen's user avatar
1 vote

"Could not create IPv6 socket" postgresql standby error

To disable the IPv6 error, you have to do following steps. paste the following code in this file (/etc/sysctl.conf) net.ipv6.conf.all.disable_ipv6 = 1 In postgresql.conf file change the listen ...
Abhijeet Kamble's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible