DigitalOcean Managed MySQL Database

DigitalOcean Managed MySQL Database subscription active
You will receive email notifications for new publications on DigitalOcean Managed MySQL Database.
190 Results
  • Tutorial

    How to Set Up a Scalable Laravel 6 Application using Managed Databases and Object Storage

    Data persistence and file storage represent two of the biggest challenges when horizontally scaling web applications. This is mainly due to the fact that it is hard to maintain consistency of variable data between mul...
    By Bobby Iliev, Erika Heidi PHP PHP Frameworks Object Storage Scaling DigitalOcean Managed MySQL Database DigitalOcean Spaces Laravel
  • Tech talk

    Building an Enterprise-Ready eCommerce Site in Under an Hour With DigitalOcean

    How to use DigitalOcean and Magento, a free open source eCommerce platform, to build and grow an enterprise-ready online store from the ground up.
    By Austin Black DigitalOcean Managed MySQL Database DigitalOcean Managed Load Balancers Tech Talks
  • Tech talk

    What's New In DigitalOcean Managed Databases

    Migrate your data quickly, get more powerful instances, and see how leveraging DigitalOcean Managed Databases allows you to focus on what's important — building your product.
    By Mark Huber Tech Talks Databases DigitalOcean Managed MySQL Database DigitalOcean Managed PostgreSQL Database DigitalOcean Managed Redis
  • Question

    How can I downgrade my DB cluster

    Hi, I was able to upgrade my DB cluster, but there is no option to downgrade it! I don't understand why not. I can downgrade and upgrade my droplets whenever I want, but not my DB cluster? Is there a way to do this, o...
    Accepted Answer: Hi @ALKateb, At the moment Digitalocean does not support scaling down of a Managed database cluster from the UI, You can read about limitations here: Alt...
    1 By ALKateb DigitalOcean Managed MySQL Database Scaling
  • Question

    Managed Database Cluster is full and it's on Read-only mode

    Hi, I would like to know what I can do to free up space in a full database, I can't do anything because it has been put in read only mode. Thank you
    Accepted Answer: Hi there, I just noticed a similar question asked here with a very good answer: The answer suggests ...
    1 By cativo23 DigitalOcean Managed MySQL Database
  • Question

    Managed Database or Droplet?

    I am currently running 1 droplet and within that it's running 1 web server and 1 database (MySQL). My plan is to move out the database into a server of it's own. The database is still fairly small, it's only at 250MB....
    Accepted Answer: It depends on how much time/energy you want to dedicate to maintain/update/backup your DB server. If you'd rather focus on something else, you could spin up your own Droplet. However, if you trust DO to have better me...
    3 By davidyap DigitalOcean Managed MySQL Database
  • Question

    How to connect MySQL managed database as a datasource in Google Data Studio

    Is it possible to connect MySQL version 8 Managed database as the data source for Google data studio? I am getting an error "Sorry, we encountered an error and were unable to complete your request"
    Accepted Answer: Hello, From apr-29-2021 ( update Google supports MySQL 8 version. The below URL will provide you steps to connect the MySQL database as a data source t...
    1 By Rajkishore DigitalOcean Managed MySQL Database MySQL
  • Question

    How to check metrics like CPU, Disk, RAM utilization in Managed database cluster.

    I want to know how to check disk, cpu and RAM usage of the managed MySQL and Postgresql database cluster?
    Accepted Answer: Hi, To view performance metrics, click the name of the database to go to its Overview page, then click the Insights tab. The Select object drop-down menu lists the cluster itself and all the databases in the cluster....
    1 By priyankamalik DigitalOcean Managed MySQL Database DigitalOcean Managed PostgreSQL Database MySQL PostgreSQL
  • Question

    How to enable MyISAM for MySQL managed database.

    I am trying to set up an application of mine using the new managed database, but when setting it up I get: - DBD::mysql::st execute failed: Storage engine MyISAM is disabled I was wondering is there a way to enable My...
    Accepted Answer: Hi, Currently, with our managed database offering the storage engine for MySQL cannot be changed from innoDB to MyISAM.  You can know more about it at: R...
    1 By priyankamalik DigitalOcean Managed MySQL Database MySQL
  • Question

    MySQL Managed Database can't modify database without setting primary key, but I can't set primary key without modifying the database.

    Hi, so I currently have a table with the following datatypes: column1 -> TEXT column2 -> TEXT column3 -> TEXT This table is huge, with over 500k+ rows. When I initially started using MySQL on DO, I hardly knew what a ...
    Accepted Answer: Hi @miramallows You can use the SET SESSION sqlrequireprimary_key = 0; It is for a single session though. Once you log out, you would need to run this again before you could do modify the table without primary key. T...
    1 By miramallows DigitalOcean Managed MySQL Database MySQL SQL
  • Question

    Grant on File permission is not working for the user doadmin.

    Grant on File permission is not working for the user doadmin. Can you please guide us how to do that? I have tried the following query: SELECT id, url, html INTO OUTFILE '/tmp/test.txt' FIELDS TERMINATED BY ',' OPTION...
    Accepted Answer: Hi, The operation (INTO OUTFILE) is potentially very dangerous, and we don't currently allow this in managed mysql services, because it could allow overwriting etc. Regards Priyanka
    1 By priyankamalik DigitalOcean Managed MySQL Database
  • Question

    "Out of sort memory, consider increasing server sort buffer size" error on mysql managed db

    I recently started using a managed DB and am getting the error "Out of sort memory, consider increasing server sort buffer size". How would I go about altering the sortbuffersize on a managed mysql instance? I can't s...
    Accepted Answer: Hey @northerncyclist, Indeed you are correct, as this is a managed solution you do not have access to the my.cnf file to make that change directly yourself. However, please reach out to our amazing support team who wi...
    2 By northerncyclist DigitalOcean Managed MySQL Database
  • Question

    App platform as trusted sourced to connect to managed database doesn't work

    I can select "app platform" as a trusted source in my managed database settings, but my app can't connect to the database once I do so. Even though it's attached as a component to the app. Am I overlooking something?...
    Accepted Answer: Hi all, This has been implemented and can be achieved by following the steps here: Hope that this helps! Regards, Bobby
    3 By VoordeMensen DigitalOcean App Platform DigitalOcean Managed MySQL Database Security
  • Question

    How to connect to Managed Database Cluster using Workbench

    I understand that it is not possible to use an SSH connection to a Managed Database server. That means I would need to use a TCP connection, right? I have tried entering the public host, port number, username doadmin,...
    Accepted Answer: Hi there @FrankJernigan, What is the exact error that you get when you try to connect? Also, what is the Workbench version that you are using? On another note, if you have enabled Trusted Sources for your Database Clu...
    1 By FrankJernigan DigitalOcean Managed MySQL Database
  • Question

    Having issue with connecting DB cluster with phpmyadmin

    I have installed phpmyadmin in my centos8 droplet, and created an db cluster with same private network, I could connect db cluster through centos8 droplet terminal, however, I couldn't use phpmyadmin to connect the db...
    Accepted Answer: Hi there, In your PHPmyAdmin config, you need to also specify the database port as the Managed Databases run on a non-standard port. Another thing that could be causing the problem is if you've installed PHPmyAdmin wi...
    1 By karlhui CentOS 8 PHP DigitalOcean Managed MySQL Database
  • Question

    How to set up SSH connection from remote database cluster to MySQL workbench

    I have a MySQL database cluster set up that I can connect to successfully via the command line (by running the flags in the terminal). I'd like to be able to connect to the MySQL Workbench. I looked at this tutorial (...
    Accepted Answer: Hi there, The tutorial with the remote MySQL connection via SSH would not work for Managed MySQL Clusters as the clusters do not come with SSH access. The tutorial would work if you had MySQL installed on a regular Dr...
    1 By jjustinjaeger MySQL DigitalOcean Managed MySQL Database Databases
  • Question

    Managed mysql database for small app

    Hello, we have a small application running on a droplet and this application receives an average of 160 requests / minutes and performs some CRUD operations on the database. In each request, a connection is opened wit...
    Accepted Answer: Hi there, I believe that 160 requests per minute should be OK, this is a little bit less than 3 queries per second. However, it really depends on the complexity of the queries and the amount of data. If you are doing ...
    1 By csalg12 DigitalOcean Managed MySQL Database MySQL Databases
  • Question

    Manage DigitalOcean MySQL Database with MySQL Workbench - Reverse Engineer

    Hi, I am using Digital Ocean MySQL database service with MySQL workbench to manage it (Version 8.0.22 build 107600 CE 64 bit). I have succesfully connected to the database with MySQL workbench and can see my schema an...
    Accepted Answer: Asked DigitalOcean support and they managed to find a solution. Remove ANSI_QUOTES from Global SQL Mode for the managed database server and it worked for me.
    4 By johnnychenjiahao Databases MySQL DigitalOcean Managed MySQL Database
  • Question

    How standby node work?

    i want to ask when standby node work and how it mirror primary node? is it mirrioring in real-time? so the data itself will be exact same on real-time. and what if the datacenter is down? is the standby database will ...
    Accepted Answer: Hello, In the event of a failure, Managed Databases will automatically switch data handling to a standby node to minimize downtime. The data between the nodes is being replicated using SQL replication. All database c...
    1 By yggitteam DigitalOcean Managed MySQL Database Needs Product Answer
  • Question

    How to use Managed MySQL Database read-only node with WordPress

    I have setup a Manage MySQL Database primary note and a read-only node and want to use them for my WordPress site. Does the "read-only node" works automatically as in auto split the read transactions? If not, how do...
    Accepted Answer: Does the “read-only node” works automatically as in auto split the read transactions? No, usually applications have to route the queries themself. Some ORMs makes this easier. In Node.js, I use Sequelize and see their...
    3 By Liew DigitalOcean Managed MySQL Database