Today we’re pleased to announce the general availability of InfluxDB Enterprise on Microsoft’s Azure Marketplace. We’ll dive into all of these below, but first, let’s take a step back in case you’re not familiar with time series databases. If you’re looking for a time series database, here are three things to look for.

In today’s post, we’ll learn about Mnesia, see when you would use such a tool, and take a look at some of the pros and cons of using it. After covering the fundamentals of Mnesia, we’ll dive right into a sample application where we’ll build an Elixir application that uses Mnesia as its database. Let’s jump right in!

Elasticsearch and MongoDb are the two most popular distributed datastores used to manage NoSQL data. Both of these technologies are highly scalable and have document-oriented design at the core. There are differences between the two technologies, however, and it’s important to understand these differences in order to choose the right one for your use case. This blog post will examine the differences between these two technologies in a number of critical areas.

In the previous blog in this series, we discussed authentication and authorization mechanisms, and how configuring them properly can help secure your databases. In this blog, we’ll talk about how data breaches can be prevented by implementing the principle of least privilege (POLP). According to Verizon’s 2019 Data Breach Investigations Report, insiders account for 76 percent of all compromised database records.

ProxySQL is a MySQL/MariaDB protocol–compliant load balancer and reverse proxy with native support for a range of popular backends including ClickHouse, Amazon Aurora, and Amazon RDS. ProxySQL efficiently distributes queries to your database servers and caches results, improving resource management and boosting database performance. You can also configure ProxySQL for high availability to reduce downtime.

It’s no secret that organisations have a love-hate relationship with data. Decision making can be unguided and market insights can be lost when organisations collect too little data. On the other hand, with large and active datasets, where requests number in the hundreds of thousands, maintaining database performance is increasingly difficult. One open source application, Apache Cassandra, enables organisations to process large volumes of fast moving data in a reliable and scalable way.

PostgreSQL offers flexibility on how data is stored and compared in a relational database. This is why it’s so popular among enterprises as a solution for their database requirements. Although PostgreSQL is quite reliable, database problems are inevitable, especially in large-scale environments. Ignoring these problems could result in a plunge in the productivity of your business.

If you missed the recent webcast on SQL performance tuning presented by Janis Griffin, you are definitely going to want to watch it on-demand. She packed so much information into 60 minutes, it’s a wonder there weren’t thousands of heads exploding across WebEx – and every nugget of advice was pure gold. Let’s start with Janis’ 30+ year career as a DBA across multiple platforms, especially Oracle and SQL Server. She knows her stuff and knows how to talk about it.