SharePlex® by Quest® was designed to address the HA/DR and horizontal scaling issues in Oracle databases. Building on this two-decade legacy, SharePlex for PostgreSQL now provides PostgreSQL database replication that solves many of these issues…
SharePlex® by Quest® was designed to address the HA/DR and horizontal scaling issues in Oracle databases. Building on this two-decade legacy, SharePlex for PostgreSQL now provides PostgreSQL database replication that solves many of these issues…
Database developers and DBAs have been using open-source databases, such as MySQL and PostgreSQL, for years. The platforms are mature, offer flexibility with low license costs and have a huge community following. Plus…
Patching, Upgrading or Migrating your Oracle Database can leave you feeling that you're in the midst of the same tornado that swept Dorothy into the Land of Oz; and you might run into some of the same characters as well. Here's how SharePlex, Quest's…
We all remember Abbott and Costello’s skit “Who’s On First?”. If you haven’t seen it, I highly recommend you pop over to YouTube and give it a watch. It has become one of the legendary classic comedies of all times, with Costello not knowing baseball…
I’ve been interested in weather, meteorology and clouds in the sky for as long as I can remember; which may explain why one of my favorite songs is Joni Mitchell’s “Both Sides Now”. I’ve learned that some clouds are pretty, and…
In recent SharePlex blogs, my colleagues and I have discussed using the Analyze Config command to help gather information to tune SharePlex, and the importance of tuning the target database. In this blog, I’ll attempt to put it all together. This…
When a large customer appreciation company needed to categorize their Oracle auditing data by region, SharePlex came to their rescue. They were already using SharePlex’s Change History feature to track the userid’s, timestamp, before and after data values…
A large educational Institution recently approached us with a problem. Their Student Information and Financial databases were in Oracle, and a data warehouse containing extracts from both of these used for decision making, including opening more sections…
A major financial institution recently completed a project to consolidate all of their employee information, including credentials for building and online access, into a single database. Of course, they protected their…
Moving big amounts of data can be very stressful and quite often requires all of your technical skills. Users expect data migrations to be done quickly and ideally with no downtime and impact on the applications that they are working with.
Sometimes it…
I was looking at my losing Mega Millions ticket last night and thought 'can I ever win this?'
I am not holding out much hope but then I thought, 'how about if I took the winning numbers for the year so far and tried to find a pattern in them?…
SharePlex peer-to-peer setup
Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer replication is not appropriate…
Does the process of replicating data from one source to another fill your body with an inner joy like it does mine? The thrill of changing data in one location and watching those changes appear in another, in my eyes is better than well you know….. Ice…
When installing SharePlex one of the things you need to do is verify the installation is working by using the SharePlex test tables before using your own tables.
There are a couple of scripts you can run to do this but in the video I recorded I show you…
SharePlex has an interesting feature termed Auto-Add that allows objects to be brought into replication as and when they are created on the source. Essentially the ongoing replication creates the objects in the target database once they are created on…
When very large tables are out of sync on the target and Compare is not a suitable sync option, it requires a set of coordinated steps to bring them in sync with the source tables. This is especially true if the downtime on the source table is not acceptable…
I’m sure Oracle DBAs everywhere are keeping their collective ears close to the ground waiting for the official announcement on 12cR2. We still, rightly or wrongly, have a habit of waiting for the 2nd release of Oracle versions, but that’s for another…
I remember as a young lad of 12 years of age writing letters to friends and family that I had grown up with. As I would finish the letter, I would jump on my bike and run to the local post office to purchase a stamp for the letter. I’m not going…
In database replication, “immediately” never feels quite fast enough for your users, does it?
“We replicate transactions from production databases in real time,” you tell them. “You’ll see the change immediately, as soon as the transactions…
Peer-to-Peer replication (P2P) allows users on multiple databases to make changes concurrently to the same data, while SharePlex replication keeps all of the databases synchronized. Peer-to-Peer…
My grandmother was the greatest. She was the iconic example of old world class and style… I never knew she was also a prophet.
As I was growing up, she would always take me aside and raising a finger crooked from age, she would point to me and…
“How can I cook when they’ve taken my kitchen away?”
Like the man in the photo, you may have to ask yourself that question now that Oracle Streams has been deprecated. If you depended on Oracle Streams for moving data in your database…