Magento – Magento 2 Commerce Cloud accessing DB

magento2magento2-cloud

I am working on a project based on Magento Commerce Cloud.

Can anyone please guide me on how can I access the database of the staging branch?

Thanks!

Best Answer

If your goal is to access it using some type of GUI client, you could accomplish this by opening an ssh tunnel using the magento-cloud utility, similar to the above answer:

magento-cloud tunnel:open --project=<PROJECT_ID> --environment=staging

Then run the command magento-cloud tunnel:info to get the appropriate credentials to input into whatever utility you may be trying to use.

[edited] syntax error on "tunnel:open"

Related Solutions

Magento 2 Commerce Cloud – Database Export Guide

As MSA has noted, you can ssh into the machine and use ece-tools db-dump and then rsync the database dump down locally.Here is the rsync command

 rsync -avzh <SSH URL>:/tmp/<BACKUP NAME> ./

Another option is to utilize the magento-cloud CLI utility. You can download the CLI utility with these instructions: https://devdocs.magento.com/guides/v2.1/cloud/before/before-workspace-magento-prereqs.html#cloud-ssh-cli-cli-install

Once you have that installed you can create a dump like this: magento-cloud db:dump -p <PROJECT ID> -e <ENVIRONMENT NAME>

The `magento-cloud CLI will also allow you to open up an SSH tunnel to the database so you could access it locally.

Magento Cloud – Autodetect Browser Language and Redirect

If you can reliably use the HTTP header "Accept-Language" then there may be two ways of doing it (rely on the HTTP header availability, so please validate the fallback.)

For example:

Accept-Language: en-US,en;q=0.5

Using Fastly Custom VCLs

Fastly provides a way of reading this header, process/filter it and apply custom redirect. https://docs.fastly.com/en/guides/accept-language-header-vcl-features

Using ./magento-vars.php File

PHP provides the ability to parse the HTTP Accept-Language header https://www.php.net/manual/en/locale.acceptfromhttp.php

$locale = locale_accept_from_http($_SERVER['HTTP_ACCEPT_LANGUAGE']);
$locale = Locale::acceptFromHttp($_SERVER['HTTP_ACCEPT_LANGUAGE']);

You may write your own custom logic on ./magento-vars.php and do the necessary redirections. ./magento-vars.php has the visibility to $_SERVER, $_ENV, $_COOKIE etc.

Multi-store setup and sample snippets can be found on this DevDocs link: https://devdocs.magento.com/cloud/project/project-multi-sites.html#modify-magento-variables

For an example:

<?PHP


// enable, adjust and copy this code for each store you run
// Store #0, default one

// ./magento-vars.php

function customStoreLogic()
{
    $storeView = false;
    if (!isset($_SERVER['HTTP_HOST'])) {
        return false;
    }

    $locale = locale_accept_from_http($_SERVER['HTTP_ACCEPT_LANGUAGE']);

    switch ($locale) {
        case "en_US":
            $storeView = 'us_store';
            break;
        default:
            $storeView = 'default';
            break;
    }
    return $storeView;
}

$storeView = customStoreLogic();

if ($storeView) {
    $_SERVER["MAGE_RUN_CODE"] = $storeView;
    $_SERVER["MAGE_RUN_TYPE"] = "store";
}

Hope this helps.