MariaDB 10.0.13 was recently released, and is available for download here:
https://downloads.mariadb.org/mariadb/10.0.13/
This is the fourth GA release of MariaDB 10.0, and 14th overall release of MariaDB 10.0.
This is primarily a bug-fix release.
Here are the main items of note:
August 12, 2014 By Severalnines
Moodle is an open-source e-learning platform (aka Learning Management System) that is widely adopted by educational institutions to create and administer online courses. For larger student bodies and higher volumes of instruction, moodle must be robust enough to serve thousands of learners, administrators, content builders and instructors simultaneously. Availability and scalability are key requirements as moodle becomes a critical application for course providers. In this blog, we will show you how to deploy and cluster moodle/web, database and file-system components on multiple servers to achieve both high availability and scalability.
We are going to deploy moodle on top of GlusterFS clustered file system and MariaDB Galera Cluster 10. To eliminate any single point of failure, we will use three nodes to serve the application and database while the remaining two are used for …
[Read more]Diablo Technologies engaged Percona to benchmark IBM eXFlash™ DIMMs in various aspects. An eXFlash™ DIMM itself is quite an interesting piece of technology. In a nutshell, it’s flash storage, which you can put in the memory DIMM slots. Enabled by Diablo’s Memory Channel Storage™ technology, this practically means low latency and some unique performance characteristics.
These devices are special, because their full performance potential is unlocked by using multiple devices to leverage the parallelism of the memory subsystem. In a modern CPU there is more than one memory controller (4 is typical nowadays) and spreading eXFlash™ DIMMs across them will provide maximum performance. There are quite some details about the device that are omitted in this post, they can be found in this redbook.
Diablo technologies also provided us a …
[Read more]
MySQL Central @ OpenWorld is less than 7 weeks
away, have you registered?
The event represents a unique opportunity to boost your MySQL
skills and hear from Oracle's MySQL engineers along with
customers, partners and MySQL community members.
Here are the top 10 reasons why you should join us:
Recently, I came through with this error. It was weird because I have never seen this error earlier.
[root@percona-pxc55-1 nilnandan]# sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=dbtest --mysql-user=msandbox --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox5537.sock prepare sysbench 0.4.12: multi-threaded system evaluation benchmark FATAL: no database driver specified FATAL: failed to initialize database driver! [root@percona-pxc55-1 nilnandan]#
After some research, found that with Sysbench 0.4.x, we have to use option –db-driver to make it work. So I have used it and it worked.
[root@percona-pxc55-1 nilnandan]# sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=dbtest --mysql-user=msandbox --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox5537.sock --db-driver=mysql --oltp-auto-inc=off prepare sysbench 0.4.12: multi-threaded system evaluation benchmark Creating table 'sbtest'... Creating …[Read more]
Some tips for MySQL architecture
Release Notes Changelog What is MariaDB 10.0?
MariaDB APT and YUM Repository Configuration Generator
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.13. This is a Stable (GA) release.
See the Release Notes and …
[Read more]This week we are talking about size, which is a subject that should matter to any system administrator in charge of the backup system of any project, and in particular database backups.
I sometimes get questions about what should be the best compression tool to apply during a particular backup system: gzip? bzip2? any other?
The testing environment
In order to test several formats and tools, I created a .csv file (comma-separated values) that was 3,700,635,579 bytes in size by transforming a recent dump of all the OpenStreetMap nodes of the European portion of Spain. It had a total of 46,741,126 rows and looked like this:
171773 38.6048402 -0.0489871 4 2012-08-25 00:37:46 12850816 472193 rubensd 171774 38.6061981 -0.0496867 2 2008-01-19 10:23:21 666916 9250 …[Read more]
Database modelling is the process of defining the logical structure of a database. This structure determines how data is stored, organized and manipulated. This enables you to:
The entity relationship model (ERM) is the most common model for an RDBMS.
Learn more about database modelling, design and much more in the MySQL for Beginners training course.
You can take this 4-day instructor-led training course via the following formats:
As I briefly mentioned in my previous post, I have been working on a new
project for HP's Advanced Technology Group called
libAttachSQL.
libAttachSQL is a lightweight C connector for MySQL servers.
It is Apache 2 licensed (and therefore compatible with many
open source licenses as well as commercial use) and has a new
asynchronous API. With the new API you send a command which
returns immediately and you poll until the library tells you
there are results ready, this is very useful for applications
that have many things going on that you do not want held up by
waiting for the MySQL server to process a query. In later
posts I will give usage examples of this.
I am a great believer in release early/often so on Friday, 5
weeks after I started …