Priyanka Malik Employee
31 contributions
26.7k contribution views
Recognition
Posts
-
Published Answer
Does Digitalocean have access to our customer's data?
Hello, Database data is encrypted at rest and in transit. This means all data is unreadable outside of the cluster until sent pu… -
Published Answer
Grant on File permission is not working for the user doadmin.
Hi, The operation (INTO OUTFILE) is potentially very dangerous, and we don’t currently allow this in managed mysql services, be…Accepted Answer: Hi, The operation (INTO OUTFILE) is potentially very dangerous, and we don’t currently allow this in managed mysql services, be… -
Published 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 -
Published Answer
How to scale back managed database to a smaller cluster?
Hi, At the moment we do not support scaling down of a database cluster from the UI, You can read about limitations here: ht… -
Published Question
How to scale back managed database to a smaller cluster?
During a traffic spike, we scaled up our database to higher plan. Now that traffic has slowed we would like to scale this back. Is it possible to scale back managed database cluster from the higher plan size to lower ... -
Published Answer
How to check metrics like CPU, Disk, RAM utilization in Managed database cluster.
Hi, To view performance metrics, click the name of the database to go to its Overview page, then click the Insights tab. The Se…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 Se… -
Published 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.... -
Published Answer
How to reclaim disk space in MySQL managed database
Hi, MySQL managed database is configured to use inodbfileper_table=ON which means that for every table its data and indexes a… -
Published Question
How to reclaim disk space in MySQL managed database
I just noticed that my disk space is full in mysql managed database. I have deleted unwanted significant amount of data from mysql database. However, I do not have my disk space back at all. Is there a way to reclaim ... -
Published Answer
How to enable MyISAM for MySQL managed database.
Hi, Currently, with our managed database offering the storage engine for MySQL cannot be changed from innoDB to MyISAM. You ca…Accepted Answer: Hi, Currently, with our managed database offering the storage engine for MySQL cannot be changed from innoDB to MyISAM. You ca… -
Published 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: https://www.digitalocean.com/docs/databases/mysql/#mysql-limits R... -
Published Answer
In Logs and Queries getting error
Hi @fantasysports a) Can you confirm if database have any tables without a primary key, contain more than 5000 rows? Databas… -
Published Answer
Managed databases: major version upgrades
Hi @collimarco You can upgrade earlier versions of PostgreSQL clusters or nodes to newer versions without any downtime using th… -
Published Answer
How to set timeout to 0 in Redis Managed Database?
Hi @dekev We set timeout value to 300 seconds by default for Redis Managed database. This is configurable parameter. If you wou… -
Published Answer
Managed database standby nodes in different datacenter
Hi @arturczapiewskiremi Standby nodes is only supported for the same region now. We’ve never had a total outage in any of our d… -
Published Answer
MySQL to PGLoader migration error on Managed database
Hi @alramalho It seems like SSL mode is not enabled. By default, you are not permitted to transmit data unencrypted (meaning… -
Published Answer
Managed Redis select DB, any limits?
Hi @CarterB By default, we provide 16 databases in Redis which you can switch to by using SELECT statement. Increasing the numb… -
Published Answer
Configuration for Full Text Search with custom dictionary in Managed Database
Hi @balykinaao Due to the managed nature of the database, installing custom dictionaries is not currently supported since it wi… -
Published Answer
Managed database and backups
Hi @HappyBlueGreenKelp Daily backups are available with our managed database service at this time. We maintain 7 days worth of … -
Published Answer
MySQL Managed Database can't modify database without setting primary key, but I can't set primary key without modifying the database.
Hi @miramallows You can use the SET SESSION sqlrequireprimary_key = 0; It is for a single session though. Once you log out…Accepted Answer: Hi @miramallows You can use the SET SESSION sqlrequireprimary_key = 0; It is for a single session though. Once you log out…