Dear MySQL users,
MySQL Connector/C++ 8.0.21 is a new release version of the MySQL
Connector/C++ 8.0 series.
Connector/C++ 8.0 can be used to access MySQL implementing Document
Store or in a traditional way, using SQL queries. It allows writing
both C++ and plain C applications using X DevAPI and X DevAPI for C.
It also supports the legacy API of Connector/C++ 1.1 based on JDBC4.
To learn more about how to write applications using X DevAPI, see
“X DevAPI User Guide” at
…
Jul
13
2020
Jul
13
2020
Dear MySQL users,
MySQL Connector/NET 8.0.21 is the latest General Availability
release of
the MySQL Connector/NET 8.0 series. This version supports .NET
Core 3.1
and the X DevAPI, which enables application developers to write
code
that combines the strengths of the relational and document models
using
a modern, NoSQL-like syntax that does not assume previous
experience
writing traditional SQL.
To learn more about how to write applications using the X DevAPI,
see
http://dev.mysql.com/doc/x-devapi-userguide/en/index.html.
For more
information about how the X DevAPI is implemented in
Connector/NET, see
http://dev.mysql.com/doc/dev/connector-net.
NuGet packages provide functionality at a …
Jul
13
2020
Dear MySQL users,
MySQL Connector/ODBC 8.0.21 is a new version in the MySQL
Connector/ODBC
8.0 series, the ODBC driver for the MySQL Server.
The available downloads include both a Unicode driver and an ANSI
driver
based on the same modern codebase. Please select the driver type
you
need based on the type of your application – Unicode or
ANSI.
Server-side prepared statements are enabled by default. It
is suitable
for use with the latest MySQL server version 8.0.
This release of the MySQL ODBC driver is conforming to the ODBC
3.8
specification. It contains implementations of key 3.8
features,
including self-identification as a ODBC 3.8 driver, streaming of
out for
binary types only), and support of the
SQL_ATTR_RESET_CONNECTION
connection attribute (for the Unicode driver only).
The release is now available in …
Jul
13
2020
Dear MySQL users,
MySQL Connector/Python 8.0.21 is the latest GA release version of
the
MySQL Connector Python 8.0 series. The X DevAPI enables
application
developers to write code that combines the strengths of the
relational
and document models using a modern, NoSQL-like syntax that does
not
assume previous experience writing traditional SQL.
To learn more about how to write applications using the X DevAPI, see
http://dev.mysql.com/doc/x-devapi-userguide/en/
For more information about how the X DevAPI is implemented in
MySQL
Connector/Python, and its usage, see
http://dev.mysql.com/doc/dev/connector-python
Please note that the X DevAPI requires at least MySQL Server
version 8.0
or higher with the …
Jul
10
2020
We’re very excited to open up our ProxySQL Total Training online course to the public!
Get yourself, or your team, trained by our Professional ProxySQL Trainers who have built and actively maintain ProxySQL in our upcoming total Training course.
Designed for DBAs, application developers and IT professionals in the industry, the course will focus on real world implementation and hands-on labs that will ensure you acquire the needed skills to deploy efficient, scalable and highly available solutions with ProxySQL!
Immerse yourself in the world of ProxySQL with our two-day ProxySQL Total Training.
ProxySQL Total Training topics include:
- ProxySQL use cases and real world examples
- How to install, upgrade and configure ProxySQL with zero-downtime
- Query routing, query caching and query fire-walling
- Advanced performance …
Jul
09
2020
In my day to day tasks as a DB Engineer at Mydbops we have been using multiple MySQL tools for multiple use cases to ensure an optimal performance and availability for servers managed by our Remote DBA Team.
A tool like pt-online-schema can be used for any DDL changes ( Overview to DDL algorithm ), if any tool which needs to scheduled for longer period we tend to use screen or cron.
Some of the problems we face when we demonise the process or use screen for running processes.
- The daemon process gets killed when the server reboot happens. …
Jul
09
2020
In any MySQL replication or migration, generally, we’ll skip the
mysql database from the dump file. Since it has the
current server’s settings, users, etc. So we should not create a
mess on the target server with this source mysql database dump.
But one downside of this approach is we’ll not get the users on
the target MySQL server. Maybe you tried some approaches that are
mentioned here. But whenever I don’t the credentials
list during the migration and don’t have time to explore/install
any tools likept-show-grants, then I’ll use this trick.
DISCLAIMER You should try this approach when you don’t any user credentials on the source DB. Take a backup of the MySQL database on the target DB side. Do this with …
[Read more]
Jul
09
2020
You got yourself a Kubernetes cluster and are now testing our Percona Kubernetes Operator for Percona XtraDB Cluster. Everything is working great and you decided that you want to increase the number of Percona XtraDB Cluster (PXC) pods from the default 3, to let’s say, 5 pods.
It’s just a matter of running the following command:
kubectl patch pxc cluster1 --type='json' -p='[{"op": "replace", "path": "/spec/pxc/size", "value": 5 }]'
Good, you run the command without issues and now you will have 5 pxc pods! Right? Let’s check out how the pods are being replicated:
kubectl get pods | grep pxc cluster1-pxc-0 1/1 Running 0 25m cluster1-pxc-1 1/1 Running 0 23m cluster1-pxc-2 1/1 Running …[Read more]
Jul
09
2020
ProxySQL Firewall Overview
ProxySQL’s flexible query rules engine has many uses, from Read/Write splitting, sharding and even creating firewall blacklist. This allows ProxySQL to be loved by both Performance and Security-minded engineers.
Starting in ProxySQL 2.0.9, ProxySQL has another Security feature: the Firewall Whitelist.
Modeled on MySQL Enterprise Firewall, this allows a security-conscious administrator to tune access to only allow certain queries.
Imagine a situation where your webapp gets hacked, which exposes your user’s database credentials.
If your webapp connects directly to the database, the malicious user can do what they want to your data with the same permissions your webapp has.
So perhaps they can’t just DROP TABLE because you’ve smartly removed DDL permissions …
[Read more]
Jul
09
2020
Following on from our recent newsletter and the message from Eero Teerikorpi, Founder and CEO, in this blog I will set out the outline and plan for the work we are currently undertaking to make a number of changes within the terminology used in our product and communications.
Tags: MySQL terminology replica primary source target tungsten clustering …
[Read more]