Is there any better solution besides AlwaysOn on the market?
Reasons:
a. High reliability: Even the sync mode in AlwaysOn has NO
guaranteed zero data loss when in disaster,
let alone the async mode. It means that the
switching process is risky and people rarely
use the automatic switching mode due to
its obvious performance impact.
Why AlwaysOn doesn't have Guaranteed Zero
Data Loss(GZDL)?
http://www.zhetides.com/nd.jsp?id=24
b. High availability: Since the disaster switchint process is risky,
it means the length of downtime is variable
and depends on the skill of the attendant which
means there is NOT guaranteed max downtime.
c. High performance: The sync mode has obvious impact on performance.
What's more, AlwaysOn has NO automatic r&w splitting
and loadbalance which is crucial for the separation of
OLTP/OLAP and hence the db performance.
Why is AlwaysOn NOT A TRUE loadbalancer?
http://www.zhetides.com/nd.jsp?id=23
d. Installation and maintainence: Maintainability is crucial
when a disaster strikes. The more complex the
maintainence, the more unpredictable and longer the
length of downtime is. AlwaysOn needs a least one
professional skillful DBA to take care of.
THEN WHO IS MUCH BETTER?
The answer is: DBTwin Active-active Database Cluster.
1. DBTwin Features:
a. High reliability: When a disaster strikes, one node is down, another
node continues with Guaranteed Zero Data Loss(GZDL)
b. High availability: near-zero downtime. When a disaster strikes, one
node is down, another node continues running. The
service downtime is less than 20 seconds.
c. High performance: automatic r&w splitting and load balance with any
source code change. This feature is UNIQUE on the
market. It is crucial for the separation of OLTP/OLAP
and so the db performance.
d. Simple installation and maintainence: Why do many people prefer
buying third-party solutions over SQL Server
self solutions? Maintainability is an important factor.
An ordinary engineer can be qualified for the job.
2. DBTwin Benefits:
a. Free from the fear and accountability of data loss.
b. Free from the shock and accountability of service disruption.
c. Free from the drowsiness and fatigue of 3AM.
A GOOD TOOL IS FAR BETTER THAN A TOP-LEVEL DBA.
A foolproof and one-stop solution.
More info: http://www.zhetides.com