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


MongoDB and Tardigrade are excited to collaborate and demonstrate managing data backups and migrations across multiple computing and storage platforms with enterprise security and SLAs.

  • mongodb.com

Do you have an app on Heroku using Postgres? Are you running out of database connections? In this article, we'll look at how to use PgBouncer to scale your app.

  • dzone.com
  • Michael Bogan

Replication lag is an inevitable occurrence for multi-cloud database deployments, as it causes delays of transactions to reflect into the target node or cluster.

  • severalnines.com
  • Paul Namuag

Developing on your Mac? Get the latest stable MariaDB version set up on OS X easily with Homebrew. See this step by step guide on installing MariaDB 10.1.16.

  • mariadb.com
  • Ben Stillman

Prometheus 2.19 is good to go. The new version picks up where it left off, further improving the monitoring system’s storage layer TSDB amongst other things.

  • devclass.com
  • Julia Schmidt

This article explores the process to stop an AWS RDS SQL Server using web console and AWS CLI. AWS RDS provides managed database instances for SQL Server, Oracle, MySQL, MariaDB and PostgreSQL. You can easily create, configure and manage the AWS RDS SQL Server.

  • sqlshack.com
  • Rajendra Gupta

In early 2018, I had a conversation with some of my leadership team about what we could build to address our client’s most pressing needs. We knew data was growing at an exponential rate, and analytics were critical.

  • ibmbigdatahub.com
  • Dinesh Nirmal

Hi everybody. Today we will see how to put a job in dummy mode on the monitoring part.

  • blog.dbi-services.com
  • Nabil Saoual

In this blog post, we will discuss how to deal with jumbo chunks in MongoDB. Scenario: You are a MongoDB DBA, and your first task of the day is to remove a shard from your cluster. It sounds scary at first, but you know it is pretty easy. You can do it with a simple command:

  • percona.com
  • Miguel Angel Nieto

In this webinar, Sveta Smirnova, MySQL Engineer at Percona, will uncover nuances of Percona XtraDB Cluster (PXC) schema upgrades and point out details you need to give extra attention to. Percona XtraDB Cluster (PXC) is a 100% synchronized cluster in regards to DML operations.

  • percona.com
  • David Quilty

Just recently, I have been asked to look into what a Disaster Recovery site for InnoDB Cluster would look like. If you’re reading this, then I assume you’re familiar with what MySQL InnoDB Cluster is, and how it is configured, components, etc.

  • mysqlmed.wordpress.com
  • Keith Hollman

Using a multi-cloud or multi-datacenter environment is useful for geo-distributed topologies or even for a disaster recovery plan, and actually, it is becoming more popular nowadays, therefore the concept of split-brain is also becoming more important as the risk of having it increase in this kind o

  • severalnines.com
  • Sebastian Insausti

Alexander Diab demonstrates how a team of developers can work on and test features in different branches of a SQL Server database development project, while their local development database automatically remains 'synchronized' with the current branch in version control.

  • red-gate.com
  • ANTS Performance Profiler

Greetings to all Scylla and Big Data aficionados! Today, we have a special treat for you. We know you’re also all fans of Apache Parquet for storing columnar data in data lakes.

  • scylladb.com
  • Itamar Ravid

MySQL powers all the major internet properties, Which include Google, Facebook, Twitter, LinkedIn, Uber etc.

  • minervadb.com
  • Facebook

There is a common belief that any application, like anything in the real world, is not ideal and there is always something to develop, make it better, and more competitive.

  • mssqltips.com
  • Sergey Gigoyan

11th Jun 2020

HTAP, or hybrid transaction/analytics processing, combines transactions and analytics, providing speed and simplicity, while greatly reducing cost.

  • memsql.com

Join our Online Conference in September! In three different time zones, we will meet users of MariaDB Server for two packed days of presentations, interactions and insights. The Call for Papers is open.

  • mariadb.org
  • Kaj Arnö

After many weeks of designing, implementing, and testing we are happy to announce that all the exciting features are now in place for ArangoDB 3.7. We are proud to share a 3.7 Beta 1 preview release, which provides an opportunity for you to try out all upcoming features before the final release.

  • arangodb.com
  • Joerg Schad

In the real-world implementation of SQL Server of an enterprise system, it always needs to implement data in multiple databases. In most of the cases, a single transaction will span across multiple databases.

  • sqlshack.com
  • Dinesh Asanka

This article gives you an overview of Unique Constraints in SQL and also the Unique SQL Server index. Along the way, we will look at the differences between them. Constraints in SQL Server allows defining the rules at the column level in the SQL table.

  • sqlshack.com
  • Rajendra Gupta

In Part 1 and Part 2 of this series, I covered the logical, or conceptual, aspects of named table expressions in general, and derived tables specifically. This month and the next I’m going to cover the physical processing aspects of derived tables.

  • sqlperformance.com
  • Itzik Ben-Gan

The orchestration war is over (at least for now) but the battle to move all of our apps into Kubernetes has just begun. While K8S has been historically great for stateless apps and services, what about state and more importantly, the database?

  • cockroachlabs.com

The MemSQL Spark Connector 3.0 offers tight integration and SQL pushdown between Spark & MemSQL; use it for "big data processing," AI, and machine learning.

  • memsql.com

. In this series of small examples on recent features, I have imported in a previous post, the statistics of covid-19 per day and per countries.

  • blog.dbi-services.com
  • Franck Pachot

Got multiple AWS data sources in the same S3 bucket but struggle with efficient SNS notifications based on prefix wildcards? Well, struggle no more, we’ve got your back. Many of our customers have a centralised S3 Bucket for log collection for multiple sources and accounts.

  • splunk.com
  • Paul Davies

Editor’s Note: This presentation was given by Christian Tsambikakis, Manager Director at KERBEROS Compliance, Julian Schibberges, Managing Director at Bernstein Group, and Axel Morgner, Co-Founder and CEO and Structr, at GraphConnect New York in September 2018.

  • neo4j.com
  • Christian Tsambikakis

In February, we had the opportunity to join hundreds of other enthusiasts and professionals in attendance this February at the GraphQL Asia 2020 conference. It's been five years since Dgraph started, and we felt this was the perfect time to look back at our journey and share the Dgraph story.

  • dgraph.io
  • Daniel Mai

Are you currently using Flux with InfluxDB? Have you written a great Flux function that would be useful to the community? If the answers to these questions are “Yes!”, then I encourage you to contribute your awesome work to Flux, so that others can appreciate you and your work.

  • influxdata.com
  • Anais Dotis-Georgiou

Logs provide a wealth of information that is invaluable for use cases like root cause analysis and audits. However, you typically don’t need to view the granular details of every log, particularly in dynamic environments that generate large volumes of them.

  • datadoghq.com
  • Datadog