sql server - Questions about Active Geo-Replication (and how it interacts with local, within-datacenter, redundancy) -

-

i read thisactive geo-replication azure sql database article on active geo-replication , have questions. posted these questions on page article haven't gotten reply yet.

could use help!

  1. “every forced termination results in irreversible loss of replication relationship between primary database , associated online secondary database.” irreversible mean here? mean in order re-establish replication relationship between primary database , associated online secondary database after forced termination, we’d need start on seeding online secondary database?

  2. “local data redundancy , operational recovery standard features azure sql database. each database possesses 1 primary , 2 local replica databases reside in same datacenter, providing high availability within datacenter. means active geo-replication databases have redundant replicas. both primary , online secondary databases have 2 secondary replicas.” so, if imagine have active geo-replication , running , primary database lost reason. azure sql automatically put 1 of remaining 2 local replicas exist within same datacenter part of standard local data redundancy , operational recovery azure sql feature in place of primary database lost no impact existing connections? if so, take mean case in forced termination of replication relationship between primary database , online secondary (via geo-replication) necessary if 3 copies of database existing in local datacenter lost. right?

  3. using active geo-replication configuration, can online secondary databases in same region primary? wanted active geo replication within same region time. doable? realize that, regional disaster perspective, having online secondaries in same region defeat purpose. still know if it’s doable.

  1. if force terminate continuous copy link new link must established enable geo-replication on new primary database. create new database , start on seeding of online secondary database.

  2. azure sql database has built-in high availability. geo-replication (and forced failover) needs used in event of disaster causing entire data center primary database (and replicas) unavailable.

  3. active geo-replication can used scale out read workloads. active geo-replication can configured in same region, replica must on different server primary. see "design pattern 2".


Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more