Build a WordPress app using Azure Database for MySQL service : Build 2018


>>>I’m a program manager in the azure os databases team. Concentrated my sql. Do any of you use my sql Today? can you hear me? Now? better? the best type of technical difficults. Like i was saying, i work on the mysql team. We recently made our service generally available back in march. Do any of you use that currently? i hope some of you maybe use Ct-post guess as well. Frameworks and tools and use Them against this mysql service we have. Want to make as low overhead as possible for you to have to Learn new tools. Use what you’re used to. We don’t want to force any specific microsoft tooling on You. With our elastic scaling, this Mines we offer a 99.99 Percent sla. For some other cloud Competitors, you see you have to deploy another replica in order To guaranty some ha or availability. We provide 99.99 Per single instance so you don’t have to go Double your costs for creating a new rep i can lick awe. Azure is one of the most secure cloud as vailable. We’re working to make sure mysql services have all the Compliances certification standards, including iso, hipaa, And the other big ones. Terms of industry leading glenn global reach. We’re in good b40 regions in azure and 24 right now. Look to see for more regions come up. Being part of the azure ecosystem we try to integrate With as many services as possible. You saw a lot about Aks. Mysql and post services are Heavily integrated as much as possible to make development a Lot easier for you guys. When you want to deploy a WordPress application. We try to make sure you don’t Have to do more work than you already have to. Today’s demo’s going to beck be Focuses mostly on aks. We’ll talk more about the sifts We’re integrated with. One of the big ones we see Coming onto the service for is wordpress. We have templates available in the azure portal. It’s a few clicks to get a wordpress site up and running. It’s all in the same subscription you have and within The same resource group. We’ll talk about the azure Couper net’ service, which is currently in preview. We’ll be using the open service broker or sba for short. It helps you us bind a bunch of different azure services to the cluster. As we’re deploying the cluster and to the cluster, it create’s Database for us. The service knows where the mri Data base is and how to access the secrets it creates for us. Jumping to the demo. All right. So let’s start with i’m using The system for linux. I enjoy using bash than i like Command line for windows. Basically, to create a new Cooper netties can cluster. I’m going to do all this. I installed the azure cli beforehand. I’m going to create a new Resource group. All of the resources irate, Whether it’s my cluster as well as Make sure i get the right. We’ll call it build. I’m going to put this in central Us. It’s called build 2018aks group. Then i’m going to create my cluster. I’m specifying the same resource group. I’m going to name is tas ba Quick start cluster. Depening which region you choose And the amount of resources available, it can take 1010 and minuter minutes. I’ve experienced an hour or so. You have to be patient with it. In this command, if you kind of want to use an older version of Cooper netties you can specify the version. They default to the most recent version which is 1.96. I have a cluster currently Running in central us as well. This is called build aks group. When what i’m doing right now is Getting the creds for it. This will pass into my cuber net He’s utility. I want to make sure the cluster is up and running, can basically Run a get notes command. What it’s going to Provide is, yes, so i have three notes in the in my custer. When you create your cluster, you can specify as many as you Want and the number of cores you want on the machines in your Cluster. Basically, you can do take Advantage of all the power of the vms we have in azure and in The cloud. Like i said, you have three Agents vailable right now or three notes. I mentioned earlier in one of our previous slies we’re using The osba, so the open service broker for azure. This allows us to bind azure services to our kubernetes cluster. Before we do that, we actually have to install something called Helm, like a package manage for linux. You can use it to install a Bunch of different applications already available to you. In this instances, one thing i’ll deploy is wordpress. So to get helm, we can initially it, make sure it’s up and running. All right. So helm installs the client side And a service side piece. The service side is called tiller. When you initially helm, it initializes hiller on the Service side. That gets deployed across all Nodes as well. All right. So using helm, i had deployed the service catalog. The service catalog is basically a bunch of different listing of Apps that i can install into or deploy into my kubernetes cluster. You can see the catalog is already up and running, which is great. Then i also want to make sure i deploy osba, so run another helm Install, essentially. I did that beforehand because it Takes a bit of time. As you can see here, that’s also running. The open service broker for azure running, about tree days Old. So now that i have all that Deployed, i can now install, deploy, sorry, deploy wordpress Across my three nodes. I use helm to do that. So i should have it up and running. Let’s Double-check. One of the quick ways to check Is to actually start the kubernetes dashboard. So you can see here it’s starting to serve locally. Swing over to edge real quick. Make sure this is up to date. Perfect. And so when sba created my mysql database on the back end when i Deployed word press, it saved all the credentials for the Application as well as the database I can head to secrets. It has a pointer to the Database, pointer to the password as well as username. This is all for the database that will house all my my week Well database that has all the wordpress data in it. Let me go back. For the actual wordpress Application itself, i have an admin user it created for me. It gives me the password. So to ensure i actually deployed WordPress on the cluster, let me go back to here. Stop that real quick. I’m able to actually grab the ip Address for the wordpress site that was deploy ad long side. So this is just like your regular vanilla starter wordpress site here. To actually make sure i deployed it and i have the correct log-in Credentials, i’ll use the credentials i have here. So i’ll copy this password over. The username is user. Pasted that in. We’ll log in. So i’m inside the admin page. Let’s create a new blog post. Let’s see. So i’m actually going to publish this. This will publish to my wordpress site. That generates a user-facing url i can send to you guys to Comment on or to help me with my blog post. Obviously, i can see all that inside the wordpress site. I want to make sure it actually wrote it to the database. A quick way to do that is use mysql workbench. If you’ve used it before. I have the secrets already saved In here. I had taken the secrets from the Kubernetes dashboard here, the ones i showed You. Thanks, rachel. Yeah, you’re right. That’s some teammate over there. Cool. Let me double-check back to the secrets. So like i said, it generates a bunch of different secrets for me. The username, password, it creates the data, shows me the Database name as well as server or host name. What’s going on here? all right. It’s going to be here. The database is muc something Something something post is 2eb et cetera. I pass it all along to mysql workbench. I’m going to connect to the database. Let me see if i can make this bigger for you Guys? can you see this okay even Though it’s super small -ish? okay. So the table i’m really look for Is wp posts. So it’s going to be this table Where all the blog posts i create will get written into this table. I want to make sure i’m using the right table and let’s just Inquiry from here. Let’s see if i can make this Bigger. If you squint, you can see it Says welcome to build. It gets written directly into

Danny Hutson

Leave a Reply

Your email address will not be published. Required fields are marked *