קטגוריות
Uncategorized

מאמרים EDBA

So what is SQL AlwaysOn

So what is SQL "AlwaysOn"?

The Technical term of "Always on" refers to a system that is constantly available, operational and responding to demands from users.

Microsoft's AlwaysOn technology was first presented on SQL Server 2012.
Microsoft presented it as the new Active-Active technology for SQL server high availability solution. The AlwaysOn technology
, is basically based on the mirroring feature, that exists for a very long time (Since SQL 2005), but includes better and advanced features. This technology is served up as a whole solution for your critical databases.

The AlwaysOn solution, is SQL server new way to accomplish HADR – High Availability Disaster Recovery, since it covers both server and database storage in case of disaster. The AlwaysOn solution is installed on top of WSFC – Windows Server Failover Cluster, and it is based on two technologies:

1.     FCI – Failover Clustered Instances, which gives us redundancy through multiple SQL instance

 


2.       AG – Availability Groups that gives us redundant copies of our data across multiple servers

The strongest architecture of SQL server AlwaysOn, presented in SQL 2016. It has the ability to combine between FCI and AG, :as well as creating a Distributed AG, as described in the sketch


The strongest architecture of SQL server AlwaysOn, presented in SQL 2016. It has the ability to combine between FCI and AG, as well as creating a Distributed AG, as described in the sketch:

Now, let's review the new AlwaysOn features:

·        AlwaysOn Cluster configuration supports multi Subnet failover capabilities, including Azure servers, as part of the cluster solution

·        AlwaysOn Availability Group can contain 1 primary instance and up to 4 Replicas (SQL servers). The primary replica is the active read/write copy on the database, 2 of the 4 replicas can work with synchronous data replication whereas the additional 2 need to be asynchronous. All the replicas are read only databases

·        The Availability Group allows us to connect to the AG listener that will always point to the Primary replica, but on the other hand, we can also access directly each one of the read only replicas. This is the best solution for reporting and other activities we want to perform on production data, but not on production database!

·        Availability group can contain multiple user databases

·         Automatic Failover is possible to the synchronous replicas and is almost un noticed by the users

What are the limitations of AlwaysOn Availability Group?

·        In SQL 2012 and SQL 2014 AlwaysOn was only available on Enterprise Edition. Since SQL 2016 AlwaysOn is also available on Standard Edition, but it has a lot of limitations

·        System Databases cannot be part of the Availability Group. As result, all server objects (like Jobs, Logins, Linked servers etc.) are not part of the Always On replication and needs to be synchronized manually


קטגוריות
Uncategorized

מאמרים EDBA

?WhyDBA

Why I need the services of a Database Administrator

Or

I do daily backups! – so my data is safe. Right!?

 

Wrong! It's no more right than thinking "since I brush my teeth daily – I'll never need a dentist"!

 

We Often hear IT managers say: "My data is completely safe since I have a full system backup and my environment is totally virtual. So, what do I need a DBA for?

 

Thought System Backups are a critical part of your protection plan, they are just that! A part of the whole, and by themselves will not protect your data! Likewise, A virtual environment can make it easier to restore a server if properly backed up, but It still does not protect your data.

 

 

DATA is the most important property of every organization!

As the IT Manager, responsible for all the organizations data, you should be able to:

 

1.    Recover Physical machines and servers.

2.    Recover data to any point in time.

3.    Recover specific databases or objects of your choice.

4.    And do all of this with minimal downtime, data loss, and effort!

 

Most of this, unfortunately can't be achieved by standard backup procedures or virtual environment.

The only way to make sure your data is secured, redundant, robust, and available to the users with optimum performance, is to have a Professional DBA design and implement A regular database maintenance plan.

This should be carried out by an experienced DBA that can fit the best maintenance plan to the organization's needs.

 

You want "peace of mind" and confidence that you’ve done all you can to ensure your organizations data, no matter what disaster comes your way?  You need A DBA!

 

Want to know more about securing you data? Contact us at eDBA
קטגוריות
Uncategorized

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!