Developing modern applications using MySQL.
In this seminar series learn how to best use MySQL for your existing and new development requirements with leading MySQL expert and Oracle Ace Director Ronald Bradford.
These presentations provide a detailed review of the essential lifecycle components for developing a successful software application and offer a checklist for your company to review the design, development, deployment and support of your business applications with MySQL.
The presentations include:
• Effective MySQL Architecture and Design Practices
• Effective Software Development with MySQL
• Effective Web Site Operations
• Upcoming MySQL features for modern applications
More information about Ronald Bradford:
To attend this event, please RSVP!
This event is organized by Oracle User Group Estonia (https://www.ouge.eu/) in cooperation with Finnish (http://www.ougf.fi/index.php/en/), Swedish (https://www.linkedin.com/groups/SMUG-Sweden-MySQL-User-Group-4510296) and Latvian (http://www.lvoug.lv/) user groups.
The event in Tallinn is sponsored by TransferWise (https://www.transferwise.com).
If you require more information about this event, please contact [masked]
Here below is more detailed description about each presentation.
Effective MySQL Architecture and Design Practices
Correctly designing a MySQL architecture has a huge impact on the growth of your system for future needs.
In this presentation we will cover:
• The strengths and weaknesses of MySQL
• What MySQL scale-out architecture means
• High Availability considerations
• The importance of changing key system default configurations
• How to integrate MySQL with existing and and new data sources.
From this presentation we will create a checklist of what key business and technology decisions 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 and with applicable business logic is what makes each company in unique.
Some key points in this presentation include:
• Integrating MySQL with common programming languages
• The various developer tools that work well with MySQL
• The importance on developing standards and good SQL practices
• Common mistakes developers and frameworks make, and how to avoid them.
• What causes the most time for development and support time.
• How to invest time in quality and performance during development
We will review some of the important changes between versions including new features and compatibility differences. A great example is the impact of the new sql_mode default in Version 5.6.
From this presentation we will create a checklist of what developers need to know and do for creating great software that lasts.
Effective Web Site Operations
It is very important for companies to be able to support and manage your MySQL installation and related technology stack.
We plan to cover the following topics:
• Be prepared for handling software, OS or dependency upgrades.
• Ensure the right backup and recovery procedures for failed hardware.
• The correct testing and verification of backup and recovery and how to avoid common pitfalls.
• What monitoring and alerting is necessary.
• New tools and instrumentation including the Performance Schema.
• Choosing the best repo or binary for your environment needs
• What are the security needs for your data, backups.
• How does the use of public cloud affect your business data governance and compliance needs.
From this presentation we will create a checklist the key operations needs your business should undertake to ensure a smooth running production system.
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.
• We will discuss the details of each Oracle version and identify the right version for your needs and current technology stack.
• How to integrate with your existing stack including legacy MySQL.
• What is the impact of NoSQL with MySQL.
• How the MySQL product development cycle works.
• How to try out beta software.