Sorry I mixed up nodes with node groups, it is obviously number of nodes * number of LDM threads.
Dec
19
2016
Dec
16
2016
In this article, I will show you how it’s possible to perform an online migration from a 3 members Galera cluster setup (in this case I’m using PXC 5.7.14) to a 3 members MySQL Group Replication cluster setup (MySQL Community 5.7.17).
Don’t forget that before adopting Group Replication as database backend, you should validate that your application do match GR requirements and limitations. When this is validated, you can start !
So first, let’s have a look at the current situation:
We have an application (sysbench 0.5), reading and writing to a Galera Cluster ( …
[Read more]
Dec
16
2016
Hi dear all,
I would like to share our experimental tests about, writing UDF
with Python.
So the basic idea was writing a UDF for factorial calculation.
The interesting part was to move factorial calculation logic to
Python code and then calling this Python file inside UDF code.
Here is the repo link -> UDFs-written-in-Python
The factorial calculation is here -> factorial.py
UDF code is here -> factorial.cc
Basic idea with UDF code quite simple as it has 3 parts:
1. initialization part -> factorial_init() -> all necessary
checks reside here
2. main logic -> …
Dec
16
2016
Dear MySQL Users,
A new GA (general availability) version of MySQL Connector/C++
has
been made available: MySQL Connector/C++ 1.1.8 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 …
Dec
16
2016
Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.
|
Download our new DevOps Guide to Database Backups for MariaDB
& MySQL
Check out our free whitepaper on database backups, which discusses in detail the two most popular backup utilities available for MySQL and MariaDB, namely mysqldump and Percona XtraBackup. If you’re looking for insight into how to perform database backups efficiently or the impact of Storage Engine on MySQL or MariaDB backup procedures, need some tips & tricks on MySQL / MariaDB backup management … our new DevOps Guide has you covered. |
Dec
16
2016
As stated in the MySQL Cluster documentation:
Partition. This is a portion of the data stored by the cluster. There are as many cluster partitions as nodes participating in the cluster. Each node is responsible for keeping at least one copy of any partitions assigned to it (that is, at least one replica) available to the cluster.
According to my understanding for the previous paragraph, if we
have a cluster of 6 datanodes we should have 6 partitions for
each NDB table. I claim that this is not true for all cases – at
least, after the introduction of ndbmtd (Multi-Threaded Daemon) in MySQL
Cluster 7.2 .
In this post, I’ll do some …
Dec
15
2016
Percona announces the release of Percona XtraDB Cluster 5.7.16-27.19 on December 15, 2016. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.7.16-27.19 is now the current release, based on the following:
- Percona Server 5.7.16-10
- Galera Replication library 3.19
- wsrep API version 26
All Percona software is open-source and free.
…
[Read more]
Dec
15
2016
Welcome to a new series of blogs: Percona Live featured tutorial speakers! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration bonus!
In this Percona Live featured tutorial, we’ll meet Giuseppe Maxia, Quality Assurance Architect at VMware. His tutorial is on MySQL Document Store: SQL and NoSQL United. MySQL 5.7 introduced document store, which allows asynchronous operations …
[Read more]
Dec
15
2016
Related resources Customizing your database backups with ClusterControl Become a ClusterControl DBA - Safeguarding your data Webinar: Become a MySQL DBA - Backups Download ClusterControl
This week we’re happy to announce that our new DevOps Guide to Database Backups for MySQL & MariaDB is now available for …
[Read more]
Dec
15
2016
Dear MySQL users,
MySQL Connector/Python 2.1.5 GA is a third GA version of 2.1
release
series of the pure Python database driver for MySQL. It can be
used for
production environments.
MySQL Connector/Python version 2.1.5 GA is compatible with MySQL
Server
versions 5.5 and greater. Python 2.6 and greater as well as
Python 3.3
and greater are supported. Python 2.4, 2.5 and 3.1, 3.2 are
not
supported.
MySQL Connector/Python 2.1.5 is available for download from:
http://dev.mysql.com/downloads/connector/python/#downloads
The ChangeLog file included in the distribution contains a brief
summary
of changes in MySQL Connector/Python 2.1.5. For a more complete
list of
changes, see below or online at:
…
[Read more]