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, locking etc)
• The three components of scalability – Read Scalability/Write …

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 better indexes and provide even great performance gains.

This presentation …

In a few weeks, I will be on the road, for an intense set of presentations in the USA.

San Francisco, April 7thI 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, 12The MySQL conference starts on Monday, April 11th, with several three-hour tutorials.

• April 11, 9:00amMySQL Replication Advanced Techniques. This will cover MySQL replication beyond the basics. Everything you can do with replication, …

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:

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:

• On Wednesday, January 26th, I will be speaking about MySQL High Availability Solutions at the San Francisco MySQL Meetup. I feel honored for having been invited to speak there and I'm quite excited that venue is fully booked! I look forward to meeting so many MySQL users in one place.
• On Saturday, February 5th, I'll be attending and speaking at the MySQL & Friends Developer Room at FOSDEM 2011 in Brussels, Belgium. I helped organizing the DevRoom and preparing the schedule for this event. …

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 Francisco MySQL Meetup Group on Wednesday, 26th of January. …

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: | …

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: | …

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: | …

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, Xtrabackup and XtraDB next week which is great if …