PlanetMysql.ru — информация о СУБД MySQL

This release is just a quick bug fix release of an older 1.1.1 version of the plug-in. It’s long overdue but I’ve managed to fix “” problem only couple weeks ago. I’ve distributed the new version to the folks who have reached out to me by email of via blog reporting the issue in the [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Chief Corporate Architect at Oracle, been at Oracle since 1986, technology and architecture decisions, responsible for all open source at Oracle. Company-wide initiatives on standards management and security — http://en.oreilly.com/mysql2010/public/schedule/detail/12440.

Where MySQL fits within Oracle’s structure.

Oracle’s Strategy: Complete. Open. Integrated. (compare with MySQL’s strategy: Fast, Reliable, Easy to Use).

Most of the $$ spent by companies is not on software, but on integration. So Oracle makes software based on open standards that integrates well.

Most of the components talk to each other through open standards, so that customers can use other products, and standardize on the technology, which makes it much more likely that customers will continue to use Oracle.

Oracle invested heavily in open source even before the acquisition. Linux (Oracle Unbreakable Linux = Oracle Enterprise Linux = OEL). Clustering, data integrity, storage validation, asynchronous I/O, virtualiation technology that has been accepted back into the Linux kernel. They have enhanced Xen, in order to make a good Oracle VM server for x86. With Sun, they now have VirtualBox. In the 3 years of OEL, they have over 4,500 companies.

Oracle never settles for being second best at any level of the stack.
“Complete” means we meet most customer requirements at every level.
That’s why Oracle matters to Oracle and Oracle customers.

MySQL is small, lightweight, easy to install and easy to manage. These are different from Oracle, so MySQL is the RIGHT choice for many applications, so by adding MySQL to Oracle’s database offerings, it makes the Oracle solution more complete.

Investing in MySQL means:
making MySQL a better MySQL. Keep MySQL the #1 db for web apps.
improve enginnering consulting and support
24×7, world-class oracle support

MySQL community edition: “If we stop investing in the community edition, MySQL will stop being ubiquitous”.

They want to focus even more effort on:
web
embedded
telecom
integration with other products in the LAMP stack
Windows — #1 download platform is Windows, but it’s not the #1 *deployment* platform.

They want to invest more money in allowing Oracle tools to work with MySQL too. For example, Oracle Enterprise Manager for monitoring, Oracle Secure Backup for backups, and Oracle Audit Vault for auditing. (Pythian already has a free Oracle Grid Control plugin to monitor MySQL).

Oracle will keep pluggable storage engine API, they are starting a Storage Engine Advisory Board to talk about their requirements and experiences and future plans and product direction.

MySQL 5.5 is beta, that’s the big news. InnoDB is the default storage engine there.

5.5 is much faster….including more than 10x improvement in recovery times. There’s a 200% read-only 200% performance gain. Read/Write performance gain is 364% faster than MySQL 5.1.40. These are for large # of concurrent connections, like 1024 connections.

Better object/connection management, database administration, data modelling in MySQL workbench.

MySQL Cluster 7.1, improved administration, higher performance, java connectors, carrier grade availability and performance. “Extreme availability”.

They’re also making support better — MySQL Enterprise — bettter.

MySQL Enterprise Backup – formerly InnoDB hot backup. This is now included in MySQL Enterprise, not a separately paid for feature.

(Demo of MySQL enterprise manager)

In conclusion:
MySQL is important to Oracle and our customers — it’s part of Oracle’s complete, open, integrated strategy. Oracle is making MySQL better TODAY. A “come to Oracle OpenWorld pitch (I’ve been, it certainly is a great conference.)

PlanetMySQL Voting: Vote UP / Vote DOWN

Oracle Open World 2009 is just few weeks away and I firmed up my presentation schedule now. I will present three “normal” presentations and couple unconference sessions. I’m arriving in San Francisco few days before the conference (7th of October) get to the Oracle ACE Directors briefing so I’ll spend the first few day in Redwood Shores and then off to Moscone Center.

Before I get to the schedule, if you want to catch up with me during OOW — tweet me @alexgorbachev. You are likely to see me in the OTN Lounge or in “The Cave” if you know what I’m talking about.

Here is a quick summary of my presentations:

Date & time	Session	Location
Sun,11-Sep 8:30-10:00	Demystifying Oracle Real Application Clusters Workload Management	Moscone West L2 Room 2001
Mon,12-Sep 11:30 - 12:30	Developing Plug-ins for Oracle Enterprise Manager by Example (MySQL plug-in)	Moscone South Room 270
Tue,13-Sep 11:30 - 12:30	Making Oracle E-Business Suite Highly Available: What’s the Path?	Moscone South Room 236
Tue,13-Sep 14:00 - 16:00	Unconference: Under The Hood of Oracle Clusterware with live demo & QA (2 slots)	Moscone West L3 Overlook II
Wed,14-Sep 10:00 - 11:00	Unconference: HA DBA Roundtable: How Do You Make DBA’s Highly Available?	Moscone West L3 Overlook I

My first presentation starts on Sunday as part of the Oracle User Groups Forum. It’s one and a half hour long session and as far as I know it’s the only long slot available on Sunday. The penalty is to start at 8:30am so I’ll see you all fresh that morning! :) I have presented on Sunday last year (also a long session with demos) and it was great success — it was standing room only and I know few people could get in (that’s why I’m repeating the session this year as part of unconference — see below). If you want to make sure to have a spot — use Schedule Builder and register for the session. Last time, I’ve done this presentation as the master class at the UKOUG Conference 2008 and it was very successful session. I will most likely pre-record the demos to make sure we fit in the allocated time — there is lots of content.

The next presentation is on Monday and I’m very much looking forward to that one. While the presentation is about building monitoring plug-ins for Grid Control, the example is based on the MySQL plug-in, which I wrote and that Pythian published as free software and Oracle validated the plug-in working closely with us. I had proposed this session for the last year but I guess I’ve made a mistake of adding the MySQL in the title. :) This year I removed MySQL from the title and the presentation passed through the Oracle Mix voting being in the top 10.

The last of my “normal” conference sessions in on Tuesday at 11:30 — just in time before the lunch break. This is a rather unusual area for me as the talk is about E-Business Suite and how to design EBS environment for high availability. While I’m not an Apps DBA, I’ve been digging into that area quite a bit recently and I’ve done this talk here in Sydney during AUSOUG InSync 09 conference.

Finally, I’m doing couple unconference sessions. Many people asked for a repeat of my last year’s presentation “Under the Hood of Oracle Clusterware” which was a huge success so I decided to put that session into unconference schedule. I have reserved a double slot as there is a live demo and it takes some time. In addition, there is always quite a bit of follow up during this presentation so I don’t mind to get side-tracked and dig into live environment that I will have setup for this demo. In addition, we should check out what’s new in 11g Release 2 Clusterware (re-branded as Grid Infrastructure).

The last unconference session is on Wednesday and I decided to make it less of a presentation but more like a roundtable. I hope that my role would be as just a moderator as I would be looking forward to get more participation from the attendees and share methods and tools that various companies adopted to make their teams highly available. I’m also excited to have Paul Vallee by my side as he has lots of insights on this topic. The idea behind this session is that very little is told about organizing a proper round the clock support team. I’ve seen lots of situations when companies deploy expensive HA solutions without thinking about organizing seamless support from their engineers so it’s “normal” for one or two engineers to be “chained to the desk” and on the hook 24×7 no weekends and vacations. I would be more than happy to bring forward and discuss how we handle it at Pythian but I would like to see more contributions from the attendees and not make it look like a Pythian marketing plug. :) It’s not about DBA support only — it’s just that “HA DBA” sounds really cool!

And don’t forget about Bloggers Meetup this year. I’m organizing it with the help of OTN and it should be good fun this year.

PlanetMySQL Voting: Vote UP / Vote DOWN

I have just released a new version of the MySQL plug-in for Oracle Enterprise Manager — MySQL plug-in 1.1.1. This is a long overdue bug fix release.

There are no new features implemented (we have another branch in development) but just fixed number of fairly annoying bugs that I was finally able to reproduce.

The download link is on the plug-in’s home page where you can also find a data-sheet and installation guide.

Here are the changes in the 1.1.1 release:

• Tested with Oracle Enterprise Manager Grid Control 10g Release 5 (10.2.0.5)
• Fixed the bug with connections not closed properly
• Fixed bug that caused collection to hang and time-out (Net::MySQL bug — not recognizing a final packet in result-set)
• Fixed bug that caused collection processes to spin on CPU (Net::MySQL bug when zero length packet returned from the socket — very weird why it happens)
• Fixed few bugs in Commands and Executions report - graphs produced errors from time to time
• Removed columns Compression and Tc_log_% in Others metric
• Changed metric Opened_tables into ratio per second

I have tested it on Linux and Windows with MySQL 5.0 and 5.1. Please do post here in the comments to confirm that it works on your release and provide the following info:

• Oracle Grid Control Server (OMS) version
• Oracle Agent version
• Operating Sysytem and version
• MySQL version and the details of the build
• Do you monitor MySQL instance running locally (on the same host as Oracle Agent) or remotely

This will help the whole community and confirm that there are no platform/version specific issues. I will take care of summarizing your comments — don’t be afraid to duplicate the info. Thanks!

Any issues please report here as usual.

PlanetMySQL Voting: Vote UP / Vote DOWN