DigitalOcean Managed MySQL Database

DigitalOcean Managed MySQL Database subscription active
You will receive email notifications for new publications on DigitalOcean Managed MySQL Database.
52 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
  • 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

    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...
    3 By businessbcbdbe0eab0de5765a 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

    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? https://www.digitalocean.com/docs/databases/mysql/ 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

    memory limit down mysql in site wordpress ec.com.uy

    how can fix this problem in dropplet ec.com.uy
    1 By administradorcncscomuy DigitalOcean Managed MySQL Database
  • Question

    Moodle Site for 1000 concurrent users

    I am planning to install Moodle (php application) with MySql database. At present i have it on a VPS with 8GB Ram 6 CPU centos but it is not efficiently catering the need of even 100 concurrent users. What way I can u...
    1 By doctshind DigitalOcean Managed Load Balancers DigitalOcean Managed MySQL Database DigitalOcean Accounts
  • Question

    Cannot set up SSL for MySQL using only DO-provided CA certificate

    I'm having a lot of trouble successfully setting up connections to the MySQL managed databases, and finding the usually very informative DO documentation and tutorials lacking in details. The documentation notes that ...
    0 By BrianIbbotson DigitalOcean Managed MySQL Database
  • Question

    How to debug DO managed DB throughput/latency spikes?

    I recently moved my WordPress database to a DO managed MySQL db. So, I have a single droplet connected over a private network to a single DO db. Since then, I have been seeing occasional large spikes in db throughput ...
    1 By businessbcbdbe0eab0de5765a DigitalOcean Managed MySQL Database
  • Question

    MySQL ACCESS information

    How do I get access to MySQL since there is no PHP myadmin available here
    1 By avinashkrishnani DigitalOcean Managed MySQL Database
  • Question

    Unable to import database from another managed database

    Hey, I'm trying to set up a staging Managed Database So far I have Exported all my databases from the production Managed DB to an SQL file using mysqldump but when I try to import to the staging I stumble upon an err...
    1 By omercohen DigitalOcean Managed MySQL Database
  • Question

    How do I connect to a managed MySQL database using Java?

    I've spent three days on this so far, and I'm tearing my hair out. I'm trying to adapt some code I've inherited to migrate from AWS to DigitalOcean. Amazon's DB didn't require SSL to connect, so the code worked fine b...
    1 By baronofclubs Java MySQL DigitalOcean Managed MySQL Database
  • Question

    cant connect wordpress mysql. The server requested authentication method unknown to the client

    hi , im trying DO managed databases and im facing some problem conencting it to my wordpress. i read some on this community but i cant found the correct answer. i have tried ALTER USER 'MYUSER'@localhost IDENTIFIED W...
    1 By advcloudjagoan DigitalOcean Managed MySQL Database
  • 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 157.245.108.229 Port 80
    3 By pacificsofttechltd DigitalOcean Managed MySQL Database
  • Question

    Tableau is unable to connect to Digital Ocean Managed Database

    I'm having trouble with Tableau and connecting it to the DO Managed Database. The issue is whenever I want to create a new data source, it asks for my database credentials naturally I have to enter the username/pass...
    1 By omercohen MySQL Databases DigitalOcean Managed MySQL Database
  • Question

    Database encryption for backup and DB instances

    Hiya. I've been using AWS previously, and they provide the ability to encrypt their DB instances with a private key. This requires some level of trust in AWS of course, but in general it ticks the compliance box for c...
    1 By dld DigitalOcean Managed MySQL Database
  • Question

    I'm trying to use a managed database but without success.

    Hi, I created a managed database to use with my droplet, imported all fine but when trying to connect via php I get this error "Server sent charset unknown to the client." I understand this is caused by the utfmb4 cha...
    1 By aarnold69607b07794fbfca66e DigitalOcean Managed MySQL Database
  • Question

    can we install two databases one master and another slave on a single droplet in digitalocean?

    Hi we want to install two databases on one droplet and one should be master and other as slave. Is it possible? Please suggest.
    1 By serveradmin7162d00ccd8f76e DigitalOcean Managed MySQL Database
  • Question

    Unable to execute a query without super admin

    Hey, I have recently migrated my database to DO managed Database however I bumped into an issue that is very critical for me to resolve and would be happy if someone would explain how to overcome this issue I am cur...
    1 By omercohen DigitalOcean Managed MySQL Database