Unfortunately, I don’t find the GsmAlphabet class anymore on my PC. However, you can find details for the Gsm Alphabet on the Internet and you just have to make sure that it’s implemented correctly. Have a look at the class, it’s not too complicated.

We’re excited to announce that customers & users of Continuent will now receive our expert MySQL™ database solutions, services and support when they use Continuent’s Tungsten Enterprise, a complete clustering and data management solution for the MySQL database. The same applies to customers using Tungsten Replicator, an advanced data replication solution.

Overall, the big news is that our companies will now jointly offer Tungsten Enterprise and Tungsten Replicator-based solutions to help MySQL users in accelerating the deployment and management of clustered MySQL databases, as well as the deployment of complex data replication solutions. We will also together offer MySQL users the SkySQL Enterprise subscription, a comprehensive offering of server software, production support and monitoring tools for any version of the MySQL database.

SkySQL continues to be focused on bringing the MySQL database into the future while …

Continuent and SkySQL announced today a strategic partnership. SkySQL will provide its expert MySQL database software, services and support to customers of Continuent’s Tungsten Enterprise, a complete clustering and data management solution for MySQL, and Tungsten Replicator, an advanced data replication solution.Under the partnership agreement, SkySQL and Continuent will jointly offer Tungsten

mysql> CREATE TABLE t1 (id INT PRIMARY KEY ) 
             engine=myisam PARTITION BY HASH(id) PARTITIONS 1000;
Query OK, 0 rows affected (0.18 sec)

mysql> alter table t1 add column v int;
ERROR 1016 (HY000): Can't open file: './test/t1.frm' (errno: 24)

mysql> quit
Bye

$ perror 24
OS error code  24:  Too many open files

Looks as if MyISAM tries to open all the 1000 partition .MYD/.MYI files at once and runs out of file handles during this operation ...

In the latest episode of our “Meet The MySQL Experts” podcast, Dimitri Kravtchuk talks to us about MySQL Performance. He reviews at a high level improvements made over the past few years, including in MySQL 5.5, as well as MySQL Enterprise Scalability, some of the new MySQL 5.6 features improving performance and more.

Enjoy the podcast!

Creating or dropping a partitioned table on InnoDB can become a quite expensive operation, on my laptop i'm seeing the following times for a simple table with 100 or 1000 partitions (using 5.1.58 right now as i'm testing on stock Ubuntu 11.10):

  mysql> CREATE TABLE t1 (id INT PRIMARY KEY )
               engine=innodb PARTITION BY HASH(id) PARTITIONS 100;
  Query OK, 0 rows affected (5.21 sec)

  mysql> drop table t1;
  Query OK, 0 rows affected (5.11 sec)

  mysql> CREATE TABLE t1 (id INT PRIMARY KEY )
               engine=innodb PARTITION BY HASH(id) PARTITIONS 1000;
  Query OK, 0 rows affected (52.76 sec)

So the time to create a partitioned InnoDB table grows linearly with the number of partitions at a 'speed' of about 20 partitions per second, and during that time the hard disk LED is always on. The rate for creating regular InnoDB tables on this machine is about 10 tables per second by the way.

MyIsam on …

My last post explained what to expect from memcached plugin in MySQL 5.6 (labs release). But I want to take a step back and think about "why" first. Why is memcached plugin of interest at all? What can I gain from using this instead of plain SQL?
First: I don't see this as a replacement for memcached. If you want memory caching with memcached then use memcached.
But the memcached plugin to MySQL is a replacement or addition to the SQL interface to MySQL. So instead of using SQL queries in your application to persist or retrieve data from MySQL you can use the memcached interface. And what are the benefits?

• Much higher performance
• Easier scalability via sharding
• Simpler application coding

1. PerformancePerformance is always good. But there are two different aspects of performance: Latency (or runtime) of a specific query …

Read the original article at Oracle to MySQL – prepare to bushwhack through the open source jungle

I was recently approached by a healthcare company for advice on suitable database solutions capable of executing its new initiative. The company was primarily an Oracle shop so naturally, they began by shopping for possible Oracle solutions.

The CTO relayed his conversation with the Oracle sales rep, who at first recommended an Oracle solution that, expensive as it may have been, ultimately aligned with the company’s existing technology and experience. Unfortunately this didn’t match their budget and so predictably, the Oracle sales rep whipped out a MySQL-based solution as an alternative.

Having worked as an Oracle DBA throughout the dot-com years, I know the technology well. I also know …

Last week I was part of a discussion panel on SQL versus NoSQL. Many in the audience seemed to believe that you needed to be one or the other with an exclusive or. Then today I learned about Vitess, an idea to use MySQL as a data layer while providing easy scaling and control the roll out of a logical schema. Is there room for an inclusive or.

Some traditional SQL rules are relaxed in conjunction with pools of sessionless connections. I hope Vitess does well and maybe this hybrid approach makes some of our current SQL/NoSQL arguments moot.

…

Read the original article at A handy guide for PHP and MongoDB Web Development

What makes a beginner’s guide handy is when it speaks to your intuition. It anticipates the burning questions that follow from a newbie trying to grasp new concepts and it quickly answers them. PHP and MongoDB Web Development – Beginner’s Guide is one such guide.

I hadn’t heard of Packt Publishing or Rubayeet Islam before picking up this title and I must say I’m impressed. Based in Birmingham, with offices in Mumbai, part of Packt’s business model is to give part of the royalties earned from its books to the open …