<p>There shouldn't be any reason why you can't.  I think that the issue would be in getting the memory management correct on the host.  The orchestration would be the same.</p>

<p>Here's some resources:</p>

<ul>
<li><p><a href="https://dev.mysql.com/doc/mysql-cluster-excerpt/8.0/en/faqs-mysql-cluster.html#qandaitem-B-1-13" rel="nofollow noreferrer">https://dev.mysql.com/doc/mysql-cluster-excerpt/8.0/en/faqs-mysql-cluster.html#qandaitem-B-1-13</a></p></li>
<li><p><a href="https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-ubuntu-18-04" rel="nofollow noreferrer">https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-ubuntu-18-04</a>.  It shows with docker as well. it shouldn't be hard to apply to vmware or k8s.</p></li>
<li><p><a href="https://towardsdatascience.com/high-availability-mysql-cluster-with-load-balancing-using-haproxy-and-heartbeat-40a16e134691/" rel="nofollow noreferrer">https://towardsdatascience.com/high-availability-mysql-cluster-with-load-balancing-using-haproxy-and-heartbeat-40a16e134691/</a></p></li>
<li><p><a href="https://www.cockroachlabs.com/docs/stable/orchestrate-a-local-cluster-with-kubernetes.html" rel="nofollow noreferrer">https://www.cockroachlabs.com/docs/stable/orchestrate-a-local-cluster-with-kubernetes.html</a> to set up k8s locally.</p></li>
</ul>

CC BY-SA 4.0
2020-04-29T22:49:25.657Z
How is it possible to scale it automatically when it's deployed on VMs, without Kuberentes? Let's say scale up depending on a metric such as CPU usage
jwalker
CC BY-SA 4.0
2020-04-30T19:12:58.330Z
I'm not sure what you use for tools, but I'd use Ansible/Chef/etc. to set up the replication to add or remove slaves as necessary.  Have a role/recipe to spin up a new VM, another to introduce the VM into the cluster and a third to adjust the load-balance to introduce the node.  How this is triggered depends on the monitoring system to detect the load.
Arcege
CC BY-SA 4.0
2020-04-27T00:18:17.940Z
2020-04-27T00:18:17.940Z
Arcege
<p>Is it possible to build a similar solution to managed MySQL cluster on a private cloud (VMware vSphere / Hyper V). Even with Kubernetes.
A solution which supports auto-scaling, auto-upgrade, multi-master and similar to the largest public clouds offerings.</p>

<kubernetes><mysql><vmware>
Managed MySQL cluster - similar solution for a private cloud
jwalker
# Managed MySQL cluster - similar solution for a private cloud

(Asked by: username_0 on 2020-04-25)

Is it possible to build a similar solution to managed MySQL cluster on a private cloud (VMware vSphere / Hyper V). Even with Kubernetes.
A solution which supports auto-scaling, auto-upgrade, multi-master and similar to the largest public clouds offerings.

**Tags:** kubernetes, mysql, vmware


---

## 1 answers

### Answer by username_1 on 2020-04-27. Score: 1

There shouldn't be any reason why you can't. I think that the issue would be in getting the memory management correct on the host. The orchestration would be the same.

Here's some resources:

* <https://dev.mysql.com/doc/mysql-cluster-excerpt/8.0/en/faqs-mysql-cluster.html#qandaitem-B-1-13>
* <https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-ubuntu-18-04>. It shows with docker as well. it shouldn't be hard to apply to vmware or k8s.
* <https://towardsdatascience.com/high-availability-mysql-cluster-with-load-balancing-using-haproxy-and-heartbeat-40a16e134691/>
* <https://www.cockroachlabs.com/docs/stable/orchestrate-a-local-cluster-with-kubernetes.html> to set up k8s locally.

> **Comments:**
> **username_0**: How is it possible to scale it automatically when it's deployed on VMs, without Kuberentes? Let's say scale up depending on a metric such as CPU usage  
> **username_1**: I'm not sure what you use for tools, but I'd use Ansible/Chef/etc. to set up the replication to add or remove slaves as necessary.  Have a role/recipe to spin up a new VM, another to introduce the VM into the cluster and a third to adjust the load-balance to introduce the node.  How this is triggered depends on the monitoring system to detect the load.  

---

