Archive for July 2017

Using avahi / mDNS in a Vagrant project

I’m working on a project, with Vagrant and Ansible, to deploy a MongoDB Cluster. I needed name resolution to function between the VirtualBox VMs I was creating and didn’t want to hardcode anything in the hosts file. The solution I decided on uses avahi which essentially works like Apple Bonjour. As this solution has broader […]

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 […]