Official Pythian® Blog
Official Pythian® Blog
Overview In this blog, we aim to discuss the new MySQL 8.0 feature: invisible indexes and how to manage index visibility. MySQL 8.0 supports invisible indexes, that is, indexes not used by the optimizer. This feature applies to indexes other…
Many engineering leaders have challenges with expectations regarding timelines, complexity, level of integration and usability because of what I call the “iPhone conundrum.” The iPhone conundrum is the expectation by technology consumers that new functionality shows up overnight, has high…
From merging domains and transferring accounts to rebranding to data migrations to aligning, there are a lot of steps involved in bringing Google Workspace under one, central umbrella. During a merger or acquisition—when companies are most likely to be doing…
l.e. Which option would you prefer to receive when asked to make many changes throughout a complex system you’re unfamiliar with? “fix this” (many times), or “fix this, which might be better known as a name, most likely by making…
All public clouds offer flexible computing, networking and storage. And you’re likely using at least one public cloud, if not two or more. But if you’re thinking about moving some of your mission-critical applications to the cloud—such as SAP or…
When I started learning Cassandra, I noticed some concepts were not well explained, and it might be helpful for beginners to have information on a single topic in one place. This is how the idea of this blog was born….
The first postcard of 2023 is from a coastal city where Gopi Kampa helps streamline the onboarding process while collaborating with various departments across multiple time zones. Read on to learn more about how this amiable HR coordinator lives and…
Our previous post discussed how data governance is an enabler when implemented early and aligned with data strategy initiatives. The application of data strategy priorities as part of our data governance programs ensures teams can deliver high-quality and trustworthy data….
Overview: It is a general rule of thumb, that the more indexes you have on a table, the slower the INSERTs, UPDATEs, and DELETEs operations become. Indexes in MySQL—or for that matter, any database—are never static. Each time you modify…
Every year, tens of thousands of IT professionals and executives visit Pythian’s blog to tap into our team’s deep expertise and experience. As 2022 comes to a close, we’d like to highlight a few of our reader’s favourites over…
