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

Join Peter Zaitsev, Percona CEO, as he discusses MySQL 8 Observability. Broken MySQL means broken application, so maintaining insights in MySQL operational performance is critical.

  • percona.com
  • David Quilty

The MongoDB Database Tools are a collection of command-line utilities for working with a MongoDB deployment. These include, among other things: mongodump, mongorestore, mongoimport, and mongoexport. For a long time now, the tools have been bundled into each MongoDB Server release.

  • mongodb.com

In this article, I am going to explain how we can configure the iSCSI initiator and use it to connect to the iSCSI virtual disk on the target server. The iSCSI initiator (Internet small computer system interface) is used to connect to the iSCSI based external storage.

  • sqlshack.com
  • Nisarg Upadhyay

Db2 Offering team organized a Db2 webinar series on various topics. This series was open to all and we received overwhelming participation from you. Since we could not cover all the time-zones, we recorded the webinars to make them available to you.

  • mailchi.mp

In recent weeks I've been re-learning Go, looking for similarities with existing Java libraries. Naturally, I went on a search for storing and retrieving data from an Oracle database. There are no shortages of options in the Java space for interacting with data stored in a database.

  • blogs.oracle.com
  • Andres Almiray

MySQL has multiple mutex implementations viz. wrapper over pthread, futex based, Spin-Lock based (EventMutex). All of them have their own pros and cons but since long MySQL defaulted to EventMutex as it has been found to be optimal for MySQL use-cases.

  • mysqlonarm.github.io
  • Freepik

The fleet management industry has been quick to embrace technology. They want to understand the current state of vehicles and drivers to improve operations and safety. Data privacy laws are especially important as fleet managers expand their reach into new territories.

  • influxdata.com
  • Caitlin Croft

Every great data-driven product starts with a series of questions. What problem are we trying to solve? Who is our target user? How are we going to measure success? Building a great search experience is no different.

  • elastic.co
  • Josh Devins

Index builds on MongoDB production clusters need to be handled with the utmost care. We have documented the issues in detail in one of  our previous blog posts – The Perils of Building Indexes on MongoDB.

  • dzone.com

PostgreSQL has become the preferred open-source relational database for many enterprise developers and startups, and powers leading business and mobile applications.

  • aws.amazon.com

Late last year I told you about AWS Outposts and invited you to Order Yours Today.

  • aws.amazon.com
  • Jeff Barr

Overview of N1QL (SQL for JSON) support for full text search in Couchbase. (With SQL) Your app is sitting on a Ferrari-style compute engine. — Lukas Eder Over time, the database industry has realized text search and SQL are two sides of the same coin.

  • dzone.com
  • Keshav Murthy

When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed of MySQL.  Below are some of the most important of these settings to help you get started. The first thing to look at is what swappiness is set to.

  • percona.com
  • Michael Patrick

Cloud Native PostgreSQL and Cloud Native BDR are the two Kubernetes operators written by 2ndQuadrant entirely from scratch in the Go language and relying exclusively on the Kubernetes API. The reason behind this choice stands on an important 3-word concept: Immutable Application Containers.

  • 2ndquadrant.com
  • Gabriele Bartolini

This month, 15 community folks contributed code – I think that’s an all-time high for a single month’s release! Good work, y’all. Thanks for payin’ it forward. The bad news is that they’re almost all bug fixes, hahaha.

  • brentozar.com
  • Brent Ozar

In this article, we will review how to set up multi-subnet Always On Availability groups using AWS EC2 instances and AWS FSx as file share witness. Let’s go over these steps one by one.

  • sqlshack.com
  • Jignesh Raiyani

It’s release roundup time here at Percona! Our Release Roundups showcase the latest software updates, tools, and features to help you manage and deploy our software, with highlights and critical information, as well as links to the full release notes and direct links to the software or service its

  • percona.com
  • David Quilty

Why would I be concerned with prepared statements? Wouldn’t sql_batch_completed and rpc_completed cover us? Well, no. What happens when you use sp_prepare? What happens when you’re using an ORM tool that’s using prepared statements? You may see queries that look like this:

  • scarydba.com
  • Grant Fritchey

“What we really want to do is transform Oracle’s market,” Cockroach Labs co-founder and CEO Spencer Kimball told me in a recent interview. It was part of his explanation for why Cockroach Labs chose to build a relational database system in the middle of the cloud computing era.

  • thenewstack.io
  • Richard MacManus

6th Jul 2020

Our Data Parsing Wizard allows you to define your own custom parsing method for your logs using an easy to use dedicated wizard. Follow these 4 steps in order to start parsing your data today.

  • logz.io

Deadlocks is a topic covered many times and with a lot of articles on the web, also from Percona. I suggest you review the reference section for articles on how to identify Deadlocks and from where they are generated.

  • tusacentral.com
  • Marco Tusa

Data is both our most valuable asset and our biggest ongoing challenge. As data grows in volume, variety and complexity, across applications, clouds and siloed systems, traditional ways of working with data no longer work.

  • neo4j.com
  • Navneet Mathur

In today’s video we’ll give a quick demonstration of deploying an APEX application using the SQLcl implementation of Liquibase. I Know what you’re thinking. Didn’t I do this video two weeks ago? The answer is yes and no.

  • oracle-base.com
  • Tim...

PG13; not to be confused with PG-13, only PostgreSQL Guidance required here! PostgreSQL Beta 1 was released on May 21, 2020 and Beta 2 on June 25, 2020. A beta might not be bug free, but it almost always includes all core features of the full release. PG betas are no different.

  • highgo.ca
  • Hamid Akhtar

I frequently get requests to refresh a test / dev SQL Server database and need a way to test database backups from the latest full backup of a production database.

  • mssqltips.com
  • Joe Gavin

The Data Scientist and Data Analyst roles are critical for organizations looking to extract insight from information assets from any kind of structured or un-structured data.

  • mssqltips.com
  • Matteo Lorini

Containers continue to revolutionize enterprise architectures. Although there are many benefits of using this technology, many DBAs shy away from it. Perhaps because it’s a foreign technology, or simply because they don’t understand its applications.

  • sqlservercentral.com
  • Contributors

. I’ll reference Alex DeBrie article “SQL, NoSQL, and Scale: How DynamoDB scales where relational databases don’t“, especially the paragraph about “Why relational databases don’t scale”.

  • blog.dbi-services.com
  • Franck Pachot

The agenda of this blog is simple. We’ll discuss various parameters that we keep in mind while deciding a perfect database for our Application Service. In terms of data engineering, data pressure is the ability of the system to process the amount of data at a reasonable cost or a reasonable time.

  • dev.to
  • OM

The Percona Kubernetes Operator for Percona XtraDB Cluster(PXC) comes with ProxySQL as part of the deal. And to be honest, the behavior of ProxySQL is pretty much the same as in a regular non-k8s deployment of it.

  • percona.com
  • Daniel Guzmán Burgos