Operations | Monitoring | ITSM | DevOps | Cloud

How Do MySQL Indexes Work? An In-Depth Tutorial on Creating Clustered and Secondary Indexes and The Effect on Database Performance

MySQL is the most used database in the world. And as it continues to grow in popularity as an open-source database system for developers, understanding how these indexes work is an important step for database developers and administrators. This tutorial is going to explore clustered indexes and secondary indexes in MySQL. MySQL also has other types of indexes besides the B-tree indexes I’ll be discussing, such as fulltext indexes and hash indexes.

The Roblox Outage

Just before Halloween 2021, Roblox engineers experienced a horror story: a service outage that also took down critical monitoring systems. It seemed like the issue was a hardware problem, but it wasn’t. Users were frustrated, and the clock was ticking. After three full days of downtime, service was finally restored on Halloween day. While the incident itself was an IT nightmare, Roblox’s detailed technical post-mortem several months later was an excellent way to bounce back.

Bring Efficiency to Log Management in DigitalOcean

The ongoing partnership between Papertrail and DigitalOcean led to the development of the Papertrail software as a service (SaaS) add-on in the DigitalOcean Marketplace. With the add-on, developers can add powerful, simple, and scalable Papertrail log management to their DigitalOcean infrastructure in seconds. In two earlier posts, we reviewed how the add-on helps teams simplify and centralize log management.

How Businesses Are Benefiting from Hybrid Cloud Infrastructures

Side by side with the popularity of hyperscale public cloud providers such as AWS and Microsoft Azure, many organizations maintain on-premises data centers. Organizations may keep them for mission-critical legacy systems with performance demands the cloud cannot meet, or simply be in transition and have not yet migrated their infrastructure to the cloud.

A Simplified Introduction to Azure Database for PostgreSQL Flexible Server

I find it amazing how much opportunity and flexibility cloud environments are creating for organizations of all sizes. I’m seeing more and more companies experimenting with open-source software (OSS) relational database systems, which years ago would’ve been too complicated for the customer to set up. With Azure, you can spin up OSS systems like MySQL or PostgreSQL quickly to determine if the engine fits their needs. If it does, you can continue development on it.

Everything You Need to Know About SolarWinds Observability-Our Transformational Subscription Service

Transformation is key to being at the forefront of the tech industry, and over the past two years, I’ve been excited to lead an outstanding team of developers and engineers as we’ve embarked on evolving our monitoring tools toward observability. With this in mind, we’re excited to announce two significant product releases today. The first is a completely new product offering and subscription service we call SolarWinds® Observability.

It's Time to Rethink Observability and Rethink SolarWinds

Everyone in the information technology industry understands “change” is guaranteed. People are creative and constantly striving to find more efficient ways to solve problems and more innovative ways to deliver services to consumers. But keeping up with the constant cloud and internet technology shifts and taking advantage of all the new capabilities is a harrowing task for digital organizations.

Container Observability

In the recent past, container-based deployment architectures have played a significant role in improving applications on multiple fronts, including: Containers are all-inclusive packages containing lightweight services which are easy to spawn and terminate. However, container-based deployments can comprise hundreds of individual services and their replicas spinning up and down at any moment.

What To Know About Microsoft Azure PostgreSQL Hyperscale

As organizations adopt cloud technologies and modernize their applications, the data they generate and ingest often grows exponentially, leaving them with difficult choices for storing and using this data. Customers are beginning to explore moving away from traditional relational database management systems (RDBMS) because of the data volume to be ingested, as these RDBMS often cannot handle workloads.