3 ms·

We use Amazon RDS and S3. Only applications are run in the cluster.

superuser2 12y ago
Yeah, this seems to be common. CoreOS seems to do a decent job as the application layer for something operating in a larger cloud that provides database and file storage as services, like Amazon or OpenStack. However, I think Docker has the potential to eliminate the need for infrastructure-level "clouds" to be so complex. The basic unit can be the container instead of the instance, so you don't need fancy automated instance management and all that. It'd be nice if you could also obviate the need for the other external services, and just run everything in containers on metal. I was really excited by CoreOS as a way to do this, but it seems to fighting me at every turn. It seems much easer to just wire together the REST APIs of several Ubuntu/CentOS nodes running Docker.
- opendais 12y ago
  I haven't used CoreOS, mainly just watched, but have you tried deploying a Galera cluster at a scale of 5 containers? That is more likely what they'd have in mind than a single MySQL master container.
  - otterley 12y ago
    Who uses Galera successfully? Every DBA I've ever spoken to about it has advised me to avoid it because it's incredibly deadlock-prone.
    - tryphan 12y ago
      I'd like an answer to this as well. Openstack installation guides recommend it for HA.
    - opendais 12y ago
      http://blog.scoutapp.com/articles/2013/09/24/from-mysql-mmm-to-mariadb-galera-cluster-a-high-availability-makeover http://blog.scoutapp.com/articles/2013/09/24/from-mysql-mmm-... That explains how they chose to minimize deadlocks. Yes, if you use it incorrectly and/or for the wrong problem space, you will have issues. It isn't a magical solution to all problems. It is, however, an effective solution for a specific problem space.
    - kraig 12y ago
      I've been using it in our development environment. It locks like crazy. This is after configuring HAProxy to have a primary node which all connections go to. OpenStack seems to be OK with it though, it chugs along without fully breaking down. I'm sure I would see a pretty big performance delta if I ran a benchmark against it with and without Galera.

Yeah, this seems to be common. CoreOS seems to do a decent job as the application layer for something operating in a larger cloud that provides database and file storage as services, like Amazon or OpenStack. However, I think Docker has the potential to eliminate the need for infrastructure-level "clouds" to be so complex. The basic unit can be the container instead of the instance, so you don't need fancy automated instance management and all that. It'd be nice if you could also obviate the need for the other external services, and just run everything in containers on metal. I was really excited by CoreOS as a way to do this, but it seems to fighting me at every turn. It seems much easer to just wire together the REST APIs of several Ubuntu/CentOS nodes running Docker.

opendais 12y ago
I haven't used CoreOS, mainly just watched, but have you tried deploying a Galera cluster at a scale of 5 containers? That is more likely what they'd have in mind than a single MySQL master container.
- otterley 12y ago
  Who uses Galera successfully? Every DBA I've ever spoken to about it has advised me to avoid it because it's incredibly deadlock-prone.
  - tryphan 12y ago
    I'd like an answer to this as well. Openstack installation guides recommend it for HA.
  - opendais 12y ago
    http://blog.scoutapp.com/articles/2013/09/24/from-mysql-mmm-to-mariadb-galera-cluster-a-high-availability-makeover http://blog.scoutapp.com/articles/2013/09/24/from-mysql-mmm-... That explains how they chose to minimize deadlocks. Yes, if you use it incorrectly and/or for the wrong problem space, you will have issues. It isn't a magical solution to all problems. It is, however, an effective solution for a specific problem space.
  - kraig 12y ago
    I've been using it in our development environment. It locks like crazy. This is after configuring HAProxy to have a primary node which all connections go to. OpenStack seems to be OK with it though, it chugs along without fully breaking down. I'm sure I would see a pretty big performance delta if I ran a benchmark against it with and without Galera.