I’m going to explain how to do a manual Switchover in a MariaDB HA setups using master-slave replication. In my example, let’s consider that I’ve a server01 and server02, both running on Ubuntu 20.04. server02 is currently the master, server01 the slave. We’ll perform a switchover to come back to a normal status, meaning server01 as master and server02 as…
Introduction In an Oracle database, services have multiple purposes: identifying group of users prior authenticating them enabling/disabling access to a database for particular groups managing preferred nodes on a RAC configuration redirecting users to the primary after a switchover/failover when using Data Guard or Dbvisit Standby redirecting read only connections to Standby database with Active Guard option A customer asked…
Eclipse setup In order to test Java JDK12 you will have to download Eclipse 4.11 at least. Then download JDK12 from Oracle’s web site. And configure Eclipse to use this JDK for the project. Also download the JDK12 support with the following repository link: https://download.eclipse.org/eclipse/updates/4.11-P-builds Edit the projects properties to use the “Java Compiler” compliance 12. And “Enable preview features”…
In this blog post, I would like to share with you a weird issue I faced when I implemented a sliding Windows partition scenario on SQL Server 2014 SP1 at one of my customer. The idea was to keep SQL Server audit records from several SQL Server instances into a global archiving table during two years in order to meet…
This time let’s talk about an interesting customer scenario where table partitioning was implemented on a table with 100 GB of data on SQL Server 2014. Partitioning in this context aimed to save disk space (archive data were compressed) , help to reduce maintenance time and consumed resources as well (by using index and statistic maintenance operations on the active partition). Finally,…
