Is auto sharding enabled in DigitalOcean Managed MySQL ?

November 1, 2019 72

By:

hirenkavad

MySQL cluster (NDB Cluster) now supports auto sharding across data nodes, does DigitalOcean Managed MySQL implements MySQL NDB cluster internally or they use another technique.

Does it supports auto sharding across nodes or the just replicate data across nodes and you need to scale database vertically ?

Be the first one to answer this question.

question

WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list...

Hi, We’re using DO managed database for two of our Wordpress sites, one of them shows the following error with debug=true in wp-config.php WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column 'wordpress-programs.wp_posts.post_date' which is not in SELECT list; this is incompatible with DISTINCT] SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month FROM wp_posts WHERE post_type = 'attachment' ORDER BY post_date DESC Wordpress 5.2.3. PHP 7.3.9-1+ubuntu18.04.1+deb.sury.org+1, MySQL 8.0.16 - Linux The other site is just fine, see config below and the content is identical i.e we have similar posts on both Wordpress 5.2.3 PHP 7.2.19-0ubuntu0.18.04.2, MySQL 8.0.16 - Linux We’ve tried the fixes for Disable ONLY_FULL_GROUP_BY from the following link but didn’t help. Can you please review and help? https://stackoverflow.com/questions/23921117/disable-only-full-group-by Thanks James
question

Private connection to Managed DB not working from within same region droplet.

I have a droplet in the same region as my managed DB, like DO suggested. I have added my IP and droplet to the Restricted Access section of the managed database. I can connect via public connection from my computer. If I try connecting from within the droplet using private credentials, no error message, just timeout. Is there a step I'm missing? I even disabled the droplet's firewall thinking the port was being blocked.
question

Connecting from Node.js to MySQL managed database

Hi, We are trying to connect the MySQL managed database cluster from Node.js app, and DB configuration as follows, ``` export const databaseConfig: DatabaseConfig = { username: 'doadmin', password: 'xxxxxxxxx', database: 'xxxxxxxxx', host: 'xx-xx-xx-xxxx-xx-xxx-xxx-x.db.ondigitalocean.com', port: 25060, dialect: 'mysql', logging: true, force: true, timezone: '+00:00', pool: { max: 100, min: 0, idle: 200000, acquire: 1000000, }, ssl: true, dialectOptions: { ssl: { ssl: true, cert: fs.readFileSync(process.env.INIT_CWD + '/server/config/' + 'glitra_mysql_ca-certificate.crt') } }, ``` The .crt file is downloaded from DO database connection setting section, When we run the application we are getting "self signed certificate in certificate chain". Anybody tried connecting with from Nodejs to managed db and help us on this issue? Thanks, -SK
question

Possible to disable strict in Managed MySQL?

I know we cannot make changes like that. However is there a way to have a managed database setup like this? It is one of the major hangups with a large codebase that we are wanting to use Managed MySQL with. Thanks

Share

Share your Question

Is auto sharding enabled in DigitalOcean Managed MySQL ?

Leave a Comment

Related

question

WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list...

question

Private connection to Managed DB not working from within same region droplet.

question

Connecting from Node.js to MySQL managed database

question

Possible to disable strict in Managed MySQL?

Almost there!