This week we interview Luis Soares about multi-source replication. Ear Candy is about memory allocation with FEDERATED and FEDERATEDX storage engines, and At the Movies is about increasing performance by archiving data.
Download the
multi-source replication MySQL server snapshot at labs.
Enabling MySQL multi-source replication on
Luis' blog,
A quick introduction to multi-source replication,
with an example
The second article in a series covering Big Data and SQL interaction is available now:
“Big data” is a term that has been used regularly now for almost a decade, and it — along with technologies like NoSQL — are seen as the replacements for the long-successful RDBMS solutions that use SQL. Today, DB2®, Oracle, Microsoft® SQL Server MySQL, and PostgreSQL dominate the SQL space and still make up a considerable proportion of the overall market. Here in Part 2, we will concentrate on how to use HBase and Hive for exchanging data with your SQL data stores. From the outside, the two systems seem to be largely similar, but the systems have very different goals and aims. Let\’s start by looking at how the two systems differ and how we can take advantage of that in our big data requirements.
SQL to Hadoop and back again, Part 2: …
[Read more]MySQL Connect 2013 has been a great edition. There was of course a lot of nice announcements of improvements in the the core MySQL server technology. One of the major announcement that received a lot of buzz was MySQL Fabric. MySQL Fabric is an infrastructure component aimed at simplifying construction of a highly available, sharded, [...]
Recently Todd blogged about why you should register for MySQL 5.6 certification exams now: http://mysqlblog.fivefarmers.com/2013/10/04/why-you-should-register-for-mysql-5-6-certification-exams-now/ and i also think that now is a good opportunity to renew or take a new mysql certification.
The most interesting point in my opinion is that you can save a lot of money if you take the exam NOW! The exam price is 50 dollar (39 Euro) till 14.12.2013.
So, if you want to update your, probably years old, mysql certification now is the time! You can search for a test center and register for the exam here:
http://pearsonvue.com/oracle/
Be aware that you won’t get your results directly but after a few weeks. Also there are about 150-220 questions! Phew! All information about the exam can be found here:
…
[Read more]
This is to announce that me and Daniel Nichter (Lead of Percona
Toolkit) are coming to the MYSQL NOSQL &
CLOUD CONFERENCE & EXPO in Buenos Aires, Argentina on Oct.
15-16.
There also will be local Percona experts in attendance.
Talks from Percona include:
We also will present at The Montevideo MySQL Meetup group in Uruguay on Oct. 17.
So if you want to talk with Percona experts, chat with me and Daniel on Percona Software, or …
[Read more]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.
Would you like to learn about the latest MySQL news and
innovations from MySQL Connect/Oracle OpenWorld but couldn't
travel there? Are you about to develop a new modern web-based
application, wondering what the best database solution is for
you? Would you like to learn how to use NoSQL access to MySQL and
the new MySQL Database and MySQL Cluster features to build next
generation applications?
Join one of our upcoming "Performance, Scalability and High
Availability with MySQL" Tech Tours! You will hear directly from
the source about new MySQL innovations from Oracle, including how
the latest MySQL 5.7 DMR yet again doubles the performance of
MySQL, and how the new MySQL Fabric provides you with a framework
for both High-Availability and sharding of MySQL Databases. Our
technical experts will show you how to take advantage of the new
features and enhancements in the best MySQL product releases
ever, and share …
Do you want to get more familiar on how to become a MySQL DBA?
Are you a developer familiar with writing applications that use MySQL but you feel a bit limited on how to manage a MySQL Database?
I would like to invite you in my tutorial ‘MySQL DBA In A Nutshell! Hands On! ‘ at Percona Live UK, London on 11 November!
The full day tutorial, co-presented by my colleague Dimitri Vanoverbeke and …
[Read more]
For decades MySQL has considered BLOB a sink for
data junk that didn’t fit the strictly typed SQL bill. As the
outside world began voting for JavaScript, JSON and
key-value/key-document stores,
TEXT/BLOB was rediscovered as the only
way to store JSON inside MySQL. But having no SQL support for the
JSON serialization format, JSON remained junk for MySQL. Community developed
SQL functions could not cure the issue. That said, MySQL 5.7
introduces SQL functions to work on JSON documents! MySQL slowly
takes a different position on JSON.
From the labyrinth: labs.mysql.com
In the recent past, MySQL has developed a talent hiding feature previews at http://labs.mysql.com/. This is where you find …
[Read more]
Going to MySQL Connect was truly a blast. We got a lot of good
questions and feedback in the sessions and there were a lot of
interest in both MySQL Fabric and the MySQL Applier for
Hadoop.
A big thank you to all that attended the talks, I got a lot of
good questions and comments that will help us build good
solutions.
The talks are available on SlideShare:
