Please note that this content is targeted for SysOps 1
Administrators if you're a Solutions Architect or a developer you may want to 2
skip over this one. Welcome back to BackSpace Academy. In this hands-on 3
lecture on monitoring RDS we're just going to run through some of the tools 4
that are available for monitoring our RDS instances okay so our instance is 5
now available and what we can do now is start to have a look at some of the 6
metrics that are being produced from it so we click on show monitoring and then 7
we can see our standard cloud watch metrics so we've got CPU utilization 8
free storage space and this is coming from the hypervisor information so what 9
we can also look at is our enhanced monitoring and that is coming from an 10
agent that is running on that actual ec2 instance in a similar way that you would 11
have a monitoring script on an ec2 instance for example so we can actually 12
go into here and look at enhanced monitoring and we can see there there's 13
a lot more lower level operating system level information available for surround 14
memory and file system information and load on the system which is very 15
important as well so this is quite a good one to monitor number of tasks that 16
are running and the average load as well so what we can do is we can actually 17
create CloudWatch alarms around this as well 18
so if I just go back to instances now and we can also see in here 19
under the information we can go to logs and there we can see that the logs for 20
our era running log are being recorded and our my cycle upgrade log as well so 21
we can download and and view those as well we've also got RDS events so 22
just on the left hand side here we've got events and there are a number of 23
things that we can look at subscribing to so we've got some events here that 24
I've could so the DB instance was restarted it was created it was backed 25
up and that has finished backing up that instance and so we can actually go into 26
here into event subscriptions and we can create an event subscription just give 27
it a name and we'll create a topic there a new topic and we just call that test 28
again. Just copy this user@domain that will do and we'll select source 29
type of instances and so we just select say whenever an instance files over or 30
or we have a failure of an instance we can subscribe to that and we just create 31
that. Okay so the final thing I'd like to show is a new feature to RDS at the time 32
of this video it is only in preview so if you're looking at your RDS console 33
and you don't see this tab on the this menu option on the left-hand side here 34
called performance insights don't be too concerned about it as it will be coming 35
to you eventually and also we've got here an option to launch an Aurora PostGre SQL 36
preview. So Aurora has always been a mySQL database engine 37
database but it's now also going to be a PostGre SQL 38
as well. So what we'll do is we'll launch a PostGre SQL Aurora 39
instance because that is what we can use now with performance insights so I just 40
click on that so I'll just use the smallest class that it's available just 41
give it a simple name now we can't use admin for a PostGre database we use 42
something else 43
just give the cluster a simple name as well and the database a simple name now 44
I'm just going to enable enhanced monitoring as well and I'll give the 45
granularity of 15 seconds and we can see here we've got an option for enabling 46
performance inside so that's a new feature that is currently at the time of 47
writing or at the time of this video being created is only available for 48
Aurora PostGre SQL instances so just go and launch that DB instance now 49
and after certain amount of time that will be up and running. Okay so our 50
Aurora PostGre SQL database is up and running so what I'm going to do now 51
is just connect in to it so I'll just grab that endpoint and jump into PG 52
admin create a new server put the connection in there take the 53
5432 off the end of it and if you don't remember how to do this just go 54
back to the RDS section and do the labor on post crazy sequel databases and I'll 55
put my username and password save the password just give it a name test two 56
that will be fine and save okay so now I've connected in there if I have a look 57
at my database I should see my test two database we'll just connect into that 58
and that is a good go to the dashboard, okay so I'm connected in as a user there 59
so I should be able to now go back into the RDS console and now if I click 60
on performance insights which is that new feature 61
and now if I select I can see here I've got my master database and my replica 62
here, if I select that master database I can see that there's 63
information there of my activity of connecting into that instance so we can 64
see we've got a little bit more information here from from the 65
performance insights in particular around load on the data based so what 66
we've got here is is that we can we can have a look at users as well so load by 67
user and it gives us a lot more granularity around what it's actually 68
happening with our RDS Aurora instance so that's about all I need to show you 69
about monitoring of RDS and I'll look forward to seeing you in the next 70
lecture