Database Laboratories During the last years, I’ve been working on several open labs for Database trainings and webinars for OnGres and CanalDBA community. Some of these laboratories may look out-of-date, but they should commit their purpose for references and examples on how to setup them with few lines of code and with the most popular technologies. If you are willing to start with Ansible, Terraform, Docker and others for Databases, you may found this resources interesting for you.

Install minikube or similar curl -Lo minikube https://storage.googleapis.com/minikube/releases/v1.2.0/minikube-darwin-amd64 &&\ chmod +x minikube && sudo cp minikube /usr/local/bin/ && rm minikube Getting the token Access Kubernetes API Ansible k8s K8S_AUTH_API_KEY in environment. Getting facts with k8s_fact

Concept In the current concept, we are going to combine Foreign tables inheritance with the postgres_fdw extension, both being already available features since 9.5 version. Cross-node partitioning allows a better data locality and a more scalable model than keeping local partitions. Being said, the data will be split into several nodes and organized using a particular key, which will determine in which shard data will be allocated. For the current POC, we are going to specify the shardKey , which is a simple char(2) type.

Currently binlogtop is in status WIP and very alpha state, although there is a python script doing sort of the same thing is: binlogEventStats. Hey! Replication is delaying, don’t know what’s happening. binlogtop just do a real-time streaming statistics. What has inside? golang If you want to indicate issues, go for it at report issues.

As a DBA we usually have to do dirty things under a running clock. Using that moto, I started a repository to start collecting those nasty things that save time a day. That’s what alambre does: small and complex things. What has inside? bash (preferred) python SQL If you want to indicate issues, go for it at report issues.