-
Tech talk
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
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
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
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
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:
https://www.digitalocean.com/community/questions/how-to-create-a-se...
1
•
•
By
IoTUpbeat
DigitalOcean Managed MySQL Database
-
Question
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
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
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
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.
https://vercel.com/knowledge/how-to-allowlist-deployment-ip-address
https://github.com/vercel/vercel/discussions/4595#discussioncomment-26799
2
•
•
By
brian801307
DigitalOcean Managed MySQL Database
-
Question
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
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: https://do.co/diagram-kit
1
•
•
By
rsharma
DigitalOcean Managed Kubernetes
DigitalOcean Managed Load Balancers
DigitalOcean Managed PostgreSQL Database
DigitalOcean Managed MySQL Database
DigitalOcean Spaces
DigitalOcean Volumes
-
Question
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
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
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
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
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
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
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
Is it normal for a managed mysql database to have memory usage of 89% all the time? We have 4GB of RAM and the CPU is idle but the memory is high.
Is it possible to restart the managed mysql process to see if it fr...
1
•
•
By
heNMJ
DigitalOcean Managed MySQL Database
-
Question
Hi. There is a local mysql database on a cloud server with a size of 52GB+
How do I export it to DigitalOcean Managed Databases?
1
•
•
By
vlladoffwork
MySQL
DigitalOcean Managed MySQL Database