Marco Tusa had his own international practice for the past twenty eight years. His experience and expertise are in a wide variety of information technology and information management fields, cover research, development, analysis, quality control, project management and team management. Marco is currently working at Percona as High Availability Practice Manager, previously working at Percona as manager of the Consulting Rapid Response Team on October 2013. He has being working as employee for the SUN Microsystems as MySQL Professional Service manager for South Europe., and previously in MySQL AB. He has worked with the Food and Agriculture Organization of the United Nation since 1994, leading the development of the Organization's hyper textual environment.Team leader for the FAO corporate database support. For several years he has led the development group in the WAICENT/Faoinfo team.
MySQL 8 introduces a feature that is explained in a single document page, but that can help a lot if correctly used.
It is well hidden, in the optimization: optimizing of the MySQL server chapter.
I am talking of Resource Groups.
Resource groups permit assigning threads running within the server to particular groups so that threads execute according to the resources available to the group.
Group attributes enable control over its resources, to enable or restrict resource consumption by threads in the group. DBAs can modify these attributes as appropriate for different workloads.
This small simple feature can be a blast in case you have contention between different type of load on your database.
The simplest example is a combination of OLTP/OLAP or OLTP/ETL.
In this presentation, I will illustrate the feature and how it can be easily and successfully implement.
Also covering those contexts, like large enterprises, where code dynamic is not as agile as we would like to be.
Or to be better say my PostgreSQL "hello World".
In this presentation I will illustrate the ways, the accidents and the surprises I had in my journey as MySQL DBA to implement a specular solution with PostgreSQL as total probie.
I will start from the basics, covering my journey in:
- Basic configuration
- Security definition
- Create a database and tables
- The magic behind indexes