Le 27 mars de 14h à 19h à l'Atelier du France, Paris
SkySQL et Monty Program organisent une demie journée de conférences consacrées aux bonnes pratiques et retours d'expériences autour des bases de données MySQL®et MariaDB, l'objectif étant de répondre aux préoccupations actuelles des administrateurs de bases de données.
A few years ago, I used MySQL Sandbox to filter binary logs. While that one was a theoretical case, recently I came across a very practical case where we needed to provision an Oracle database, which is the designated slave of a MySQL master.
In this particular case, we needed to provision the Oracle slave with some auditing features in place. Therefore, mass load functions were not considered. What we needed was the contents of the MySQL database as binary rows i.e. the same format used for row-based replication.
To achieve the purpose as quickly and as painlessly as we could, I thought to employ the services of a MySQL Sandbox. The flow of information would be like this:
My previous writings were mostly teoretical, so I wanted to give a more practical example, showing the actual state of the current code. I also wanted to show how I have tried to make the feature fit well into the existing replication features, without requiring the user to enable lots of options or understand lots of restrictions before being able to use it.
So let us start! We will build the code from lp:~maria-captains/maria/10.0-mdev26,
which at the time of writing is at revision
knielsen@knielsen-hq.org-20130214134205-403yjqvzva6xk52j.
First, we start a master server on port 3310 and put a bit of data into it:
server1> use test; …[Read more]
This is just a quick record of my attempt to build the new GA
version of mysql 5.6.10 on an amazon linux instance on aws.
Background:
Output from uname -a:
Linux dz1 3.2.36-1.46.amzn1.x86_64 #1 SMP Mon Jan 14 04:42:23 UTC
2013 x86_64 x86_64 x86_64 GNU/Linux
Prerequisites:
Use "sudo yum list installed" for each of these to see if they
exist, or just install using "sudo yum install" :
make.x86_64
cmake.x86_64
ncurses-devel.x86_64
libaio-devel.x86_64
gcc47-c++.x86_64
bison.x86_64
I created a mysql user and an installation directory in
/opt/mysql. That is where I copied the downloaded source file
mysql-5.6.10.tar.gz. Exctracting creates the new mysql-5.6.10
subdirectory:
Created a "build" subdirectory:
cd /opt/mysql/mysql-5.6.10
mkdir …
We are very pleased to announce the addition of HP and Amazon Web Services as keynote speakers for the Percona Live MySQL Conference and Expo which is April 22-25 in Santa Clara, California. Amazon Web Services is sending Simone Brunozzi, Senior Technology Evangelist, who will speak on “Databases in the Cloud: Present and Future.” HP will be represented by Brian Aker, a Fellow at HP’s Cloud Division, and a returning keynote presenter from the 2012 conference. HP, the newest Diamond Plus conference sponsor, joins additional new conference sponsors GenieDB, GreenSQL, DaniWeb, Software Developer’s Journal, and Web and PHP Magazine.
One Day …
[Read more]A high-level comparative overview of the features
With the recent GA release of MySQL 5.6, there have been a lot of questions about where MariaDB stands with regards to MySQL 5.6. SkySQL will of course support both as Patrik explained in his recent blog post, but there are many questions about the technical differences. Rasmus from Monty Program gave a detailed view on MariaDB 10.0 here but I thought it would be beneficial to share a comparison table of the two. MariaDB recently released a benchmark including various versions of both MariaDB and MySQL (as did DmitriK from Oracle), but this post will focus solely on features (not …
[Read more]Very informative and to the point, useful! Thanks Sanjay.
Take a look at the comparison I think you will find it very interesting
Thank you!
Readers of the MySQLPlus blog have voted Galera as the top choice in the "What would you like to test in 2013?" category. We apparently are narrowly more interesting to test than MySQL 5.6, which is both humbling and difficult to put into right perspective. But we were all very glad to find out about this selection for sure!
Galera development was started in 2007 by Seppo, Teemu and Alex. They had already worked on various MySQL replication products since 2003. Around that time they read about some new academic research on concepts like virtual synchrony and certification based clustering. They were convinced this was the key to create a robust and useful synchronous multi-master cluster for MySQL.
Having failed to convince the management of their then employer about the …
[Read more]
Time for some shameful self promotion and hopefully some helpful
information too.
What follows are my lists of talks at the MySQL conference
that I would suggest to others, based on experience level, and/or
interests. I've focused on my interest areas, as others
have posted lists with their interest areas already, but I also
provide a list of those who may be new to the event and want
suggestions for what I think will be great all-around talks with
a wide focus.
If you are new to MySQL, or new to PCLME: Day
1: