DigitalOcean Managed MySQL Database

DigitalOcean Managed MySQL Database subscription active
You will receive email notifications for new publications on DigitalOcean Managed MySQL Database.
85 Results
  • 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...
    1 By northerncyclist 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...
    2 By davidyap DigitalOcean Managed MySQL Database
  • Question

    How do I restrict to a Vercel Now hosted deployment?

    Hello! Just fired up a DigitalOcean managed MySQL database, and need to restrict to specific hosts that can access it. However I don't think there's a static IP or range they could potentially fire connections from. H...
    Accepted Answer: Hi @brian801307 I found the answer at these two links.
    2 By brian801307 DigitalOcean Managed MySQL Database
  • Question

    Trouble connecting remote mysql managed database to one-click phpmyadmin

    Good Morning, I created a mysql managed database (open to all incoming connections/raw initial setup). I then created a one-click phpmyadmin droplet from the marketplace, as I would like to create a web-based ui for m...
    Accepted Answer: Hi there @meloku, I think that the PHPmyAdmin that ships with Ubuntu 18.04 has some issues connecting to MySQL 8, what you could do instead of using the 1-Click PHPmyAdmin install is to just install PHPmyAdmin manuall...
    1 By meloku DigitalOcean Managed MySQL Database One-Click Install Apps
  • Question

    How can I create good diagrams for my infrastructure architecture based on DigitalOcean products?

    I build interesting applications using best practices in infra architecture and would love to be able to write/blog about them. However, I lack the tools to be able to create good architecture diagrams for all the di...
    Accepted Answer: A great resource for creating architecture diagrams for infrastructure configurations based on DigitalOcean can be found here:
    1 By rsharma DigitalOcean Managed Kubernetes DigitalOcean Managed Load Balancers DigitalOcean Managed PostgreSQL Database DigitalOcean Managed MySQL Database DigitalOcean Spaces DigitalOcean Volumes
  • Question

    removing conditional comments from sql backup

    Hey, I'm having trouble with importing my production cluster to staging on digital ocean managed database I use mysqldump with --routines --triggers --events --all-databases &set-gtid-purged=OFF parameters every tim...
    Accepted Answer: Hi there @omercohen, Have you tried using the --compact flag? As a workaround, what you could also try is when running the MySQL import to specify the -f flag so that it would force the import even if there is an erro...
    1 By omercohen DigitalOcean Managed MySQL Database
  • Question

    Which SQL mode values to use for WordPress?

    I have a WordPress site running on a DO droplet and WordPress uses a localhost MySQL db. I want to migrate the db to a DO managed MySQL db. I have created the new db and completed migrating the db data, however, I hav...
    Accepted Answer: DO managed DBs do work with WP, I ran many tests with them. You might bump into a couple of issues: In the DO GUI DB settings, you need to set STRICTTRANSTABLES You might want to check this: https://www.digitalocean.c...
    4 By JigsawBob DigitalOcean Managed MySQL Database
  • Question

    Connection timed out on MySQL Managed Database Cluster

    Hi guys, we start up with a new Managed Database MySQL cluster but unfortunately we cant connect with any PHP tool AND also phpMyAdmin. The config for the phpMyAdmin: ``` $cfg['Servers'][$i]['verbose'] = 'CLUSTER'; $c...
    Accepted Answer: Failed with; $cfg['Servers'][$i]['port'] = 3306; Success with; -P 25060 You're simply using the wrong port in your application. Try changing it to the latter and retry connection. BR A
    2 By goetzm Databases MySQL Clustering DigitalOcean Managed MySQL Database
  • Question

    Backups and Point In Time Restore (PITR)

    I currently use AWS RDS. Looking at your managed database pages and the documentation it's not clear if, like AWS, you're taking snapshots every 5 minutes in addition to the daily backups - or there is only the daily ...
    Accepted Answer: Hey petersys 👋 The service takes a single full backup every 24 hours; the write ahead log (WAL) is backed up approximately every 5 minutes, enabling point-in-time-restore operations. If user error occurs that needs ...
    4 By petersys DigitalOcean Managed MySQL Database
  • Question

    Best method to sync Managed MySQL to MySQL on a Droplet

    Hi, I was hoping to use log shipping to sync a DB hosted on Managed MySQL to a DB on MySQL installed on a Droplet. Can I do this and is there any documentation, as I can't seem to see any. If I can't sync using log sh...
    Accepted Answer: Unfortunately, the managed DBs won't have any such access or options. If we could change basic settings such as key buffers etc, we'd be happy already. In your case, it seems like it would be easier to schedule a CRON...
    1 By smartlist DigitalOcean Managed MySQL Database
  • Question

    How install filebeat module to mysql cluster

    I have a mysql digital ocean cluster and I want to transfer logs from my database to logstash. How can I install the filebeat module for mysql cluster?
    Accepted Answer: I don't think that this would be possible, as with the Managed MySQL servers you would only have MySQL access and not direct access to the server itself via SSH for example.
    1 By degorych DigitalOcean Managed MySQL Database
  • Question

    Connection pooling is not supported?

    I just want to make sure I read that correctly, pooling is not supported by your managed Mysql instances? Does this mean I can only have a single connection from my ...
    Accepted Answer: Hello, Connection pooling is just a specific technique in handling connections, it means that connections are reused rather than created each time a connection is requested. Connection pooling is different from max_c...
    2 By eparry MySQL DigitalOcean Managed MySQL Database
  • Question

    Can we create a web service only with MYSQL cluster?

    I am an android developer and don't know so much about server side. I was using a simple hosting and firebase for my backend needs. However, now I need a high scale database. I want to use managed database mysql. Can ...
    0 By uzunapps MySQL DigitalOcean Managed MySQL Database API PHP
  • Question

    All my post request are headed to the same table inMySQL database

    I have a MySQL 8 managed database connected to my NodeJs app on Ubuntu 18.04.3, I have a condition that determines which table my post request would enter, but all the requests are headed to a single table in mysql 8 ...
    1 By Eebrugzy MySQL DigitalOcean Managed MySQL Database Ubuntu 18.04 Node.js
  • Question

    Why connecting to Managed MySQL DB from local is very slow?

    I managed to connect my local WordPress multisite instance to the remote MySQL instance, but it takes literally minutes to load! If I switch DBs I get the same speed I had in my local which was pretty fast, I'm now te...
    1 By giggs DigitalOcean Managed MySQL Database PHP WordPress
  • Question

    I cannot access phpMyAdmin on Ubuntu 18.04

    I can not access phpMyAdmin Through the website. Not Found The requested URL /phpmyadmin was not found on this server. Apache/2.4.29 (Ubuntu) Server at Port 80
    3 By pacificsofttechltd DigitalOcean Managed MySQL Database
  • Question

    How to edit MySQL system variables in Managed Database

    Hey! I was looking into how I could change the behavior of AUTOINCREMENT in our database, specifically innodbautoinclockmode from 2 to 0. I cannot any way to make this change, does anyone know how I can apply this cha...
    1 By Boohi DigitalOcean Managed MySQL Database
  • Question

    Transfering wordpress databases to managed database

    Having trouble transferring large databases to a managed database, as the mysql settings seem to be very strict and hard to work round, and when changing the mysql mode via the control panel it doesn't seem to be refl...
    2 By gabba DigitalOcean Managed MySQL Database
  • Question

    Are MySQL comments allowed on Databases hosted by Digital Ocean?

    I receive this exception anytime when trying to add a comment on a database column or table: add column label_data mediumtext NULL DEFAULT NULL COMMENT 'Shipping labels file encoded in base64' to table {{%orders}} .....
    0 By cgsmith DigitalOcean Managed MySQL Database
  • Question

    Nodejs connecting to managed mysql database ERR: connect ETIMEDOUT

    Hi, my nodejs has connect ETIMEDOUT error. i wonder what is happening. this is my connection on my nodejs var mysql = require('mysql'); var con = mysql.createConnection({ host: "db-mysql-xxx-xxx-do-user-xxx-0.a.db...
    1 By legihendra7 Node.js DigitalOcean Managed MySQL Database