Run and Manage ProxySQL on Kubernetes

Provision, Upgrade, Scaling, Monitor, Security for ProxySQL in Kubernetes on any Public & Private Cloud

 1apiVersion: kubedb.com/v1
 2kind: ProxySQL
 3metadata:
 4  name: proxy-demo
 5  namespace: demo
 6spec:
 7  backend:
 8    name: mysql-group-repl
 9  deletionPolicy: Delete
10  replicas: 3
11  syncUsers: true
12  version: 3.0.1-debian

Run and Manage ProxySQL on Kubernetes

As the world’s enterprises rapidly move to the cloud, and containers are taking over the world of software development, Kubernetes is the platform that lets users seamlessly deploy, scale, run containers, and manage their application life-cycle.

But, running databases and stateful applications in Kubernetes has always been a challenge. And it is really difficult to Run and Manage Production-Grade Databases on Kubernetes. Every Enterprise needs a Production-Grade operator to deploy its databases and manage its life cycle on Kubernetes.

KubeDB is the leader in Kubernetes Native Database Management Solutions which simplifies and automates routine database tasks such as Provisioning, Monitoring, Upgrading, Patching, Scaling, Volume Expansion, Backup & Restore, Failure detection, and Recovery for various popular databases on private and public clouds. KubeDB developed the first-ever Production-Grade Kubernetes operator for ProxySQL to manage its Day-2 operations. KubeDB is a managed DBaaS that allows developers to run their databases alongside the respective application. You can simply deploy ProxySQL on Kubernetes and manage its Day-2 operations via KubeDB ProxySQL Operator.

    Why Choose KubeDB?🤔

  • check-box Provisioning
  • check-box Version Upgrade
  • check-box Scaling
  • check-box Monitoring
  • check-box Security
Run and Manage ProxySQL on Kubernetes
Provisioning

Provisioning

If you can run Kubernetes, you can simply provision ProxySQL using KubeDB. You don’t need to worry about all of the knowledge of Kubernetes Concept, Helm, and ProxySQL server side setup. KubeDB simplifies the whole process for you. You just have to use standard Kubernetes CLI and API to provision ProxySQL .

Version Upgrade

Upgrading the database version in Kubernetes is complicated. Upgrade operation should follow a specific order. KubeDB allows you to upgrade your running ProxySQL version without any downtime. You can upgrade your database to any major or minor update of the ProxySQL version.

Version Upgrade
Scaling

Scaling

To improve your database performance you have to make sure that your database is scalable. KubeDB offers both Vertical and Horizontal Scaling of ProxySQL in Kubernetes. You can simply scale your ProxySQL cluster in Kubernetes using KubeDB.

Monitoring

KubeDB comes with native support for monitoring via Prometheus. You can use builtin Prometheus scrapper or CoreOS Prometheus Operator to monitor your ProxySQL in Kubernetes. You can use the Grafana to view key operational metrics, including compute/memory/storage capacity utilization, I/O activity, and instance connections.

Monitoring
Security

Security

To secure a database your data needs to go through a cryptographic protocol that provides end-to-end security of the data transmission over the network. You can secure your ProxySQL with TLS using KubeDB. Also, KubeDB allows you to use encrypted storage for your databases using keys you manage through your cloud provider’s key management service.