Install and configure MariaDB Galera 4 cluster on Centos 7 in VirtualBox

Background: Clustering is used to achieve High Aaailability(HA) in many forms and is widely used in database technologies to meet the service uptime and to load balance clients requests. We will see how to configure a Opensource Galera cluster on MariaDB database. This documents assume that you are familiar with virtualization technologies especially VirtualBox, you…

Migrating Bitnami WordPress website from AWS EC2 to VPS Bitnami NGINX

Steps to perform during migration: Install VPS with CentOS 7 without any LAMP stack. configure the x11 window and forwarding make a directory named as /bitnami to be used as installed directory Download the WordPress NGINX stack installer from bitnami. Login as root user, installation should be done as root user to avoid later complexities.…

Enabling tracing for oracle LISTENER

Background: For the oracle errors like “ORA-12170: TNS:Connect timeout occurred”, “ORA-12535: TNS:operation timed out”, “ORA-12560: TNS:protocol adapter error”, “TNS-00505: Operation timed out” and like others related to oracle listener it is useful of tracing the listener activities to dig down further. Workaround: Connect to the listener control utility from the command line or shell. LSNRCTL…

Oracle-Error: opiodr aborting process unknown ospid ( ) as a result of ORA-609

Background: After shutdown and restarted the oracle instance by an executive, client can’t connect to database instance though database is up and running and listener service is up. OS: Windows Server 2012 x64, Oracle: 11g R2, Data Guard Configured Workaround: From the alert_SID.log file found the below error raised after shutdown and consecutive startup and when…

Show carrier’s current and previous rates information by destination

Background: After rate sheets applied in the billing system provided by the partners/carriers, executive likes to sort out the destination and carrier with their latest applied rates along with their very previous rates with the below format: Carrier Name | Destination | Prefix | Applied Date | Applied Rate | Previous Date | Previous Rate…

CDR cross check to resolute dispute with parties

In telecommunication sometimes it needs to analyze traffic to resolute dispute with parties; in this case either parties or both will provide their CDRs and will cross-check them. CDR cross-checking criteria: CDR should be matched with respect to call: start_time, a_party, b_party and duration Some cases partners have differences in the call pattern for a_party…