Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-mirroring]

103 questions
0
votes
2 answers

Apache / MariaDB Questions

this is my first post here, and I have searched for a good answer to this question with no luck so far. I am in the process of upgrading our web server (LAMP stack on CentOS 6) to new hardware and more recent software. I'll be migrating our sites to…
TheMalman
  • 3
  • 3
0
votes
1 answer

Changing from database mirroring to transaction log shipping

I'm considering dumping database mirroring and go with transaction log shipping on our SQL Server 2008 Standard server instead, because there's a noticeable performance hit due to the principal being a beefier machine. Is it non-trivial to do? I am…
J F
  • 133
  • 6
0
votes
1 answer

Database server vs NAS for data files

Regarding costs and maintenance speed/simplicity in case of hardwar failures, does it make any sense to keep SQL data files on a NAS server, separate from the SQL Server instance? Our app stores large amounts of measurements (time-series) from many…
Groo
  • 1,287
  • 2
  • 16
  • 25
0
votes
0 answers

SQL Server Mirroring and Azure Regions Connection Error

I can't seem to get my SQL Server mirroring to work. I keep getting a server can't be reached when I enable the mirroring part. My virtual machines are in different regions. I can connect to all SQL Servers (Primary, Mirror, Witness), and get all…
exposure
  • 273
  • 1
  • 5
  • 10
0
votes
0 answers

SYNC MYSQL database instantly from one Digital ocean server to another

I have a site (data entry site ) on a Digital Ocean server and its database ( MYSQL ) is being updated with new records every second. I am hosting the public site on another Digital ocean server which is only reading information from the…
brainHax
  • 151
  • 1
  • 1
  • 7
0
votes
1 answer

SQL Server Mirror issue on Mirror side

Team, I am having an issue on one of my Mirroring environment. It is SQL2008R2. DB mirror was somehow broken between principle and Mirror side. Someone(Not sure who is he/she due to offshore support) Manually remove mirroring from principle side.…
Man
  • 1
  • 2
0
votes
1 answer

What carries out SQL Server Mirroring?

I'd like to know what service(s)/process(s) carries out Mirroring in SQL Server. For example, we have various Agents carrying out the different steps for SQL Database Replication. Similarly, what is taking care of the various aspects of Database…
Santa
  • 559
  • 5
  • 15
0
votes
1 answer

Migrating from normal RDS to Encrypted RDS

I saw this and this which in theory are the same, but no extra details were given, so they answers are general and unsolved. My issues is similar, with a sad twist: I have a Master RDS instance serving the application right now and I want to move…
dulac
  • 133
  • 1
  • 6
0
votes
1 answer

SQL Server 2012 AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

I am setting up a 3 node cluster as part of an availability group. Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, and I was still able to write queries. I started…
leeman24
  • 147
  • 1
  • 9
0
votes
0 answers

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 Database server but I just had a network issue on the DR…
totalfreakingnoob
  • 145
  • 1
  • 6
0
votes
1 answer

Migrate existing database to mirrored database on Azure

I have setup 3 Sql VM's on Azure for database mirroring as described in this link with the idea being that we move our current database, which is currently on a single VM outside of Azure. Everything works so far, except now I am stumped at how I…
Peuge
  • 113
  • 4
0
votes
1 answer

Two SQL Failover Clusters in two-node failover servers

I need 2 SQL Failover clusters: Core Database Cluster: this contains all of my core application databases Analytic Database Cluster: this contains my web analytic database Now, I only have 2 physical servers (DB1 and DB2) connected to a SAN. How…
ronanray
  • 103
  • 1
  • 3
0
votes
3 answers

MySQl, Postgresql replication comparison

One main issue with MySQL replication is that the slave is single threaded. This can cause replication lag. How does Postgresql handle replication? Does it (or add-on such as slony-I) allow multi-threaded slaves? In general, what are the pros and…
Continuation
  • 3,050
  • 5
  • 29
  • 38
0
votes
1 answer

SQL 2008 R2 Clustering AND DB Mirroring (Async)

I've got a MS SQL 2008 R2 Fail-Over Clustered Instance running between two Windows 2008 R2 servers using the inbuilt Windows Clustering features, that is working with a DTC and Quorum with a disk based Witness. This has been working fine for months…
Ben Bowman
  • 113
  • 2
  • 3
  • 13
0
votes
2 answers

Azure Table Storage mirroring

I am proposing an Azure environment with the following: VM SQL Server for core relational data Table Storage for bulk data I want to mirror the SQL Server database to another server so that Reports can be run on this server so to minimize data…
Dave New
  • 155
  • 7
1 2 3 4
5
6 7