Categories

Vitess – New keyspace and xtrabackup

Last time we ended up with scaling the ‘sbtest’ keyspace up and down. We have also discussed how we can monitor the state of the replication between primary vttablet and replicas. Let’s continue by adding another keyspace to the mix. If you would like to follow our steps you can clone this repository: vitesstests Adding … Continued

Read more...

Vitess – Scaling keyspace up and down

We left our cluster while sysbench was loading the data into the Vitess. This process may take a bit of time, let’s start this blog by discussing what we can do to monitor the status of the process. If you would like to follow our steps you can clone this repository: vitesstests Monitoring the replication … Continued

Read more...

Vitess – deploying a cluster

Let’s just assume we have a clean Kubernetes cluster waiting for pods to show up. Nothing has been deployed so far: root@k8smaster:/vagrant/sbtest_cluster# kubectl get pods,pv,pvc,svc NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE service/kubernetes ClusterIP 10.96.0.1 <none> 443/TCP 21d root@k8smaster:/vagrant/sbtest_cluster# kubectl get nodes NAME STATUS ROLES AGE VERSION k8smaster Ready control-plane,master 21d v1.20.9 k8snode1 Ready <none> 21d … Continued

Read more...

Intro to Vitess

Database landscape changed quite rapidly in the last couple of years. In the past the typical setup that we have seen was the database cluster. It could have been a standard, asynchronous replication-based cluster. It could have been a more cluster-aware solution like Galera. We are mentioning here solutions related to MySQL but this trend … Continued

Read more...