Showing entries 1 to 10 of 1000
10 Older Entries »
Displaying posts with tag: Uncategorized (reset)
Mydbops Delighted to be part of Open Source India -2017

Open Source India (OSI) is the premier Open Source conference in Asia targeted at nurturing and promoting the Open Source ecosystem in the subcontinent. Started as Linux Asia in 2004, OSI has been at the helm of bringing together the Open Source industry and the community since its inception.

The objective of OSI is to convince you for the adoption of Open Source when you’re looking for software, using quantitative measures and NOT because these are cost free.. OSI emphasizes quantitative measures (such as use case experiments and case studies) to justify why using OSS is, in many circumstances, a reasonable or even superior approach.

It is one of the prominent conference for open source in ASIA. In the past we have seen huge contribution from open source database community like Oracle MySQL, MongoDB , Postgresql  and others.

Mydbops :

[Read more]
Paramiko 2.x Update Tutorial

MySQL Workbench has tunneling capabilities, and these
depend on third-party libraries.

One required library is Paramiko, which is a python module used to 
create an SSH connection to the destination server. MySQL Workbench uses
Paramiko 1.8.x, and 1.8.x depends on the pycrypto library. But
because recent Python distributions replaced pycrypto with a
different cryptography module, this causes problems for software
(like Workbench) that depends on the older (1.8.x) Paramiko library, 
problems such as MySQL BUG#87381 (

For details on upgrading the Paramiko library, see our previous blog post
Paramiko Update Tutorial
. The procedure to upgrade to
Paramiko …

[Read more]
On Open Source Databases. Interview with Peter Zaitsev

“To be competitive with non-open-source cloud deployment options, open source databases need to invest in “ease-of-use.” There is no tolerance for complexity in many development teams as we move to “ops-less” deployment models.” –Peter Zaitsev

I have interviewed Peter Zaitsev, Co-Founder and CEO of Percona.
In this interview, Peter talks about the Open Source Databases market; the Cloud; the scalability challenges at Facebook; compares MySQL, MariaDB, and MongoDB; and presents Percona’s contribution to the MySQL and MongoDB ecosystems.


Q1. What are the main technical challenges in obtaining application scaling?

Peter Zaitsev: When it comes to scaling, there are different types. There is a Facebook/Google/Alibaba/Amazon scale: these …

[Read more]
MySQL Cluster in Docker: quick step by step

I just wanted to share the ‘how to’ in getting to know MySQL Cluster a bit more, via Docker, as mentioned in the docker store install guide:

all I’m doing here is replicating what’s mentioned there. Hopefully someone might find it interesting, if considering wanting to get a MySQL Cluster up and running to see how it works.

For more info on MySQL in Docker, I’d highly recommend looking at this blog:

(Thanks to Giuseppe here!)

So, what’s needed? Here we go.

Get the cluster image from docker:

$ docker pull …
[Read more]
Taming a ‘wild’ NDB 7.3 with Cluster Manager 1.4.3 & direct upgrade to 7.5.

Well, since working with outdated clusters and upgrade paths that quickly become obsolete, as in my last post, Migrating/importing NDB to Cluster Manager w/ version upgrade. , I wanted to share that we can also use Cluster Manager, mcm, to upgrade NDB Cluster from 7.3 directly to 7.5. So we can start using the mcm new features like autotune that help guide us towards some Cluster tuning, or 7.5 new features like READ_BACKUP or FULLY_REPLICATED tables. …

[Read more]
Migrating/importing NDB to Cluster Manager w/ version upgrade.

I’ve had some questions from people using MySQL Cluster GPL and wanting to move to using MySQL Cluster Carrier Grade Edition, i.e., they want to use MySQL Cluster Manager, MCM, to make their lives much easier, in particular, upgrading (as well as config change ease and backup history).

All I want to do here is to share with you my personal experience on migrating what’s considered a ‘wild’ NDB Cluster to a MCM managed cluster. It’s just as simple to follow the manual chapter Importing a Cluster into MySQL Cluster Manager so at least you can see how I did it, and it might help someone.

[ If you’re not migrating but just looking for further information on NDB Cluster, and came across this post, please please PLEASE look at the …

[Read more]
On Apache Ignite, Apache Spark and MySQL. Interview with Nikita Ivanov

“Spark and Ignite can complement each other very well. Ignite can provide shared storage for Spark so state can be passed from one Spark application or job to another. Ignite can also be used to provide distributed SQL with indexing that accelerates Spark SQL by up to 1,000x.”–Nikita Ivanov.

I have interviewed Nikita Ivanov,CTO of GridGain.
Main topics of the interview are Apache Ignite, Apache Spark and MySQL, and how well they perform on big data analytics.


Q1. What are the main technical challenges of SaaS development projects?

Nikita Ivanov: SaaS requires that the applications be highly responsive, reliable and web-scale. SaaS development projects face many of the same challenges as …

[Read more]
Another Hanging Query

You are a DBA, enjoying a good read about the MySQL 8.0.1 development milestone release which contains CTEs.  And, window functions are coming in 8.0.2. Perhaps, you think, the analytics team could make good use of window functions to perform rankings on the sales of products compared to the average sales for all the products.

Dreaming about the possibility of trying CTEs in 8.0.1, you get a phone from a user complaining that her ‘SELECT’ statement has been running for a long time.

Fortunately, you have the MySQL Enterprise Monitor (MEM) which is part of the MySQL Cloud Service (MySQLCS).  You have recently set up your MySQL database in MySQLCS where you have installed MEM.

You login to your identity domain in MySQLCS and select you service and click the pull-down menu choice ‘Enterprise Monitor URL’:

After logging in, you notice on the MEM dashboard that there is a spike in database activity …

[Read more]
Reset root password on Galera Cluster (Percona or MariaDB)

Reset MySQL root password for Galera Cluster ( Percona Xtradb / MariaDB )

A practical explanation: problems during unicode collation conversion


Recently I have been involved in an effort to convert MySQL databases from a utf8 character set to utf8mb4. As a part of this effort, my team evaluated which collations would be best for facilitating a broad range of multi-lingual support.

There have been many recent posts in the MySQL community about better unicode collation support in MySQL 8 such as from the MySQL Server Team’s blog at Oracle, who have also done a good job of showing us how newer collations based on UTF8 9.0.0 will properly group and sort characters according to their case and inheritance. As the title of the latter post suggests, the “devil is” indeed “in the details”.

There is also the matter of the …

[Read more]
Showing entries 1 to 10 of 1000
10 Older Entries »