Slashdot Mirror
Continuent To Bring Open Source DB Replication To the Oracle World
Robert Hodges, CTO of Continuent, has an interesting blog entry about a new approach to database replication that they are undertaking. The new approach aims to provide easier access to replication for low-end Oracle users in addition to the alpha offering they already have for MySQL. "It's not a coincidence that we chose to implement MySQL and Oracle replication at the same time. MySQL has revolutionized the simplicity and accessibility of databases in general and replication in particular. For example, MySQL users have created cost-effective read scaling solutions using master/slave replication for years. MySQL replication is not free of problems, but there is no question MySQL AB helped by the community got a lot of the basics really right. On the other hand, Oracle replication products offer state-of-the-art solutions for availability, heterogeneous replication, application upgrade, and other problems, albeit for high-end users. For example, Oracle Streams and Golden Gate TDM offer very advanced solutions to the problem of data migration with minimal downtime. The big problem with these solutions is not capabilities but administrative complexity and cost."
what do you think?
Why not create a hybrid of MySQL and Oracle and give it out for a lower price than Oracle? Something that has the best features of both MySQL and Oracle.
And call it MyOracle [tm].
slashdot rocks
If there is one thing that really sucks in mysql it's replication, and no, they did not get it right.
Even running top notch hardware about as redundant as you can get after running for a couple of months the master and slave can be out of sync.
I think this is one of the major remaining issues with mysql.
MP3 Search Engine
I'm suprised Oracle is letting this fly--it probably somehow violates the EULA, by reverse engineering Oracle redo logs. Basically, it seems like they are targetting smaller shops, who don't want to buy Oracle Enterprise Edition (and hire a f/t DBA). My only question would be, how big is the market that needs to do replication, but can't spend the $ or â on Oracle Enterprise (which can be cheaper than you think for a small shop)
It depends on what type of replication one needs. The simplest means of Oracle replication is to create another database somewhere else and simply copy the logs over and apply them. We have done that for years for one simple reason ... for databases that don't require 5 nines service, I don't want an 'up-to-date' copy.
A major cause of database failures in my experience has been due to programmer or administrator error (i.e. program bug or someone typing truncate table wrong.) Creating scripts to copy the logs to another server as soon as they are created, and applying them after they are a few hours old, we maintain an environment where it only takes a few minutes to switch over and prevent the 'uh-oh' moments from corrupting both databases.
We have found that the decision to switch over to a remote database takes time. No one wants to do it because then we have to copy that whole database back to the primary site eventually, and that takes a lot of effort and time. When we have a failure, someone is tasked at getting the remote database ready while the discussions are held whether or not to fix or fail-over.
One benefit of this has been that when we have 'uh-oh' moments, the old data is still available and we can correct it, sometimes without the end-users even being impacted.
So .. for all of you database admins out there, replication is possible without the fancy software *IF* you can write scripts, create a somewhat simple system to repoint to the new one (i.e. DNS), and can live with a few minutes of downtime a couple of times a year.
I rarely read replies, it's my opinion and if you thought about your opinion a little more, I'm OK with that.
Continuent? Continuent? Who thinks up this stuff? All I can think of is some suit explaining it. "We harness the synergistic energy of the word 'Continue' while simultaneously fulfilling our carnal, earthy ambitions by joining in sympathy with the Ents who will, perhaps in some future time or far-away land, form our products' user base."
That's not partitioning. That's a weird, ugly, error-prone hack with table inheritance and constraints.
And you're further telling me I further have to enable constraint exclusions on my entire database server, which is a performance hog on non-partitioned tables?
And what if I want to change my partition keys? No can do. Parameterized queries? Nope.
So mod me -1 troll all day long--I don't care. Being right is more important to me.
They don't grade fathers, but if your daughter's a stripper, you fucked up. --Chris Rock
It sounds like somebody has never used SQLite. MySQL is WAY too complex for the majority of applications.
A slashdotter who didn't build his own computer is like a Jedi who didn't build his own lightsaber.
Continuent wants 160 euro per socket PER MONTH for their product.
that includes the *enforced* support package.