unterstein / dcos-galera Goto Github PK

What is IP and PORT?

and ROOT PASSWORD is wrong.

"MYSQL_ROOT_PASSWORD": "galera"

With the galera cluster running in my DC/OS 1.9 environment, I can connect into the VIP name from the mysql client, and behaviour seems as expected.

However when I try to connect a stock wordpress or drupal7 front end via the VIP, they do not work as expected. In both cases the servers hang up and often don't even pass health check. The variability in how long they operate is curious. I've gotten as far as having drupal7 running, to the point where I can enter a page or two, but not long into usage, it hangs up and I start getting bad gateway/timeout messages in the browser - and the service instance goes red. With wordpress I can't get past the first page of the install. In the brief instances where things worked, they were very slow in comparison to the non-galera test.

I tested the same wordpress configuration against a single instance mariadb running off the stock mesosphere package, and it worked perfectly, and was quite snappy. All in the same DC/OS cluster. So the VIP appears to work as expected, and the front-end resource provisioning seems fine.

Everything is running in VMware Fusion BTW.

Not sure where to check for logs... front end doesn't produce anything useful, stdout and stderr for both containers show nothing during a hang up. I wonder if the galera cluster is playing nice with minuteman.

service json used for the wordpress-galera configuration:

{
  "id": "/wordpress-galera",
  "cmd": null,
  "cpus": 1,
  "mem": 800,
  "disk": 0,
  "instances": 1,
  "container": {
    "type": "DOCKER",
    "volumes": [],
    "docker": {
      "image": "wordpress",
      "network": "BRIDGE",
      "portMappings": [
        { "hostPort": 0, "containerPort": 80, "servicePort": 10144 },
        { "hostPort": 0, "containerPort": 443, "servicePort": 10145 }
      ],
      "privileged": false,
      "parameters": [],
      "forcePullImage": false
    }
  },
  "env": {
    "WORDPRESS_DB_HOST": "galera.marathon.l4lb.thisdcos.directory:3306",
    "WORDPRESS_DB_USER": "root",
    "WORDPRESS_DB_PASSWORD": "galera",
    "WORDPRESS_DB_NAME": "wordpress"
  },
  "healthChecks": [
    {
      "path": "/",
      "protocol": "HTTP",
      "portIndex": 0,
      "gracePeriodSeconds": 300,
      "intervalSeconds": 60,
      "timeoutSeconds": 20,
      "maxConsecutiveFailures": 3,
      "ignoreHttp1xx": false
    }
  ],
  "labels":{
    "HAPROXY_DEPLOYMENT_GROUP":"wordpress",
    "HAPROXY_DEPLOYMENT_ALT_PORT":"10146",
    "HAPROXY_GROUP":"external",
    "HAPROXY_0_REDIRECT_TO_HTTPS":"false",
    "HAPROXY_0_VHOST": "wordpress.intelligent-design.ca"
  }
}

When I change galera.marathon.l4lb.thisdcos.directory to mariadb.marathon.l4lb.thisdcos.directory (my single instance mariadb), along with the credentials... it works nicely.