Archive for the ‘DBA’ Category

Cassandra 3 Node Cluster Setup Notes

Install on each node ?View Code BASHwget http://www-eu.apache.org/dist/cassandra/redhat/30x/cassandra-3.0.13-1.noarch.rpm yum install jre rpm -ivh cassandra-3.0.13-1.noarch.rpm chkconfig cassandra on Configuration changes on each node vi /etc/cassandra/conf/cassandra.yaml Customise the seeds / ip address for your environment cluster_name: ‘cassandra_cluster’ seeds: “192.168.65.120,192.168.65.121,192.168.65.122” listen_address: rpc_address: Start the cassandra service on each node ?View Code BASHservice cassandra start service cassandra status If […]

A Clone of the STRING_SPLIT MSSQL 2016 Function

I have recently been developing some stuff using MSSQL 2016 and used the STRING_SPLIT function. This doesn’t exist in earlier versions and I discovered I would be required to deploy to 2008 or 2012. So here’s a my own version of the STRING_SPLIT function I have developed and tested on MSSQL 2008 (may also work […]

A simple MariaDB deployment with Ansible

Here’s a simple Ansible Playbook to create a basic MariaDB deployment. The basic steps the playbook will attempt are: Install a few libraries Setup Repos Install MariaDB packages Install Percona software Create MariaDB directories Copy my.cnf to server (note this is a template file and not supplied here) Run mysql_install_db if needed Start MariaDB Set […]

A dockerized mongod instance with authentication enabled

Here’s just a quick walkthrough showing how to create a dockerized instance of a standalone MongoDB instance. First, from within a terminal, create a folder to hold the Dockerfile… ?View Code BASHmkdir Docker_MongoDB_Image cd Docker_MongoDB_Image touch Dockerfile Edit the Dockerfile… ?View Code BASHvi Dockerfile Enter the following text. You may wish to modify the file […]

MongoDB: Making the most of a 2 Data-Centre Architecture

There’s a big initiative at my employers to improve the uptime of the services we provide. The goal is 100% uptime as perceived by the customer. There’s obviously a certain level of flexibility one could take in the interpretation of this. I choose to be as strict as I can about this to avoid any […]