Thursday, May 9, 2013

Comparing the Databases :: MySQL :: Percona :: MariaDB with the MySQL Sandbox

Do you often find yourself curious yet to busy to explore?

Often people stay with what they are comfortable with and started with. MySQL has a very loyal following of users. It is ok to be curious and explore the forks as well. The MySQL Sandbox makes it extremely easy for you to do just that.

MySQL Sandbox is a great tool and the documentation is available if you need help.
http://mysqlsandbox.net/docs.html. The MySQL Sandbox also allows you to check against forks and different versions of the MySQL server easily.

I already have a MySQL 5.6 version running on my server.


$ mysql -p
Enter password:
Server version: 5.6.10-log MySQL Community Server (GPL)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.




I used the MySQL Sandbox to compare three similar versions of MySQL:
  • mariadb-5.5.30
  • Percona-Server-5.5.30
  • mysql-5.5.31
I decided make my sandboxes this way:
$ make_multiple_custom_sandbox mariadb-5.5.30-linux-i686.tar.gz Percona-Server-5.5.30-rel30.2-500.Linux.i686.tar.gz mysql-5.5.31-linux2.6-i686.tar.gz


node1]$ ./use
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.30-MariaDB-log MariaDB Server

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
> select VERSION();
+--------------------+
| VERSION()          |
+--------------------+
| 5.5.30-MariaDB-log |
+--------------------+

  • Ok this is as expected.




node2]$ ./use
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4

Server version: 5.5.30-MariaDB-log MariaDB Server

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others
> select VERSION();
+--------------------+
| VERSION()          |
+--------------------+
| 5.5.30-MariaDB-log |
+--------------------+
  • Ah? ok not as expected.


node3]$ ./use
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.31-log MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
 > select VERSION();
+------------+
| VERSION()  |
+------------+
| 5.5.31-log |
+------------+


I expected or at was at least hopeful it was going result with this.


I still think that MySQL Sandbox is a great tool and makes some comparisons and tests very easy to do. I just happen to run into a conflict when trying to run all 3 versions at once. It could completely be my error as well and I have just overlooked something. I think it would be a valid test for some people to want to do though. Regardless I moved and built from source instead. More on that is available here: