This talk will explain the steps needed to make connection from Java to MySQL work and highlight potential issues you might encounter. It will cover all components, installation, and configuration.
In this talk, you'll be introduced to the basic concepts of profiling Java code using perf_events (aka perf). You'll see how to collect stack traces, and how to use Flame Graphs to provide a dynamic visual display for them. This, in turn, allows you to see if your code has room for improvement â€“ and where it could be improved â€“ in an easy and scalable way.
It doesn't matter if you are coding a one-hundred or a one-hundred thousand-line application, the Flame Graph visualizer will make it easy to spot CPU hogs! After checking some basic how-to steps and recipes, I will take a deeper dive into using perf and Flame Graphs, to demonstrate how to make the most of these tools.
Finally, I'll show you examples through use cases that should help you to better understand the purpose behind the workflow and tools.
This presentation will go through the simple process of accessing data from a Java application. What actually happens when we use a simple direct connection, and what instead happens using an ORM/Persistent layer like hibernate. How this apparently makes programmers life easier... and the DBA's days more difficult.
MongoBD is one of the most popular NoSQL database: how can we get started?
This talk will explore Document Oriented Modeling, Spring Data MongoDB framework features and lessons learned using this stack in production.
It's easy for Java developers (and users of other OO languages) to mix object-oriented thinking and imperative thinking. But when it comes to writing SQL the nightmare begins! Firstly because SQL is a declarative language and it has nothing to do with either OO or imperative thinking and as for one point it makes it relatively easy to express a condition in SQL it is not so easy to express it optimally and even worse to translate it to the OO paradigm. For another point, they need to think in terms of set and relational algebra, even if unconsciously!
In this talk, we'll see the most common mistakes that OO, and in special Java, developers make when writing SQL code and how we can avoid them.
Usually, Java applications use databases as storage. With an already working app, it's not necessarily so easy to support and maintain. We'll review some cases where you have a MySQL-powered Java application, and how you can easily set up monitoring for it using PMM. You'll see information about Java, system, and database in one system, and will be able to analyze it,
We'll see the latest version of Percona Monitoring and Management system (PMM) and combine it with JMX exporter to get data from Java metrics. All of these will be collected in Prometheus. We'll review dashboards and see how to make your own dashboards.