Dave Stokes

Artificial Intelligence is an overhyped distraction, except for what it can do for you when using MySQL. AI is strong in he pattern matching area, which means it is great with SQL syntax and examining DDL metadata. This session will cover basic prompting, using AI to repair or augment existing queries, and developing new schemas. And you can write queries in English (or French, or German, or Italian) instead of SQL, saving you a lot of time determining which tables need to be joined where. SO, yes, you do need an AI Assistant to get the maximum out of your MySQL instances, and this session will show you how to do it.

VALKEY is a superfast in-memory distributed database with clustering, redundancy, and low latency. If you need a cache, then you need to look at VALKEY. The VALKEY project started when REDIS changed from an open-source license to extort money from its community. VALKEY is a much-improved fork of REDIS, and the Linux Foundation supports the project.    This session briefly covers the fork's 'why,' explores some exciting new features, and shows you how to start with VALKEY.

Relational databases = strict data types and stored schema.  JSON = free form but no data rigor.  But what if you could reliably use JSON in your relational database to get performance, the processing power of SQL  and reatain the flexibility JSON is know for.  This talk will cover the best practices for using JSON in your realtional database, how to temporarily transform unstructured JSON to structured with JSON_TABLE() or permanently with generated columns.  And how do you ensure that the JSON data has the proper format or is required before entry.

The LAMP stack was the internet model for so many years. But now everything is 'cloud this' or 'Kubernetes that'.  But how do you move from LAMP to this new medium, how do the various 'tinker toys' work together, and what tricks does an 'old dog' need to learn to accomplish all this?  So if Kubernetes is in your future but you do not know where to start then you should probably be in this presentation. 

I used to be the Certification Manager for MySQL AB and I would hear from hiring managers that it was hard to find qualified MySQL DBAs but it was impossible to find qualified PostgreSQL DBAs.  So if we need more PG DBAs can we build them from MySQL DBAs?  I have been delivering a series on PostgreSQL for MySQLs that has a very good response and it turns out that MySQL DBAs can learn another database easily.  This talk will compare and contrast what MySQL DBAs are used to and how to 'transpose' their knowledge to PG. 

MySQL 5.7 introduced a JSON data type that is fantastic, obviously, for JSON data.  But how do you use this new data type efficiently, what tools do you need to manipulate JSON data, when is it best to use a regular columns instead of JSON, and what magic new technology (generated columns) can you use to work with SQL indexes. So come learn how to use this new data type to become a rockstar developer.

Are you are the developer / system admin / network / analyst / everything-else person at your company and the boss jsut told you that you need to take care of the MySQL databases too!! Don't panic!! This session covers what you need to know to keep your MySQL database instances happy, healthy, and performing at the best of their ability.  Learn how to cheaply monitor your systems health, discover proper backup methods that will save your rear, and lewarn tricks of the trade it noramlly takes full time DBAs years to learn.

This presentation covers the use of the NoSQL access to InnoDB data engines via the memcached protocol.  Bypassing the SQL parser and optimizer is 9x faster!   This allows applications to 'drink from the fire hose' at over 1,000,000 access a second.  This approach is easy to set up, can be secured easily, stores data as a key/value pair while allowing SIMULTANEOUS access through SQL, and provides for a crash safe persistent cache.  If you are looking for a quick, painless entry into the world of big data or need very high speed access to your data, come to this!

Nobody complains where the database is fast.  But adding one index speeds things up.  But the second index makes things worse?  There is a lot of mythology about indexes in the MySQL area and this talk will show that getting performance out of an index is simple engineering and not magic.  You will walk out of this session knowing how indexes are built, how to use them to provide better information to the query optimizer, and how to make sure that what you are doing is a positive change and not hurting your instance performance.

MySQL has been the most rapidly implemented version of the most popular database on the web. Our new CI/CD release schedule means we are introducing improvements on a quarterly basis and you may have missed one or two new features. You may have missed hash joins, random password generation, multi-value indexes, check constraints, the Clone plugin, how to validate JSON documents for required fields or range checks, and dual passwords. This presentation will cover the new features and how to implement them so you too can take advantage of the latest and greatest from MySQL.

The MySQL Document Store is a NoSQL JSON Document Database built upon the MySQL Server.  It provides a way to use a database without setting up relational tables, relying on a database administrator, and uses a modern programming style -- no more ugly strings of Structured Query Language in your code. Plus it can also work with relational tables at the same time providing the best of both worlds. This is an introduction to the document store, the new X Devapi (built on Google Protobufs), and the new MySQL Shell.

Need to store schema-less data or do you need a data store but do not know structured query language (SQL)? The MySQL Document Store allows developers with NoSQL skills to use the popular database as a NoSQL database. The new X DevAPI greatly broadens the usefulness of the MySQL database for those who do not want to write SQL queries. Languages supported include JavaScript, C++, Java, Node.JS, PHP, Python, and more. This presentation has lots of programming examples and a demo of the new MySQL Shell.

MySQl 5.7 was the best received version ot the popular database. But there were some legacy issues that needed to be corrected. Come see the release candidate of MySQL 8 and explore the many new features including a true data dictionary (byebye .FRM files, hello millions of tables in a database), usee roles, Windowing functions, Invisible Indexes,  Commont Table Expressions, and more.   Plus see how improved UTF8MB4 support, oprimizer hints, abd the ability to do 2 million querys per second will change your life.