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 this event please visit the link below:
http://www.oracle.com/us/dm/29173-emeafm13045970mpp010-oem-2020763-es.html
Zendcon is a difficult conference if you work in an exhibit hall booth. At other shows, attendees ask general questions about MySql or how Oracle is guiding products. Zendcon is much more pointed. When is 5.7 multisource relication going to be available? How does Visual Explain work? How can I make sure replication goes back to semi-sync after going async? It is a great show but the level of questions are a notch or two higher than most other shows.
Last week, we at SkySQL had a webinar titled MariaDB Query Optimizer - Improving Query Performance with yours truly as the author and presenter. The recording is now available online at the above link.
The webinar is an overview of all important parts of the MySQL/MariaDB query optimizer. Special attention is given to the new optimizer features and differences between MySQL and MariaDB.
Send to Kindle
Na semana passada, durante o evento MySQL Connect, foi lançada a versão de testes do MySQL 5.7 (MySQL 5.7.2 DRM), dentre as novas funcionalidades, uma que chamou bastante a minha atenção foi a replicação de múltiplos masters (multi source replication). Atualmente o MySQL não possui uma funcionalidade oficialmente (build-in) , pode se conseguir esse resultado com alguns hacks, como, a cada x segundos executar um change master to no slave para ficar trocando de master, mas como o nome diz, isso é um “hack”.
Veja como configurar aqui
Não confundam muti source replication com multi master, veja as
figura abaixo para entender a diferença:
…
[Read more]Thank you for attending MySQL Connect 2013.
The Saturday session 50 Tips for Boosting MySQL Performance [CON2655] was sold out. It shows the interest in practical recipes to solve performance problems. Maybe the topic of a book as suggested by the audience ?
On Monday, the tutorial Enhancing Productivity with MySQL 5.6 New Features [TUT8131] was less crowded due to MySQL 5.6 Replication Tips and Tricks [TUT8133] happening at the same time, again tips and tricks are more popular .
Here are the slides :
Proving this it is the show for in-depth technical information, MySql Connect finished with a bang. Six different two hour plus deep dive tutorials were offered and all had very good attendence. Many of the attendee were seasoned Oracle DBAs eager to gorge at this buffet of technical knowledge.
The crowd for Ligaya Trumele’s Getting Started
with MySql was packed with
Oracle DBAs who were amazed at the simplicity of the MySql
architecture once they figured out the concept of multiple
storage engines.
Luis Soares had a tutorial that was everything you ever wanted to know about 5.6 replication plus a look multi source that will be in 5.7. His discussion on how and when binlogs are written and the impact if that timing on replication was intense, detailed, and worth the price of the show itself.
Finishing a mentally overload day, I listened to Bernd Ocklin on MySql Cluster 7.3 and this product has …
[Read more]Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).
I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_ol63uek01-LogVol01
7.1G 5.7G 1.1G 85% /
As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.
fdisk -l
Will be able to identify the new & unused partition:
[root@ol63uek01 ~]# fdisk -l Disk /dev/sda: 8589 MB, 8589934592 bytes 255 heads, 63 sectors/track, 1044 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00091104 …[Read more]
Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).
I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_ol63uek01-LogVol01
7.1G 5.7G 1.1G 85% /
As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.
fdisk -l
Will be able to identify the new & unused partition:
[root@ol63uek01 ~]# fdisk -l Disk /dev/sda: 8589 MB, 8589934592 bytes 255 heads, 63 sectors/track, 1044 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00091104 …[Read more]
http://www.oracle.com/us/dm/29127-emeafm13045970mpp014-oem-2019447.html
Come hear me talk about whats new with MySQL and loads of other interesting things.. come see the raspberry pi project in the flesh
Sign up today!
“The most valuable thing I’ve learned in this role is that judicious use of a little bit of knowledge can go a long way. I’ve seen colleagues and other companies get caught up in the “Big Data” craze by spend hundreds of thousands of pounds sterling on a Hadoop cluster that sees a few megabytes [...]