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

Ronald Bradford is a busy man. He has just finished Effective MySQL: Optimizing SQL Statements, the first in a series of MySQL books. There is a sample chapter at the link above.

The chapters on indexing will be valuable to novices. Ronald has distilled his presentation on the use of EXPLAIN into chapter that should be made mandatory reading. The book is free of fluff and full of information that you will reference well after the initial reading.

For those of you at Oracle Open World, this book and others are heavily discounted in the bookstore on the second level of Moscone West, near the MySQL Community Kiosk.

PlanetMySQL Voting: Vote UP / Vote DOWN

It's great to see so many presentations and activities surrounding MySQL at Oracle Open World this year.  There are a lot of Dolphins around the conference which is great to see as well. They MySQL reception Tuesday evening is going to be a great opportunity to get caught up with everyone.
PlanetMySQL Voting: Vote UP / Vote DOWN

The MySQL Community Sessions at Oracle are going great. Good crowds, lots of questions about MySQL at the kiosk, and great presentations. Here Sarah Novotny gets camera time. I am not sure if her new show will be called ‘Two and a half DBAs’ or ‘The Big Data Theroy’.

PlanetMySQL Voting: Vote UP / Vote DOWN

I will be presenting at Oracle Open World but my presentation is not designed for a MySQL Audience. MySQL for Oracle DBAs or Speaking MySQL for Beginners will help Oracle DBAs embrace MySQL. Many Oracle shops also have MySQL and 11G or RAC DBAs can easily add MySQL skills to their existing set but can benefit from some gentle nudges in the right direction to get them started. Look for Session 15143 on Tuesday at 3:30 in Golden gate B at the Marriott Marquis. And do not forget the community reception after!

PlanetMySQL Voting: Vote UP / Vote DOWN

Virtualization is going to be one of the hottest topics at Oracle Open World 2011.   Here is a link to track a number of the virtualization presentations. http://www.oracle.com/openworld/oow11-focuson-virtualization-485282.pdf
PlanetMySQL Voting: Vote UP / Vote DOWN

Be sure to drop by the MySQL Demo Pod while you are attending Oracle Open World. There you will see a demo of the changes in MySQL Cluster 7.2. My favorite part of this release is that you can access the same data via SQL, LDAP, REST, memcached or via APIs. You get the best of both SQLand NoSQL worlds in one. At the Demo Pod, you can see how to see up multi-site clustering, simplified Active/Active replication, and how Adaptive Query Localization speed up joins. In the past, many cluster users avoid joins and simply used primary key or key/value pairs. But Adaptive Query Localization gets the data nodes to do more of the work in parallel.

And Cluster Administration has been greatly streamlined. So less typing gets you more performance.

So drop by the MySQL Demo Pod as you will want to see MySQL Cluster 7.2 in action. And there will be several session on cluster covering in detail things I have not mentioned here.

PlanetMySQL Voting: Vote UP / Vote DOWN

MySQL will be big at Oracle Open World. Not only are their demo pods, a community run area, and two community organized tracks on the first day! A full MySQL session track will be part of Open World for the first time. A full searchable list of all session with the options is available here a quick list of MySQL sessions is below. Note the sessions starting with IOUG are on Community Sunday on October 2nd. And the number after the title is the session id number.

If you register by August 12, there is a special early bird discount for the MySQL community. Use the code “MYSQL11″ during registration and save $1,000 over the on-site price.

1. Accelerating Telecom Transformation with Web 2.0 Data Management (20263)
2. Advanced MySQL Replication Architectures (15587)
3. Becoming a Rock Star MySQL DBA (20880)
4. Building Highly Available and Scalable Real-Time Services with MySQL Cluster (13702)
5. Cloud Computing Solutions for MySQL (15713)
6. Customer Success Stories: MySQL as an Embedded Database (20600)
7. Data Protection and Recovery for MySQL (15715)
8. Diagnosing Scalability Issues in Java Applications on MySQL (15742)
9. General Session: MySQL—The State of the Dolphin (20281)
10. Getting the Most Out of MySQL on Windows (20264)
11. Getting to Know MySQL Enterprise Monitor (15619)
12. IOUG: Bridging MySQL and Oracle Databases with Open Source Replication (27661)
13. IOUG: Challenges of Big Databases with MySQL (28682)
14. IOUG: Lessons Learned from Managing Way Too Many Database Servers (27680)
15. IOUG: Securing MySQL (31520)
16. Implementing Online Backup for Large-Scale MySQL Environments (31500)
17. InnoDB Performance Tuning (20020)
18. Introduction to InnoDB, MySQL’s Default Storage Engine (10042)
19. Introduction to MySQL Replication (15762)
20. Monitoring MySQL with Oracle Enterprise Manager Grid Control (30280)
21. MySQL Authentication Options (19181)
22. MySQL Crash Course: Overview of Basic MySQL Concepts (15423)
23. MySQL Efficiency on NetApp (8584)
24. MySQL Enterprise Backup (20260)
25. MySQL Monitoring Mechanisms: How the Different Pieces Fit Together (20280)
26. MySQL Performance Tuning at Ning (20265)
27. MySQL Server Performance Tuning 101 (16040)
28. MySQL Workbench: Developing MySQL Applications on Windows (30580)
29. MySQL for Oracle DBAs, or How to Speak MySQL for Beginners (15143)
30. MySQL: Don’t Be a Rookie Forever—Be in Command (Line) (29060)
31. MySQL: Explaining the MySQL Explain (29000)
32. MySQL: Importing and Exporting Data Between Hadoop and MySQL (29080)
33. MySQL: Improving Performance with Better Indexes (28980)
34. MySQL: Jailbreaking MySQL Replication (29021)
35. MySQL: Maatkit Tools—Like a MySQL Guru in a Box (29101)
36. MySQL: MySQL High Availability (29120)
37. MySQL: MySQL and SSD—Usage Patterns (29121)
38. MySQL: SQL Injection Myths and Fallacies (29081)
39. NoSQL Access to MySQL: The Best of Both Worlds (14141)
40. NoSQL Interfaces to MySQL Cluster (15702)
41. Operational Wins in MySQL Release 5.5 (20882)
42. Scaling and Monitoring MySQL for Rapidly Growing Social Gaming (14882)
43. The MySQL Roadmap: Discover What’s New (14740)
44. Ticketmaster: Building the Fastest Ticketing Site with MySQL and Oracle Database (21340)
45. Using MySQL with Other Oracle Products (20261)
46. What Causes Downtime in MySQL, and How Can You Prevent It? (9304)

PlanetMySQL Voting: Vote UP / Vote DOWN

The OpenWorld early bird pricing ends this Friday, July 29!

This is the last week to use the “MYSQL11″ special MySQL discount code
and get $1,000 over regular price, so please take time to share the code
again with customers/prospects or remind them to register by Friday.

Register here and remember to enter Priority Code MYSQL11 during registration.

Oracle OpenWorld will be held on October 2-6, 2011 in San Francisco, CA. This year, we’re offering even more MySQL content and networking activities as a track under the Database Stream, including:

• 30+ Conference Sessions
• Sunday User Group Sessions
• 3 Demo Pods
• 1 Hands-on Lab
• MySQL Customer Advisory Forum
• MySQL Community Reception

If you register by July 29, there is a special early bird discount for the MySQL community. Use the code “MYSQL11” during registration and save $1,000 over the regular price.

The MySQL track is jam-packed with sessions to get you up to speed on the latest technical innovations and community developments that are making MySQL an even better product. Featured sessions include:

• MySQL – The State of Dolphin, by Tomas Ulin
• Ticketmaster: Building the Fastest Ticketing Site with MySQL and Oracle Database, by Ed Presz
• MySQL Performance Tuning at Ning, by Chris Schneider and Tom Disheroon
• Becoming a Rock Star MySQL DBA, by Sheeri Cabral
• Operational Wins in MySQL Release 5.5, by Sarah Novotny

In addition to the MySQL track, the OpenWorld package also allows you to attend all the 2,000+ Oracle OpenWorld sessions, as well as the just-can’t-be-missed Appreciation Event featuring rock-and-roll legend Sting. Take advantage of the special MySQL discount and register today!

Register NOW and SAVE up to US$1,000

Enter Priority Code MYSQL11 during registration.



PlanetMySQL Voting: Vote UP / Vote DOWN