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

I hinted last week of my acceptance with Oracle before the formal announcement this week at the MySQL Users Conference, not for a job but as Oracle ACE Director. In today’s State of the MySQL Community keynote by Kaj Arnö I was one of the first three MySQL nominees that are now part of this program.

What exactly is an ACE Director? Using the description from the Oracle website.

Oracle ACEs and Oracle ACE Directors are known for their strong credentials as Oracle community enthusiasts and advocates, with candidates nominated by anyone in the Oracle Technology and Applications communities. The baseline requirements are the same for both designations; however, Oracle ACE Directors work more closely and formally with Oracle in terms of their community activity.

What does this mean to me?

As a significant contributor to the community I now have the opportunity to continue as well as to contribute to how Oracle continues to interact, promote and involve the MySQL community. As stewards our role as an Oracle ACE Director is to be actively involved. I look forward to the challenge to help shape and improve our State of the MySQL Community.

News and References
Welcome, Oracle ACE Directors for MySQL

Edward Screven – Chief Corporate Architect of Oracle provided the opening keynote at the 2010 MySQL Users Conference.

Overall I was disappointed. The first half was more an Oracle Sales pitch, we had some product announcements, we had some 5.5 performance buzz. While a few numbers and features were indeed great to hear, there was a clear lack of information to the MySQL ecosystem including employees, alumni and various support services. I hope more is unveiled this week.

Some notes of the session.

• Oracle’s Strategy covers storage, servers, virtual machines, operating system, database, middleware, applications
• We build a complete technology stack that is “open” and “integrated” based on “open standards”
• products talk via open standards with the intention for customers to not feel locked in to any technology
• Examples include apache, java, linux, xen, eclipse, and innodb
• Unbreakable linux has now over 4,500 customers

After the sales pitch we got down to more about MySQL.

What MySQL means to Oracle? We make the Oracle solution more complete as a stack for customers.

What is the investment in MySQL?

• Make MySQL a better MySQL
• Develop, promote and support MySQL
• MySQL community edition

Integration with Oracle Enterprise Manager, Oracle Secure Backup and Oracle Audit Vault infrastructure. *This I expected and have blogged about, so I’m glad to see this commitment.

MySQL 5.5 is now in Alpha, some features are

• InnoDB will be default engine
• Semi sync replication
• Replication heartbeat
• Signal
• Performance Schema

MySQL 5.5 is planned on being faster with Innodb Performance Improvements & MySQL Performance Improvements.
MySQL 5.5 sysbench claims, read 200% faster, write 364% faster.

MySQL Workbench 5.2 announcement

• SQL Development
• Database Administration
• Data Modelling

MySQL Cluster 7.1 GA announcement

• Improved Administration
• Higher Performance
• Carrier Grade Availability & Performance

MySQL Enterprise Backup announcement

• Online backup for InnoDB only
• Formally InnoDB hot backup with additional features including incremental backups

MySQL Enterprise Monitor 2.2 Beta announcment

In closing the statement was “MySQL lets Oracle be more complete at the database layer”. Is that good for the MySQL Community or better for the Oracle revenue model?

Many Percona employees will be at the 2010 MySQL conference. We’ll be giving a lot of informative technical talks on various topics. Here’s a list:

• Morgan Tocker, Baron Schwartz: Diagnosing and Fixing MySQL Performance Problems
• Peter Zaitsev: Scaling Applications with Caching, Sharding and Replication
• Baron Schwartz: EXPLAIN Demystified
• Vadim Tkachenko: An Overview of Flash Storage for Databases
• Matt Yonkovit: The Five Minute DBA
• Bill Schuler, Baron Schwartz: Performance and Feature Enhancements to MySQL and InnoDB
• Fernando Ipar: PHP Object-Relational Mapping Libraries In Action
• Baron Schwartz: Read-Write Splitting: Techniques, Challenges, and Solutions
• Matt Yonkovit, Yves Trudeau: Choosing the Right Tools for the Job, SQL or NOSQL
• Vadim Tkachenko, et al: Panel: How Solid-state Technologies are Transforming MySQL Server Performance and the Datacenter Architectures
• Morgan Tocker: Understanding the Role of IO As a Bottleneck
• Baron Schwartz: MySQL Graphing and Trending with Cacti
• Vadim Tkachenko: XtraBackup: Hot Backups and More
• Aleksandr Kuzminsky: Recovery of Lost or Corrupted InnoDB Tables
• Ryan Lowe: Achieving PCI Compliance with MySQL
• Yves Trudeau: How to choose High Availability solutions for MySQL
• Yasufumi Kinoshita: How to Fulfil the Potential of InnoDB’s Performance and Scalability
• Peter Zaitsev: Choosing Hardware and Operating Systems for MySQL
• Peter Zaitsev: Instrumenting your Application for MySQL and Memcached
• Peter Zaitsev: InnoDB Architecture and Performance Optimization – Part 1 and InnoDB Architecture and Performance Optimization – Part 2

In addition, you’ll be able to visit us at our booth in the expo hall, where you can play Stump The Experts with your tough problems. And Daniel Nichter will be staffing the Maatkit booth, so you can ask him all about Maatkit. If Maatkit is of interest to you, you might also want to attend the Maatkit BoF session.

We look forward to seeing you there. It’s going to be a great conference!

Entry posted by Baron Schwartz | No comment

Add to: | | | |

I’ve submitted a Birds of a Feather session for Maatkit at the upcoming MySQL conference. It’s not on the public schedule yet, but it has been accepted and scheduled for 19:00 on 13 Apr 2010. See you there!

Related posts:

1. Presentation uploaded for Maatkit talk at MySQL Conference The slides
2. I’ll be speaking at the O’Reilly MySQL Conference 2010 I’m
3. Learn about Maatkit at the MySQL Conference I’m

Related posts brought to you by Yet Another Related Posts Plugin.

One of my colleagues, Ryan Lowe, has just heard that his session on PCI compliance with MySQL has been accepted at the upcoming MySQL conference. Ryan is highly qualified to present this topic, and not many people can say that; I certainly can’t claim that title myself. If you’re looking to learn how to make your MySQL installation PCI-compliant, there’s also not a lot of trustworthy information online. Personally — and really, no bias just because he’s my colleague — I think this is a great session for the MySQL conference, which I sometimes thought didn’t have enough diversity of topics in past years. We need more stuff like this to give people a reason to return after they’ve gone for 2 or 3 years in a row.

Related posts:

1. Learn about Maatkit at the MySQL Conference I’m
2. Learn about mk-query-digest at PgEast 2010 I’ll
3. There will be an O’Reilly MySQL Conference in April 2010 O’Re

Related posts brought to you by Yet Another Related Posts Plugin.

For those of you on the O’Reilly MySQL conference list you will no doubt see this email, but for readers here is the important bits.

Oracle Executive Will Speak at O’Reilly MySQL Conference & Expo
Edward Screven to Answer Questions re: Future of MySQL

Edward Screven reports to CEO Larry Ellison, and he drives technology and architecture decisions across all Oracle products to ensure that product directions are consistent with Oracle’s overall strategy. He’ll discuss the current and future state of MySQL, now part of the Oracle family of products. His presentation will also cover Oracle’s investment in MySQL technology and community, as well as the role that open source in general is playing within heterogeneous customer environments around the world.

I have not found a link yet to provide reference to this.

I’m speaking at the O’Reilly MySQL Conference 2010. I hope I don’t lose my voice, because I have four sessions!

• Diagnosing and Fixing MySQL Performance Problems
• EXPLAIN Demystified
• Read-Write Splitting: Techniques, Challenges, and Solutions
• MySQL Graphing and Trending with Cacti

You can click through on the links above to learn more about each session. I’m also looking forward to the other sessions. Here’s a sample of a few that I have my eye on:

• Linux performance tuning and stabilization tips by Yoshinori Matsunobu
• MySQL Proxy meets: Memcache by Jan Kneschke
• PHP Object-Relational Mapping Libraries In Action by Fernando Ipar

The schedule is far from complete, because the conference committee is still working on it, but the proposals to choose from are impressive. Stay tuned as more talks are approved and the schedule fills out, and don’t wait too long to register and book your flight! This is going to be a banner year.

Related posts:

1. Submit your proposals for MySQL conference 2010 The MySQL
2. There will be an O’Reilly MySQL Conference in April 2010 O’Re
3. Speaking at EdUI Conference 2009 I’m

Related posts brought to you by Yet Another Related Posts Plugin.

At the recent FOSDEM 2010 event, I presented in my keynote Dolphins, now and beyond a option which I termed the “Blue Pill” or the “Red Pill”. The following slide produced noticed interest in a packed room, and subsequent conversation.

While the ownership of MySQL has changed, the option between MySQL and Oracle as a product for use still remains. While MySQL is the most popular for modern online applications, Oracle continues to have the widely used enterprise database product and has a large number of Oracle DBAs in the IT marketplace.

Over the past 5 years I have presented a number of topics on MySQL for Oracle DBA’s. At the upcoming MySQL Users Conference 2010 I will be presenting the first two talks in my new series “MySQLCamp for the Oracle DBA”.

• IGNITION – is the preparation necessary for a successful launch of a MySQL ecosystem for an Oracle DBA. This volume covers the preparation needed to be ready for ongoing production administration of MySQL.
• LIFTOFF – Only after a successful preparation covered in IGNITION can you be ready for the implementation and management of a MySQL ecosystem and a successful launch of your product.

My talk on 10x performance improvements – A case study has just been approved for the 2010 MySQL Conference. This will be my 5th straight year speaking at the MySQL conferences. For those in Europe wanting a sneak peek I am also speaking at FOSDEM 2010 in Brussels on Feb 7th where I’ll be giving an abridged version.

As an independent MySQL consultant, my work generally covers performance tuning and scalability and sometimes database architecture. Often however my work involves a review of a given problem and recommendations (immediate, short and long term). I’m rarely involved in the full implementation and generally do not see the full fruits of the proposed work.

Recently however I was able to work with a client, first in resolving critical performance issues and then in a review of the application architecture and MySQL environment, provide recommendations and also helping internal resources in the successful implementation. The result was a very successful engagement and an ideal case study on a strategy for tackling improving performance of an application using MySQL.

With an existing environment that included a MySQL master, 3 database slaves and 6 web servers this application provided the grounds of a well sized configuration and the need for greater availability and scalability.

The Call for Papers for the 2010 MySQL conference is still open. If you would like to share your experiences with MySQL submit your talk today.