Introduction In DevOps, upgrades are rarely exciting. They don’t ship new features (most of the time). They don’t impress clients. They don’t always get leadership applause. And yet, over the years at To The New, one thing has become very clear to us: DevOps teams that do upgrades regularly move faster, stay safer, and break […]
Introduction Elasticsearch has become a go-to choice for building fast, intelligent search experiences. But what if your source of truth is a relational database like MySQL? In this blog, we’ll walk through how we migrated structured relational data into Elasticsearch using Python — with company_registry as a working example. Why Migrate from MySQL to Elasticsearch? […]
Introduction In today’s rapidly evolving technological landscape, database management has become more complex yet essential for ensuring high availability, scalability, and resilience. One of the most effective ways to manage MySQL databases in a cloud-native environment is by integrating InnoDB Cluster with Kubernetes and containers. This integration leverages MySQL Group Replication and MySQL Router to […]
Performance Tuning As our data grows in the database, it is always important to view database insights. We’ve been using some complex queries to solve difficult problems without checking how they affect the server performance. It’s always preferred to frequently visit the performance schema. USE performance_schema; Where to Begin With We want to boost cluster […]
Introduction In the realm of MySQL databases, fragmentation can significantly impact performance and efficiency. This blog will delve into what fragmentation is, how it occurs, how to identify it, and methods to defragment your MySQL tables. What is Fragmentation in MySQL? Fragmentation in MySQL refers to the inefficient use of disk space within database tables, […]
Introduction Nowadays, MySQL is among the most popular and beloved databases for applications. But, managing and designing is a crucial and important task when selecting a database for your application. Let’s dig into what are the best practices to manage the database. MySQL Best Practices: Schema Design Indexing Performance Optimization Backup and Recovery Security Schema […]
Introduction MySQL is one of the most popular open-supply relational databases. As your application’s statistics grow, MySQL’s performance may be impacted by different factors, including database design, server configuration, and query performance. In this blog, we can talk about the various components of MySQL’s overall performance tuning and explore common situations to help you to […]
Java/JVMSoftware developmentTechnology
Introduction to Common Table Expression (CTE) in MySQL? A Common Table Expression (CTE) is a temporary named result set that is defined within the scope of a single SQL query. It allows you to write complex queries in a more readable and maintainable manner, by breaking them down into smaller, logical steps. CTEs can be […]
The conveyance of data from many sources to a storage medium where it may be accessed, utilized, and analyzed by an organization is known as data ingestion. Typically, the destination is a data warehouse, data mart, database, or document storage. Sources can include RDBMS such as MySQL, Oracle, and Postgres. The data ingestion layer serves […]
