Second Life: Understanding the Oracle RAC and the MySQL Cluster Architectures
By George Trujillo on Nov 26, 2008
Understanding the Oracle RAC and the MySQL Cluster Architectures
Date: TBD (sometime in February) sorry for change
Location: Second Life Sun Islands (specific location will be defined soon)
Presenter: George Trujillo
Attendees: Sun Employees must have an avatar and access to the Sun Islands.
This internal Sun Microsystems second life presentation will teach attendees the fundamentals of the Oracle RAC and MySQL Cluster architectures. The presentation will start with the fundamentals of the Oracle single instance architecture then show the Oracle RAC architecture and how it differs from the a regular Oracle database server. The fundamentals of the MySQL Cluster architecture will then be shown. The presentation will wrap with a comparision of the Oracle RAC and MySQL Cluster architectures. Topics will include:
- The Oracle Instance
- Logical versus physical storage
- The Oracle Database - data files, index files, tablespaces, undo data, temporary data, redo log files and archive log files
- Oracle background processes - SMON, PMON, DBWR, LGWR, RECO, ARCH, ...
- The Listener
- Server processes
- Important memory and buffer caches - database buffer cache, shared pool area, log buffer, java pool area, ...
- Managing a database server with SQL\*Plus and the Oracle Enterprise Manager
- The Oracle RAC architecture
- Cache Fusion
- Shared disk strategy
- How an Oracle RAC server works
- The MySQL Cluster architecture
- MySQL instances
- How MySQL memory works
- Data nodes
- Management nodes
- Comparing Oracle RAC and MySQL Cluster
This is an excellent presentation for anyone that wants an understanding of how the Oracle RAC and MySQL Cluster architectures compare to each other.
Go to my blog entry Why Use Second Life? What's so great about it? to get a better understanding of second life, avatars and virtual worlds.