DBplatz - Database News. Read our handpicked database-related articles. Where all databases are welcome. SQL and NoSQL. Windows, Linux and MacOS. #useThemAll


This document will cover procedures for low disk space alert on OS/C: drives as well as general disk space low alert. Low disk space can have potentially negative consequences with a server. Some examples are:

  • virtual-dba.com
  • Frank Leonetti

In fairness, it’s really only 8 lines of code, but @krisrice is a fan of comments. I have a query I want to run, where I can dump out a BLOB column in my table to separate files. And I need to automate this.

  • thatjeffsmith.com
  • thatjeffsmith

In this blog, I will look at the tool binlog2sql, designed by Cao Danfeng. The tool will help to decode the MySQL binary logs and extract the raw SQL, which also helps to generate the ROLLBACK statements for point in time recovery (PITR) using the “flashback” feature.

  • percona.com
  • Sri Sakthivel

Just about six years ago to the day Docker hit the first milestone for Docker Compose, a simple way to layout your containers and their connections. A talks to B, B talks to C, and C is a database. Fast forward six years and the container ecosystem has become complex.

  • docker.com
  • Chad Metcalf

ProxySQL Firewall Overview ProxySQL’s flexible query rules engine has many uses, from Read/Write splitting, sharding and even creating firewall blacklist. This allows ProxySQL to be loved by both Performance and Security-minded engineers. Starting in ProxySQL 2.0.

  • proxysql.com
  • Derek Downey

You got yourself a Kubernetes cluster and are now testing our Percona Kubernetes Operator for Percona XtraDB Cluster. Everything is working great and you decided that you want to increase the number of Percona XtraDB Cluster (PXC) pods from the default 3, to let’s say, 5 pods.

  • percona.com
  • Daniel Guzmán Burgos

The post How SHA-2 Works Step-By-Step (SHA-256) appeared first on Qvault. SHA-2 (Secure Hash Algorithm 2), of which SHA-256 is a part, is one of the most popular hashing algorithms out there.

  • dev.to
  • Lane Wagner

A new release of InfluxDB 2.0 Beta is available now. We will be shipping regular updates as we add new features and fix issues. Please keep in mind that these beta builds are not meant for testing performance or production usage.

  • influxdata.com
  • Russ Savage

Dear SQL DBA is back! Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss why learning a VCS is necessary for DBAs, then give three tips on scoping your project, choosing the right tools, and making sure the project is successful.

  • littlekendra.com

This article gives an insight into the terms in the Git repository of Azure Data Studio. In the previous articles, we learned the following things: As you know, Git provides a version control system to track changes in your scripts.

  • sqlshack.com
  • Rajendra Gupta

In our recent Newsletter, Eero Teerikorpi, Founder and CEO, introduced our plans to some significant changes that we are making to adjust the terminology used in our product and in our communications. An excerpt of Eero’s message is below:

  • continuent.com

In any MySQL replication or migration, generally, we’ll skip the mysql database from the dump file. Since it has the current server’s settings, users, etc. So we should not create a mess on the target server with this source mysql database dump.

  • thedataguy.in
  • Bhuvanesh

The closure of schools has called attention to the digital divide, which sees poorer families struggling or unable to access education*. The coronavirus pandemic didn’t cause this divide, but it has highlighted it and its impact on many people in our society.

  • raspberrypi.org
  • Olympia Brown

SQL Server Integration Services is Microsoft’s powerful platform for implementing Extract, Transform and Load (ETL) solutions. It allows SQL Server Professionals to solve complex business intelligence tasks and work with a wide range of data sources.

  • mssqltips.com
  • Sergey Gigoyan

Use the world’s most popular open source monitoring and troubleshooting technologies as a service on the cloud. Scalability, availability and security assured. Use a unified solution for monitoring, troubleshooting and security. Logz.

  • Logz.io

Come and get it! What’s new?

  • thatjeffsmith.com
  • thatjeffsmith

Given Netflix’s scale and emphasis on data-driven decision making, we invest heavily in our data infrastructure which is composed of dozens of data platforms, hundreds of data producers and consumers, and petabytes of data.

  • netflixtechblog.com
  • Netflix Technology Blog

8th Jul 2020

The ScyllaDB team announces the release of Scylla Manager 2.1.1, a production-ready Scylla Manager patch release of the stable Scylla Manager 2.1 branch. As always, Scylla Manager customers and users are encouraged to upgrade to Scylla 2.1.1 in coordination with the Scylla support team.

  • scylladb.com
  • Tzach Livyatan

MariaDB Cluster consists of MariaDB Server with Galera Cluster and MariaDB MaxScale. As a multi-master replication solution, any MariaDB Server with Galera Cluster can operate as a primary server.

  • severalnines.com
  • Ashraf Sharif

Building on the success of Oracle’s Exadata Cloud@Customer service over the last three years, Oracle announced the availability of Oracle Autonomous Database on Exadata Cloud@Customer.

  • oracle.com

In this article, take a look at using Docker network to take advantage of container isolation features. We very often use a container for the deployment of a microservices application/java app.

  • dzone.com
  • Alok Ranjan Meher

Get a cheatsheet full of ways to improve your database ingest (INSERT) performance and speed up your time-series queries using PostgreSQL. Ingest performance is critical for many common PostgreSQL use cases, including application monitoring, application analytics, IoT monitoring, and more.

  • dzone.com
  • Mike Freedman

We are excited to announce that DigitalOcean Managed Databases now supports PostgreSQL 12! PostgreSQL is arguably the world’s most advanced open source relational database, and it has been the bedrock of numerous applications for the past few decades.

  • digitalocean.com
  • André Bearfield

In this on-demand webinar, you’ll first learn which threat each of the subsystems addresses. Second, you’ll learn which parts probably differ, by convention, to other databases you know.

  • percona.com
  • David Quilty

Software development and delivery is an ever-changing landscape. Writing software was once an art form all its own, where you could write and deploy machine code with singleness of purpose and no concern for things like connecting to other computers.

  • elastic.co
  • Woody Walton

Ever wanted to extend MySQL and add some feature you think it is missing?  With MySQL plugins, you can do exactly that.  One thing that has bothered me for several years is that you cannot easily retrieve system metrics from within MySQL.

  • percona.com
  • Michael Patrick

You can do so much with slicing and indexing in Python! Here are some of my favorite tricks: If you have a list say animals = ['cat', 'dog', 'squirrel','mouse','dolphin'] and you want to grab the last value you could use animals[len(animals - 1)].

  • dev.to

A vulnerability has been discovered in F5 BIG-IP Traffic Management User Interface (TMUI), which could allow for remote code execution. F5's BIG-IP is a family of products covering software and hardware designed around application availability, access control, and security solutions.

  • cisecurity.org

Prescriptive guidance for Check Point Firewall, provides prescriptive guidance for establishing a secure configuration posture for Check Point Firewall versions R75.x – 80.x installed on Gaia Platform. The guide was tested against Check Point R80.10 installed on Gaia.

  • cisecurity.org

Visual Studio Code is a popular text editor or code editor to write queries and codes for developers. It is popularly known as VS code. It can highlight and format the code for quick development and understanding purposes.

  • sqlshack.com
  • Rajendra Gupta