- MySQL Happy Hour - Organized by Oracle
Link to Register: https://eventreg.oracle.com/profile/web/index.cfm?PKwebID=0x670036abcd Join MySQL experts and your peers for an evening of complimentary premium cocktails and hors d’oeuvres at the cool speakeasy style bar, Clyde Common! Kenny Gryp, MySQL’s high-availability expert and evangelist, will be in town to provide a brief update on the latest advancements in MySQL 8.0 and answer all of your questions. Register today and take advantage of this casual evening to share best practices while mingling with your peers and MySQL experts! This event is organized by Oracle.
- Synchronous replication for MySQL
Topic: Synchronous replication for MySQL Summary: Built-in MySQL Replication is known for its capability to enable to scale reads easily. However, there are some limitations and known issues with this solution because of the asynchronous nature of this replication. This talk will describe another way of doing MySQL replication, by using synchronous replication, available in Percona XtraDB Cluster. The open source solution will be explained and compared to traditional asynchronous MySQL replication, as well as some known use cases will be described. Percona XtraDB Cluster is an, open source, high availability and high scalability solution for MySQL clustering. Features include: Synchronous replication, Multi-master replication support, Parallel replication, Automatic node provisioning. Speaker: Kenny Gryp Kenny is currently Principal Architect at Percona. Bitten somewhere in the late 90s by the open-source bug, most of his spare time was spent working with Linux & OpenBSD servers. Before joining Percona, he worked at a large social networking company in Europe as DBA & Puppeteer. --- Schedule: 6:00 beer, soda, pizza 6:15 presentation 7:15 chat 7:30 end --- There will be pizza, so please register so that we can order the proper amount.
- Emily Slocombe presents "Drupal just wants to hug your database"
Drupal is one of the more widely adopted CMSs. It is open source and has a huge developer base. However, I rarely hear a DBA mention having to administer Drupal with anything but frustration and pessimism. At Acquia, we have thousands of Amazon instances running Drupal databases. Most sites are quite different from each other, but some basic principles apply to all. Being the DBA for Drupal does not have to be a negative experience! In addition to covering the generic Drupal MySQL configuration tips, I will cover optimization methods for specific features like semaphores, sessions, Views, and the various Drupal caching layers. I’ll also cover the use of query cache in the Drupal context, which while normally frowned upon in the MySQL community, is often beneficial in maintaining a healthy Drupal site. --- There will be pizza, so please register so that we can order the proper amount. Due to various scheduling conflicts, the August month's meeting has been delayed and wrapped into an early September one.
- Using Go and MySQL with Daniel Nichter from Percona
Agenda • 6-6:30: Pizza, beer, mingle • 6:30-7:30: Presentation • 7:30-8: Q&A The presentation will cover: • Basic usage • Interpolation • Connection pools and leaks • Scanning results and NULL • Non-MySQL behaviors If you're thinking about using Go and MySQL (or you already are), this info will get you started and spare you some lessons and gotchas we learned from a year in production with Go and MySQL.
- Topic: Effective Architecture/Design/Development with MySQL - Ronald Bradford
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. About the speaker: Ronald (http://ronaldbradford.com) has over 25 years of professional RDBMS experience in MySQL, Oracle, and Ingres. His expertise covers MySQL, LAMP and cloud-based consulting in architecture, performance, scalability and business continuity. Ronald is a former employee of the MySQL Inc consulting team (06-08) and Oracle Corporation (96-99). He has currently published 4 books on MySQL, his most recent titles available from Oracle Press include Effective MySQL: Optimizing SQL Statements, Effective MySQL: Backup & Recovery and Effective MySQL: Replication Techniques in Depth.
- Topic: Live demo - breaking things then fixing them & mysql-cli project demo
We will have a short demo from Amjith Ramanujam who is looking for feedback on his preliminary set of functions for mysql-cli (https://www.kickstarter.com/projects/1839007321/mysql-cli) Then: live demo! Recent transplant from Oklahoma's MySQL User Group, Alex Ward, will be breaking things, live... then fixing them Important note: venue change - We are in the main Elemental office on Broadway again
- Topic: TBD (note - different location!)
Meeting topic: tbd. Either we will have a continuation of last month's topic, or we will just talk about what we are all currently doing and planning to do. Informal! Note: different location this month. We are at Elemental's 721 SW Oak location (head W on Oak and the entrance will be after the newly renovated bar on your right.) There is a metal gate at the entrance to the location.