How to Save on AWS RDS MySQL Costs by Instance Right-sizing

Right-sizing database instances is the process of adjusting your database instances’ size to match the workload generated by the application. In most cases, the incentive to right-size your database instances will be to lower the cloud infrastructure’s costs, ideally without compromising on performance. In this post we’ll guide you through how to analyze the instance’s… Continue reading How to Save on AWS RDS MySQL Costs by Instance Right-sizing

EverSQL and GitHub to launch a new partnership for students

We are excited to announce that EverSQL and GitHub have launched a new partnership as a part of the GitHub Student Developer Pack, which offers valuable free software licenses to students. We believe that there's no substitute for hands-on experience. For most students, real-world tools can be cost-prohibitive. That's why partnered with GitHub: to give… Continue reading EverSQL and GitHub to launch a new partnership for students

Visualize and Optimize Slow SQL Queries on Google Cloud SQL

Analyze slow queries from Google Cloud SQL instances The new enhancement for our Chrome extension will allow Google Cloud SQL and EverSQL users to automatically visualize MySQL's slow query log entries directly on the log viewer of Google Stackdriver. No configuration is needed other than configuring your database to actually log slow queries. EverSQL's extension… Continue reading Visualize and Optimize Slow SQL Queries on Google Cloud SQL

Optimize Slow Queries with RDS Performance Insights & EverSQL

In today's tech companies, engineers are expected to know and care more about the database and the performance of their application. To effectively face these challenging requirements, DBA, engineering and DevOps teams need the right tools to monitor, diagnose and resolve performance issues. In this post, I'll demonstrate how one can track down slow SQL… Continue reading Optimize Slow Queries with RDS Performance Insights & EverSQL

MySQL Explain Example – Explaining MySQL EXPLAIN using StackOverflow data

I personally believe that the best way to deliver a complicated message to an audience, is by using a simple example. So in this post, I chose to demonstrate how to obtain insights from MySQL's EXPLAIN output, by using a simple SQL query which fetches data from StackOverflow's publicly available dataset. The EXPLAIN command provides… Continue reading MySQL Explain Example – Explaining MySQL EXPLAIN using StackOverflow data

MariaDB vs MySQL – Comparing MySQL 8.0 with MariaDB 10.3

Introduction The goal of this article is to evaluate and highlight the main similarities and differences between the MySQL Server Database and the MariaDB Server Database. We’ll look into performance aspects, security, main features, and list all aspects which need to be considered before choosing the right database for your requirements. Who is using MySQL… Continue reading MariaDB vs MySQL – Comparing MySQL 8.0 with MariaDB 10.3