(Carlos Tutte and marcos.albe) During our work in support, we see this again and again: “I try to connect to MySQL and am getting a 1045 error”, and most times it comes accompanied with “…but I am sure my user and password are OK”.
Tag: Open Source
(Ivan Ma) This tutorial is showing how manual fix of GTID inconsistency but it can be VERY RISKY to mess up the InnoDB Cluster.
(Krzysztof Ksiazek) Most databases grow in size over time. The growth is not always fast enough to impact the performance of the database, but there are definitely cases where that happens.
(Przemys³aw Malkowski) I think it is often confusing to compare upstream MySQL and Percona Server for MySQL, and some helpful information can be found in the introductory notes.
(Vlad Mihalcea) In this article, we are going to test the MySQL 8 implementation of custom SQL CHECK constraints.
(Robert Agar) The working life of a DBA is often centered on optimizing their systems to provide users with the best performance. There are many aspects of a MySQL implementation that can be tuned to increase its functionality.
(Ankit Kumar) There could be various requirements at application end which need realtime slaves. Let me introduce a solution to a problem we used to face how can we monitor whether our slaves are real time or they are lagging in Milliseconds.
(Pete Freitag) Ran into an interesting situation trying to configure a MySQL JDBC driver to connect over TLS (though the driver may call it SSL, TLS is the name for more recent versions of the protocol).
(Mike Benshoof) The CTO has issued the decree: “We are moving to the cloud!” Great, so now what do we do? When it comes to migrating from on-premise to the cloud, there are many factors to consider and decisions that need to be made.
(Dave Stokes) MySQL has added a lot of functionality for Geographical Information System (GIS) data in the last two releases. This has given us better ways to save and explore GIS data.