I run into this quite a bit. You have an auto incrementing row where you are interested in the last (most recent) entry made for a group of records.
Blog
Building Influx on Ubuntu 20.04
Some quick notes on how to build Influx on Ubuntu. I’ve built a couple of instances of influx in the past for specific projects, usually without any other elements of the TICK stack. Update the system: Get and install repository for Influx. Update repository Install Influxdb Start up influx and enable it as a service… Continue reading Building Influx on Ubuntu 20.04
Using Nginx to reverse proxy for microservices.
It is a pretty common practice for ISP’s to give you a /29 (or charge you). If you have a bunch of microservices running you’ll quickly outlive the usefulness of the /29 and need a way to offer up those sweet, sweet services to people on the outside of your network. I covered setting up… Continue reading Using Nginx to reverse proxy for microservices.
Nginx GeoIp2 configuration and blocking by country
In a previous blog post I detailed the installation and build process for nginx with a geoip2 module. Here I’ll outline a simple setup that will allow blocking by country code for virtual host entries. Add the following to the nginx config. If you followed my previous tutorial it will be located at /usr/local/nginx/conf/nginx.conf. Add… Continue reading Nginx GeoIp2 configuration and blocking by country
Nginx Geoip2 Setup on Ubuntu 20.04
There are lots of tutorials for setting up nginx for GeoIP using Maxmind’s database. The old .dat style database is being depreciated and being replaced with their new format — mmdb. This requires an updated build for nginx using the new GeoIp2 modules. This guide uses Ubuntu 20.04 server though could be adapted to whatever… Continue reading Nginx Geoip2 Setup on Ubuntu 20.04