Infrastructure at your Service
Introduction Hi everybody,today let’s see an easy way to order a folder at a specific hour/date instead of being ordered directly by the new day procedure. To do so, we will use the ctmudly utility. Ctmudly command To order a folder depending of a specific user daily we will use this syntax (connected as controlm) ctmduly -DAILY_NAME ENTER_YOUR_USER_DAILY_NAME Be careful of maximum numbers of characters allowed to define your specific user daily(10 char). Example: ctmduly…
In the last post we had a look at how EDB BART integrates into EDB PEM, so backups and restores can be managed centrally from the PEM console. Another tool that comes with an EDB subscription is EDB EFM (EDB Failover Manager). We again will not cover how that tool works or how you need to set it up, but rather focus on how EFM integrates into PEM. What I expect from the integration of…
When it comes to our PostgreSQL customers we basically have two types: There are customers that do not want to have a subscription. For these types of customers we go with plain community PostgreSQL and a choice of other open source components for supporting backup and recovery, high availability and monitoring/alerting. The other type of customer usually already has a subscription for the underlying Linux operating system and wants to have the same supported model…
From Oracle GoldenGate (OGG) version 12.2 and above, there is a transparent integration of OGG with Oracle Data Pump as explained in the Document ID 1276058.1. The CSN for each table is captured on an Oracle Data Pump export. The CSN is then applied to system tables and views on the target database on the import. These views and system tables are referenced by Replicat when applying data to target database. This 12.2 feature, no…
If you are thinking about to move your MySQL databases to the Cloud but you are still reticent, you can maybe use the “Oracle Cloud Free Tier” offer to test it.
Introduction Hi everybody, making jobs has never been such easier in using mass create utility, easy also to increment with counter feature (ex: JOB1,JOB2,JOB3) but sometimes we may not have the expected result,especially when you do mass update for 2 different folders.Let’s see that: You already know how to do mass update, if not check on of my previous posts But what happens when I try to mass create jobs for another folder? As we…
In this blog post, I will show you what I did to troubleshoot an interesting problem with Memory on SQL Server. It all started with a job performing DBCC CHECKDB on all databases taking hours to complete instead of 10 minutes. So the Job ran outside of its maintenance window, still running in the morning when users come back to the office. They immediately complained about poor application performance. While running the CHECKDB we could…
Introduction A complaint I heard from customers about ODA is the low core speed of the Intel Xeon processor embedded in the X8-2 servers: Intel(R) Xeon(R) Gold 5218 CPU @ 2.30GHz. 2.30GHz only? Because of its comfortable number of cores (16 per processor), the cruise speed of each core is limited. Is it a problem compared to a home made server with less cores? Why clock speed is important? As you may now, the faster…
In the following blog, you will learn how to install the latest version of the MariaDB Server 10.5.5 on CentOS 8 and how to use the mariadb user & binaries instead of mysql.
By Franck Pachot . I have written a few blog posts about some NoSQL (vs. RDBMS) myths (“joins dont scale”, “agility: adding attributes” and “simpler API to bound resources”). And I’ll continue on other points that are claimed by some NoSQL vendors and are, in my opinion, misleading by lack of knowledge and facts about RDBMS databases. But here I’m sharing an opposite opinion: SQL being user-friendly is now a myth. Yes, that was the…
