Tag Archives: MySQL

MySQL 5.7.7 RC & Multi Source Replication 40 to 1.

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.

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

Advertisement

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

MySQL Enterprise Backup 3.10: Teasing compression.

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

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

MySQL Enterprise Backup: parallel config & backup n restore results.

In this post I go into some performance metrics and time spent on using MySQL Enterprise Backup instead of mysqldump, and seeing how far I could go with some parallel configuration.

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

MySQL Utilities: copy, replicate, show, failover… over and over again.

So, after installing Workbench 6.0.7 on my pc, and playing around with the MySQL Utilities that are included, I thought I’d do similar to what others have done (Thanks Tony D.) and share my experience on how I’ve used them. … Continue reading

Posted in MySQL, Oracle Linux, Replication | Tagged , , , , , , | Leave a comment

MySQL Tech Tour @Barcelona, 7th Nov.

We’re on the move again. Come and join us on the 7th of November at the Oracle office in Barcelona. Find out more details about what was announced at MySQL Connect, as well as what’s next… For more information about … Continue reading

Posted in Cluster 7.3, MySQL, MySQL Cluster, MySQL Connect, MySQL Enterprise Edition, Oracle, Uncategorized | Tagged , , | Leave a comment

MySQL Enterprise Backup: PITR Partial Online Recovery

Here’s a look at using MySQL Enterprise Backup in a specific example: Consider a Backup Policy – Full Backup of the environment. – Complemental Incremental backups & online BinLogs. And the Restore: – Logical Restore. – Online, Zero impact. – … Continue reading

Posted in Backup, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle, Oracle Linux, PITR, Recovery | Tagged , , , , , , , | 1 Comment

Raspberry Pi, MySQL Cluster ‘n’ Cream.

Ok, so I’ve been playing around with the idea of setting up MySQL cluster on a couple of Raspberry Pi’s and this is how it has been going. References First of all, for anyone else who’s reading this, it’s not … Continue reading

Posted in ARM, Cluster 7.3, MySQL, MySQL Cluster, MySQL Enterprise Edition, Oracle, Raspberry, Raspberry Pi | Tagged , , | 11 Comments