Recognition

Posts

31 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…
    By priyankamalik
  • 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…
    By priyankamalik
  • 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
    1 By priyankamalik DigitalOcean Managed MySQL Database
  • 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…
    By priyankamalik
  • 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 ...
    1 By priyankamalik DigitalOcean Managed MySQL Database DigitalOcean Managed PostgreSQL Database
  • 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…
    By priyankamalik
  • 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....
    1 By priyankamalik DigitalOcean Managed MySQL Database DigitalOcean Managed PostgreSQL Database MySQL PostgreSQL
  • 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…
    By priyankamalik
  • 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 ...
    1 By priyankamalik DigitalOcean Managed MySQL Database MySQL
  • 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…
    By priyankamalik
  • 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...
    1 By priyankamalik DigitalOcean Managed MySQL Database MySQL
  • 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…
    By priyankamalik
  • 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…
    By priyankamalik
  • 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…
    By priyankamalik
  • 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…
    By priyankamalik
  • 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…
    By priyankamalik
  • 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…
    By priyankamalik
  • 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…
    By priyankamalik
  • 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 …
    By priyankamalik
  • 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…
    By priyankamalik