(Hannes Du Preez) .NET is great and provides a ton of tools for working with databases and data sources. There are times though that a data source may not be inherently supported.
Tag: Open Source
Use Cases for MySQL NDB Cluster 8.0
(Mikael Ronstrom) In this blog I will go through a number of popular applications that use NDB Cluster 8.0 and also how these applications have developed over the years.
A must-know about NOT IN in SQL – more antijoin optimization
(Guilhem Bichot) I will try to make it short and clear: if you are writing SQL queries with “NOT IN” like SELECT … WHERE x NOT IN (SELECT y FROM …) you have to be sure to first understand what happens when “x” or “y” are NULL: it might not be what you want! And if it is not, I […]
MySQL ERROR 1034: Incorrect Key File on InnoDB Table
(Peter Zaitsev) Sometimes, you may experience “ERROR 1034: Incorrect key file” while running the ALTER TABLE or CREATE INDEX command:
Requirements on NDB Cluster 8.0
(Mikael Ronstrom) In this blog I am going to go through the most important requirements that NDB Cluster 8.0 is based on. I am going to also list a number of consequences these requirements have on the product and what it supports.
3 Step Migration of MySQL data to Clickhouse for faster analytics.
(Sri Sakthivel) Recently one of our client approach Mydbops with Query slowness on a MySQL environment . They deployed the new code for generate the huge reports for the year end analytics data.
Influences leading to Asynchronous Programming Model in NDB Cluster
(Mikael Ronstrom) A number of developments was especially important in influencing the development of NDB Cluster. I was working at Ericsson, so when I didn’t work on DBMS research I was deeply involved in prototyping the next generation telecom switches.
What to Check if MySQL Memory Utilisation is High
(Paul Namuag) One of the key factors of a performant MySQL database server is having good memory allocation and utilization, especially when running it in a production environment.
Make It Smarter: Tuning MySQL Client Request Routing for Tungsten Connector
(Eric M. Stone) In this blog post we explore various options for tuning MySQL traffic routing in the Tungsten Connector for better control of the distribution.
MySQL Encryption: How Master Key Rotation Works
(Robert Golebiowski) In the last blog post of this series, we discussed in detail how Master Key encryption works. In this post, based on what we already know about Master Key encryption, we look into how Master Key rotation works.