DigitalOcean Managed MySQL Database

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

    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

    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

    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 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

    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

    "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

    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
  • Question

    how to properly bind a database to be used in app?

    Hi! I'm experiencing the app platform to deploy a single WordPress application. So, I created a database to be associated with the app and I did the deploy but I can't connect the WordPress application with the databa...
    Accepted Answer: Found the reason: The app platform doesn't have any persistent data so there is no possibility to deploy WordPress application on it.
    1 By mikhaelipcn DigitalOcean App Platform DigitalOcean Managed MySQL Database
  • Question

    Restore MySQL Managed Database to today's transaction

    Hello, Managed database control panel says that: You can restore to any transaction, as far back as 7 days. This will not restore standbys or read-only nodes from this cluster. I am able to select today's date, but la...
    Accepted Answer: Hello there, Thanks for your patience! To restore your database, you can restore to any transaction, as far back as 7 days. The restore point can be from the lastest transaction or a specific point in time, A new dat...
    1 By dmitrijssadovsk DigitalOcean Managed MySQL Database Needs Product Answer
  • 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

    Managed MySQL: Failed to create table

    Hello, I'm using Managed MySQL and the OpenLiteSpeed WordPress 1-Click image. Enabling some css or js options in the bundled LSCache plugin shows the following error: Failed to create table cssjs! SQL: CREATE TABLE I...
    Accepted Answer: Hi, What if you directly run CREATE TABLE IF NOT EXISTS `wp_litespeed_cssjs` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `hash_name` varchar(60) NOT NULL COMMENT "hash.filetype", `src` text NOT NULL COMMENT "full url ...
    2 By PSNick DigitalOcean Managed MySQL Database OpenLiteSpeed WordPress 1-Click Databases
  • Question

    Recovery for Managed MySQL + Redis

    Hello, I'll soon start an e-commerce website for digital files based on WordPress and EDD and thought the ideal setup would be: OpenLiteSpeed Wordpress (from the marketplace) Managed MySQL Managed Redis Spaces for the...
    Accepted Answer: Hi there @PSNick, This sounds like a solid setup, I like it! It also gives you the chance to, later on, scale up your webserver to multiple web servers and add a load balancer. Regarding, the MySQL restore, I would re...
    1 By PSNick OpenLiteSpeed WordPress 1-Click DigitalOcean Managed MySQL Database DigitalOcean Managed Redis
  • Question

    How to get long term backups for DigitalOcean's Managed Databases (MySQL)?

    The documentation for Managed Databases states backups are only held for a week. I want to keep longer term backups, but can't make them manually without SSH access which Managed Databases don't give. Is there a way t...
    Accepted Answer: Hi there @visarunas, What I usually do is use a MySQL backup tool like mysqldump for example. It allows you to export your databases without SSH access. To export a backup you could run the following command: mysqldu...
    2 By visarunas DigitalOcean Managed MySQL Database Databases
  • Question

    How to connect to DB cluster using MySQL Workbench?

    Hi! I've been looking at the documentations and tutorials but I could not find what I'm looking for. Is it possible to connect to my DB cluster using MySQL Workbench or any MySQL client? Thanks so much :)
    Accepted Answer: Hello, yes you can connect using MySQL workbench, by entering all the details such as hostname, port and username. Refer to below link, for guidance:
    1 By IoTUpbeat 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 DigitalOcean 1-Click Apps Marketplace
  • 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