Hot off of
href="https://www.oracle.com/openworld/index.html" target="_blank">Oracle Open World 2016 is the lab release of
href="http://mysqlserverteam.com/introducing-mysql-innodb-cluster-mysql-ha-out-of-box-easy-to-use-high-availability/" target="_blank">MySQL’s InnoDB Cluster.
Today an application team had a problem with a production system and they wanted the database restored to a point a couple of days ago. It is a configuration management system and they figured they could lose any changes . Their call.
You have done a failover to your Standby database so it becomes the new Primary. It may be possible to convert the old Primary into a Standby database now instead of having to do a time consuming duplicate again. The old Primary must have been running in flashback mode before the failover. The playground:
Based on the available statistics on the objects, the Oracle optimizer could incorrectly estimate the cardinality of certain row sources, resulting in a sub-optimal plan. Adaptive plans are a technique used by the Oracle 12c optimizer to adapt a plan, based on information learned during execution, to pick a better plan.
There are two types of optimizations oracle 12c can do under adaptive plans. One is a technique called “Adaptive Joins” and the second is called “Adaptive Parallel Distribution Methods”. This article deals with “Adaptive Joins”
It is a common auditing requirement to log user connection events, including whether or not authentication was successful.
/> There are a number of alternatives available for MySQL, but unfortunately there is no built-in functionality at the time of this writing. In this post we will discuss auditing MySQL users with McAfee
href="https://github.com/mcafee/mysql-audit">plugin, which is available under GPL Version 2 license.
Whether it’s Oracle, MySQL, Java, or any other Oracle-related technology, you can bet Pythian will be talking and learning about them at this years Oracle OpenWorld from September 18-22nd at the Moscone Center in San Francisco. Pythian will have six attendees speaking on seven different topics, and we will be hosting the
href="https://www.pythian.com/blog/oracle-openworld-2016-bloggers-meetup/">OOW Bloggers Meetup.