In the light of support for Percona XtraDB Cluster (PXC), the DBdeployer anniversary, and the newly released Percona XtraDB Cluster 8.0, I’m happy to announce that Giuseppe Maxia has recently updated DBdeployer to support Percona XtraDB Cluster 8.0.
We at Percona, with my colleague Ramesh Sivaraman, have tested and deployed Percona XtraDB Cluster (PXC) 8.0.18 successfully using DBdeployer.
What is DBdeployer and How Do You …
[Read more]It is common knowledge that built-in asynchronous master-master (active-active) replication is not safe in MySQL. I remember times when the official MySQL User Reference Manual stated that such an installation is not recommended for production use. Some experts repeat this claim even now.
While this statement is generally true, I worked with thousands of shops that successfully avoided asynchronous replication limitations in active-active setups.
In this talk, I will show how they did it, demonstrate situations when asynchronous master-master replication is the best possible high availability option and beats such solutions as Galera or InnoDB Clusters. I will also cover common mistakes, leading to disasters.
Please join Sveta Smirnova of Percona, on Thursday, May 21 at 12 pm EDT for her webinar “How Safe is Asynchronous Master-Master Setup in MySQL?”.
…
[Read more]Human geography examines the dynamics of cultures, societies and economies, and physical geography examines the dynamics of physical landscapes and the environment.
In this blog i am going to explain what are the new Geography features available in MySQL 8.0
Major Difference in MySQL 5.7 & 8.0 Geography :
There is a big change from MySQL 5.7 to 8.0 when it comes to spatial data, it’s support, multiple spatial reference systems and geographic computations.
This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs(spatial reference identifier) are ignored, and all computations are Cartesian.
What’s new in MySQL 8.0?
* Introduced ellipsoid computation instead of flat plane cartesian.
* Introduced multiple spatial reference systems. …
[Read more]My students want to transfer their course setup MySQL files from the Linux VM that I provide to Microsoft Windows 10. This post explains how because I found a couple small errors in the Google’d posts they would most likely see.
The first step is required because when I didn’t assign a name or domain to the the Fedora VM, which allows it to run as localhost on any student machine. In tandem, I didn’t assign a static IP address but opted for dynamic IP assignment. That means, the first step to securely copy the files requires you to find the assigned IP address. You can do that with the following Linux command:
ifconfig -a | grep 'inet[[:blank:]]' | head -1 | cut -c 14-30
It would return something like:
192.168.147.198
After you have discovered the IP address, you need to download PuTTy from their web site because includes the pscp (PuTTy …
[Read more]MySQL NDB Cluster 8.0.20 new features
This post is about changes in the implementation of NDB Cluster from MySQL NDB Cluster 8.0 through 8.0.20, as compared to earlier release series. We have included only those of MySQL NDB Cluster 8.0.20 new features which are really interesting and can directly influence / make an impact to performance, scalability and reliability:
In one of the latest post, I discussed how to transform a large MySQL table to JSON using Apache Spark. Well, that approach works for any tables with any volume. But it’s an overkill for simple and small tables. The good news is MySQL by default has a feature for …
The post Export MySQL query results as JSON appeared first on Geeky Hacker.
The new MySQL-8.0.20 release is coming with re-designed InnoDB Double Write Buffer (DBLWR), and, indeed, it's one huge historical PITA less.. -- why it was so painful and cost us much blood in the past, I could not better explain than already done it in the following article yet from 2018 about MySQL on IO-bound workloads.. The story is not complete, as it's missing the 2019's chapter (will tell it later, np) -- but if you'll (re)read the mentioned above article first, you'll better understand the next ;-))
But at least the current post is only about good news now -- the new DBLWR and how it helps to solve historical MySQL performance problems ! -- and as one picture is better than million words, I'll try to save 3M words here (as there are 3 pictures in this article ;-))
Well, I'll also skip all new design details …
[Read more]In this post, we introduce a configuration option that controls whether replication channels allow the creation of tables without primary keys. This continues our recent work on replication security, where we allowed users to enforce privilege checks, and/or enforce row-based events.…
Tweet Share
Peter Zaitsev, Founder and CEO at Percona, presents a webinar focused on dealing with an unexpected high traffic event as it is happening. He’ll address the impact a traffic spike can have on your database – from poor query response time to replication lag issues – and provide actionable tips and tricks. Join us and learn how to bring your database under control, earn performance gains, and delight your customers!
Please join Peter Zaitsev, CEO of Percona, on Wednesday, May 13 at 12 pm EDT for his webinar “18 Things To Do When You Have a MySQL Bottleneck“.
If you can’t attend, sign up anyway and we’ll send you the slides and recording afterward.
Dear MySQL Users,
MySQL Connector/J 5.1.49, a maintenance release of the production
5.1
branch, has been released. Connector/J is the Type-IV pure-Java
JDBC
driver for MySQL.
MySQL Connector/J is available in source and binary form from
the
Connector/J download pages at
http://dev.mysql.com/downloads/connector/j/5.1.html
and mirror sites as well as Maven repositories.
MySQL Connector/J (Commercial) is available for download on the
My Oracle
Support (MOS) website. This release will shortly be available
on
eDelivery (OSDC).
As always, we recommend that you check the “CHANGES” file in
the
download archive to be aware of changes in behavior that might
affect
your application.
MySQL Connector/J 5.1.49 includes the following …