Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 186 Next 30 Older Entries

Displaying posts with tag: Presentation (reset)

MySQL Best Practices for DBAs and Developers
+0 Vote Up -0Vote Down

Download PDF
Presentation Part I

Download PDF
Presentation Part 2

Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Learn what subtle differences between Oracle and MySQL are essential to understand in order to maximize the benefits of MySQL. We will be covering the ideal means for writing SQL statements,





  [Read more...]
Common MySQL Scalability Mistakes
+0 Vote Up -0Vote Down

Download PDF Presentation

The most common mistakes are easy to avoid however many startups continue to fall prey, with the impact including large re-design costs, delays in new feature releases, lower staff productivity and less then ideal ROI. All growing and successful sites need to achieve higher Availability, seamless Scalability and proven Resilience. Know the right MySQL environment to provide a suitable architecture and application design to support these essential needs.

  • The different types of accessible data (e.g. R/W, R, none)
  • What limits MySQL availability (e.g software upgrades, blocking statements,

  [Read more...]
Better Indexes $ave You Money
+0 Vote Up -0Vote Down

Download PDF
Presentation

Can database performance improvements be achieved with zero code changes? Learn how to use one simple advanced technique to make better MySQL indexes and improve your queries by 500% or more. Even with a highly indexed schema as shown in our 10 table join example, significant improvements in performance can be achieved.

This presentation introduces the approach for correct identification and verification of problem SQL statements and then describes the means of identifying index choices for optimization. Then discussed is not only how to apply indexes to improve query performance, but how to apply



  [Read more...]
Replication and sandbox talks on the road - San Francisco, Santa Clara, Orlando
+3 Vote Up -1Vote Down
In a few weeks, I will be on the road, for an intense set of presentations in the USA.

San Francisco, April 7th

I will start the tour at the San Francisco MySQL User Group. On April 7, at 6pm I will talk about Advanced MySQL replication for the masses. This talk will explore topics such as bi-directional replication, multiple sources, parallel replication, seamless failover, with the help of Tungsten replicator.




Santa Clara, April 11, 12

The MySQL conference starts on Monday, April 11th, with several three-hour tutorials.
  • April 11, 9:00am








  [Read more...]
Announcing the FOSDEM MySQL & Friends DevRoom schedule
Employee +4 Vote Up -0Vote Down

It was ready for a while already, but now it's part of the official FOSDEM schedule as well: I am very pleased to announce the presentations and speakers of the MySQL & Friends Developer Room, which will take place this coming Saturday (5th of February) in Brussels, Belgium.

This year, our DevRoom will be located in room H.2213 (in the H Building), which has a capacity of up to 100 people and will be available to us from 13:00-19:00 o'clock. We have 12 sessions lined up, each will last 25 minutes (incl. Q&A). Without further ado, here's our schedule:

Time Speaker Session Title 13:00-13:25 Lenz Grimmer  [Read more...]
Upcoming speaking engagements: SF MySQL Meetup, FOSDEM, GUUG FFG and COLLABORATE 11
Employee +3 Vote Up -0Vote Down

My calendar is filling up with speaking engagements about MySQL at various events quickly. Here is a list of events for the coming months where I'll be present:

  [Read more...]
Speaking about MySQL High Availability at the San Francisco MySQL Meetup Group (Jan 26th)
Employee +7 Vote Up -0Vote Down

I will be in the Bay Area at the end of this month, to attend a summit of the IOUC (International Oracle Users Group Community), to talk about MySQL and to meet with the organizers of Oracle User Groups worldwide. MySQL is a big topic for many members of their groups, I am looking forward to learn more about their activities and how we can better collaborate in the future. My recent experiences at the DOAG Conference in Nuremberg and the UKOUG Conference in Birmingham were quite positive — I was very pleased by the number of attendees at the MySQL sessions.

Since I'm so close to San Francisco, I gladly accepted the invitation to speak at the San

  [Read more...]
Speaking on MySQL/PHP Meetup in Charlotte, NC
+1 Vote Up -0Vote Down

I'm speaking at MySQL/PHP Meetup at Charlotte,NC next week with topic being Scaling MySQL Applications. We will have a presentation probably for about an hour and the good amount of time for questions. So come prepared.

Great thanks to Red Ventures, LLC for help organizing and sponsoring this event. I'm hearing there are going to be a door prizes, some snacks and drinks available on this event.


Entry posted by Peter Zaitsev | No comment

Add to:

  [Read more...]
Recordings for webinars are now online
+1 Vote Up -0Vote Down

We've just published the recordings for our webinars; Migrating MyISAM to InnoDB and Introduction to Percona Server, XtraDB and Xtrabackup.  To listen, click on (Watch: Recorded Webinar) on each of these links.

We're planning for future webinars next year.  If you have any suggestions, feel free to leave a comment.


Entry posted by Morgan Tocker | 5 comments

Add to:

  [Read more...]
Speaking at MySQL Meetup event in NYC, December 15
+1 Vote Up -0Vote Down

I'm going to be in NY next week and as part of the meeting I agreed to speak on New York MySQL Meetup. I'm going to speak about
Scaling MySQL driven applications by us of caching, replication, sharding and other technologies. Hope to see you there.


Entry posted by Peter Zaitsev | No comment

Add to: |


  [Read more...]
Doing Re-run of Migrating MyISAM to Innodb Webinar
+0 Vote Up -0Vote Down

We had some technical difficulties with Webex today which prevented from all registered attendees to be able to join webinar. I personally would be very upset having booked my time to attend event, pre-registered to ensure there is a space available and when unable to join at the time of event (which is frankly exactly what happened to me).

As result we have scheduled Migrating MyISAM to Innodb webinar to run again on Tuesday, December 7 at 9AM Pacific (Same Time). Here is direct link if you would like to register.

Note we also Webinar on Percona Server,

  [Read more...]
This Wednesday: Free MySQL talks at the UKOUG Conference in Birmingham (UK)
Employee +2 Vote Up -0Vote Down

Hello from Birmingham, UK! I'm here to attend and speak at the UKOUG Technology & E-Business Suite 2010 conference (what a name!) We actually have two packed tracks of MySQL Sessions this Wednesday, including a keynote by Richard Mason (Vice President of MySQL Sales and Consulting at Oracle) about Oracle's strategy and plans for MySQL as well as highly technical sessions about MySQL High Availability, Scalability and Performance tuning from experts in the field. Ronald Bradford, Oracle Ace Director and long-time MySQL community advocate will also be there, speaking about

  [Read more...]
My Presentation at the DOAG 2010
+5 Vote Up -0Vote Down
Yesterday I presented PBXT: A Transactional Storage Engine for MySQL at the German Oracle User Group Conference (DOAG) in Nuremberg. A number of people asked for the slides, so here is the link.

The talk was scheduled to be in English, but since I had a German-only audience I presented in German. There was quite a bit of interest, particularly in the Engine Level replication built into PBXT 2.0.

As Ronny observed, this feature can be used effectively for many tasks, including for online backup and maintaining a hot-standby. This all with the addition of a "small" feature:

The Master could initially stream the entire database over to the Slave before actual replication begins. This would also make it extremely easy to setup replication.

A brilliant idea, but a good 3 months work...
Back from Lisbon, off to Nuremberg
Employee +3 Vote Up -0Vote Down

Yesterday afternoon I returned from the SAPO CodeBits 2010 conference, which took place in Lisbon, Portugal. Just like the previous year, CodeBits has been a great conference to be at and I am grateful for having been selected for participation. Thursday, the first conference day was quite a busy one for me — I gave two presentations in a row:

Afterwards, I also participated in a panel discussion about "To SQL or not to

  [Read more...]
Talks in Moscow, Minsk, Samara
+3 Vote Up -0Vote Down

I have my schedule pretty busy during a trip to Russia this year. In addition to giving a master class and Sphinx Conference I'm going to speak at HighLoad++. I'll also have a user meeting presentations in Samara on October 17 and Minsk on October 22 This looks like it is going to be a lot

  [Read more...]
Diagnosing and fixing MySQL Performance Problems in Russian in Moscow, Russia
+0 Vote Up -1Vote Down

During my visit to Moscow, Russia next month I’m going to give a full day training/tutorial presentation on Diagnosing and Fixing MySQL Performance Problems . This even will be based on updated and expanded tutorial from MySQL Conference & Expo which was so popular it was sold out earlier this year. This also will be the only full day training event open to the public during this trip. There are few conference talks, user meetings and private training engagements which I’m doing on this trip as well. I’ll blog about these later.


Entry posted by peter |

  [Read more...]
OpenSQL Camp Europe and FrOSCon: A summary
Employee +4 Vote Up -0Vote Down

With OpenSQL Camp and FrOSCon being over for almost a week now, it's time to come up with a short summary. I traveled home on Monday morning and then took Tuesday off, so I had some catching up to do...

As for the past years, FrOSCon rocked again! According to the closing keynote, they had around 1.500 (unique) visitors and I had a great time there. I really enjoyed meeting all the old and new faces of the various Open Source communities. The lineup of speakers was excellent, Jon "maddog" Hall's keynote about "Free and Open Source Software in the Developing World" was quite insightful and inspiring.

Most of the time I was busy with

  [Read more...]
Speaking at the DOAG Conference in Nuremberg
Employee +2 Vote Up -0Vote Down

The DOAG ("Deutsche ORACLE Anwendergruppe e.V.") is the German association of users of Oracle products. In November 2010 (16th-18th), they will hold their annual Oracle Users Conference 2010, which will take place in Nuremberg, Germany.

This event is quite an institution – it has been established more than 20 years ago already. This year, there will be more than 400 sessions by over 300 speakers. For the first time, this year's conference will also have a dedicated stream of sessions about MySQL and I'm happy to announce that I'll be there, too, giving an overview of the various MySQL Replication Technologies as well as a glimpse into a MySQL DBA's toolchest.

Here's the full list of MySQL sessions, as of today:

Tuesday 2010-11-16

      [Read more...]
    OpenSQL Camp Europe: Some last-minute changes to the schedule
    Employee +0 Vote Up -0Vote Down

    In just two days the OpenSQL Camp Europe (hosted by the excellent FrOSCon) will kick off!

    We've had a few last-minute changes to the schedule, as some speakers could not make it due to visa or family issues. But we managed to keep all slots filled on both days and I think we've come up with a very nice program! In addition to the two sessions I already had, I've volunteered to take over Giuseppe's talk about Shooting from the Hip. MySQL at the Command Line.

    The most up-to-date version of the schedule is on the OpenSQL Camp Wiki, I expect the remaining changes to be reflected on the

      [Read more...]
    Reminder - UKOUG Conference CfP closes next Monday!
    Employee +1 Vote Up -0Vote Down

    I just wanted to send out a friendly reminder: you still have time until next Monday, 16th of August, 8:00 am (UK) to submit MySQL-related talk proposals for the Conference Series Technology & E-Business Suite 2010 conference which will take place in Birmingham (Nov. 29th - Dec. 1st). The UK Oracle User Group is looking forward to set up a dedicated track with great talks about MySQL! Thank you.

    CORRECTION: MySQL Idiosyncrasies that BITE Webinar
    +0 Vote Up -0Vote Down

    If you have not looked at my recent presentation that I presented at ODTUG Kaleidoscope 2010, then feel free to join me on Tuesday, July 27, 2010 6:00 PM – 7:00 PM EDT tomorrow at 5pm EDT when I will giving a webinar on this talk. You can register online at https://www1.gotomeeting.com/register/730452824

    A parallel universe
    +0 Vote Up -2Vote Down

    What happens when you mention Open Office and Firewall in once sentence, in public ?

    People start actually building it (French Article)

    Then add to that list that there's also people out there that think that running MySQL over NFS is providing them High Availability, or that using DNS Round Robin will provide them a scalable setup,

    So yes .. apparently there is indeed a parallel universe out there.

    And no .. I don't want to see Webmin in any Appliance .. that is a joke..., or rather a rant ..

    Technorati Tags:   [Read more...]
    Slides from my MySQL UC 2010 presentation
    +1 Vote Up -0Vote Down

    As requested by a few fans out there, here are the slides of my presentation:

    Pentaho Data Integration 4.0 and MySQL.pdf

    I had a great time at the conference, met a lot of nice folks, friends, customers, partners and colleagues. After the conference I was unable to get back home like so many of you because of the Paul Simon singing Eyjafjallajökul volcano in Iceland.

    So I ended up flying over to Orlando for a week of brutal PDI 4.0 RC1 hacking with the rest of the l33t super Pentaho development team.  However, after 2+ weeks from home, even a severe storm over Philadelphia couldn’t prevent me from getting home eventually.

    Until next time,
    Matt

    2010 O’Reilly MySQL Conference Slides and Videos
    +7 Vote Up -1Vote Down

    Here’s a matrix of all the videos up on YouTube for the 2010 O’Reilly MySQL Conference and Expo. The matrix includes the title, presenter, slide link (if it exists), video link, and link to the official conference detail page, where you can rate the session and provide feedback that the presenter will see. They are grouped mostly by topic, except for the main stage events (keynote, ignite) and interviews.

    If there’s a detail missing (ie, slides, or there are other videos you know about), please add a comment so I can make this a complete matrix.TitlePresenterSlidesVideo link
    (hr:min:sec)Details (Conf. site link)

    Keynotes

    State of the DolphinEdward Screven (Oracle)29:10

      [Read more...]
    Slides from my Sphinx talk at RIT++ 2010
    +0 Vote Up -0Vote Down

    While the majority of Percona gang travelled to California for the MySQL event of the year, I headed in the opposite direction to Moscow for RIT++ 2010 conference where I presented a talk on Sphinx. You can get the PDF file here - Improving MySQL-based applications performance with Sphinx.

     

     

    I have been invited to talk at Open Source Data Center Conference in Nürnberg, Germany in June this year, so I hope I can meet some of you there.

      [Read more...]
    Slides of the PBXT Presentation
    +1 Vote Up -0Vote Down
    Here are the slides to my talk yesterday: A Practical Guide to the PBXT Storage Engine.

    For anyone who missed my talk, I think it is worth going through the slides, because the are fairly self explanatory.

    If there are any questions, please post them as a comment to the blog. I will be glad to answer :)
    Upcoming speaking engagements: Grazer Linuxtage and amoocon
    Employee +1 Vote Up -0Vote Down

    As I already wrote, I will be speaking at the MySQL Conference & Expo in Santa Clara in two weeks and I am excited to be there again. This year's conference is going to be interesting for a number of reasons, but most importantly I think that the schedule looks great! This is going to be a "drinking from the firehose of MySQL knowledge" event. Afterwards, I'll be on parental leave in May and June, so I likely will miss a lot of great conferences – these months are usually quite packed, as our Open Source Events Calendar can confirm. I just

      [Read more...]
    Loadays CFP
    +0 Vote Up -0Vote Down

    I would like to point the crowd to the Call For Presentaions of Loadays. , the Linux Open Administration Days .


    The Linux Open Administration days 2010 will be the first edition of a new conference focusing on Linux and Open Administration, we are trying to fill a gap for System Engineers and Administrators using Open Source technologies"

    More details on the Linux Open Administration Days site

    I'll probably be there .. given the fact that the event will be 5 minutes from where I live .

    Technorati Tags: antwerpen cfp conference
      [Read more...]
    Basic Joins and Subqueries Video
    +1 Vote Up -0Vote Down

    Last month at the Boston MySQL User Group, I went through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. I also explained how to recognize when you want those types of joins, and best practices for the semantics of writing joins and design patterns. Subqueries were explained in this session, and some examples of how to think differently so that you end up writing JOINs instead of subqueries. The slides (slightly different from the slides in the video — due to error correction) can be found at http://technocation.org/files/doc/2010_01MySQLJoins.pdf.

    Here’s the video:

    Read this before submitting a conference proposal
    +5 Vote Up -1Vote Down

    The O’Reilly MySQL Conference & Expo 2010 Call for Participation ends in just under 3 weeks. I am on the conference committee, and thus get to see and review all the conference proposals.

    This blog post will briefly explain the how each part of the proposal is used, then have a list of what not to do in your conference proposal, and end with a checklist of questions to go over your proposal before submitting. Click here if you want to skip to the checklist.


    The proposal has several parts.
    Title: This is the title of your presentation. This shows

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 186 Next 30 Older Entries

    Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.