MSAndrosov - AI, Cloud, Productivity, Computing, Gaming & Apps

MSAndrosov

Cloud

Software

Networks

Hardware

Deals

Mikandr

Support

MySQL Security from Data Protection to Regulation Compliance

Date:May 22, 2025

Start Time: 10:00 a.m. Pacific Time Duration: 60 mins

In the era of data breaches, security issues can bring lots of headaches to any organization. Besides fines from authorities, bad reputation can put many customers away.

Being able to protect important data from external threats, as well as control the increasing number of people who have internal access to the database systems means minimizing risks and ensuring that monitoring and prevention is in place. Furthermore, to protect sensitive data and privacy of personal information, governments and industry organizations have developed multiple privacy regulations and data protection laws (GDPR, PCI DSS, HIPAA).

Discover how the latest MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools, and technical support to achieve the highest levels of MySQL security.

Event Speaker: Mike Frank, MySQL Product Management Director

Learn more

Optimizing MySQL for Cost Efficiency in the Public Sector – Strategies to Reduce Costs Without Sacrificing Performance

Public sector agencies are under constant pressure to optimize IT spending while ensuring mission-critical database performance. Join us for this webinar to explore how tuning and optimizing MySQL environments can drive significant cost savings while improving efficiency. We'll delve into key strategies for performance tuning, schema and query optimization, and infrastructure consolidation—all tailored to the unique challenges of federal, state, and local government IT. Learn how MySQL Enterprise Edition provides the tools and support needed to enhance security, ensure compliance, and maximize cost efficiency in public sector deployments.
Agenda:

Welcome & Introduction

Welcome and Introductions

Webinar Overview and Key Objectives

Understanding the impact of database efficiency on public sector IT budgets

DLT: Delivering Value to the Public Sector

Introduction of DLT and their partnership with Oracle

Highlighting DLT's expertise and value-added services for public sector clients

How DLT helps agencies streamline procurement and implementation of Oracle solutions

Optimizing MySQL for Cost Efficiency

Understanding cost factors in MySQL environments

Performance tuning as a cost-saving strategy

Schema optimization for efficient data management

Query optimization techniques to reduce resource consumption

Enhancing MySQL Performance and Resource Utilization

Indexing strategies for improved query efficiency

Memory and caching configurations to optimize performance

Connection pooling and concurrency control for workload management

Infrastructure optimization strategies for reduced total cost of ownership

Business Impact and Real-World Success Stories

Demonstrating the business impact of MySQL tuning

Real-world case study: cost savings through MySQL optimization

Best practices for ongoing cost optimization and performance management

Q&A and Closing

Open Q&A session

Summary of key takeaways

Next steps and resources

Oracle Releases Java 24

Oracle today announced the availability of Java 24, the latest version of the world’s number one programming language and development platform. Java 24 (Oracle JDK 24) delivers thousands of improvements to help developers maximize productivity and drive innovation. In addition, enhancements to the platform’s performance, stability, and security help organizations accelerate their business growth. Find out more about the latest Java 24 release at the JavaOne 2025 conference in Redwood Shores, CA on March 18-20, 2025.

“As Java approaches its 30th anniversary later this year it continues to expand its toolset to meet developers’ evolving needs, including capabilities that support the development of AI-powered applications,” said Arnal Dayaratna, research vice president, software development, IDC. “The wide range of capabilities in the new release will help increase developers’ productivity, enabling them to deliver feature-rich applications to their organizations and customers faster and more efficiently. The Java 24 release underscores that Java is unparalleled for the development of enterprise-grade, mission-critical applications at scale.”

“Over the past 30 years, Java has provided developers with a comprehensive platform to build and deploy applications that address a diverse range of use cases,” said Georges Saab, senior vice president, Oracle Java Platform and chair, OpenJDK governing board. “With more than 20 new features spanning every element of Java, including new AI and post-quantum crypto capabilities, the Java 24 release gives developers the tools they need to build innovative, AI-infused applications. As the stewards of Java, we’re excited to work with the global Java community to continue delivering a steady stream of new features via our predictable, six-month cadence.”

MySQL 9.2.0 Release

Oracle has formed a new branch of the MySQL 9.2.0 DBMS. MySQL Community Server 9.2.0 builds are available for all major Linux, FreeBSD, macOS, and Windows distributions. As part of the new release model introduced in 2023, MySQL 9.2 is assigned to the "Innovation" branches, which will also include the next major release of MySQL 9.3. Innovation branches are recommended for those who want to get access to new functionality earlier, are published every 3 months, and are supported only until the next major release is published (for example, after the appearance of branch 9.2, support for branch 9.1 was discontinued). In the summer, they plan to form an LTS release, recommended for implementations that require predictability and long-term preservation of unchanged behavior. Following the LTS branch, a new Innovation branch will be formed - MySQL 10.0.

Major changes in MySQL 9.2:

The MLE (Multilingual Engine Component), which enables the use of code in languages other than SQL in stored procedures and functions, now supports reusable JavaScript libraries. Functions from such libraries can be called from JavaScript stored procedures, but must be explicitly marked as imported using the "export" keyword. New SQL statements "CREATE LIBRARY" and "DROP LIBRARY" have been added to manage the connection of JavaScript libraries. The "SHOW CREATE LIBRARY" statement has been added to view the list of available JavaScript libraries. Information about JavaScript libraries is reflected in the "LIBRARIES" system table, and about stored procedures that use such libraries, in the "ROUTINE_LIBRARIES" table. A library is connected in a stored procedure by specifying a list of libraries in the "USING" statement.
Added API for accessing stored procedures, functions and session variables from JavaScript code. The getFunction() method has been added to access MySQL functions, and the getProcedure() method has been added to stored procedures, returning a Function JavaScript object that can be run with arguments. Variables are accessed directly as properties of the Session JavaScript object. Additionally, the ability to directly access the built-in rand(), sleep(), uuid() and isUUID() functions has been added, which are similar to the SQL functions of the same name.
Added a transaction API from JavaScript that allows you to perform most transaction-related SQL statements, such as START TRANSACTION, COMMIT, ROLLBACK, and SET AUTOCOMMIT.
Added the ability to use MySQL ENUM and SET types in arguments of stored procedures written in JavaScript
Added the CREATE_SPATIAL_REFERENCE_SYSTEM privilege to control the ability to create and delete spatial reference definitions for geographic information systems. This privilege or the SUPER privilege is now required to execute the CREATE SPATIAL REFERENCE SYSTEM, CREATE OR REPLACE SPATIAL REFERENCE SYSTEM, and DROP SPATIAL REFERENCE SYSTEM statements.
The "EXPLAIN FORMAT=JSON" output now includes information about the JSON format version. To set the JSON format version, use the explain_json_format_version variable ("SET explain_json_format_version=1|2").
Deprecated: the "FLUSH PRIVILEGES" statement, the "mysqladmin flush-privileges" and "mysqladmin reload" commands, and the "version_tokens" plugin.
The BINLOG keyword has been deprecated.
A total of 32 vulnerabilities have been fixed, 3 of which can be exploited remotely. The two most serious issues have a severity level of 9.1 and are related to vulnerabilities in the Kerberos and Curl components. Less dangerous vulnerabilities affect InnoDB, Thread Pooling, DDL, optimizer, parser, and authentication system.