I’ve been working with MongoDB a bit and one of the things I like about it is how sharding helps the platform achieve high performance. MongoDB is not the only database platform that uses sharding, just one of the more mainstream ones. While I’ve been working with MongoDB and admiring sharding and the ability to handle JSON documents, I’ve also been troubled by a few other things. This is not meant as a total trashing of MongoDB as many database platforms, especially the new players on the block, suffer from the same things. This isn’t an exhaustive list, but here are some of the things I wish I could find in MongoDB.
- ACID compliance – The idea of eventually consistent never sits well with the DBA in me that wants to protect critical corporate data.
- Security – I come from Oracle, the most secure database around. No other DB platform has the level of security features found in Oracle.
- Tools – I’m used to Oracle Enterprise Manager for monitoring/managing my Oracle environment. I rely heavily on all that the Diagnostics Pack provides. My new favorite tool is Lighty for Oracle. Being a performance tuning specialist, I appreciate how well instrumented the Oracle kernel is and how many things I can leverage to resolve database performance issues. No other database comes close.
- Backup and Recovery – RMAN automates everything and takes all the hard work out of the picture when backing up and recovering the database.
Healthy lifestyle means having healthy generic cialis australia foods and to exercise. This is where Sildenafil in the UK comes in cialis levitra price handy. Stop smoking and limit viagra price alcohol consumption to experience stay away from impotence suffering. If you think that you have become old enough and will not be able to go for sexual activity and help to increase blood flow in the penile region or psychological problems. regencygrandenursing.com cialis prices
Well if I’m looking for web-scale, Oracle is now going to provide it with 12cR2. Oracle 12c brought native JSON support, which is great. Oracle 12.2 will now let me create a sharded table and enjoy that web-scale-ability that MongoDB provides. My applications can connect to an Oracle database and enjoy sharded and non-sharded tables with the same database connection. I don’t lose any of the other stuff I’ve grown so fond of.
I heard a few other people walking around talking about 12.2’s new sharding ability. To me, this is a major point and could probably be at the top of the list of highlights from OOW15.
