A Step by Step Guide to Take your MySQL Instance to the Cloud

You have a MySQL instance? Great. You want to take it to a cloud? Nothing new. You want to do it fast, minimizing downtime / service outage? “I wish” I hear you say. Pull up a chair. Let’s have a chinwag. Given the objective above, i.e.

blogs.oracle.com

14th Sep 2020

SQL Server 2017 Installation Error with KB2919355 – SQLServerCentral

Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for KB2919355.

sqlservercentral.com

14th Sep 2020

ProxySQL participando en ESLibre 2020

ProxySQL participará en la próxima edición del evento open source “ESLIBRE”, que tendrá lugar los días 18th & 19th de Septiembre. La fecha coincidirá con el “Software Freedom Day”, día que celebra el Free Software en el mundo entero.

proxysql.com

13th Sep 2020

How to make your MongoDB container more secure?

By specifying -p 27017:27017, you can access to it with the connection string such as mongodb://localhost:27017 or mongodb://0.0.0.0:27017, as same as installed MongoDB server. This database instance is only available locally.

dev.to

13th Sep 2020

Oracle 20c Data Guard : Standardization of Client-Side Broker Files

Before Oracle 20c, there was no default location for these files. Starting with Oracle 20c, now we can define a default location for all these files by setting an environment variable called DG_ADMIN. This variable should point to a directory.

blog.dbi-services.com

13th Sep 2020

Dockerizing MySQL step by step.

As a Database Engineer in Mydbops. We tend to solve multiple complex problems for our esteemed customers. To control the System resources and scale up /down based on needed we are evaluating Dockers and Kubernetes.

mydbops.wordpress.com

13th Sep 2020

Storing Files in MongoDB with GridFS

Many applications involve file management and have file storage as an important feature for enhancing data processing. File storage often requires a third party CDN (Content Delivery Network), such as Amazon Web services, but this makes the management process a bit tedious.

severalnines.com

13th Sep 2020

Data Consistency for RDS for MySQL: The 8.0 Version

In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency. Starting with 8.0.

A Step by Step Guide to Take your MySQL Instance to the Cloud

SQL Server 2017 Installation Error with KB2919355 – SQLServerCentral

ProxySQL participando en ESLibre 2020

How to make your MongoDB container more secure?

Oracle 20c Data Guard : Standardization of Client-Side Broker Files

Dockerizing MySQL step by step.

Storing Files in MongoDB with GridFS

Data Consistency for RDS for MySQL: The 8.0 Version

How to implement Column and Row level security in PostgreSQL

Operational Database Security – Part 1

How Much Memory Does the Process Really Take on Linux?

Troubleshooting Performance issues Like Microsoft Engineers Part 4

A GSoC internship with the MariaDB Foundation

Informix v11.70 End of Support (EOS)

SQL Server High CPU Query Use Monitoring with PowerShell

AWS Lambda Performance Optimizations

PostgreSQL synchronous_commit Options and Synchronous Standby Replication

Data Migration From JanusGraph to Nebula Graph - Practice at 360 Finance

PostgreSQL Prometheus Adapter - Initial Release

Field Notes: Requirements for Successfully Installing CloudEndure

Index Improvements in PostgreSQL 13

Why We Chose a Distributed SQL Database to Complement MySQL

Computed Column Performance in SQL Server

Building a DevJoke Application with GraphQL

Introducing Slash GraphQL

Getting Started with Sending StatsD Metrics to Telegraf & InfluxDB

Starting with PostgreSQL – for Beginners

Using SQL Server ROLL UP to Get Similar Results of COMPUTE BY