Showing entries 12871 to 12880 of 44106
« 10 Newer Entries | 10 Older Entries »
Proposal to simplify SQL_MODE options

In the MySQL team, we’ve observed that having a large number of possible SQL modes creates confusion amongst users. For example, if you follow my advice on ‘recommended defaults for new applications’, it is:

sql-mode="STRICT_TRANS_TABLES,
  ERROR_FOR_DIVISION_BY_ZERO,
  NO_AUTO_CREATE_USER,
  NO_AUTO_VALUE_ON_ZERO,
  NO_ENGINE_SUBSTITUTION,
  NO_ZERO_DATE,
  NO_ZERO_IN_DATE,
  ONLY_FULL_GROUP_BY"

This is quite specific, and may be too much to expect of a novice user to set in configuration.

One proposal we are putting forward to address this is to simply reduce the number of options that are available. Namely:

  • Remove the options ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE and NO_ZERO_IN_DATE.
  • Have these behaviours be enabled when turning on the …
[Read more]
Percona Live London MariaDB-related schedule

Percona Live London 2013 is almost here: November 11-12 2013. Team MariaDB & SkySQL will be present, and here’s an agenda if you’re interested in all things MariaDB:

  1. Monday, 11.11.2013 – 2-5pm – What’s New in MariaDB 10 and MariaDB Tools – a tutorial from Ivan Zoratti. This is a hands-on lab, complete with virtual machines provided by Ivan. You’ll also get to see MariaDB Manager from the abstract.
  2. Tuesday 12.11.2013 – 9.45-10.00am – What’s New in MariaDB 5.5 and what will happen with MariaDB 10.0 – a keynote from Michael “Monty” Widenius of the …
[Read more]
Using Amazon Web Services for MySQL at Scale Presentation

PalominoDB CEO Laine Campbell presented this class at the O'Reilly Velocity Conference, NYC Oct 2013. The class is broken into two videos and is a total of 85 minutes.

Click here for Part 1 - Click here for Part 2

Laine will explain the options for running MySQL at high volumes at Amazon Web Services, exploring options around database as a service, hosted instances/storages and all appropriate availability, performance and provisioning considerations using real-world examples from Call of Duty, Obama for America and many more.

Laine will show how to build highly available, manageable and performant MySQL environments that scale in AWS—how to maintain then, grow them and deal with failure. Some of the specific topics covered are:

[Read more]
After 10 Years, MySQL Still the Right Choice for ScienceLogic's "Best Network Monitoring System on the Planet"

ScienceLogic has a pretty fantastic network monitoring appliance.  So good in fact that InfoWorld gave it their "2013 Best Network Monitoring System on the Planet" award.  Inside their "ultraflexible, ultrascalable, carrier-grade" enterprise appliance, ScienceLogic relies on MySQL and has since their start in 2003.  Check out some of the things they've been able to do with MySQL and their reasons for continuing to use MySQL in these highlights from our new MySQL ScienceLogic case study.

  • Science Logic's larger customers use their appliance to monitor and manage  20,000+ devices, each of which generates a steady stream of data and a workload that is 85% write. On …
[Read more]
Continuent Tungsten at The OpenStack Summit HK

Continuent is proud to sponsor The OpenStack Summit, November 5-8, at the AsiaWorld Expo in Hong Kong! Don't miss this presentation by Edward Archibald:

Deploying a Highly-Available Database-as-a-Service in OpenStack

In his talk, Edward Archibald, CTO at Continuent, will demonstrate the ease of deploying a multi-site, highly-available, scalable Database-as-a-Service across two OpenStack

MySQL: Restore backup from compressed file

Due to disk space constraints, many times compressed sql dump file restoration is required. Mostly, where the uncompressed sql dump size is too big. The options available is show below.

Option 1:

[root@localhost sakila-db]# ls -ltrh
total 660K
-rw-r--r-- 1 root root 5.3K Dec 15  2011 sakila-schema.sql.gz
-rw-r--r-- 1 root root 650K Dec 15  2011 sakila-data.sql.gz
[root@localhost sakila-db]#
[root@localhost sakila-db]# gunzip < sakila-schema.sql.gz | mysql
[root@localhost sakila-db]# gunzip < sakila-data.sql.gz | mysql
[root@localhost sakila-db]#

Option 2:

[root@localhost sakila-db]# ls -ltrh
total 660K
-rw-r--r-- 1 root root 5.3K Dec 15  2011 sakila-schema.sql.gz
-rw-r--r-- 1 root root 650K Dec 15  2011 sakila-data.sql.gz
[root@localhost sakila-db]# zcat sakila-schema.sql.gz | mysql
[root@localhost sakila-db]# zcat sakila-data.sql.gz | mysql
[root@localhost …
[Read more]
MySQL Fabric with MariaDB Galera Cluster ?

MySQL Fabric is a very promising sharding framework. If I take Ulf Wendel definition of MySQL Fabric :

MySQL Fabric is an administration tool to build large “farms” of MySQL servers. In its most basic form, a farm is a collection of MySQL Replication clusters. In its most advanced form, a farm is a collection of [...]

Comment on Raspberry Pi, MySQL Cluster ‘n’ Cream. by Rudy

Hi,

Very interesting. Could you give me the memory consumption on your raspberry’s with the cluster up and running?

You will understand why I am asking that by looking at my page: http://wiki.ryayon.com/doku.php?id=mysql:howto:how_i_installed_mysql_cluster_on_my_raspberry_pi

Regards,
Rudy

Percona XtraDB Cluster - A Drop-in-place Clustering Solution for MySQL

Emphasis on clustering solutions comes up quite a lot when talking to customers about High Availability. The reason is because clustering is supposed to provide an easier solution for maintaining high availability and so that you do not have to rely on other tools and techniques outside of the database server.

I thought it would be good to share the gist of many of my discussions around clustering, in the form of a blog post.

People usually tend to compare MySQL NDB Cluster and Percona XtraDB Cluster but both of them really are very different solutions.

For one NDB Cluster would mean a complete rethink of how data is accessed by the application. You also get to have to deal with a storage engine that works and behaves differently from InnoDB storage engine. The key point with NDB Cluster is data partitioning between different nodes. Not all applications are built with partitioning in mind specifically. And such you would …

[Read more]
Introducing TokuMX Transactions for MongoDB Applications

Since our initial release last summer, TokuMX has supported fully ACID and MVCC multi-statement transactions. I’d like to take this post to explain exactly what we’ve done and what features are now available to the user.

But before beginning, an important note: we have implemented this for non-sharded clusters only. We do not support distributed transactions across different shards.

At a high level, what have we done?

We have taken MongoDB’s basic transactional behavior, and extended it. MongoDB is transactional with respect to one, and only one, document. MongoDB guarantees single document atomicity. Journaling provides durability for that document. The database …

[Read more]
Showing entries 12871 to 12880 of 44106
« 10 Newer Entries | 10 Older Entries »