In an ever-evolving technology landscape, understanding the implications of end-of-life and end-of-support dates for database technologies is crucial. When a technology reaches its end of support period, it means vendors cease updates, patches, and technical support, potentially exposing your organization to security risks, increased operational costs, and performance issues.   To help you plan your database upgrade and migration strategies, we’ve put together a list of popular database solutions that are reaching end of life in 2024. Prefer a visual guide to these dates or a printable c ..read more

  Databases are crucial to daily operations, so what happens when the versions you rely on reach their end of support, also known as end of life? Everything from data security issues to costly downtime to a lack of modern features can hold your organization back. Staying informed about database end of support dates is the key to maintaining data security, compliance, and performance. Key Database End of Life Dates in 2023 Many database technologies have end of life dates slated in 2023 or have recently passed in 2022. These include: Oracle 11g and 12c: December 2023 MySQL 5.7: Octobe ..read more

The post Preventing and Addressing DBA Burnout appeared first on Datavail ..read more

  Data Summit 2023 was filled with thought-provoking sessions and presentations that explored the ever-evolving world of data. From the technical possibilities and challenges of new and emerging technologies to using Big Data for business intelligence, analytics, and other business strategies, this event had something for everyone. I’ll recap our presentations and everything else the Datavail team learned at Data Summit 2023. About Data Summit 2023 Data Summit 2023, held in Boston, MA, May 9-11, had the overarching theme of “Unlocking the Power of Your Data.” It featured keynote sess ..read more

If you asked me back in 2008 which database to use for a given use case, I would have said pick SQL Server, Oracle, or MySQL. That was the answer back then. These days, we start by thinking outside of the relational box to ask, “Is it the right database?”   At Data Summit 2023 in Boston, MA, I presented during the Latest Trends in Database Cloud Modernization track. My presentation, “Are You Picking the Right Database?,” covered the latest trends in database modernization, and I detailed tips and best practices around choosing the right database for your modern application needs. Here ar ..read more

The post From DBA to Data Engineer appeared first on Datavail ..read more

Now that we’ve covered what Pacemaker is and why it’s an excellent solution for IBM Db2 HA/DR in the cloud in Part 1 of this blog post, it’s time to talk about how to set it up. This example demonstrates the Pacemaker deployment process on AWS using overlay IP. How to Set Up IBM Db2 Pacemaker on AWS Using Overlay IP High Level Architecture Your system must meet the following prerequisites to set up IBM Db2 Pacemaker on a two-node HADR cluster: Set up instance user ID and group ID. Set up host names for all the hosts in the /etc/hosts file on all the hosts in the cluster. Install kornshell ..read more

  Organizations today have high expectations for their data and DBAs: Agility. Organizations want innovation and speed in both infrastructure and code. With the rapid changes in technology, they need faster deployment. Cost-Efficiency. In the wake of COVID, staffing reductions, and economic headwinds, many organizations need to do more with their current resources. Reliability. Companies are looking for round-the-clock, 24/7 uptime, along with high availability and disaster recovery. Scalability. Organizations need to scale up and down rapidly based on demand, economic landscapes, an ..read more

  Pacemaker solves a problem that many companies have with their cloud transformation endeavors – how to address high availability and business continuity with IBM Db2 when lifting and shifting these systems into the cloud.   While Tivoli System Automation (TSA) and Reliable Scalable Cluster Technology (RSCT) services for high availability exist, in our experience, Pacemaker tends to be a lot more automated and robust. It’s less prone to problems than TSA clusters implemented with RSCT. Failover performance is greatly improved with Pacemaker over TSA, which can reduce mean time t ..read more

The post The Role of the DBA in 2023 appeared first on Datavail ..read more