Please join Percona’s Information Security Architect, David Bubsy, as he presents his talk Web Application Security – Why You Should Review Yours on March 14th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4).
In this talk, we take a look at the whole stack and I don’t just mean LAMP.
We’ll cover what an attack surface is and some areas you may look to in order to ensure that you can reduce it.
For instance, what’s an attack surface?
Acronym Hell, what do they mean?
…
[Read more]One of the great things about Percona Monitoring and Management (PMM) is its flexibility. An example of that is how one can go beyond the exporters to collect data. One approach to achieve that is using textfile collectors, as explained in Extended Metrics for Percona Monitoring and Management without modifying the Code. Another method, which is the subject matter of this post, is to use custom queries.
While working on a customer’s contention issue I wanted to check the behaviour of InnoDB Mutexes over time. Naturally, I went straight to PMM and didn’t find a graph suitable for my needs. No graph, no problem! Luckily anyone can enhance PMM. So here’s how I made the …
[Read more]MySQL Community Awards take place every year, during the Percona Live Open Source Database Conference – this year in Austin, TX.
The MySQL Community Awards is a community-based initiative. The idea is to publicly recognize contributors to the MySQL ecosystem. The entire process of discussing, voting and awarding is controlled by an independent group of community members, typically past winners or their representatives, as well as known contributors.
It is a self-appointed, self-declared, self-making-up-the-rules-as-it-goes committee. It is also very aware of the importance of the community; a no-nonsense, non-political, adhering to tradition, self-criticizing committee.
The Call for Nominations is open. We are seeking the community’s assistance in nominating candidates in the following categories:
MySQL Community Awards: Community Contributor of the year 2019
This is a personal award; a winner would be …
[Read more]Galera replication is relatively new if compared to MySQL replication, which is natively supported since MySQL v3.23. Although MySQL replication is designed for master-slave unidirectional replication, it can be configured as an active master-master setup with bidirectional replication. While it is easy to set up, and some use cases might benefit from this “hack”, there are a number of caveats. On the other hand, Galera cluster is a different type of technology to learn and manage. Is it worth it?
In this blog post, we are going to compare master-master replication to Galera cluster.
Replication Concepts
Before we jump into the comparison, let’s explain the basic concepts …
[Read more]On previous posts about Group Replication consistency we:
In blog 3. we presented the consistency levels: EVENTUAL, BEFORE, AFTER and BEFORE_AND_AFTER; their scopes: SESSION, GLOBAL; and their context: whether they only impact the ongoing transaction or all concurrent transactions.…
Tweet Google …
[Read more]Open source databases are quickly becoming mainstream, so migration from proprietary engines into open source engines is a kind of an industry trend now. It also means that we DBA’s often end up having multiple database backends to manage.
In the past few blog posts, my colleague Paul Namuag and I covered several aspects of migration from Oracle to Percona, MariaDB, and MySQL. The obvious goal for the migration is to get your application up and running more efficiently in the new database environment, however it’s crucial to assure that staff is ready to support it.
Related resources
Migration from Oracle Database to MariaDB - A Deep Dive
…
[Read more]MySQL Community with an APAC MySQL team are going to be part of the FOSSASIA Summit this week. We are a Bronze sponsor with a MySQL booth in the exhibition area. We are also having several talks in the Database track on Saturday, March 16, please see some of them below together with the details about the show:
Author: Scott Stone
We are pleased to announce the general availability of SQL Diagnostic Manager for MySQL 8.8. Existing users may upgrade to this version through the Idera Customer Portal. New users may download the trial version from the Idera Website or the Monyog Website.
Rebranded from the popular Monyog product for monitoring performance of MySQL and other MySQL compatible databases, SDM for MySQL is a comprehensive solution to monitor, alert, and diagnose the availability, health, and performance of MySQL, or MariaDB in physical, virtual, and cloud environments.
SQL Diagnostic Manager for MySQL addresses the most critical performance …
[Read more]MySQL error log contains diagnostics messages such as errors, warnings and notes that occur during MySQL startup, shutdown and while the server is running. For example, a InnoDB table is corrupted and need to repaired, This will be recorded in the error log. MySQL 8.0 Error uses the MySQL component architecture for log event filtering and writing. The MySQL system variable log_error_services controls which log components to enable and the rules for filtering the log events. The component table in the mysql system database contains the information about currently loaded comments and shows which components have been registered with INSTALL COMPONENT. To confirm the components installed, you may use the SQL below:
SELECT * FROM mysql.component;
Currently the available log components are in lib/plugins:
I have had some requests to write some blogs on the basics of
using PHP and MySQL together. This will not be a series for
the experienced as it will start at a level where I will go into
a lot of details but expect very few prerequisites from the
reader. If this is not you, please move on. If it is you
and you read something you do not understand, please contact me
to show me where I assumed too much.
PHP and MySQL are both in their mid twenties and
both vital in the worlds of developers. With the big
improvements in PHP 7 and MySQL 8, I have found a lot of
developers flocking to both but stymied by the examples they see
as their are many details not explained. So let's get to the
explaining!
1. Use the latest software
If you are not using PHP 7.2 or 7.3 (or maybe 7.1) then you are
missing out in features and performance. The PHP 5.x series
is deprecated, no longer support, and …
