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:

• Better understand Oracle's MySQL strategy. Hear straight from the source how Oracle is driving MySQL innovation, and what are the latest news and plans.
• Meet the engineers developing and supporting the MySQL products. You'll have the opportunity to ask them all your questions, which can save you significant time and money.
• Learn about real-world experiences from other …

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 …

Some tips for MySQL architecture

Tue, 2014-08-12 06:43vilho_raatikka_l

Let's assume you want to start an automatically expanding and shrinking MySQL replication cluster with up-to seven database servers. This blog shows how to setup up and start MaxScale to work with a master and a single slave and, when needed, how it adapts to the changing cluster configurations. While the set up here is simple similar behavior can be applied in bigger and more complex scenarios.

Configuration

We make two important assumptions here: MaxScale doesn't promote master and slaves, someone else does. Same goes with master failover, replication setup, user management, GRANTs etc. (some of the necessary steps are covered in one of the earlier blogs https://mariadb.com/blog/installing-newest-maxscale-scratch-builders-edi...).
Secondly, all server names, ip …

We are constantly soliciting user feedback and drawing from our experience to make our tool as helpful as possible. Over the past few months, our brainiacs have rolled out a number of new features. Highlighted below are some of the major product enhancements:

Galera Graphs - Supports Percona XtraDB Cluster and MariaDB Galera Cluster in addition to stock Galera.

Agent Dashboard - Sort, filter and see CPU and memory consumption on an agent basis.

Per-Database Activity- Isolate and view each tenant separetly to better assess system performance.

…

We are constantly soliciting user feedback and drawing from our experience to make our tool as helpful as possible. Over the past few months, our brainiacs have rolled out a number of new features. Highlighted below are some of the major product enhancements:

Galera Graphs - Supports Percona XtraDB Cluster and MariaDB Galera Cluster in addition to stock Galera.

Agent Dashboard - Sort, filter and see CPU and memory consumption on an agent basis.

Per-Database Activity- Isolate and view each tenant separetly to better assess system performance.

…

Download MariaDB 10.0.13

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 …

PodcastsConferences

This week we talk about the MySQL Central conference, formerly known as the MySQL Connect conference. Ear Candy is Federico Razzoli explainsing different ways to debug stored procedures in MariaDB 10, and At the Movies is how to use MySQL Fabric.

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 …

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:

• Understand your data before building the database
• Consider what questions your data must answer

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:

• Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace through streaming video. Book time on a lab environment to suit your …