Managing Your Own Databases is a Task of the Past with Linode's Managed Database Platform

Our new managed database service is now in open beta for new and existing customers! In this video, @DevOpsDirective will cover how Managed Databases allow you to quickly deploy a new database and defer management tasks like configurations, managing high availability, disaster recovery, backups, and data replication.

Chapters:
0:00 Introduction
1:10 Creating a Database
3:38 Connecting to your Database Cluster
4:40 Setting Up A Self-Managed MySQL Linode
7:10 Securing MySQL Installation
9:14 Configuring ufw Firewall
10:40 More Managed Database Information
11:20 Conclusion

#Linode #MySQL #Database #ManagedDatabase
Product: Linode, Databases, MySQL; Sid Palas;

[bradkawaii]

MySQL is a thing of the part Maria DB is a way to go. One way or another there are two cases 1. MongoDB 2. Postgers SQL
Would be awesome to see details for HA cluster with failover in case of problems with primary node. Nobody is perfect, nobody can ensure 100% uptime so it has to be properly installed. Does Linode provide that functionality out from the box?

[scottsloanne]

Need more information on how the backup works. Mainly with respect to restoring. I need to only restore specific databases not all databases on the server

[scottsloanne]

Also we would need to scale the storage and not so much the memory or CPU - how is that done

[chrisimcevoy]

Looks great. I’ll check it out for myself when it supports Postgres.

[StringPassion.]

I've been following this for awhile. This service keeps appearing and then disappearing in the cloud hosting panel menu. A couple of days ago it was there. Now it's gone again.

[andyfusniak]

What would be really good is having some visual metrics for how many connections are in use, cpu, memory, traffic to and from the server on per user basis, as well as the ability to adjust the max connections. Looking forward to seeing the Postgres offering.

[default_youtube_profile]

what type of cluster is it ? is it galera cluster or something else ? maybe its a naive question but I want to know what type of replication is happening in case of multinode ?

[MakeKasprzak]

I'm on the fence. Yes I'd like to take management off my plate, but I don't like that I can't choose what hardware my nodes run. I can't "setup and forget" some fixed machine on setup, I need the option to upgrade and downgrade my machines. I don't need 3 local copies of the data, I need the flexibility to spin down one machine for upgrades, and once it's up and sync'd, make that the focus, so I can repeat the process. I also don't need an 8 core 3rd redundant machine (or 5th). These nodes aren't there to run complex queries, they're there to sync, they're there for integrity. They're there to ensure if I have a double primary failure, or a single primary failure during an upgrade, that there's a source of truth to rebuild the other machines.

Also I can't choose MariaDB or Gallera clustering configurations (workload sharing/sharding). I don't necessarily hate regular database redundancy setup, but yes please, take Gallera off my plate. 😅

[albertomartinez]

why not develope in europe the education on studies primari services, de manera q el oficio de pastor de vacas o granjero reduciria costes al consumo

[kimsoft]

A recently created account with this email address was canceled by our automated systems. This was due to activity or patterns associated with fraudulent behavior. Additional attempts to sign up may also be rejected.

Linode

Some help why do I get this error