Author: Mysql Unleashed

Uncategorized

Analyzing Amazon RDS Database Workload with Performance Insights

AWS recently announced general availability of Amazon Aurora with PostgreSQL compatibility. With this release, AWS has also included the first release of a useful feature in Amazon Relational Database Service (Amazon RDS) called Performance Insights. Using a dashboard that visualizes database load—along with which SQL statements are causing the load and why—Performance Insights makes detecting …

Miscellaneous

How to architect a hybrid Microsoft SQL Server solution using distributed availability groups

Migrating monolithic mission-critical Microsoft SQL Server databases from on-premises to AWS (that is, to SQL Server based on Amazon EC2) is often a challenging task. The challenge comes mostly from the following: A prolonged downtime window during cutovers that can have an adverse impact on the business Challenges involved in keeping the databases (both on-premises …

Miscellaneous

New to MongoDB Atlas — Live Migrate Sharded Clusters and Deployments Running MongoDB 2.6

Live migration in MongoDB Atlas enables users to import data from MongoDB deployments running in other environments and cut over to a fully managed database service, giving you industry best practice security by default, advanced features to streamline operations and performance optimization, and the latest versions of MongoDB. Today, we’re introducing two new enhancements to …

Clustering

Top PG Clustering HA Solutions for PostgreSQL

If your system relies on PostgreSQL databases and you are looking for clustering solutions for HA, we want to let you know in advance that it is a complex task, but not impossible to achieve. We are going to discussion some solutions, from which you will be able to choose taking into account your requirements …

Miscellaneous

RDBMS Management on macOS

There was a time not so long ago that Database Administrators (DBAs) worked with database servers that were running on their company’s infrastructure, perhaps even nearby on the same floor.  Since the emergence of cloud database services like Amazon Aurora, Google Cloud SQL, and Oracle Database Cloud Service, this arrangement is all but obsolete.  Although …

Miscellaneous

SQL Server Query Execution Plan for beginners – Clustered Index Operators

We have discussed how to created estimated execution plans and actual execution plans in various formats in my previous article SQL Server Query Execution Plan for beginners – Types and Options. In this article we will continue discussing the various execution plan operators related to clustered indexes, and what they do, when do they appear …

Replication

Replication handler error HA_ERR_KEY_NOT_FOUND and Memory Tables In Replication

 Last_SQL_Error: Could not execute <Update/insert/delete>_rows event on table <dbname>.<tablename>; Can’t find record in ‘<tablename>’, Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event’s master log <master binary log file name>, end_log_pos <master log file position> This is one of the error for MySQL Replication when MASTER and SLAVE replica not in sync. The Reason for replication getting …

Software

Adding Custom Graphs and Dashboards to Percona Monitoring and Management

In this blog post, we’ll look at how to create PMM custom graphs and dashboards to track what you need to see in your database. Percona Monitoring and Management (PMM)‘s default set of graphs is pretty complete: it covers most of the stuff a DBA requires to fully visualize database servers. However, sometimes custom information …

Miscellaneous

The Data Charmer: Customizing dbdeployer

As of version 0.2.1, dbdeployer allows users to customize composite sandboxes more than ever. This is done by manipulating the default settings, which are used to deploy the sandbox templates. In order to appreciate the customization capabilities, let’s start with a vanilla deployment, and then we have a look at the possible changes. $ dbdeployer …