If you have been following events happening in the world closely, you have heard of COVID. And if you heard of COVID, you probably know how things have changed in the world. Everyone’s in lockdown, those professions that couldn’t work from home before now do so, etc.
Things have changed in the database world as well – developers dealing with databases and database administrators now deal with different things than before.
How Things Have Changed?
You see, since the beginning of 2020, COVID took place. COVID shook the world and moved things around: everything’s upside down now, isn’t it? Everyone who was working from an office now works remotely from home, everyone who couldn’t imagine their life being situated around the Internet suddenly does. Weird, isn’t it? Indeed, that’s the power of corona.
However, what we’re most interested in, is how things have changed around the database space:
- In the years leading up to 2020, the high availability of database instances didn’t have as much significance as it does now: these days, as everyone is working from home, the high availability of database nodes is as important as never before: if a database-backed service goes down, there will be problems for everyone involved: the company, its staff, as well as its clients.
- In the years leading up to covid, the monitoring of database instances was important, but it wasn’t as important as it is these days: if we neglect to monitor our database instances these days, we can be almost certain that we will face some sort of an issue. If not sooner, later on.
You see, the things that have changed are mostly related to high availability and performance, but security shouldn’t be put off the pedestal as well: with hackers being at home, we can be certain that we will see more data breaches than ever before. While in the security space there are tools that help you protect from data breaches, both performance and high availability of database instances cannot be reliably completed without using some sort of tooling.
CCX by Severalnines
Here’s where CCX developed by Severalnines comes in – building atop the power of the powerful ClusterControl, CCX can help you solve your database issues in no-time. Here’s how CCX looks from the inside:
CCX is able to provide you with an overview of your services, including the cloud provider you use, its region, whether you are able to use VPC or not, and provide you with some general information regarding your database instances as well: in this case, we can see that we run MariaDB Cluster 10.5 with one node: tags can let us search through database nodes, so they are important too.
However, what we’re perhaps more interested in, is the monitoring and query statistics provided by the tool:
CCX in this case is able to provide us with a couple of chart sets (system, database nodes, load balancers) which can be filtered on preset ranges too. The data is refreshed automatically every 30 seconds as well. CCX in this case is able to provide us with load average of our database instances, how much CPU in percentage does our database servers use, what’s happening with our memory, network or disk space, what’s our disk I/O utilization, you can observe the amount of disk IOPS, disk throughput, etc.: all of those features could prove to be vital in covid-times because you never know when performance-related disasters could strike.
As CCX by Severalnines also comes with several high availability features (such as ProxySQL which is deployed by default with all of your MySQL and MariaDB clusters), you will never have to worry about missing out on high availability too. Make sure to take advantage of everything that CCX has to offer for your business today! Or, should you need some more information, make sure to glance at our blog: it provides a lot of valuable information that could be used to improve the performance, availability, and security of both your applications and databases.