Category Archives: MySQL

Migrating/importing NDB to Cluster Manager w/ version upgrade.

Posted on 18/08/2017 by

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… Continue reading →

Posted in CGE, Cluster 7.3, Cluster Manager, MySQL, MySQL Cluster, Oracle, Uncategorized, upgrade | Tagged , , , , , , , | Leave a comment

MySQL Cluster: Una introducción en Español.

Posted on 29/06/2015 by

MySQL Cluster: El ‘qué’ y el ‘cómo’. Para aquellos que encuentran mucho sobre MySQL en Inglés pero poco en Español: mi pequeña aportación. En el enlace tenéis información sobre qué es MySQL Cluster y cómo funciona. Incluso con ejemplos técnicos … Continue reading →

Posted in CGE, Cluster 7.3, Cluster Manager, MySQL, MySQL Cluster, Oracle, Uncategorized | Tagged , , , , , , , | 1 Comment

MySQL 5.7.7 RC & Multi Source Replication 40 to 1.

Posted on 12/05/2015 by

One of the cool new features in 5.7 Release Candidate is Multi Source Replication, as I previously looked into in 5.7.5 DMR. I’ve had more and more people like the idea of this, so here’s a quick set-up as to … Continue reading →

Posted in Multi Source Replication, MySQL, Replication | Tagged , , , , , , | 1 Comment

Enterprise Monitor: “Add Bulk MySQL Instances” 50 in 1-click.

Posted on 18/02/2015 by

Carrying on with my MySQL 5.7 Labs Multi Source Replication scenario, I wanted to evaluate performance impact via MySQL Enterprise Monitor. Whilst I opened my environment, I remember that I had generated lots of different skeleton scripts that allowed me … Continue reading →

Posted in MEM 3.0, Multi Source Replication, MySQL, MySQL Enterprise Edition, MySQL Enterprise Monitor, Replication | Tagged , , , , , , , , | 2 Comments

a multisource replication scenario: 10 masters, 1 slave.

Posted on 30/01/2015 by

A customer asked whether we they could have 10 or more masters consolidate all the data into a single central slave. After getting a bit more information from them and seeing the application functionality, it was clear that MySQL Labs … Continue reading →

Posted in MySQL, Replication | Tagged , , , , | 5 Comments

MySQL Enterprise Backup 3.10: Teasing compression.

Posted on 12/04/2014 by

Ok, so I wanted to look into the new compression options of MEB 3.10. And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your … Continue reading →

Posted in Backup, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle, Recovery | Tagged , , , , , , , , , , , , | 2 Comments

–use-tts backup & restore

Posted on 06/02/2014 by

In addition to my recent post, I just had to go into using the –use-tts for specific tables and selective backup sets. As all my schemas were employeesn, I thought it would be a good idea to run: mysqlbackup -uroot … Continue reading →

Posted in Backup, MEB, MySQL, MySQL Enterprise Backup, Recovery | Tagged , , , , , , , , | Leave a comment