At Effective MySQL we provide resources for the DBA, Developer and Architect to best use MySQL. This includes currently three books in our series, available in print, PDF and Kindle formats.
|Buy Now||Buy Now||Buy Now|
A hardware, software or human failure can occur at any time. Are you prepared?
Many organizations take a risk of serious data loss and system downtime with inadequate procedures in place to support a disaster recovery. This presentation covers the essentials of MySQL backup and recovery options, identifying the necessary tools for an effective strategy to support data resilience and business continuity for your organization. MySQL has no one single unbreakable backup solution, so it is important to understand the impact of MySQL replication, storage engines, configuration options for durability, hardware configuration and the impact on locking and uptime for the various hot/warm/cold options available.
Short Url: http://j.mp/EM-BandR
Presenter: Ronald Bradford
At Cloud Expo East 2013 I gave a presentation of my experiences in dealing with large AWS environments. In summary this included:
- Understanding AWS Products (especially the growth of new/revised products and pricing)
- Knowing the true Cost of your deployment and options with instances types, sizes and products
- Being prepared for Web Scale
- The importance of Security, what exists, the minimum you need to know working with external resources
- Why most Instrumentation fails due to sampling, and determining what is important for your business needs
- Failure will happen, not if, but when. Some things you should know
This week I was the guest speaker at the New York Linux Users Group (NYLUG) Meetup where I had the opportunity to talk about The history and future of the MySQL Ecosystem. This talk, titled “”Spaghetti and MySQLBalls (with a side of greens)” detailed the beginnings of MySQL, the MySQL acquisition history, described the state of current MySQL versions/variants/forks, storage engines, related vendors and much more. It was actually great to reminisce and share some of the great stories of the fantastic team at MySQL Inc/AB, and it amazed me as I presented just how many former employees have created companies in the ecosystem.
These Linux guys were also a great group to talk to, with lots of good questions and feedback. Many thanks to comments verbally and online including, “One of the best meetups I have been to. Ronald Bradford gave a great talk.”, “Ronald’s presentation was great. … the presentation really helped clear up a lot of longstanding confusion on the myriad of MySQL choices available…” and “Superb presentation and exactly what it said on the tin.”
A video of the presentation will be available soon.
Thanks to Tim Callaghan for speaking Tuesday night at the Effective MySQL New York meetup on Fractal Tree Indexes : Theory and Practice (MySQL and MongoDB). There was a good turnout and a full room to learn how the TokuDB storage engine from Tokutek is changing how to handle big data in MySQL.
Also interesting is how the same technology has been applied for use in MongoDB including giving MongoDB transactions; a big change for NoSQL.
Related News: Tokutek Meets Big Data Demand With Open Source TokuDB
There is a long list of new replication features in the latest MySQL 5.6 release including:
- Binary log group commit
- Multi-threaded slaves
- Crash-save slaves
- Global Transaction Identifier (GTID)
- Replication checksums
- Optimized row-based replication
- Time-delayed replication
- Remote binary log backup
This presentation from the MySQL Tech Tour events in New York and Boston provides an overview and syntax examples of many of these features. The Effective MySQL: Replication Techniques in Depth also discusses many of these features in detail. Chapter 3 is available for FREE download.
At the recent MySQL Tech Tour Events in New York and Boston I gave a presentation on MySQL integration with NoSQL,Big Data and the Cloud.
This covered discussion on topics including:
- Memcached API for InnoDB
- InnoDB Online Alter
- InnoDB Full Text Search (FTS)
- Partitioning inprovements for import/export
- SSD Optimisations
- Replication Improvements
- And much more …