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|
This presentation from the MySQL/NoSQL/Cloud Conference in Latin America provides my experiences of the most common problems managing MySQL Operations in general with customers, and a number of current problems experienced recently.
Many consider the ease of installation and use of MySQL as a selling point, however MySQL installation is not install and forget. It sounds simple, however there are many important decisions that have long lasting effects. The choice of version, choice of repo, choice of variant is just the beginning.
The appropriate configuration before any application uses the MySQL instance is also critical. Some decisions can lead to data integrity issues that can be difficult or impossible to correct without expensive rework. The decision regarding timezone management is one point discussed in detail.
However the greatest impact to the time and energy of MySQL operations is application development. The use of frameworks, the absence of knowledge of writing SQL, the lack or abuse of transactions all contribute to unnecessary complexity and stress in ensuring a performing and highly available MySQL infrastructure.
Day to day, tasks including testing and managing MySQL upgrades in a 24x7x365 environment, changing QEPs due to data distribution, complexities in point in time recovery with triggers, ROW base replication are all edge cases that have to be experienced to understand that MySQL operations is a detailed process to manage and support.
The outline of this presentation includes:
- What is Operations
- Operations Woes
- Day to day problems
- Other experiences
I recently completed a four country tour of Baltic Sea countries presenting this seminar series at:
- Helsinki, Finland on Wednesday August 20.
- Stockholm, Sweden on Thursday August 21.
- Riga, Lavtia on Tuesday August 26.
- Talinn, Estonia on Wednesday August 27.
This seminar of four presentations provided a detailed review of the essential lifecycle components for developing a successful software application and offered a checklist for your company to review the design, development, deployment and support practices of your MySQL business applications. Presentations included:
NOTE: More detailed posts which include detailed links will be released soon.
Effective MySQL Architecture and Design Practices
Correctly designing a MySQL architecture has a huge impact on the growth of your system for future needs. This presentation covered some key business and technology decisions that should be asked and discussed before building a MySQL based system.
Effective Software Development with MySQL
While the MySQL RDBMS is essential for storing your information, how your application interacts with applicable business logic is what makes each company in unique. Ensuring the practices of your developers can deliver reliable and maintainable systems cost effectively is important for success.
Upcoming MySQL features for modern applications
Are you running a legacy version of MySQL that is no longer supported? Oracle has provided three versions since purchasing Sun Microsystems in 2010. This presentation discusses the current and upcoming features of the various MySQL versions and provide insights into why these new features are important for developing modern applications.
Effective Web Site Operations
It is very important for companies to be able to support and manage your MySQL installation and related technology stack. This presentation included being prepared for handling software, OS or dependency upgrades. Ensuring the right backup and recovery procedures and correct testing and verification to avoid common pitfalls. Monitoring, alerting and instrumentation options.
This overview of MySQL provided a background of the history, ecosystem, current community and commercial products available.
A special thank you to all the organizers and sponsors that made each of these events possible. It takes a lot of work for organizers and event locations to enable attendees to get the best event possible.
- Heli Helskyaho, EMEA Oracle User Group President
- Petri Koistinen from the Finland MySQL Users Group
- Solinor. Sponsor and host for Finland event.
- Olle Nilsson and Thomas Johansson from the Sweden MySQL Users Group and Ted Wennmark from Oracle Sweden.
- B3IT. Sponsor and host for Sweden event.
- Andrejs Vorobjovs from the Oracle Users Group Latvia
- BDA. Sponsor and host for Latvia event. DBACC our beer sponsor for after event
- Ilmar Kerm from the Oracle Users Group Estonia
- TransferWise. Sponsor and host for Estonia event.
- Vikka Lira – Oracle ACE Program
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