2012 Oracle events in Bucharest

Even if we've just entered in 2013, here is the summary of two events that took place in Bucharest in October and November in Bucharest: Oracle Day 2012 and MySQL workshop. Oracle Day was the opportunity to get some details about the announcements made at Oracle Open World 2012.
Those 2 events highlighted the main directions for Oracle in developing and improving his 2 databases: Oracle Database and MySQL Database.

Oracle Day 2012Oracle Open World announcements:
•              Infrastructure as a Service – IaaS
•             Complete Cloud Offering 
◦                     SaaS,
◦                     PaaS,
◦                     IaaS
•             Exadata
•             Exalogic 

2. Oracle Private Cloud

3. Oracle Database 12c
Oracle Database 12c into Oracle Cloud – Multitenant database
•         multitenancy, enables users to create multiple "pluggable" databases that reside within a single database container
•         "heat map“ tracks how frequently different chunks of data are used
.•         Database upgrades and patches are made simpler than in the past thanks to the pluggable database concept.
•         Backup and recovery efforts benefit as well.

4. EXADATA X3 & EXALOGIC X3
•         Exadata X3 (www.youtube.com/watch?v=vcA71QGEhzI)
•          Database In-Memory Machine
◦              26 TB in DRAM (4) in Flash (22) in one rack
◦              X3H2M2 (X3 Heuristic Hierachical Mass Memmory) – Automatically keeps all active data in memory
•          All Active Data in Memory
•          Exadata Database Cloud
•          New Entry-level Eighth Rack
•          Exalogic X3
•          Extreme Performance For Java Applications
•          Extreme Performance For Oracle Business Applications
•          Natively Leverages Exadata
•          Best Consolidation Platform
•          Entry-level Eighth Rack
http://cloud.oracle.com 

Parallel sessions
•         Cloud
•          Instrastructure as a Service
•          Database as a Service
•          Midleware as a Service
•         Customer Experience•          Talent management (Oracle Taleo Cloud Service)
•          Customer experience (Oracle RightNow CX Cloud Service)
•         Data Center•          Exadata, Exalogic, Exalitycs
•         Enterprise Applications•          Business Intelligence
•          Business Process Modelling

MySQL workshop
•         MySQL 5.6 RC (Release Candidate)
•          MySQL Enterprise
•          What’s new in MySQL 5.6
•         MySQL Cluster 7.3 DMR1 (Developemnt Milestone Release)
•          What’s new

 MySQL 5.6 Enterprise Edition
•         MySQL Support
•         MySQL External Authentication
•         MySQL Enterprise Audit
•         MySQL Thread Pool
•         MySQL Enterprise Monitor
•         MySQL Enterprise Backup

 MySQL 5.6 RC
•         InnoDB engine
•          SSD optimization
◦              Page size from 4K to 64K
◦              Separate tablespaces for InnoDB Undo Log
•          Innodb_log_file_size (redo) 4GB limit dropped
•          Online DDL operations
◦              CREATE/DROP INDEX, ADD/DROP FOREIGN KEY
◦              Add, drop, rename, reorder, chane NULL/NOT_NULL for COLUMN
•          Persistent optimizer statistics
•          Optimized for READ ONLY workloads
◦              Autocommit=1: automatic
◦              Autocommit=0: START TRANSACTION READ ONLY
•          NoSQL solution for MySQL - delivered via memcached
•          Full Text Search 

MySQL 5.6 RC
•         Replication
•          Global Transaction IDs
◦              Unique identifier for each transaction written to the Binlog
•          Multi Threaded Slaves
◦              Great for systems which isolate application data using databases – e.g. multi-tenant
•          Optimized row base replication
◦              Binlog-row-image=minimal
•          Crash-safe Slaves
◦              Binlog and table data are transactionally consistent
•          Replication event checksum
 
MySQL 5.6 RC
•         Performance schema
•         Security
•          Password strength policies
•          Stronger password hashing
•         Other
•          Default optimized configuration
•          TIME/TIMESTAMP/DATETIME - fractional second precision
•          Improved partition


MySQL Cluster 7.3
•         MySQL Cluster is designed for
•          Short transactions
•          Many parallel transactions
 
MySQL Cluster
•         MySQL Cluster 7.2 GA
•          Adaptive Query Localization (AQL) – ndb_join_pushdown=on
•          Distribution Aware App
•          Connection pooling between MySQL Servers and data node
◦              ndb-cluster-connection-pool > 1 in my.cnf 
 •          NoSQL API
•         What’s new in MySQL 7.3 (EA)•          Autoinstaller
•          Support for Foreign Keys
•          Integration with the latest MySQL Server
•          New NoSQL APIs;