Our blog isn’t just a record. It’s a resource.
We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
MongoDB – WARNING: This server is using MONGODB-CR
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...
MySQL Max Connect Errors
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...
MongoDB – WARNING: This Server is bound to localhost
When you're upgrading from previous versions before 3.6 you might notice this warning showing up in the shell when you start the server for the first time. This warning is telling you that you don't have an IP bound to your instance, preventing any connections to the...
Oracle 11g AUD$ Table Maintenance after ORA-01653: unable to extend table SYS.AUD$
Problem: ORA-01653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM This error generally results when the aud$ table has a next_extent value that is greater than the available contiguous space in the SYSTEM tablespace. The aud$ table records logins to the...
MongoDB – Disabling Transparent Huge Pages Ubuntu 16.04+
When running a MongoDB instance, it's always important and even recommended to disable Transparent Huge Pages. Database workload can be poor when THP is enabled. Service File This service will allow you to disable THP during startup. Create the service file we'll use....
How to Install Agent for Hybrid Management Via Azure Arc
Microsoft states, "Azure Arc for servers allows you to manage machines which are outside of Azure. When a non-Azure machine is connected to Azure, it becomes a Connected Machine and is treated as a resource in Azure. Each Connected Machine has a Resource ID, is...
Amazon RDS – Serverless Automated Snapshots Tutorial
Snapshots in Amazon when taken manually, are not available for scheduling. In order to accomplish this you could run Amazon CLI but for that you would need to execute from a server based on a cron job or something similar. This solution will allow you to run a...
Setting Up HADR with Two Auxiliary Standbys
In my previous blog, I presented some of the issues you can run into when setting up one auxiliary HADR standby and a potential solution. This blog discusses setting up two auxiliary standby databases in detail. Let's start with all the information we need to set the...