Infrastructure at your Service
By Franck Pachot . I thought that my last post on this blog was the previous one but I blog when it comes to my mind – nothing planned. And two things got me to write this. First, last week we got our 20th dbi xChange where we meet with colleagues. And I love discussing with colleagues about what we see, and foresee, in our jobs. The second one is: https://twitter.com/FranckPachot/status/1409084362637942786?s=20 The web.archive.org is full…
By Franck Pachot . Here is how to quickly install the CLI (Command Line Interface) for the following public clouds: Amazon, Google, Microsoft and Oracle. On Linux, I’m using wget but you can use curl. I’ll install all cloud command line interfaces into a $HOME/cloud directory and add an alias into $HOME/.bashrc if not already existing Amazon – AWS AWS – install ( mkdir -p ~/cloud/aws-cli ; cd /var/tmp && wget -qc https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip && unzip…
By Franck Pachot . Oracle Cloud free tier is already outstanding since OOW19 with two VMs and two databases that you can leave always running without any risk of being billed or seeing them stopped. I use them daily. And it goes to another level on May 25th with the announce of the ARM Ampere Altra 80 cores processor running at 3.0 GHz. Because on your free tier, one of those two VMs can be…
By Franck Pachot . In a previous post I tried to build a glossary about Amazon DynamoDB terms that look like relational database terms, but with a different technical meaning. Here is more about it. If you work with AWS Databases and frequently switch between DynamoDB and Aurora, or other RDS databases, you may be confused by the same terms used for different meanings. An index is a redundant structure that is maintained by the…
Introduction What if you need quickly to launch virtual machine instances running Ubuntu for development and testing purposes. Multipass from Canonical can be the right tool for this. You can even customize the instances during launch by using Cloud-init in order to simulate a small cloud deployment from your laptop or desktop. So, in this short blog post, I will talk about this tool and demonstrate how easy it is to use it.
By Franck Pachot . Should CPU-intensive logic be done in the DB or in application server? Here was a answer found in Reddit: Comment from discussion xpiv’s comment from discussion "Should CPU-intensive logic be done in the DB or in application server?". Reducing the CPU usage on the database server is a major cost saver with commercial databases, like Oracle Enterprise Edition where you pay license per core. But even in Open Source, on-premises or…
Data and applications integration is always a technical challenge for most of the companies. All data integration tool ensures that information is timely, accurate, and consistent across complex systems. Oracle Data Integrator (ODI) is different than traditional data integration tools in the sense it integrates data in a different orders. ODI is known as en E-LT because it Extracts data from the source system and Loads and Transforms data into the target system while traditional…
By Franck Pachot . Linux kernel has a powerful instrumentation that can be accessed easily. When you want to drill down into your program functions to understand their CPU usage, “perf” is the easiest. It can attach to the processes, sample the CPU cycles, get the symbol name, or even the call stack. And display an histogram of sample counts. This provides an easy profiling tool to understand in which function your program spends its…
Once Rancher is up and running, it makes the deployment and management of Kubernetes clusters quite easy. In this post we’ll deploy a brand new cluster on top of EC2. If you want to have a simple and quick Rancher playground you can follow this post, which will give you a Rancher setup on SLES 15. If you want to have a more production like Rancher setup, you can follow these posts: Rancher, up and…
By Franck Pachot . If you want to run an Oracle Database in the Microsoft Azure cloud, you will install it yourself on a VM. And then, you can expect the same as when you install it in your premises, in a virtual environment. Except that Oracle makes it two times more expensive by accepting to license the processor metric on vCPUs at the condition that the Intel core factor is not applied. And in…
