Getting the size of MySql databases and tables

Getting the size of MySql databases and tables

Friday, Jan 4, 2019
Getting accurate results about the size and growth of your database tables enabled you to make smart decisions about partitioning and management of storage. I can guarantee that no-one wants to run out of storage on a database server. Show the largest database from a database server This has the assumption that you have access to the root account on the database server. You can normally look inside /var/lib/mysql to get an idea of the overall disk space, however, you will likely get more reliable results from querying the information_schema table inside MySql. ...

Read more
Testing UDP port connections using netcat

Testing UDP port connections using netcat

Wednesday, Dec 5, 2018
Sending messages over the Internet can be fun (we are doing it now). However, testing that connections are correctly established behind a mask of firewalls, load balancers and application servers can be challenging. Netcat offers a simple way to test the sending of messages between two servers and it is already available on the majority of server installs. Using netcat is relatively straightforward. The core thing we are doing here is using both UDP -u and listening -l. ...

Read more
My Most Popular Command Line Commands

My Most Popular Command Line Commands

Tuesday, Sep 4, 2018
What commands do you use most on command line? As a daily (hourly) linux user, I use command line tools for almost everything that I do. Opening files, copying, moving, making connections (ssh), starting containers (docker). But what ones do I use most? Here is a little command to find out for yourself. Find out your top 10: history | awk '{CMD[$2]++;count++;}END { for (a in CMD)print CMD[a] " " CMD[a]/count*100 "% " a;}' | grep -v ". ...

Read more
Build, Test, Store and Distribute Docker Containers with GitLab

Build, Test, Store and Distribute Docker Containers with GitLab

Friday, Mar 2, 2018
The use of Docker containers has exploded (at least within Web Development) and therefore we have a whole bunch of new tools that can be used to manage the DevOps process. However, there are a massive range of tools that can be used to achieve all of these. Be it Git hosting (GitHub, Bitbucket); Continuous Integration and Delivery and Build Tools (Jenkins, CircleCI, Drone); Docker Registry (Docker EE, Quay.io), or a range of other add-on tools, there sometimes seem as many new, great products in the DevOps area as there are Javascript frameworks(! ...

Read more
What I Learnt Building and Selling My First Application

What I Learnt Building and Selling My First Application

Tuesday, Feb 13, 2018
There is a lot of discussion around the amount of money that is inside the tech industry. Although there is money to be made it is not without the trials and tribulations of selling software. This is my story of selling my first application and some of the lessons learnt. Although this was not my first built application, it was the first application that I built without request from clients. ...

Read more
What I Learnt from DockerCon Europe in Copenhagen

What I Learnt from DockerCon Europe in Copenhagen

Sunday, Nov 12, 2017
It has been a while since I returned from DockerCon Europe in Copenhagen, and despite doing a presentation 4 days after arriving home for Docker Cambridge meetup group, I haven’t yet done a blog post for it. However, that is about to change. So, here is my review of DockerCon Europe. Overall, what I love to see in software is passion and ideas around everything. I remember feeling how exciting it was to be involved in a massive open-source project like Drupal in 2011 at DrupalCon London and to me it seems that Docker is around the same stage of growth now (in terms of number of attendees), however, its potential as a software solution is far different to Drupal. ...

Read more
Docker DevTools: Docker as part of your development toolset

Docker DevTools: Docker as part of your development toolset

Wednesday, Jul 26, 2017
The use of tools seems to have exploded in the past few years. Simple web applications take 5 tools just to build and more complex setup are even more prevalent. Add to that that we also end up configuring our tools to better suit our needs and you are faced with a big dependency problem. How do you manage those dependencies? My most recent answer is Docker. It’s not easy for developers and users to use tools Tools were invented to make doing tasks easier. ...

Read more
Tidying Docker Containers and Images without Filling Your Disk Space

Tidying Docker Containers and Images without Filling Your Disk Space

Tuesday, Jun 13, 2017
Docker. You know that I love it. I guess maybe sometimes I love it a little too much because on some of my test servers I have been filling up a lot of GB with new images and containers. All of which hang around indefinitely if you don’t clear them. Add to that if you have a continuous integration pipeline that builds a new container every time you do a commit/push and you have an ever growing disk of redundant Docker containers and images. ...

Read more
Digital: The Stack and The Roles

Digital: The Stack and The Roles

Sunday, Jun 4, 2017
The most recent buzz word around is digital, however, it is often used as a catch all term for almost anything that is related to computers. So, what is the scope of digital and where do different roles exist inside the landscape? Generally speaking, I term digital to be anything that uses the wider Internet, however, that does not mean anything that is networked. So, simply accessing a file server is not using digital services, however, using a web application to access a file server is. ...

Read more
Why Coding Standards? The answer may surprise you.

Why Coding Standards? The answer may surprise you.

Friday, Apr 14, 2017
TL; DR. Coding standards are about more that the code on the screen, in the application. They are about culture, trust and collaboration. Smell and readability. So, coding standards, fun topic eh. Arguing over tabs and spaces (check out Silicon Valley if you haven’t already) for alignment of your code. It may seem like a bit of a petty idea to begin with. However, what I believe is that coding standards should give you better tools as a team to be able to collaborate. ...

Read more