Databases

Databases subscription active
You will receive email notifications for new publications on Databases.
275 Results
  • Question

    How to change caching_sha2_password to mysql_native_password on a DigitalOcean's Managed MySQL Database?

    I want to use the new DigitalOcean MySQL Managed Databases with my PHP application but I'm getting this error here: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; con...
    Accepted Answer: Hello, The easiest way to fix that would be to alter your existing user with the following: ALTER USER <^>myuser <^>IDENTIFIED WITH mysql_native_password BY '<^>mypassword<^>'; Another thing that you could do is to ...
    6 By bitmap Databases MySQL PHP WordPress
  • 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

    MongoDB database price

    So I am searching for my options to host my mongodb database for production. I am looking for the least price hosting service which obviously has backup. I found that digitalOcean has what is called by Managed databas...
    Accepted Answer: Hi there, Indeed as of the time being MongoDB is not offered as a managed database solution, but this might change soon. For the moment you could install MongoDB on a regular Droplet or use this 1-Click installation o...
    1 By abdelrahmanshahda MongoDB Node.js Databases
  • 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

    How to move Manticore Search data to another drive ?

    Hello, I want to move my Manticore Search data to a different drive. So far my searches have been unsuccessful. I will soon have a disk space problem if I don't move my data, so I need to be told the steps necessary t...
    Accepted Answer: Hello Your steps are correct. Changing Manticore Search configuration is super simple in this case: in Ubuntu you'll need to just update data_dir in /etc/manticoresearch/manticore.conf
    1 By florianbrgnr Databases
  • 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

    Can ScyllaDB cluster be deployed to DO without performance bottleneck?

    According to ScyllaDB hardware requirements (https://docs.scylladb.com/getting-started/system-requirements/#hardware-requirements) it needs network interface speed of 10 - 56 GB/s for production work loads, but as far...
    Accepted Answer: Hi! I’m honestly am not very familiar with ScyllaDB, but do know that our network speed is 2 GB/s for both Basic droplets and Dedicated droplets (General Purpose, CPU optimized, Mem optimized, Storage optimized).
    2 By kaushalyap Databases NoSQL Networking
  • Question

    "Cannot log in to the MySQL server" without code using phpMyAdmin on CentOS7

    I've set up a new CentOS 7 server with Apache, MySQL and phpMyAdmin using Digital Ocean's guides. However, when I try to log in to phpMyAdmin via the browser, I get the message "Cannot log in to the MySQL server" with...
    Accepted Answer: Assuming MySQL 8. ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD'; Reason: Some applications are having trouble with <^>caching _sha2 _password<^> method. Above sets the credentials to use the...
    4 By NielsKersic MySQL Databases CentOS
  • Question

    Using App Platform database env variables

    As I was looking into the environment variables documentation (https://www.digitalocean.com/docs/app-platform/how-to/use-environment-variables/#component-specific-variables) for App Platform, I could not understand wh...
    Accepted Answer: @gabrielbottari 👋 The bindable variables (https://www.digitalocean.com/docs/app-platform/how-to/use-environment-variables/#using-bindable-variables-within-environment-variables) are meant to be used directly in the va...
    1 By gabrielbottari Node.js DigitalOcean App Platform Databases
  • Question

    How to install the latest stable MariaDB version on CentOS 8?

    If you have a CentOS 8 server you might have noticed that installing MariaDB directly with the sudo dnf install mariadb-server command does not install the latest stable MariaDB version. Here’s how you could install t...
    Accepted Answer: Before getting started, make sure to follow our Initial Server Setup Guide for CentOS 8 guide: https://www.digitalocean.com/community/tutorials/initial-server-setup-with-centos-8 Also, make sure that you have wget ins...
    1 By bobbyiliev MariaDB MySQL Databases CentOS CentOS 8 Linux Basics Linux Commands
  • Question

    How to configure Laravel 5.7 with Redis TLS (Using phpredis)

    Hi I'm using laravel 5.7 with phpredis (PHP 7.2), but I’m not able to get it to work with tls, I am trying to use it with digitalocean Redis managed database which only supports tls connections. Any idea if tls even s...
    Accepted Answer: So I managed to get this to work, basically the current phpredis version that is shipped with php 7.2 (Ubuntu 18) is old and does not support tls, to fix this I had to update phpredis from pecl (https://pecl.php.net/p...
    2 By ahmadt Redis Databases PHP PHP Frameworks
  • Question

    trying to install mysql but I cannot start the service and cannot locate mysqld.sock

    I'm trying to install mysql but I cannot start the service and cannot locate mysqld.sock I am following the how to here: https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-sta...
    Accepted Answer: Hi there @dezshredder, To me it looks like that your MySQL service is stuck in a crash loop as the status output that you've shared indicates that the status is: "Server startup in progress" and the uptime is 15 secon...
    3 By dezshredder Ubuntu MySQL Ubuntu 18.04 Databases
  • Question

    media files returns 404 not found

    my nginx file looks like: ``` location = /favicon.ico { accesslog off; lognot_found off; } location /static/ { alias /home/me/projectdir/static/; } location /media/ { alias /home/me/projectdir/media/; } locati...
    Accepted Answer: Hi there @elprincipe, Do you see any errors in your Nginx error log? You can check that with the following command: command,bash sudo tail -100 /var/log/nginx/error.log It is quite possible that Nginx does not have t...
    1 By elprincipe Nginx Python PostgreSQL Django Python Frameworks Ubuntu 18.04 Databases
  • 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

    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 upgrade MySQL server, for the one-click app

    Hello, I'm using the PHPMyAdmin one-click app, but the MySQL server version is way behind and I'm not sure how to upgrade it without breaking anything The current version is: mysql Ver 14.14 Distrib 5.7.30, for Lin...
    Accepted Answer: Hi there @Geekologist, With the PHPmyAdmin 1-Click installation, you get MySQL 5.7 and PHPmyAdmin 4.6.6. I believe that if you upgrade your MySQL installation you would need to upgrade PHPmyAdmin to the latest version...
    1 By ThisUser32 PHP MySQL DigitalOcean 1-Click Apps Marketplace Ubuntu Ubuntu 18.04 Databases DigitalOcean
  • Question

    How do I use Digital Ocean to host a mini private game server?

    I am interested in put together a quick game server to test this Unity Asset = MMORPG KIT (2D/3D/Survival) (https://assetstore.unity.com/packages/templates/systems/mmorpg-kit-2d-3d-survival-110188) Based on the tip f...
    Accepted Answer: Hey @TeachMeGameServer, You are a lucky man! In their documentation, there is a section specifically for DigitalOcean. Take a look and let me know if that was helpful: https://suriyun-production.github.io/mmorpg-kit-d...
    2 By TeachMeGameServer Initial Server Setup Databases
  • Question

    How do I connect to a postgres connection pool with managed databases?

    We have decided to use Postgres and digital oceans managed databases for our next project. This database will handle about 10 million page visits a month, with certain points having spikes in traffic. We created a dat...
    Accepted Answer: To answer my own question, use the pool name to connect instead of the db name. postgresql://{user_name}:{password}@datalab-do-user-6674409-0.b.db.ondigitalocean.com:{pool_port_number}/{<^>pool_name<^>}?sslmode=requ...
    1 By gbland Databases PostgreSQL
  • Question

    Setting up a database server on another droplet in VPC

    Hi. I am currently running database and web server on single droplet, but because of site traffic increase, I am planning to put database on separate droplet with enough RAM, but there are some questions: 1) I want my...
    Accepted Answer: Hi @xrjMaker, It's totally possible what you are aiming for and I believe if the traffic to your application is huge that it's a step in the right direction! Let's start with your questions. Private Networking is a re...
    1 By xrjMaker Scaling Networking Databases
  • Question

    Connection timed out on MySQL Managed Database Cluster

    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