Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
SUMMARY: Modern computing professionals must clearly distinguish between the physical processor socket, the independent execution core, and the dependent thread to accurately calculate a system's true processing capacity in environments dominated by parallel...
The Db2 RDBMS offers many great tools for getting things done. There are, however, times when tools are unavailable. This isn’t a problem when you’re performing a simple and discrete task. When the task has many iterations then like dropping triggers or granting...
If you’re upgrading a ReplicaSet from a version before 3.2 of MongoDB to a new version, you will run into this warning when connecting to the shell. Protocol Version 0 is not supported in MongoDB 4.0. Checking Protocol Compatibility To verify which protocol version...
Recovery Catalog Purpose: The RMAN recovery catalog is a schema created inside of a new or existing database that is used to store metadata about Oracle databases. It's recommended by XTIVIA that the catalog be created in its own dedicated database due to the...
Virtual-DBA came out of XTIVIA's response to an urgent need in the market to limit travel during the dotcom bubble burst. It was vital for our customers to conserve travel resources, both time and money, while getting immediate response on database issues. In that...
The effects of COVID-19 continue to disrupt "business as usual." However, there are opportunities for strengthening business processes and even growth that were not present previously. Here is XTIVIA's top 10 list of things your DBA could be doing to help make the...
If you're running a 3 member ReplicaSet that uses an Arbiter as its third member, then you will be presented with this warning when you connect to the shell. When a node goes down in a PSA architecture (Primary, Secondary, Arbiter) the wiredTiger storage engine starts...
This article explains how to configure Oracle Golden Gate software to perform a unidirectional replication from a source non-CDB database on Oracle 12c to a target pluggable database on Oracle 19c. One possible use case is if you need to migrate from your non-CDB...
MongoDB-CR is the challenge response authentication mechanism used in MongoDB versions before 4.0. In version 4.0 this mechanism is removed and you must upgrade to the new mechanism SCRAM before you upgrade to 4.0. You will receive this warning if you have launched...
When connection requests to a MySQL database from a given host are interrupted, MySQL keeps track of the number of successive interruptions in the host cache. MySQL will eventually block the host, giving them a message [1129] "Host 'host_name' is blocked because of...