Oracle MySQL database replication for senior government office
How Unico is supporting a senior government office review architecture and configuration in light of some recent operational issues (Oracle MySQL database replication) and their roadmap.
Provided MOP (method of procedure) to implement and enable the new configuration
Supported the senior office with implementation and support.
Oracle MySQL referred us to this piece of work as we are a trusted and long-standing partner. A senior government office engaged Unico to review their architecture and configuration in light of some recent operational issues (Oracle MySQL database replication) and their roadmap.
We conducted interview workshops to clarify initial requirements, reviewed architecture and configuration, revised configuration and articulated implementation steps including a future roadmap.
Our team delivered an updated configuration, a MOP to implement and enabled the new configuration and supported the office with the implementation and support including technical queries and troubleshooting.
Replication was successfully re-instated and operational across the Oracle MySQL cluster. A high-level technical assessment of future work items including an Oracle MySQL version upgrade, cluster upgrade, and traffic balancing was also considered.
Intralot is a global lottery and sports betting operator that monitors pokie machines in Victoria on behalf of the state government
Monitoring of these machines is crucial to protect gambling integrity and ensure compliance with state regulatory requirements at venues. Audits of machines are conducted regularly to check for compliance breaches and record installation.
Historically, Intralot relied on a manual Microsoft excel based system to record booked audits, machine installations and data entry. This resulted in:
1. Inefficient and time-consuming manual data entry
2. Vulnerabilities to compliance breaches due to human error
3. Large amounts of unstructured data due to manual processes
4. Difficulty coordinating large teams across different vendors and casinos
Intralot engaged Unico to support the digitalisation of manual processes and develop a new online booking portal to accurately and effectively record audits and installation of machines.
Our solution delivered:
Process digitisation, eliminating manual data translation from vendor information into the legacy case management control system (CMCS)
Web based portal to track data entry and audits of machines
Real time viewing of upcoming deployment activities and reports on historical data
Automated management of business rules about deployments
Overall improvements in lead times for deployment activities
The MIoT tech that connects a wearable device to a mobile
Key benefit One of the key benefits of uPair is its lifecycle management of this growing family of ‘Mobile Internet of Things’ (MIoT) secondary devices towards the operator. uPair provides a service delivery framework between the operator and third party ecosystems and abstracts much of the complexity into the operator through the use of standards based TMF API’s to the operator’s Network, CRM and Charging/Billing systems.
How it works:
The handset and wearable device connects via Bluetooth, with the handset connecting to uPair via the mobile network or WiFi.
uPair checks both local and operator databases to establish existing state and whether the customer is entitled to the One Number service.
If the customer is ‘entitled’ to sign up and proceeds, uPair hosts the user sign up web flow process, assigns the eSIM and mobile details from its inventory tables, readies the eSIM for download and updates the operator’s fulfilment system.
The operator’s provisioning system updates services in the network.
uPair passes the assigned eSIM back to the handset and wearable device, and the wearable device subsequently downloads the eSIM.
uPair updates the operator CRM and charging systems as required.
The operator replies to uPair when all is complete, uPair updates its database.
The watch and handset are notified all is complete.
If you would like to find out more about how uPair can help your business, please contact Jason Bodsworth.
The largest Oracle MySQL NDB Cluster in the Southern Hemisphere
When one of Australia’s largest telecommunications providers needed a new mission-critical platform for provisioning millions of mobile, fixed, and broadband services, they turned to us – Australia’s leading Oracle MySQL technology partner – to develop a solution.
We developed an “always on technology” mobile provisioning and fixed service orchestration solution that deployed the largest Oracle MySQL NDB Cluster in the Southern Hemisphere.
The solution stores millions of services and involves:
Taking provisioning orders from multiple CRMs and orchestrating these orders across many network devices to activate fixed and mobile services.
Maintaining a comprehensive service inventory of customer network data that is used throughout the provisioning process.
Complex service and cross service orchestration when provisioning these services into various network systems.
Zero touch provisioning, with self-healing through existing state determination and use of automated retry with no manual intervention.
Fully configurable so new services and devices can be added as needed.
Oracle MySQL enabled us to deliver a single centralised database for all service inventory data resulting in significant cost savings. These solutions incorporated the MySQL database and have benefitted extensively from its function, performance, and reliability.
We have been working with Oracle MySQL for over ten years, resulting in numerous highly complex mission critical technology solutions. We have also deployed the Oracle Communications Service Gateway (OCSG) into a leading Australian Telco to provide a ‘Network As A Service’ (NaaS) gateway.
Built in multiple edge case scenario capability & ACID compliance
Utilised an Oracle MySQL database
Many Telcos don’t have the budget, resources or knowledge to develop an entitlement server solution for their own business.
That means they are missing out on crucial new streams of revenue that can be gained from charging customers for value-added services.
Entitlement server solutions are used to allow users to connect multiple SIM and eSIM enabled devices to one number and service. This connection can be bundled into a subscription package where pairing capability is offered via mobile app.
Our solution uPair gives lower tier Telcos the ability to compete with Tier 1 Telcos by offering their customers wearable tech pairing at a low cost of entry.
Unico partnered with Australia’s largest mobile service provider who needed an application that allowed Australians to use the built in cellular capability of the new ‘Apple watch’ (GPS + Cellular) .
In doing so Unico were the first in Australia to develop an eSIM solution that supported wearable device compatibility.
By integrating this entitlement solution our customer could share a single service with a mobile device through sharing accurate subscriber identification information with their network.
Our client was equipped with a telco grade, real-time and high availability entitlement server solution that enabled them to offer value-added services to their customers.
uPair was able to meet the needs of a world-class telecomms provider and deliver a world first in eSIM technology.
– John Rowland, Managing Director, Unico
The project included provisioning and enabling of the eSIM for the Apple Watch to download and update its network whilst allowing paired devices to operate with a ‘shared number’ service. The partnership marked the first time an eSIM technology had been delivered to the Australian consumer market.
Thanks to uPair thousands of Australians are connected to Australia’s biggest mobile network for phone calls and messages via their wearable devices.
If you are interested and want to find out more get in touch below and talk to us today.
Reducing integration platform maintenance windows by up to 90%: CitiPower
Unico delivered a roadmap of integration platform initiatives that would dramatically increase business efficiencies with a doubling of platform capacity, releasing 3 to 4 staff from the intensive, extremely expensive and error prone manual reconciliation and restoration obligations.
Reduce maintenance windows and increase business efficiencies
Solving reliability issues and integrity errors in data transactions between critical business IT systems
Reviewing the key integration platform
Identifying technical stability issues
Installing a future-proof architecture roadmap
Reduction of the integration platform maintenance window by up to 90%
Releasing 3-4 staff from the expensive and error prone manual reconciliation process
Reliability issues and integrity errors in data transactions between critical business IT systems were causing data loss and corruption. This was placing increasing demands on staff time through intensive manual reconciliation and restoration, impacting business confidence and daily business efficiencies.
Increasing competition and price pressure in energy delivery and services have led energy distributors to exploit leading edge technologies to enable cost-effective, high-availability and real time business and market information to better compete on price and service.
CitiPower supplies electricity to more than 310,000 distribution customers in Melbourne’s CBD and inner suburbs, operating among the most reliable urban and rural electricity networks in Australia. Powercor Australia is Victoria’s largest electricity distributor, supplying electricity to regional and rural centres in central and western Victoria, and Melbourne’s outer western suburbs for approximately 700,000 distribution customers.
CitiPower & Powercor built an integration platform to manage high volumes of data transactions between their metering, market and customer business systems. Reliability issues and integrity errors in data transactions however were impacting business confidence and efficiencies on a daily basis. It was also clear that a strategy was needed to future proof data transactions as data volumes are on a steep growth curve driven by aggressive business IT sophistication.
A review of a key integration platform identified a number of technical recommendations to address stability issues. A long-term roadmap to future proof against the increasing demands for real-time business data and evolution of the platform architecture was recommended.
As one of Oracle’s most experienced implementation partners in the region with extensive experience with Oracle Fusion Middleware, Unico was able to address the issues around data transaction management and create future proofing strategies to cope with the increase data loads.
Our team focused on the core technology stack and architecture, while gaining the necessary understanding of business context and network connectivity. We were then able to identify performance issues and provide sound recommendations to restore data transaction integrity that would ensure medium term predictability and confidence for the business with real time data transactions. A robust roadmap was also proposed for improving long-term architectural design and best-practice evolution of the business technology to cope with increasing demands.
Predicted increase in business efficiencies including a doubling of integration platform capacity, a reduction of the platform maintenance window by up to 90%. A roadmap of remediation initiatives intended to restore data transaction integrity and restore business confidence in real time data transactions was also delivered.
Unico delivered a roadmap of initiatives that would dramatically increase business efficiencies with a doubling of integration platform capacity and reduction of the platform maintenance window by up to 90%, and elimination of incomplete or stranded transactions (several hundred per day), releasing 3 to 4 staff from the intensive and extremely expensive and error prone manual reconciliation and restoration obligations.
The strategy will eliminate most unplanned outages, smooth the profile and lower database latency and resource usage, and provide operational control over interfaces in outage events that may still occur.