How to Deploy Azure SQL Anywhere – Using Azure Arc for Data Services | Data Exposed: MVP Edition

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
>> Did you know that you can deploy Azure SQL anywhere with Azure Arc-enabled data services? Learn more from Ben in this episode of Data Exposed, MVP Edition. [MUSIC]. >> Hi, I'm Anna Hoffman. Welcome to this episode of Data Exposed, MVP Edition. Today, I'm joined by Ben. Ben, thanks for joining us today again. Can you start by telling us a little bit about yourself? >> Thank you for having me again. I wasn't sure if I was ever going to be invited again. But then again, that was my best behavior last time. MVP from Nuremberg, Germany, mostly in the data warehousing and BI field. Last time we spoke about big data clusters. Well, now I guess I'm here for something new. >> Yeah, we're excited to be learning something new. It's this ever-evolving thing and I'm excited to learn what you have to share with us today about Azure Arc. Without too much preamble, I thought I'd just ask you, can you tell our viewers, and myself, what is Azure Arc and how does it relate to things we know like Azure SQL and SQL Server? >> Azure Arc is this real cool thing. It is bring your own datacenter, but still enjoy the luxury of Azure services in general, I should rather say so. Azure Arc is not just for the data world, but we're going to be focusing mainly on the data world. The idea of Azure Arc is you go to any Cloud with any infrastructure and any Kubernetes. This can be Azure Kubernetes service, you can run your own Kubernetes. I'm basically running my own Arc datacenter in my basement, which we're going to see in that emulator. You can run it in any of the other public or private Cloud, AWS, Google Cloud, you name them, which means wherever you go, it doesn't matter. It can be on-premise, it can be private, can be public. It can be connected and disconnected. We're also going to see that in the other slide. There's data services, there's our Kubernetes services. There's all kinds of Azure services that are moving to other clouds. Again, on-premise is a Cloud in that context. The idea for the data world here is we get managed instances and PostgreSQL Hyperscale into your own private estate. still having all the luxuries that you would get from the classic Azure SQL service world. Classic, I mean, they're all brand new and still you get to see them in the portal, you get to manage them still on-prem, you get manage backup, you get manage updates, all that. But all that without having to be locked into the Azure Cloud, which is a big deal for many people that either run multi-Cloud strategies or that just say, "Well, I cannot move away from on-prem with some of my data for performance rate." You may just be sitting on an oil rig and just not have the connectivity to everything to run into the Azure Cloud non-stop. What does that mean for the Azure Arc-enabled data services? You start by just deploying your Kubernetes cluster. I keep that rather gentle because like I said, this can be Kubeadm, AKS, EKS, all kinds of flavors. On top of that, you deploy a so-called Azure Arc Data Controller. This is like your main endpoint. If we remember big data clusters, we had the big data cluster controller. This is the counterpart to the Azure Arc if you want. One single point of entry, and that's the only thing that you really have to deploy. This will take care of everything else that's going on there. This is happening again through the Azure Data CLI, through AC data, which we are also using for big data clusters. Azure Arc or Azure Arc-enabled data services, I should rather say, that is the answer to that question, the end of the path where people are wondering, "Well, SQL and Linux, SQL and Kubernetes, I see what it's doing. Why?" This is why, because now we get all this in those containers, in those orchestrated containers. Just like with big data clusters, again, we can either use AC data directly or we can use Azure Data Studio, a tool that more and more people are using for exactly those purposes: managing, deploying, and developing their data solutions. We got it connected to the Azure portal. Again, same logic. We will also be deploying our data instances, again, like I said, Azure SQL Managed Instance or Azure Database for PostgreSQL. Those are the two offerings we would get in Arc-enabled data services right now. By the way, Arc-enabled data services are in public preview, so we can still get monthly releases with more and more interesting features coming. Since when Azure Data Studio can even automate all that through Git merges if you want, you can have automated, built and deployment pipelines for your data estate; and you get the same Kibana and Grafana interfaces that you already know from SQL on Kubernetes and big data clusters; and we got the link back to the portal. Like I said, depending on where you are, you may have a direct connection to the Internet, to the Azure Cloud or not. That's why there's basically two ways of getting those metrics and log files into the portal. You can do the direct mode, which means your data controller will constantly upload your consumption data and log files for analysis to the Azure portal; or you can use the indirect mode. Indirect mode basically means that you're running a script every hour, every minute, every week, every month, that will just push that data to the portal so your resources will show up there and are available for analysis. Let's take a quick look at that in Azure Data Studio. This is just PowerShell what I'm doing here, but I decided just to run it in an ADS notebook, so we've got it all in one place. I already got my controller here in my basement deployed. What I can do is I can see, well, I got already three managed instances and one on PostgreSQL instance deployed there. I can manage all that right here in Azure Data Studio but I can also just run a PowerShell command where I can say, "Show me all those instances." Again, I can do that through code or through the user interface depending on what I prefer and I will see my three managed instances showing up including their external endpoints. Well, external from the Kubernetes perspective, those are private IP addresses because I'm running that in my own private basement datacenter. If I want to create a new Managed Instance, all I would need to do is run this command here, azdata arc sql mi create. If I would do this and just do go-titans 01. I think Bob What he's a big fan of the Titans so I'm doing this especially for him. >> Huge fan. >> Well, him and Buck, of course, because Buck is the biggest sports fan that is out there. Again, if I would be preferring something with a graphical interface, I could have gone here and say, "New Instance." Basically doing the same thing so this would, exactly the user agreement. I could say, "Well, this will be my go-titans too," and I could either just script it to a notebook that I could run later or deploy it right from here. We're sticking to just running it right here in PowerShell. What this will do is, in my Kubernetes cluster, it will create another part, go-titans-01 - zero. That is, by the way, super-interesting in Azure arc. This will also be the platform which allows me to run which is why it's saying, "Dash zero." There could be a dash one, dash two if I had multiple instances. This would be the way to bring SQL Server Availability Groups into Kubernetes which is currently not supported by the regular SQL Server, quote, unquote. This is running, this is creating my Instance and if I would go back here and refresh this, we would also see this is being created. We see this Instant as Creating and once you've got your first Instance created, all the consecutive one usually take about a minute to a minute and a half. There we go, go-titans-01 is ready and if I do a refresh here, I would see the Instance just as well if I do the azdata arc sql mi list here, it would show up the Instance including its endpoint and including its IP address and port so I could connect to it. Pretty cool. >> Nice. This is pretty cool. It's a good bit faster than installing SQL Server. >> Slightly. For those trying this at home, the first time will take a little bit longer because it actually needs to download SQL and that's again the beauty of Kubernetes once it's got all these images downloaded to its local library if you want so. Ninety seconds for a SQL server, that's not just a regular SQL Server because if we just go here and do a select, add, add version on one of my Managed Instances, what you will see is this is not just SQL Server or SQL Server on Linux but what I have here running on my local premises, I got my Microsoft Azure SQL Database Managed Instance Azure Arc. This is a Managed Instance. This would get automated updates, this would get automated backups, all that, if configured for that specific instance. I could get all the local information that or in my Grafana dashboard. If I go here, where of course I did not deploy a certificate, this would get me my SQL Server metrics. I could go to all the different instances that I got deployed here. How many transactions, how many batch requests I could see, what's actually happening on my host but I can also get that back to the Azure portal and this is where it gets super cool if you ask me. Because that means in the end, no matter where my databases are running, no matter where my instances are running, I get them all in one single place. The first thing I'm doing is I'm exporting the LogFiles here. This is something that you should schedule in the real world so have that run every two minutes, every two hours. Unless you're in direct mode where like I said, this would be happening automatically. What this will do is it will collect all the LogFiles and metrics from all these instances. You can see, it already picked up my go-titan so it's not like I have to configure anything, it will just do it for every single Instance that I've deployed. Then the next step, I will just upload those to the portal again using azdata so what this will do is will take the files that I just created, the two JSON files. Push them into my Log Analytics workspace in Azure and if I go into my Azure portal and do a refresh here, you will see there's my local-mi-01 where I could now see the metrics for that specific instance right here in the Azure portal. What happened to my CPU on that On-premise SQL Instance? I see it in the portal. If I go to the overview, I would also see, well, it's running in Ben's basement. This is my endpoint so this is where it's all coming together and this is the beauty of Azure Arc-enabled Data Services or Azure Arc in general. >> That's pretty cool because that means wherever your SQL is running, if you have it connected to the Azure portal, you're going to be able to manage and monitor them all from one place. Am I understanding that correctly? >> Correct. Without the worry of running your own updates and all that. All the beauty that you get from managed services on your own infrastructure or somebody else's infrastructure. It's like I said, it's bring your own data center if you want so. >> Love it. >> I think that is amazing because it really gives you that flexibility no matter where that restriction is coming from. >> Awesome, cool. Well, thanks, Ben. This has been really interesting and for our viewers, you've actually been pretty busy with Azure Arc-enabled data services. I think you might have something you might want to announce or share with our viewers. >> Indeed, my very good friend Anthony Enosantino and myself, we wrote a quick book on Azure Arc-enabled data services because I'm known for writing book on technology where you will know for sure that the technology will change five-times until the final product comes out. This is based on the current public preview but it was big fun writing that. Trevis, the PM for Arc-Enabled data service actually was nice enough to write us a great forward for that book. If you want to find out more about Azure Arc-enabled data services, how to deploy them, also more about the technical background, make sure to check out our book, I hope it's worth it and let us know what you think. >> Awesome. Thanks, Ben, and I think for our viewers, it's a great call to action. You want to learn more about Azure Arc-enabled data services, then definitely check out Ben and Anthony's book. We'll put some links in the description. Ben, again, thanks so much for joining me today, and to our viewers, thanks for tuning in. We hope to see you next time on Data Exposed. [MUSIC]
Info
Channel: Microsoft Developer
Views: 761
Rating: undefined out of 5
Keywords: Microsoft, Developer, Azure Arc for Data Services, azure arc, azure sql, microsoft azure, azure sql database, sql server, kubernetes, azure sql managed instance, azure sql mi
Id: eko8cdpWZ3M
Channel Id: undefined
Length: 14min 9sec (849 seconds)
Published: Tue Feb 23 2021
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.