(Lalit) If you walk through any office you see people working in Excel. With MySQL for Excel (https://www.mysql.com/why-mysql/windows/excel/) you can already let them pull information from Excel themselves. However, in some cases it saves a lot of time if they don’t have to pull the information, but

(Satej Sahu) Sometimes we are not sure if the database design we have created and our site has been using is correct and optimised. We all do have this feeling at times don’t we 🙂

(Peter Zaitsev) In this blog post, I’ll discuss MySQL sharding models, and how they apply to SaaS application environments.

(Dave Stokes) SQL Injection is a highly feared and often misunderstood problem. The basic phobia is that someone hijacks your SQL request and suddenly has full access to everything in your database. Well, it usually is not that easy and it is actually easy to avoid.

(Krzysztof Ksiazek) MySQL replication setups are inevitably related to failovers. Unlike multi-master clusters like Galera, there is one single writer in a whole setup – the master. If the master fails, one of the slaves will have to take its role through the process of failover.

(Shlomi Noach) I’m experimenting with sqlite as backend database for orchestrator. While orchestrator manages MySQL replication topologies, it also uses MySQL as backend. For some deployments, and I’m looking into such one, having MySQL as backend is a considerable overhead.

(Valeriy Kravchuk) Oprofile was widely used for MySQL profiling on Linux in the past. But since 2010 and 2.6.31 Linux kernels another profiler, perf, gets increasing popularity. It uses performance counters (CPU hardware registers that count hardware events such as instructions executed) subsystem i

(Marcelo Altmann) In today’s blog, I will show an issue with seconds_behind_master that one of our clients faced when running slave_parallel_works > 0. We found out that the reported seconds_behind_master from SHOW SLAVE STATUS was lying.

(Shinguz) When we do Galera Cluster consulting we always discuss with the customer if his software is Galera Cluster ready. This basically means: Can the software cope with the Galera Cluster specifics?

(Krzysztof Ksiazek) A proxy layer is an important building block for any highly available database environment. HAProxy has been available for a long time, as a generic TCP load balancer.