�ݺ�ߣshows by User: FedericoRazzoli

�ݺ�ߣshows by User: FedericoRazzoli / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: FedericoRazzoli / Fri, 07 Jun 2024 13:11:29 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: FedericoRazzoli Webinar: Designing a schema for a Data Warehouse /slideshow/webinar-designing-a-schema-for-a-data-warehouse/269559937 webinardesigningaschemaforadatawarehouse-240607131129-b6f7c7b7
Are you new to data warehouses (DWH)? Do you need to check whether your data warehouse follows the best practices for a good design? In both cases, this webinar is for you. A data warehouse is a central relational database that contains all measurements about a business or an organisation. This data comes from a variety of heterogeneous data sources, which includes databases of any type that back the applications used by the company, data files exported by some applications, or APIs provided by internal or external services. But designing a data warehouse correctly is a hard task, which requires gathering information about the business processes that need to be analysed in the first place. These processes must be translated into so-called star schemas, which means, denormalised databases where each table represents a dimension or facts. We will discuss these topics: - How to gather information about a business; - Understanding dictionaries and how to identify business entities; - Dimensions and facts; - Setting a table granularity; - Types of facts; - Types of dimensions; - Snowflakes and how to avoid them; - Expanding existing dimensions and facts.]]>
Are you new to data warehouses (DWH)? Do you need to check whether your data warehouse follows the best practices for a good design? In both cases, this webinar is for you. A data warehouse is a central relational database that contains all measurements about a business or an organisation. This data comes from a variety of heterogeneous data sources, which includes databases of any type that back the applications used by the company, data files exported by some applications, or APIs provided by internal or external services. But designing a data warehouse correctly is a hard task, which requires gathering information about the business processes that need to be analysed in the first place. These processes must be translated into so-called star schemas, which means, denormalised databases where each table represents a dimension or facts. We will discuss these topics: - How to gather information about a business; - Understanding dictionaries and how to identify business entities; - Dimensions and facts; - Setting a table granularity; - Types of facts; - Types of dimensions; - Snowflakes and how to avoid them; - Expanding existing dimensions and facts.]]> Fri, 07 Jun 2024 13:11:29 GMT /slideshow/webinar-designing-a-schema-for-a-data-warehouse/269559937 FedericoRazzoli@slideshare.net(FedericoRazzoli) Webinar: Designing a schema for a Data Warehouse FedericoRazzoli Are you new to data warehouses (DWH)? Do you need to check whether your data warehouse follows the best practices for a good design? In both cases, this webinar is for you. A data warehouse is a central relational database that contains all measurements about a business or an organisation. This data comes from a variety of heterogeneous data sources, which includes databases of any type that back the applications used by the company, data files exported by some applications, or APIs provided by internal or external services. But designing a data warehouse correctly is a hard task, which requires gathering information about the business processes that need to be analysed in the first place. These processes must be translated into so-called star schemas, which means, denormalised databases where each table represents a dimension or facts. We will discuss these topics: - How to gather information about a business; - Understanding dictionaries and how to identify business entities; - Dimensions and facts; - Setting a table granularity; - Types of facts; - Types of dimensions; - Snowflakes and how to avoid them; - Expanding existing dimensions and facts. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/webinardesigningaschemaforadatawarehouse-240607131129-b6f7c7b7-thumbnail.jpg?width=120&height=120&fit=bounds" /> Are you new to data warehouses (DWH)? Do you need to check whether your data warehouse follows the best practices for a good design? In both cases, this webinar is for you. A data warehouse is a central relational database that contains all measurements about a business or an organisation. This data comes from a variety of heterogeneous data sources, which includes databases of any type that back the applications used by the company, data files exported by some applications, or APIs provided by internal or external services. But designing a data warehouse correctly is a hard task, which requires gathering information about the business processes that need to be analysed in the first place. These processes must be translated into so-called star schemas, which means, denormalised databases where each table represents a dimension or facts. We will discuss these topics: - How to gather information about a business; - Understanding dictionaries and how to identify business entities; - Dimensions and facts; - Setting a table granularity; - Types of facts; - Types of dimensions; - Snowflakes and how to avoid them; - Expanding existing dimensions and facts.

Webinar: Designing a schema for a Data Warehouse from Federico Razzoli

]]> 34 0 https://cdn.slidesharecdn.com/ss_thumbnails/webinardesigningaschemaforadatawarehouse-240607131129-b6f7c7b7-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 High-level architecture of a complete MariaDB deployment /slideshow/high-level-architecture-of-a-complete-mariadb-deployment/268516822 high-levelarchitectureofacompletemariadbsetup-240515165134-5a961834
In this webinar Federico will illustrate how to design a complete MariaDB setup. This doesn't only include MariaDB, but all the components that are necessary to form a reliable, scalable architecture. Federico will cover these points: - MariaDB storage engines - Asynchronous replication vs Galera - Load balancing and failover: ProxySQL, MaxScale, HAProxy - Eliminating SPoFs in the proxy level - Backup strategies - Monitoring solutions]]>
In this webinar Federico will illustrate how to design a complete MariaDB setup. This doesn't only include MariaDB, but all the components that are necessary to form a reliable, scalable architecture. Federico will cover these points: - MariaDB storage engines - Asynchronous replication vs Galera - Load balancing and failover: ProxySQL, MaxScale, HAProxy - Eliminating SPoFs in the proxy level - Backup strategies - Monitoring solutions]]> Wed, 15 May 2024 16:51:34 GMT /slideshow/high-level-architecture-of-a-complete-mariadb-deployment/268516822 FedericoRazzoli@slideshare.net(FedericoRazzoli) High-level architecture of a complete MariaDB deployment FedericoRazzoli In this webinar Federico will illustrate how to design a complete MariaDB setup. This doesn't only include MariaDB, but all the components that are necessary to form a reliable, scalable architecture. Federico will cover these points: - MariaDB storage engines - Asynchronous replication vs Galera - Load balancing and failover: ProxySQL, MaxScale, HAProxy - Eliminating SPoFs in the proxy level - Backup strategies - Monitoring solutions <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/high-levelarchitectureofacompletemariadbsetup-240515165134-5a961834-thumbnail.jpg?width=120&height=120&fit=bounds" /> In this webinar Federico will illustrate how to design a complete MariaDB setup. This doesn't only include MariaDB, but all the components that are necessary to form a reliable, scalable architecture. Federico will cover these points: - MariaDB storage engines - Asynchronous replication vs Galera - Load balancing and failover: ProxySQL, MaxScale, HAProxy - Eliminating SPoFs in the proxy level - Backup strategies - Monitoring solutions

High-level architecture of a complete MariaDB deployment from Federico Razzoli

]]> 54 0 https://cdn.slidesharecdn.com/ss_thumbnails/high-levelarchitectureofacompletemariadbsetup-240515165134-5a961834-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Webinar - Unleash AI power with MySQL and MindsDB /slideshow/webinar-unleash-ai-power-with-mysql-and-mindsdb/265773015 webinar-unleashaipowerwithmysqlandmindsdb-240124193057-5880c602
MindsDB enormously simplifies the process of making machine learning based predictions. Intead of developing a model and prepare data, you can connect MindsDB to an external data source (such as MySQL, PostgreSQL, other databases, or APIs) and run SQL queries about the future. Any AI engine (predictive algorithm) can be used.]]>
MindsDB enormously simplifies the process of making machine learning based predictions. Intead of developing a model and prepare data, you can connect MindsDB to an external data source (such as MySQL, PostgreSQL, other databases, or APIs) and run SQL queries about the future. Any AI engine (predictive algorithm) can be used.]]> Wed, 24 Jan 2024 19:30:57 GMT /slideshow/webinar-unleash-ai-power-with-mysql-and-mindsdb/265773015 FedericoRazzoli@slideshare.net(FedericoRazzoli) Webinar - Unleash AI power with MySQL and MindsDB FedericoRazzoli MindsDB enormously simplifies the process of making machine learning based predictions. Intead of developing a model and prepare data, you can connect MindsDB to an external data source (such as MySQL, PostgreSQL, other databases, or APIs) and run SQL queries about the future. Any AI engine (predictive algorithm) can be used. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/webinar-unleashaipowerwithmysqlandmindsdb-240124193057-5880c602-thumbnail.jpg?width=120&height=120&fit=bounds" /> MindsDB enormously simplifies the process of making machine learning based predictions. Intead of developing a model and prepare data, you can connect MindsDB to an external data source (such as MySQL, PostgreSQL, other databases, or APIs) and run SQL queries about the future. Any AI engine (predictive algorithm) can be used.

Webinar - Unleash AI power with MySQL and MindsDB from Federico Razzoli

]]> 66 0 https://cdn.slidesharecdn.com/ss_thumbnails/webinar-unleashaipowerwithmysqlandmindsdb-240124193057-5880c602-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 MariaDB Security Best Practices /slideshow/mariadb-security-best-practices/264694975 webinar-mariadbsecuritybestpractices-231216112637-8bb9d395
MariaDB best practices for user and permissions management, secrets storage, SSL, encryption at rest, and more. Includes an overview of MariaDB most advanced security features. Webinar organised in December 2023.]]>
MariaDB best practices for user and permissions management, secrets storage, SSL, encryption at rest, and more. Includes an overview of MariaDB most advanced security features. Webinar organised in December 2023.]]> Sat, 16 Dec 2023 11:26:37 GMT /slideshow/mariadb-security-best-practices/264694975 FedericoRazzoli@slideshare.net(FedericoRazzoli) MariaDB Security Best Practices FedericoRazzoli MariaDB best practices for user and permissions management, secrets storage, SSL, encryption at rest, and more. Includes an overview of MariaDB most advanced security features. Webinar organised in December 2023. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/webinar-mariadbsecuritybestpractices-231216112637-8bb9d395-thumbnail.jpg?width=120&height=120&fit=bounds" /> MariaDB best practices for user and permissions management, secrets storage, SSL, encryption at rest, and more. Includes an overview of MariaDB most advanced security features. Webinar organised in December 2023.

MariaDB Security Best Practices from Federico Razzoli

]]> 119 0 https://cdn.slidesharecdn.com/ss_thumbnails/webinar-mariadbsecuritybestpractices-231216112637-8bb9d395-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 A first look at MariaDB 11.x features and ideas on how to use them /slideshow/a-first-look-at-mariadb-11x-features-and-ideas-on-how-to-use-them/263850126 webinar-afirstlookatmariadb11-231124084755-5f8ec69e
From my webinar "A first look at MariaDB 11.x features and ideas on how to use them", from November 2023. I talked about the features introduced in MariaDB versions 11.0 to 11.3, not yet production-ready. For some features, I provided ideas about how they can be used.]]>
From my webinar "A first look at MariaDB 11.x features and ideas on how to use them", from November 2023. I talked about the features introduced in MariaDB versions 11.0 to 11.3, not yet production-ready. For some features, I provided ideas about how they can be used.]]> Fri, 24 Nov 2023 08:47:54 GMT /slideshow/a-first-look-at-mariadb-11x-features-and-ideas-on-how-to-use-them/263850126 FedericoRazzoli@slideshare.net(FedericoRazzoli) A first look at MariaDB 11.x features and ideas on how to use them FedericoRazzoli From my webinar "A first look at MariaDB 11.x features and ideas on how to use them", from November 2023. I talked about the features introduced in MariaDB versions 11.0 to 11.3, not yet production-ready. For some features, I provided ideas about how they can be used. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/webinar-afirstlookatmariadb11-231124084755-5f8ec69e-thumbnail.jpg?width=120&height=120&fit=bounds" /> From my webinar "A first look at MariaDB 11.x features and ideas on how to use them", from November 2023. I talked about the features introduced in MariaDB versions 11.0 to 11.3, not yet production-ready. For some features, I provided ideas about how they can be used.

A first look at MariaDB 11.x features and ideas on how to use them from Federico Razzoli

]]> 92 0 https://cdn.slidesharecdn.com/ss_thumbnails/webinar-afirstlookatmariadb11-231124084755-5f8ec69e-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 MariaDB stored procedures and why they should be improved /slideshow/mariadb-stored-procedures-and-why-they-should-be-improved/263849873 mariadbstoredproceduresandwhytheyshouldbeimproved-231124083909-9e8964f5
These slides were used for my talk at MariaDB Server Fest 2023: MariaDB Stored Procedures and Why They Should Be Improved. The whole talk was based on my opinions, and was a list of suggestions for the MariaDB development team.]]>
These slides were used for my talk at MariaDB Server Fest 2023: MariaDB Stored Procedures and Why They Should Be Improved. The whole talk was based on my opinions, and was a list of suggestions for the MariaDB development team.]]> Fri, 24 Nov 2023 08:39:09 GMT /slideshow/mariadb-stored-procedures-and-why-they-should-be-improved/263849873 FedericoRazzoli@slideshare.net(FedericoRazzoli) MariaDB stored procedures and why they should be improved FedericoRazzoli These slides were used for my talk at MariaDB Server Fest 2023: MariaDB Stored Procedures and Why They Should Be Improved. The whole talk was based on my opinions, and was a list of suggestions for the MariaDB development team. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/mariadbstoredproceduresandwhytheyshouldbeimproved-231124083909-9e8964f5-thumbnail.jpg?width=120&height=120&fit=bounds" /> These slides were used for my talk at MariaDB Server Fest 2023: MariaDB Stored Procedures and Why They Should Be Improved. The whole talk was based on my opinions, and was a list of suggestions for the MariaDB development team.

MariaDB stored procedures and why they should be improved from Federico Razzoli

]]> 49 0 https://cdn.slidesharecdn.com/ss_thumbnails/mariadbstoredproceduresandwhytheyshouldbeimproved-231124083909-9e8964f5-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Webinar - MariaDB Temporal Tables: a demonstration /slideshow/webinar-mariadb-temporal-tables-a-demonstration/260989925 webinartemporaltables-230915140312-d125ee33
MariaDB Temporal Tables are useful to track how data change over time, and to handle data that refer to specific time periods. In this webinar I showed: * Which problems Temporal Tables solve * How to create Temporal Tables * How to turn regular tables into Temporal Tables * Best practices * Examples of what can be done with Temporal Tables]]>
MariaDB Temporal Tables are useful to track how data change over time, and to handle data that refer to specific time periods. In this webinar I showed: * Which problems Temporal Tables solve * How to create Temporal Tables * How to turn regular tables into Temporal Tables * Best practices * Examples of what can be done with Temporal Tables]]> Fri, 15 Sep 2023 14:03:12 GMT /slideshow/webinar-mariadb-temporal-tables-a-demonstration/260989925 FedericoRazzoli@slideshare.net(FedericoRazzoli) Webinar - MariaDB Temporal Tables: a demonstration FedericoRazzoli MariaDB Temporal Tables are useful to track how data change over time, and to handle data that refer to specific time periods. In this webinar I showed: * Which problems Temporal Tables solve * How to create Temporal Tables * How to turn regular tables into Temporal Tables * Best practices * Examples of what can be done with Temporal Tables <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/webinartemporaltables-230915140312-d125ee33-thumbnail.jpg?width=120&height=120&fit=bounds" /> MariaDB Temporal Tables are useful to track how data change over time, and to handle data that refer to specific time periods. In this webinar I showed: * Which problems Temporal Tables solve * How to create Temporal Tables * How to turn regular tables into Temporal Tables * Best practices * Examples of what can be done with Temporal Tables

Webinar - MariaDB Temporal Tables: a demonstration from Federico Razzoli

]]> 69 0 https://cdn.slidesharecdn.com/ss_thumbnails/webinartemporaltables-230915140312-d125ee33-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Webinar - Key Reasons to Upgrade to MySQL 8.0 or MariaDB 10.11 /slideshow/webinar-key-reasons-to-upgrade-to-mysql-80-or-mariadb-1011/259702481 webinar-keyreasonstoupgradetomysql8-230807160001-f2e185ee
MySQL 5.7 will reach its End Of Life in October 2023. This means that there will be no releases after that date, no bug fixes, and no security fixes. The documentation will be withdrawn and will no longer be available at some point. Official and non-official drivers and tools will, sooner or later, stop supporting MySQL 5.7. From here, 5.7 users have two paths. They can upgrade to MySQL 8.0, or they can move to MariaDB. Each option has its benefits and its drawbacks. In this webinar we will explore the differences between MySQL 8.0 and MariaDB 10.11 or 10.6, from both a technical and a less technical perspective.]]>
MySQL 5.7 will reach its End Of Life in October 2023. This means that there will be no releases after that date, no bug fixes, and no security fixes. The documentation will be withdrawn and will no longer be available at some point. Official and non-official drivers and tools will, sooner or later, stop supporting MySQL 5.7. From here, 5.7 users have two paths. They can upgrade to MySQL 8.0, or they can move to MariaDB. Each option has its benefits and its drawbacks. In this webinar we will explore the differences between MySQL 8.0 and MariaDB 10.11 or 10.6, from both a technical and a less technical perspective.]]> Mon, 07 Aug 2023 16:00:01 GMT /slideshow/webinar-key-reasons-to-upgrade-to-mysql-80-or-mariadb-1011/259702481 FedericoRazzoli@slideshare.net(FedericoRazzoli) Webinar - Key Reasons to Upgrade to MySQL 8.0 or MariaDB 10.11 FedericoRazzoli MySQL 5.7 will reach its End Of Life in October 2023. This means that there will be no releases after that date, no bug fixes, and no security fixes. The documentation will be withdrawn and will no longer be available at some point. Official and non-official drivers and tools will, sooner or later, stop supporting MySQL 5.7. From here, 5.7 users have two paths. They can upgrade to MySQL 8.0, or they can move to MariaDB. Each option has its benefits and its drawbacks. In this webinar we will explore the differences between MySQL 8.0 and MariaDB 10.11 or 10.6, from both a technical and a less technical perspective. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/webinar-keyreasonstoupgradetomysql8-230807160001-f2e185ee-thumbnail.jpg?width=120&height=120&fit=bounds" /> MySQL 5.7 will reach its End Of Life in October 2023. This means that there will be no releases after that date, no bug fixes, and no security fixes. The documentation will be withdrawn and will no longer be available at some point. Official and non-official drivers and tools will, sooner or later, stop supporting MySQL 5.7. From here, 5.7 users have two paths. They can upgrade to MySQL 8.0, or they can move to MariaDB. Each option has its benefits and its drawbacks. In this webinar we will explore the differences between MySQL 8.0 and MariaDB 10.11 or 10.6, from both a technical and a less technical perspective.

Webinar - Key Reasons to Upgrade to MySQL 8.0 or MariaDB 10.11 from Federico Razzoli

]]> 235 0 https://cdn.slidesharecdn.com/ss_thumbnails/webinar-keyreasonstoupgradetomysql8-230807160001-f2e185ee-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 MariaDB 10.11 key features overview for DBAs /slideshow/mariadb-1011-key-features-overview-for-dbas/257686454 mariadb10-230504113047-2cd363ef
Webinar: MariaDB 10.11 key features overview for DBAs Orgnised by Vettabase 27 April 2023 Amongst other topics: - Long ALTER TABLES now don’t cause replicas to lag - InnoDB configuration is now more dynamic, and certain important variables can be modified without a restart - Populating an empty table is now much faster - New data types: UUID, INET4, INET6 - SFORMAT() function, NATURAL_KEY_SORT() function]]>
Webinar: MariaDB 10.11 key features overview for DBAs Orgnised by Vettabase 27 April 2023 Amongst other topics: - Long ALTER TABLES now don’t cause replicas to lag - InnoDB configuration is now more dynamic, and certain important variables can be modified without a restart - Populating an empty table is now much faster - New data types: UUID, INET4, INET6 - SFORMAT() function, NATURAL_KEY_SORT() function]]> Thu, 04 May 2023 11:30:47 GMT /slideshow/mariadb-1011-key-features-overview-for-dbas/257686454 FedericoRazzoli@slideshare.net(FedericoRazzoli) MariaDB 10.11 key features overview for DBAs FedericoRazzoli Webinar: MariaDB 10.11 key features overview for DBAs Orgnised by Vettabase 27 April 2023 Amongst other topics: - Long ALTER TABLES now don’t cause replicas to lag - InnoDB configuration is now more dynamic, and certain important variables can be modified without a restart - Populating an empty table is now much faster - New data types: UUID, INET4, INET6 - SFORMAT() function, NATURAL_KEY_SORT() function <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/mariadb10-230504113047-2cd363ef-thumbnail.jpg?width=120&height=120&fit=bounds" /> Webinar: MariaDB 10.11 key features overview for DBAs Orgnised by Vettabase 27 April 2023 Amongst other topics: - Long ALTER TABLES now don’t cause replicas to lag - InnoDB configuration is now more dynamic, and certain important variables can be modified without a restart - Populating an empty table is now much faster - New data types: UUID, INET4, INET6 - SFORMAT() function, NATURAL_KEY_SORT() function

MariaDB 10.11 key features overview for DBAs from Federico Razzoli

]]> 312 0 https://cdn.slidesharecdn.com/ss_thumbnails/mariadb10-230504113047-2cd363ef-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Recent MariaDB features to learn for a happy life /FedericoRazzoli/recent-mariadb-features-to-learn-for-a-happy-life mariadbfeaturesslides-221119234125-a4128b6c
After MariaDB 10.6 LTS was made available last year, three Short Term Support versions were released. While they shouldn’t be used in production, they allow us to test the features that will be included in the next LTS version. I follow the development of MariaDB through their JIRA, I test the new features, and I regularly review each new major version on the Vettabase website. In this talk I will summarise the most relevant features, show how to use them, and discuss how we can leverage them for real-world cases.]]>
After MariaDB 10.6 LTS was made available last year, three Short Term Support versions were released. While they shouldn’t be used in production, they allow us to test the features that will be included in the next LTS version. I follow the development of MariaDB through their JIRA, I test the new features, and I regularly review each new major version on the Vettabase website. In this talk I will summarise the most relevant features, show how to use them, and discuss how we can leverage them for real-world cases.]]> Sat, 19 Nov 2022 23:41:25 GMT /FedericoRazzoli/recent-mariadb-features-to-learn-for-a-happy-life FedericoRazzoli@slideshare.net(FedericoRazzoli) Recent MariaDB features to learn for a happy life FedericoRazzoli After MariaDB 10.6 LTS was made available last year, three Short Term Support versions were released. While they shouldn’t be used in production, they allow us to test the features that will be included in the next LTS version. I follow the development of MariaDB through their JIRA, I test the new features, and I regularly review each new major version on the Vettabase website. In this talk I will summarise the most relevant features, show how to use them, and discuss how we can leverage them for real-world cases. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/mariadbfeaturesslides-221119234125-a4128b6c-thumbnail.jpg?width=120&height=120&fit=bounds" /> After MariaDB 10.6 LTS was made available last year, three Short Term Support versions were released. While they shouldn’t be used in production, they allow us to test the features that will be included in the next LTS version. I follow the development of MariaDB through their JIRA, I test the new features, and I regularly review each new major version on the Vettabase website. In this talk I will summarise the most relevant features, show how to use them, and discuss how we can leverage them for real-world cases.

Recent MariaDB features to learn for a happy life from Federico Razzoli

]]> 38 0 https://cdn.slidesharecdn.com/ss_thumbnails/mariadbfeaturesslides-221119234125-a4128b6c-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Advanced MariaDB features that developers love.pdf /slideshow/advanced-mariadb-features-that-developers-lovepdf/252036945 advancedmariadbfeaturesthatdeveloperslove-220622081825-6877714d
MariaDB is one of the most widely used relational databases. It is compatible with MySQL for most practical purposes, and it is appreciated by developers communities all over the world. Over the years, MariaDB has developed many features that are extremely useful for developers, saving a lot of development time and enabling its use in situations where it wouldn't be practical otherwise. In this talk, we'll briefly discuss some of those features and why they are so useful. We'll talk about: * Querying remote or heterogeneous data sources in SQL; * Using temporal tables to analyse how data changes over time; * Using JSON in a relational database; * Miscellaneous tips and tricks.]]>
MariaDB is one of the most widely used relational databases. It is compatible with MySQL for most practical purposes, and it is appreciated by developers communities all over the world. Over the years, MariaDB has developed many features that are extremely useful for developers, saving a lot of development time and enabling its use in situations where it wouldn't be practical otherwise. In this talk, we'll briefly discuss some of those features and why they are so useful. We'll talk about: * Querying remote or heterogeneous data sources in SQL; * Using temporal tables to analyse how data changes over time; * Using JSON in a relational database; * Miscellaneous tips and tricks.]]> Wed, 22 Jun 2022 08:18:25 GMT /slideshow/advanced-mariadb-features-that-developers-lovepdf/252036945 FedericoRazzoli@slideshare.net(FedericoRazzoli) Advanced MariaDB features that developers love.pdf FedericoRazzoli MariaDB is one of the most widely used relational databases. It is compatible with MySQL for most practical purposes, and it is appreciated by developers communities all over the world. Over the years, MariaDB has developed many features that are extremely useful for developers, saving a lot of development time and enabling its use in situations where it wouldn't be practical otherwise. In this talk, we'll briefly discuss some of those features and why they are so useful. We'll talk about: * Querying remote or heterogeneous data sources in SQL; * Using temporal tables to analyse how data changes over time; * Using JSON in a relational database; * Miscellaneous tips and tricks. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/advancedmariadbfeaturesthatdeveloperslove-220622081825-6877714d-thumbnail.jpg?width=120&height=120&fit=bounds" /> MariaDB is one of the most widely used relational databases. It is compatible with MySQL for most practical purposes, and it is appreciated by developers communities all over the world. Over the years, MariaDB has developed many features that are extremely useful for developers, saving a lot of development time and enabling its use in situations where it wouldn't be practical otherwise. In this talk, we'll briefly discuss some of those features and why they are so useful. We'll talk about: * Querying remote or heterogeneous data sources in SQL; * Using temporal tables to analyse how data changes over time; * Using JSON in a relational database; * Miscellaneous tips and tricks.

Advanced MariaDB features that developers love.pdf from Federico Razzoli

]]> 143 0 https://cdn.slidesharecdn.com/ss_thumbnails/advancedmariadbfeaturesthatdeveloperslove-220622081825-6877714d-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Automate MariaDB Galera clusters deployments with Ansible /slideshow/automate-mariadb-galera-clusters-deployments-with-ansible/245106932 ansiblemariadbgalera-210326102604
Best practices for writing Ansible roles to administrate a real world MariaDB Galera Cluster, including monitoring, backups,, cron jobs, and so on.]]>
Best practices for writing Ansible roles to administrate a real world MariaDB Galera Cluster, including monitoring, backups,, cron jobs, and so on.]]> Fri, 26 Mar 2021 10:26:04 GMT /slideshow/automate-mariadb-galera-clusters-deployments-with-ansible/245106932 FedericoRazzoli@slideshare.net(FedericoRazzoli) Automate MariaDB Galera clusters deployments with Ansible FedericoRazzoli Best practices for writing Ansible roles to administrate a real world MariaDB Galera Cluster, including monitoring, backups,, cron jobs, and so on. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/ansiblemariadbgalera-210326102604-thumbnail.jpg?width=120&height=120&fit=bounds" /> Best practices for writing Ansible roles to administrate a real world MariaDB Galera Cluster, including monitoring, backups,, cron jobs, and so on.

Automate MariaDB Galera clusters deployments with Ansible from Federico Razzoli

]]> 621 0 https://cdn.slidesharecdn.com/ss_thumbnails/ansiblemariadbgalera-210326102604-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Creating Vagrant development machines with MariaDB /slideshow/creating-vagrant-development-machines-with-mariadb/241401177 vagrantmariadb-210115155804
How to create Vagrant development machines with MariaDB running on them. Best practices to follow to achieve production parity and code testability.]]>
How to create Vagrant development machines with MariaDB running on them. Best practices to follow to achieve production parity and code testability.]]> Fri, 15 Jan 2021 15:58:04 GMT /slideshow/creating-vagrant-development-machines-with-mariadb/241401177 FedericoRazzoli@slideshare.net(FedericoRazzoli) Creating Vagrant development machines with MariaDB FedericoRazzoli How to create Vagrant development machines with MariaDB running on them. Best practices to follow to achieve production parity and code testability. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/vagrantmariadb-210115155804-thumbnail.jpg?width=120&height=120&fit=bounds" /> How to create Vagrant development machines with MariaDB running on them. Best practices to follow to achieve production parity and code testability.

Creating Vagrant development machines with MariaDB from Federico Razzoli

]]> 66 0 https://cdn.slidesharecdn.com/ss_thumbnails/vagrantmariadb-210115155804-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 MariaDB, MySQL and Ansible: automating database infrastructures /slideshow/mariadb-mysql-and-ansible-automating-database-infrastructures/240134551 ansiblemariadb-201215114609
Automating database infrastructures is important. Here you can find some hints and good practices, as well as a general explanation of Ansible.]]>
Automating database infrastructures is important. Here you can find some hints and good practices, as well as a general explanation of Ansible.]]> Tue, 15 Dec 2020 11:46:09 GMT /slideshow/mariadb-mysql-and-ansible-automating-database-infrastructures/240134551 FedericoRazzoli@slideshare.net(FedericoRazzoli) MariaDB, MySQL and Ansible: automating database infrastructures FedericoRazzoli Automating database infrastructures is important. Here you can find some hints and good practices, as well as a general explanation of Ansible. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/ansiblemariadb-201215114609-thumbnail.jpg?width=120&height=120&fit=bounds" /> Automating database infrastructures is important. Here you can find some hints and good practices, as well as a general explanation of Ansible.

MariaDB, MySQL and Ansible: automating database infrastructures from Federico Razzoli

]]> 277 0 https://cdn.slidesharecdn.com/ss_thumbnails/ansiblemariadb-201215114609-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Playing with the CONNECT storage engine /slideshow/playing-with-the-connect-storage-engine/238562581 connect-200920172744
CONNECT is a storage engine for MariaDB. It allows to use external, possibly remote data sources of several types. We can then query them as if they were local relational tables. In this presentation, Federico Razzoli demonstrates a couple of interesting things we can do with it. The talk took place at MariaDB Server Fest 2020.]]>
CONNECT is a storage engine for MariaDB. It allows to use external, possibly remote data sources of several types. We can then query them as if they were local relational tables. In this presentation, Federico Razzoli demonstrates a couple of interesting things we can do with it. The talk took place at MariaDB Server Fest 2020.]]> Sun, 20 Sep 2020 17:27:44 GMT /slideshow/playing-with-the-connect-storage-engine/238562581 FedericoRazzoli@slideshare.net(FedericoRazzoli) Playing with the CONNECT storage engine FedericoRazzoli CONNECT is a storage engine for MariaDB. It allows to use external, possibly remote data sources of several types. We can then query them as if they were local relational tables. In this presentation, Federico Razzoli demonstrates a couple of interesting things we can do with it. The talk took place at MariaDB Server Fest 2020. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/connect-200920172744-thumbnail.jpg?width=120&height=120&fit=bounds" /> CONNECT is a storage engine for MariaDB. It allows to use external, possibly remote data sources of several types. We can then query them as if they were local relational tables. In this presentation, Federico Razzoli demonstrates a couple of interesting things we can do with it. The talk took place at MariaDB Server Fest 2020.

Playing with the CONNECT storage engine from Federico Razzoli

]]> 135 0 https://cdn.slidesharecdn.com/ss_thumbnails/connect-200920172744-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 MariaDB Temporal Tables /slideshow/mariadb-temporal-tables-238562566/238562566 temporaltables-200920172128
Temporal Tables are a great MariaDB feature that allows us to query past data, seeing how data were at a certain point in time, or how they changed over a given period. The slides illustrate the feature itself, how to use it, what can be done with it, and a set of opinionated good practices. Federico Razzoli gave this talk at MariaDB Server Fest 2020.]]>
Temporal Tables are a great MariaDB feature that allows us to query past data, seeing how data were at a certain point in time, or how they changed over a given period. The slides illustrate the feature itself, how to use it, what can be done with it, and a set of opinionated good practices. Federico Razzoli gave this talk at MariaDB Server Fest 2020.]]> Sun, 20 Sep 2020 17:21:28 GMT /slideshow/mariadb-temporal-tables-238562566/238562566 FedericoRazzoli@slideshare.net(FedericoRazzoli) MariaDB Temporal Tables FedericoRazzoli Temporal Tables are a great MariaDB feature that allows us to query past data, seeing how data were at a certain point in time, or how they changed over a given period. The slides illustrate the feature itself, how to use it, what can be done with it, and a set of opinionated good practices. Federico Razzoli gave this talk at MariaDB Server Fest 2020. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/temporaltables-200920172128-thumbnail.jpg?width=120&height=120&fit=bounds" /> Temporal Tables are a great MariaDB feature that allows us to query past data, seeing how data were at a certain point in time, or how they changed over a given period. The slides illustrate the feature itself, how to use it, what can be done with it, and a set of opinionated good practices. Federico Razzoli gave this talk at MariaDB Server Fest 2020.

MariaDB Temporal Tables from Federico Razzoli

]]> 184 0 https://cdn.slidesharecdn.com/ss_thumbnails/temporaltables-200920172128-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Database Design most common pitfalls /slideshow/database-design-most-common-pitfalls/236142378 dbdesigncommonpitfalls-200624083427
It's easy to see antipatterns in production databases. Our schemas should be simple but extensible, and allow fast SQL queries. In this webinar I discuss what most common antipatterns are, and how to correct them.]]>
It's easy to see antipatterns in production databases. Our schemas should be simple but extensible, and allow fast SQL queries. In this webinar I discuss what most common antipatterns are, and how to correct them.]]> Wed, 24 Jun 2020 08:34:27 GMT /slideshow/database-design-most-common-pitfalls/236142378 FedericoRazzoli@slideshare.net(FedericoRazzoli) Database Design most common pitfalls FedericoRazzoli It's easy to see antipatterns in production databases. Our schemas should be simple but extensible, and allow fast SQL queries. In this webinar I discuss what most common antipatterns are, and how to correct them. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/dbdesigncommonpitfalls-200624083427-thumbnail.jpg?width=120&height=120&fit=bounds" /> It's easy to see antipatterns in production databases. Our schemas should be simple but extensible, and allow fast SQL queries. In this webinar I discuss what most common antipatterns are, and how to correct them.

Database Design most common pitfalls from Federico Razzoli

]]> 554 0 https://cdn.slidesharecdn.com/ss_thumbnails/dbdesigncommonpitfalls-200624083427-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 MySQL and MariaDB Backups /slideshow/mysql-and-mariadb-backups/234648105 mysqlbackups-200527204842
MySQL backups overview. Characteristics of every backup type, including dumps, Xtrabackup and snapshots. Planning proper backup strategies. Why and how to test backups.]]>
MySQL backups overview. Characteristics of every backup type, including dumps, Xtrabackup and snapshots. Planning proper backup strategies. Why and how to test backups.]]> Wed, 27 May 2020 20:48:41 GMT /slideshow/mysql-and-mariadb-backups/234648105 FedericoRazzoli@slideshare.net(FedericoRazzoli) MySQL and MariaDB Backups FedericoRazzoli MySQL backups overview. Characteristics of every backup type, including dumps, Xtrabackup and snapshots. Planning proper backup strategies. Why and how to test backups. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/mysqlbackups-200527204842-thumbnail.jpg?width=120&height=120&fit=bounds" /> MySQL backups overview. Characteristics of every backup type, including dumps, Xtrabackup and snapshots. Planning proper backup strategies. Why and how to test backups.

MySQL and MariaDB Backups from Federico Razzoli

]]> 797 0 https://cdn.slidesharecdn.com/ss_thumbnails/mysqlbackups-200527204842-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 JSON in MySQL and MariaDB Databases /slideshow/json-in-mysql-and-mariadb-databases/231493847 jsoninmysqlandmariadbdatabases-200406103036
JSON data can be inserted in MySQL/MariaDB databases, combining the schemaful and schemaless approaches to obtain powerful results. We can combine them with features like indexes, checks, foreign keys, as well as the JSON Schema and JSON Path languages.]]>
JSON data can be inserted in MySQL/MariaDB databases, combining the schemaful and schemaless approaches to obtain powerful results. We can combine them with features like indexes, checks, foreign keys, as well as the JSON Schema and JSON Path languages.]]> Mon, 06 Apr 2020 10:30:36 GMT /slideshow/json-in-mysql-and-mariadb-databases/231493847 FedericoRazzoli@slideshare.net(FedericoRazzoli) JSON in MySQL and MariaDB Databases FedericoRazzoli JSON data can be inserted in MySQL/MariaDB databases, combining the schemaful and schemaless approaches to obtain powerful results. We can combine them with features like indexes, checks, foreign keys, as well as the JSON Schema and JSON Path languages. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/jsoninmysqlandmariadbdatabases-200406103036-thumbnail.jpg?width=120&height=120&fit=bounds" /> JSON data can be inserted in MySQL/MariaDB databases, combining the schemaful and schemaless approaches to obtain powerful results. We can combine them with features like indexes, checks, foreign keys, as well as the JSON Schema and JSON Path languages.

JSON in MySQL and MariaDB Databases from Federico Razzoli

]]> 933 1 https://cdn.slidesharecdn.com/ss_thumbnails/jsoninmysqlandmariadbdatabases-200406103036-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 How MySQL can boost (or kill) your application v2 /slideshow/how-mysql-can-boost-or-kill-your-application-v2/204970390 mysqlcanboostorkillv2-191212153205
MySQL can boost your applications, if used properly. Or it can kill them, if you don't really understand what you're doing.]]>
MySQL can boost your applications, if used properly. Or it can kill them, if you don't really understand what you're doing.]]> Thu, 12 Dec 2019 15:32:05 GMT /slideshow/how-mysql-can-boost-or-kill-your-application-v2/204970390 FedericoRazzoli@slideshare.net(FedericoRazzoli) How MySQL can boost (or kill) your application v2 FedericoRazzoli MySQL can boost your applications, if used properly. Or it can kill them, if you don't really understand what you're doing. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/mysqlcanboostorkillv2-191212153205-thumbnail.jpg?width=120&height=120&fit=bounds" /> MySQL can boost your applications, if used properly. Or it can kill them, if you don't really understand what you're doing.

How MySQL can boost (or kill) your application v2 from Federico Razzoli

]]> 130 2 https://cdn.slidesharecdn.com/ss_thumbnails/mysqlcanboostorkillv2-191212153205-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 https://cdn.slidesharecdn.com/profile-photo-FedericoRazzoli-48x48.jpg?cb=1715791728 I founded Vettabase in 2020. I'm passionate about databases and I am an open source supporter. vettabase.com https://cdn.slidesharecdn.com/ss_thumbnails/webinardesigningaschemaforadatawarehouse-240607131129-b6f7c7b7-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/webinar-designing-a-schema-for-a-data-warehouse/269559937 Webinar: Designing a s... https://cdn.slidesharecdn.com/ss_thumbnails/high-levelarchitectureofacompletemariadbsetup-240515165134-5a961834-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/high-level-architecture-of-a-complete-mariadb-deployment/268516822 High-level architectur... https://cdn.slidesharecdn.com/ss_thumbnails/webinar-unleashaipowerwithmysqlandmindsdb-240124193057-5880c602-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/webinar-unleash-ai-power-with-mysql-and-mindsdb/265773015 Webinar - Unleash AI p...