MariaDB Temporal Tables: Uncut & Uncensored (Part III)

(This is the third of a series of blog posts covering MariaDB Temporal Tables. The first and second in the series introduced the topic.)  “Who are you?” said the Caterpillar. This was not an encouraging opening for a conversation. Alice…

Read More >

2019 Tech Geek Gift Giving Guide

It’s that time of year again!  Each year around the holidays, we offer gift ideas for the tech geek on your list — any data lover, IT pro, or fan of cool technology. And this year is no exception. The…

Read More >

Mining GoldenGate Error Logs for Consumption Rates of Trail Files

After resolving Oracle GoldenGate issues, a question typically asked is, “When will the process catch up?” The usual method to find out is to use the lag command; however, I was more interested to see the rate of the trail…

Read More >

Pythian Announces Support for AWS Outposts As A Launch Partner

Today at AWS re:Invent, Amazon Web Services (AWS)’s most important tech conference of the year, AWS Outposts was announced. As Amazon says in its release notes, “AWS Outposts is a natural extension of AWS cloud services towards on-premises and bringing…

Read More >

MariaDB Temporal Tables: Uncut & Uncensored (Part II)

(This is the second of a series of blog posts covering MariaDB Temporal Tables. The first blog post can be found here.) There are really four dimensions, three which we call the three planes of Space, and a fourth, Time….

Read More >

Mining Autoupgrade Results

We wanted to define a consistent process for upgrading databases using an autoupgrade method for single instance databases: Create directory for autoupgrade/log: $ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log, where $ORACLE_UNQNAME=db_unique_name Create upgrade.config as shown: $ORACLE_BASE/admin/$ORACLE_UNQNAME/${ORACLE_UNQNAME}_upgrade.config global.autoupg_log_dir=$ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log upg1.log_dir=$ORACLE_BASE/admin/$ORACLE_UNQNAME/autoupgrade/log upg1.dbname=$ORACLE_UNQNAME upg1.sid=$ORACLE_SID upg1.start_time=NOW upg1.source_home=/oracle/app/product/11.2/dbhome_1 upg1.target_home=/oracle/app/product/12.2/dbhome_1 upg1.upgrade_node=localhost upg1.target_version=12.2 upg1.timezone_upg=no…

Read More >

MariaDB Temporal Tables: Uncut & Uncensored (Part I)

(This is the first of a series of blog posts covering MariaDB Temporal Tables.) “You must remember this, a kiss is still a kiss. A sigh is just a sigh; the fundamental things apply, as time goes by.” Sam (Dooley…

Read More >

Live Kernel Updates Without Downtime in New RHEL 8.1, 7.7 and 7.6 Release

Most often companies scheduling downtime for patching of the Linux kernel in a production environment follow strict ITIL processes and make arrangements to be fail-safe in order to keep the production environment up and running. Patching is an important part…

Read More >

Scaling ProxySQL rapidly in Kubernetes

It’s not uncommon these days for us to use a high availability stack for MySQL consisting of Orchestrator, Consul, and ProxySQL. You can read more details about this stack by reading Matthias Crauwels’ blog post How To Autoscale ProxySQL In…

Read More >

Top 5 Extreme Programming (XP) Tools Every Team Should Use

What is XP? Extreme Programming, or commonly known as “XP”, is an Agile method with a primary focus on software development, specifically software development best practices. As you read this article, see if you can think of ways that the…

Read More >
Page 1 of 35212345...10...Last Page »