MySQL 8.0.11 comes with a catalog of 5108 spatial reference systems (SRSs): 4628 projections (flat maps), 479 geographic (ellipsoidal) representations of Earth, and one Cartesian all-purpose abstract plane (SRID 0).
Projections
Projected SRSs are Cartesian planes, just like SRID 0.…
Earlier this year, I was presented with the challenge of streamlining user access to MySQL, allowing users self-serve access using their LDAP credentials, while logging all access. Of course, various MySQL forks allow for user auditing, but the solution is also needed to eventually support other data storage systems without native user auditing. This gave me the opportunity to do a trial integration of MySQL, Vault, ProxySQL, and LDAP; Vault would be used to dynamically create user accounts, and ProxySQL would be used to limit access and log activity. To evaluate the functionality and configuration of the integration, I used Docker to set up a test environment.
Below I will present the methods used to:
[Read more]Join Percona CTO Vadim Tkachenko at the Cloud Native Utah meetup in Salt Lake City on Tuesday, May 8, 2018, for an Intro to ClickHouse.
Next week, I’ll be switching from MyRocks performance testing and present an introduction to ClickHouse to the Cloud Native Utah meetup.
Interestingly enough, even though it is totally different from OLTP engines, ClickHouse uses a MergeTree engine. MergeTree engines have a lot of similarities with Log Structured Merge Tree (which is what is used by MyRocks / RocksDB). This the structure is optimized to run on huge datasets / low memory scenarios.
PingCAP TiDB and …
[Read more]
NDB Cluster was designed from the ground up for real-time
operations.
It has its origins in the telecom industry where predictability
of performance
and latency is absolutely critical. In addition the telecom
vendors are
competing very much on pricing of their product.
This leads to that it is important to get the most performance
from each
telecom server. Increasing the performance by 10% means that you
need 10%
less network equipment. If many servers are shipped this can be a
substantial
cost that is worth spending valuable engineering time to
achieve.
Thus if you are using or are planning to MySQL Cluster on many
servers it
is a good idea to spend some time ensuring that one achieves
optimal
performance. If you are operating MySQL Cluster in just a few
servers the
payback on your time investment might not be as high.
Another reason to …
In this blog post, I’ll look at MyRocks performance through some benchmark testing.
As the MyRocks storage engine (based on the RocksDB key-value store http://rocksdb.org ) is now available as part of Percona Server for MySQL 5.7, I wanted to take a look at how it performs on a relatively high-end server and SSD storage. I wanted to check how it performs for different amounts of available memory for the given database size. This is similar to the benchmark I published a while ago for InnoDB (https://www.percona.com/blog/2010/04/08/fast-ssd-or-more-memory/).
In this case, I plan to use a sysbench-tpcc benchmark ( …
[Read more]This blog post describes how to keep sensitive data secure on slave servers in a MySQL async replication setup.
Almost every web application has a sensitive data: passwords,
SNN, credit cards, emails, etc. Splitting the database to
secure and “public” parts allows for restricting user and
application parts access to sensitive data.
Field encryption
This is based on MySQL encryption functions or on client-side encryption when the authorized user knows a secret, but encrypted data is distributed to all slaves.
Last week, Ubuntu released their newest long term support version, Ubuntu 18.04. As of today, we offer 18.04 packages for recent versions of almost all MySQL products, both for manual download and through our APT repos. Congratulations to the Ubuntu community on another solid release, and a special shout-out to our friends over at Canonical: we […]
Dear MySQL Users,
A new GA (general availability) version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.1.11 GA. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server 5.5 or newer.
You can download the production release at:
http://dev.mysql.com/downloads/connector/cpp/1.1.html
MySQL Connector C++ (Commercial) will be available for download on the My Oracle Support (MOS) website. This release will be available on eDelivery (OSDC) in next month’s upload cycle.
The MySQL driver for C++ offers an easy to use API derived from JDBC 4.0. MySQL Workbench has used it successfully for years.
We have improved the driver since the last GA release. Please see the documentation and the CHANGES file in the source distribution for a detailed description of …
[Read more]Dear MySQL users,
MySQL Connector/NET 6.10.7 is the fourth GA release with .NET
Core
now supporting various connection-string options and MySQL 8.0
server
features.
To download MySQL Connector/NET 6.10.7 GA, see the “Generally
Available
(GA) Releases” tab at http://dev.mysql.com/downloads/connector/net/
Changes in MySQL Connector/NET 6.10.7 (2018-04-30, General Availability) Functionality Added or Changed * Connections made to MySQL 8.0 (up to and including version 8.0.3) and compatibility with the new data dictionary are now supported. For information about the data dictionary, see MySQL Data Dictionary (http://dev.mysql.com/doc/refman/8.0/en/data-dictionary.html). * Support for the caching_sha2_password …[Read more]
MySQL 8.0 brings a lot of new spatial features. The main feature is the support for multiple spatial reference systems (SRSs).
Spatial reference systems is not a new concept in MySQL, but 8.0 is the first version where it affects computations, and it’s the first version where users actually have to think about it.…
