Database Administration & Monitoring Replicating specific tables in PostgreSQL 10 Beta with mimeo 15.08.2017 by Oracle Team By Mouhamadou Diaw In this blog I am going to test the extension mimeo with PostgreSQL 10 beta. Mimeo is a replication extension for copying specific tables in one of several specialized ways from any number of source databases to(…)
Oracle ODA X6 2S 2M 2L HA: Small Medium Large and High Availability 14.08.2017 by Oracle Team By Franck Pachot . There are 4 models of Oracle Database Appliance with the new ODA X6 which is for the moment the latest ODA hardware version. One is similar to the(…)
Application integration & Middleware WebLogic – Cannot register for disconnect events on local server 13.08.2017 by Morgan Patou When working with WebLogic, there will probably be a moment when you will ask yourself: damn, what is wrong? Nowadays, software are so complex that it is kind of easy to introduce bugs/non-wanted behaviors in them… In this blog, I(…)
Database Administration & Monitoring OUD 11.1.2.3 – How to recover a lost entry in a replicated OUD environment 10.08.2017 by Oracle Team By William Sescu . By accident, it could happen that someone dropped an OUD entry in your replicated environment and of course, the entry is deleted on all replicas as well. And besides that, you got no logical ldif(…)
Oracle, PostgreSQL Postgres vs. Oracle access paths VI – Index Scan 09.08.2017 by Oracle Team By Franck Pachot . In the previous post my queries were still reading the indexed column only, from a table which had no modifications since the last vacuum, and then didn't need to read table pages:(…)
Database Administration & Monitoring, SQL Server SQL Server on Linux: Introduction to DBFS experimental tool 09.08.2017 by Microsoft Team A couple of months ago, Microsoft announced two additional command line tools for SQL Server that are mssql-scripter and DBFS. The latter has drawn my attention because it exposes live data from SQL Server DMVs as(…)
Database Administration & Monitoring MariaDB – How to migrate quickly MySQL to MariaDB over different hosts with mydumper/myloader and ncat 09.08.2017 by DevOps A lot of possibilities exist to migrate MySQL to MariaDB. In this blog I would like to show a scenario where I migrate MySQL 5.7.19 with a lot of databases to MariaDB 10.2.7, which is on a different host. The(…)
PostgreSQL Postgres vs. Oracle access paths V – FIRST ROWS and MIN/MAX 08.08.2017 by Oracle Team By Franck Pachot . We have seen how an index can help to avoid a sorting operation in the previous post. This avoids a blocking operation: the startup cost is minimal and the first rows can(…)
SQL Server, Technology Survey 24 HOP French edition 2017 – Session videos are available 07.08.2017 by Microsoft Team The 2nd edition of 24HOP French Edition 2017 is over and we had great sessions about SQL Server and various topics ( SQL Server 2017 new features, Azure, PowerBI, High Availability , Linux, Hyper-convergence , Modeling …) If(…)
Database Administration & Monitoring MariaDB – Speed up your logical MariaDB backups with mydumper 07.08.2017 by Oracle Team By William Sescu Per default, MariaDB is shipped with a utility called mysqldump for logical backups. For more information, please take a look at the following link. https://mariadb.com/kb/en/mariadb/mysqldump/ The mysqldump has advantages, e.g. it is easy to use and(…)