Joro Kodinov

We will explore the latest component services offered by the server. And then we will check how one can use the table access service to make a HTTP server component that allows access to table data via HTTP without a middle-man.

The MySQL development team is constantly adding new and very useful component services. These can be leveraged by creative component authors to produce useful MySQL server add-ons. Check the latest additions to the service list and see some of them in action through a HTTP server component that serves table data.

I'll explain the newest addition to the MySQL wire format that allows client applications to pass data in the COM_QUERY command that then can be processed by the server and components in various ways. I'll demonstrate how an audit plugin and the SQL query itself can take advantage of the data passed by the client.

COM_QUERY can now take named binary values parameters. And the server can serve the values of these to components and plugins. As well as the SQL query itself. Let's learn how to prepare these values using the C API and how to process them inside the server.

You probably saw the new MySQL 8.0 commands INSTALL COMPONENT and UNINSTALL COMPONENT and been wondering "is there anything for me". I'll try to explain what the component infrastructure is, why do we need it, what's available through it and where do we have the ambition to get it. I'll present what does it take to create a simple component too.

The MySQL component infrastructure is intended as a reboot of the plugin functionality. It's built on the principle of modularity, explicit interfaces and dependencies and obfuscation of complex internal structures and object instances behind handles. It inherits the best from the plugin functionality while avoiding the known pitfalls and providing missing functionality. We'll go over the architectural principles behind the components, services and service implementations. We'll also create a simple component, see how it declares the APIs it needs and provides and how does it interact with the other APIs available in the service registry. At the end we'll go through an enumeration of the services available from the MySQL server component. We'll then try to think together on what's missing, what could be next and what's more desired in terms of functionality.