How To Inject an Empty XA Transaction in MySQL

If you are using XA transactions, then you’ve likely run into a few replication issues with the 2PCs (2 Phase Commits). Here is a common error we see in Percona’s Managed Services and a few ways to handle it, including injecting an empty XA transaction.

percona.com

15th Sep 2020

Python 3.9: All You need to know

Python is always evolving with the community needs and it will be most used language in the future. The next version of Python brings a faster release schedule, performance boosts, handy new string functions, dictionary union operators, and more consistent and stable internal APIs.

dev.to

15th Sep 2020

7 Best Practice Tips for PostgreSQL Bulk Data Loading

Sometimes, PostgreSQL databases need to import large quantities of data in a single or a minimal number of steps. This is commonly known as bulk data import where the data source is typically one or more large files. This process can be sometimes unacceptably slow.

2ndquadrant.com

15th Sep 2020

Dynamic Data Unmasking

The SQL Server 2016 dynamic data masking feature may seem like a great way to obfuscate data for downstream systems like dev and QA. Joe Obbish shows us that the data can be “unmasked” with T-SQL statements, so it’s not secure against anyone who can write their own queries.

red-gate.com

15th Sep 2020

Webinar September 29: Learn About Percona Kubernetes Operator for Percona Server for MongoDB

In this webinar, we will explore the Percona Kubernetes Operator for the Percona Server for MongoDB (PSMDB) database. Kubernetes is a widely-deployed orchestration platform for container management.

percona.com

15th Sep 2020

How to parse JSON in SQL Server

In this article, we will learn how to parse and query JSON in SQL Server with the help of the OPENJSON function. Firstly, we will briefly look at the data structure of the JSON and then we will learn details of the parsing and querying JSON data using the OPENJSON function.

sqlshack.com

15th Sep 2020

Testing MySQL Database Service without VPN – part 2

In a recent article, I explained how to test MySQL Database Service (aka MDS) on OCI without having to setup a VPN. So, in this article we will see another way to test or use MDS without VPN but using a more secure option.

lefred.be

15th Sep 2020

Hidden Gems of PostgreSQL 13

PostgreSQL 13 is a lucky release! There are some very impactful new features and the release is coming out at its regularly scheduled time in the fall.

info.crunchydata.com

15th Sep 2020

Can we make GraphQL type safe in code?

This article is part of #ServerlessSeptember (https://aka.ms/ServerlessSeptember2020). You’ll find other helpful articles, detailed tutorials, and videos in this all-things-Serverless content collection.

dev.to

15th Sep 2020

How To Install and Run PostgreSQL using Docker ?

Installing, running and managing postgres in local-machine for development is not difficult anymore. Here is a simple way to get all at one place easily installed and configured within seconds with the help of docker.

dev.to

15th Sep 2020

Fundamentals for Success in Cloud Data Management

Everybody needs more data and more analytics, with so many different and sometimes often conflicting needs. Data engineers need batch resources, while data scientists need to quickly onboard ephemeral users.

blog.cloudera.com

15th Sep 2020

Azure DevOps CI CD using GitHub Repo and Visual Studio Azure SQL Database Project

In my previous article, Deploy SQL Database from Azure DevOps with an ARM Template and DACPAC File, I discussed how to deploy an Azure SQL Database using Azure DevOps CICD.

mssqltips.com

15th Sep 2020

The Share Invalid mechanism of CACHE in PostgreSQL

PostgreSQL will create some catalog and other caches for each connection request to store some queried data locally, which can speed up query efficiency. If a process undergoes a DDL operation that causes catalog to change, other running processes need to be notified that some cache data is invalid.

highgo.ca

15th Sep 2020

Horizontally Scaling the Hive Metastore Database by Migrating From MySQL to TiDB

This post shows how TiDB helps Zhihu eliminate their database bottleneck and horizontally scale their Hive Metastore database to meet the growing business needs.

dzone.com

15th Sep 2020

SQL SERVER – What is Latch?

Earlier I wrote about SQL SERVER – SQLOS Scheduler and the Process States, lots of people liked the blog post and asked me another question – What is Latch? You can find lots of information about the latch online. Even I have previously written about this subject.

blog.sqlauthority.com

15th Sep 2020

How to Run a Software as a Service on Kubernetes

The first version of CockroachCloud, our database-as-a-service product, had our users fill out a Google doc with their cloud deployment preferences. We’ve come a long way since that initial proof of concept (including, yes, building a UI).

cockroachlabs.com

15th Sep 2020

New EC2 T4g Instances – Burstable Performance Powered by AWS Graviton2 – Try Them for Free

Two years ago Amazon Elastic Compute Cloud (EC2) T3 instances were first made available, offering a very cost effective way to run general purpose workloads.

aws.amazon.com

15th Sep 2020

How to Achieve PostgreSQL High Availability with pgBouncer

In the database world, there are many common concepts like High Availability, Failover, and Connection pooling. All of them are useful things to implement on any system, and even a must in some cases.

severalnines.com

15th Sep 2020

Q & A on Webinar “Percona Server for MongoDB Data-at-Rest Encryption”

We really enjoyed presenting Percona Server for MongoDB’s data-at-rest encryption functionality. The webinar was recorded and can be viewed here at any time.

percona.com

15th Sep 2020

Recover Corrupt MySQL Database

UPDATE: We announced online data recovery from corrupt databases. The unDROP for InnoDB tool can be used to recover corrupt MySQL database. In this post we will show how to repair MySQL database if its files became corrupted and even innodb_force_recovery=6 doesn’t help.

twindb.com

14th Sep 2020

Starting SQL: Eager Index Spools

Most of the time when the optimizer thinks an index will make a big enough difference, it’ll tell you. Sure, it’s not perfect, but it can get you where you’re going fast enough. If you’re relying on that sort of feedback in query plans, or in the missing index DMVs, you’ll hate this.

erikdarlingdata.com

14th Sep 2020

DBA in training: Know your environment(s)

It doesn’t matter if you become an “accidental DBA” or are actively looking for a database administrator position, you may need to do some research to find the servers now in your care. In this article, Pamela Mooney provides some advice about what to track down first.

red-gate.com

14th Sep 2020

How to Upgrade to MySQL 8.0 – Free Course at Percona University Online

MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.

percona.com

14th Sep 2020

How to prepare for the Exam DP-300: Administering Relational Databases on Microsoft Azure

In this article, we will show how to prepare yourself for the DP-300 exam: Administering Relational Databases on the Microsoft Azure certificate exam.

sqlshack.com

14th Sep 2020

What is Oracle ASM to Azure IaaS?

Kellyn Pot'Vin-Gorman explains Oracle Automatic Storage Management and why it’s impossible to do a comparison to Azure IaaS. There is a natural desire for us to make sense out of confusion, and Oracle is a topic that confuses many.

red-gate.com

14th Sep 2020

Configure Log Shipping for SQL Server on Linux

We have deployed SQL Server on Linux for our new database application. We want to provide a disaster recovery solution that would allow us to automatically restore backups to a secondary instance. How do I configure SQL Server on Linux to achieve this goal?

mssqltips.com

14th Sep 2020

PostgreSQL 13 and Patroni 2.0 – when parameters change

Starting with PostgreSQL 13 there is a name and value change of one of the parameters used for the streaming replication of a replica server. Some may already know which parameter I am talking about.

blog.dbi-services.com

14th Sep 2020

Video : Instance Caging to Manage CPU Usage

In today’s video we’ll discuss instance caging to manage CPU usage. This can be useful when we are trying to consolidate multiple instances on a single server. This video is based on the following article.

oracle-base.com