How to easily manage linode managed mysql database
I use phpmyadmin to easily manage my single myql instance. I'm exploring using the linode managed database cluster -- is there a graphical management tool I can use to easily manage my database ?
3 Replies
I don't see why you would not be able to continue to use phpMyAdmin with the Linode managed DB.
I also don't see why you would want to pay these crazy prices (https://www.linode.com/pricing/#databases) for a database when most of them are easy to install on almost every OS (Slackware probably being an exception) and most don't require much in the way of weekly or even monthly maintenance… and those can be done via simple shell scripts (I use Bash.)
$780 USD a year for the smallest Akamai-managed MySQL DB is, IMO, way overpriced… unless you are running some kind of corporate or government mission-critical, high-volume, DB-heavy, client-facing application where you might need 'instant' and/or 'deep-bench' technical support (and if that was the case my guess is that you would be running it on AWS or Azure instead.)
YMMV.
Thanks, to answer your 2nd question its a db that generates quite of bit of revenue and I already have a fulltime job, very little time, etc. Paying $780/yr is a rounding error & I sleep better :-) Alternatively I could pay a guy but that would exceed this cost.
tlambert
Linode Staff
Since you're already using phpMyAdmin to connect to a database, modifying the connection configs to be compatible with the Linode Managed MySQL offering shouldn't be too much of a lift. You may want to review this section on using SSL for database server connections as Managed Databases connections are encrypted.
"is there a graphical management tool I can use to easily manage my database ?"
There is not currently a GUI available for database management, however, this post titled How can I monitor the performance of a Managed Database cluster? offers some pretty concise instructions on how you can install netdata to monitor your database's stats.
I would also like to point out that $780/year is the cost of a Dedicated 1GB Node. You could spin up a Shared 1GB 3-node cluster for $420/yr if the application or DB isn't overtly sensitive to the fluctuating CPU loads associated with a shared cloud environment.