Skip to content

Eclipsys Blog: MySQL

-->

Latest Posts

SQL Server Always On Across Two Data Centers with Dual Witnesses and DNS CNAME – Part 1

Introduction In our existing SQL Server Always On configuration, we had a two-node setup, with each node hosted in a separate data center, and a single witness located in the..

Read More

Inside Eclipsys Managed Services: How DBAs Optimize Multi-Platform Environments

In today’s fast-paced IT landscape, managing databases isn’t just about keeping them online—it’s about ensuring performance, availability, security, and scalability across a wide..

Read More

How to enable SSL on MySQL Source and Replica

The procedure below outlines the steps to configure SSL on both the MySQL source and replica. Before generating a Certificate Authority (CA) certificate, confirm whether an..

Read More

ZDM Troubleshooting Part 1: VM Causes ZDM Service to Crash (Plus fix)

The Introduction Zero Downtime Migration (ZDM) is the ultimate solution to migrate your Oracle database to Oracle Cloud. I recently started using it quite a lot. On-Prem to..

Read More

Oracle Database 23ai: SQL Firewall – Part 1: Intergrate SQL-Firewall with Data-Safe

Introduction We live in the data era, where every organization invests significant resources in securing its IT infrastructure. Protecting data is crucial because modern..

Read More

Restore a Database in the MS SQL Server Always On Availability Group

Prerequisites 1. Backup File: Ensure you have a valid full backup of the database you want to restore. I used AdventureWorks2019.bak for my test. 2. Availability Group..

Read More

Encrypt an Existing MS SQL Server 2019 Database in always on Environment using TDE

Transparent Data Encryption (TDE) Transparent Data Encryption (TDE) in SQL Server protects data at rest by encrypting database data and log files on disk. It works transparently..

Read More