(Max Dudin) Day-to-day database operation requires, from an administrator, deep knowledge of db internals and security issues, in particular things like SQL injections.
Tag: Open Source
(Paul Moen) Your favourite monitoring software throws an alert or sends an email after it finds the following in the mysql error log:
MySQL powers all the major internet properties, Which include Google, Facebook, Twitter, LinkedIn, Uber etc. So how do we plan for MySQL disaster recovery and what are the most common MySQL DR tools used today for building highly reliable database infrastructure operations ?
(Carlos Salguero) Even though Percona Monitoring and Management 2 (PMM) comes with a lot of dashboards and metrics out of the box, sometimes we need to extend the default metrics by running custom MySQL queries.
(Kasra Madadipouya) Quarkus is a supersonic Java framework built with a cloud-native first mentality. It’s blazing fast in startup and has a much smaller memory footprint compared to Spring Boot. Quarkus is well integrated with Hibernate and works flawlessly.
(Krzysztof Ksiazek) These days databases spanning across multiple clouds are quite common. They promise high availability and possibility to easily implement disaster recovery procedures.
(Shahid shaikh) Node.js and MySQL are one of the necessary binding needed for any web application. MySQL is one of the most popular open-source databases in the world and efficient as well.
Modern approaches to replacing accumulation user-defined variable hacks, via MySQL 8.0 Window functions and CTEs
(Saverio Miroddi) A common MySQL strategy to perform updates with accumulating functions is to employ user-defined variables, using the UPDATE […] SET mycol = (@myvar := EXPRESSION(@myvar, mycol)) pattern.
(Ankit Kumar) Backup of Database is the pillar of our system which is necessary and mandatory to provide us data incase of crash, new machine provisioning and many other scenarios listed here.
(Dave Stokes) Constraint Checks that actually checked the constraints were introduced last year with MySQL 8.0.16 and they really do help you keep bad data out of your database.