HCI and Database servers

There are constant infrastructure technology changes. There are regular infrastructure changes - for various reasons , such as hardware refresh , hardware not supported by vendor any longer , data centre simplification , changing data centres , on-prem versus off prem. What remains permanent is the database servers that remain on the OS. So it's incumbent upon the DBA to approach the problem with a risk analysis mindset. One of the first is start to understand the underlying infrastructure. Hyper Converged Infrastructure (HCI) utilizes storage residing in servers and distributing the storage treating it like a storage array. This consolidation... Read more →

Which one to use - Apache Kafka versus RabbitMQ

Best case scenario (use case) for Apache Kafka 1) Requirement for partitioned order at least once write. Requirement for A to B streaming with high throughput. 2) Durable message store . Why would this be important? Consumers can get a replay of the event stream - whereas limited in message brokers - where once message is delivered , removed from queue 3) If a solution requires data stream processing. 4) Event sourcing required. Event sourcing persists the state of a business entity e.g maintaining a chain of event at different states in a sequential order for a Customer 5) More... Read more →

How to fix mongo odbc 1.1 access denied for user in Challenge and Response

When supporting developers during setting up BI Connector and the ODBC System DSN for connection to a MongoDB , a common problem is the incorrect application of the username format , leading to a "Access is Denied" error message. What should the correct username format be for the Challenge and Response method? Step 1 is setting up the BI Connector. Typically the developer initiated the command line utility mongosqld . The mongosqld command line utility accepts incoming requests from a SQL client (or ODBC DSN setup used by the SQL Client) and acts as a proxy for the incoming requests.I... Read more →

How to find Kafka port number and Zookeeper port number

Question: I need to supply the Kafka port number and Zookeeper port number for firewall exceptions. Where can I find the port number details for both Kafka and Zookeeper ? Answer : To find the Kafka port number - locate the Kafka server.properties file. Typically the server.properties file will have the information required. The file is normally found on this location . By default the port number is 9092. $(confluent_home)/etc/kafka/server.properties To find the Zookeeper port number - locate the Zookeeper properties file. Normally found on $(confluent_home)/etc/kafka/zookeeper.properties. Once you've opened the file , look for ClientPort=2181 For Zookeeper - 2181 =... Read more →