Inspired by the benchmark in this post, we decided to run some NDB vs Galera benchmarks for ourselves.

We confirmed that NDB does not perform well using m1.large instances. In fact, it’s totally unacceptable -  no setup should ever have a minimum latency of 220ms - so m1.large instances are not an option. Apparently the instances get CPU bound, but CPU utilization never goes above ~50%. Maybe top/vmstat can’t be trusted in this virtualized environment?

So, why not use m1.xlarge instances? This sounds like a better plan!

As in the original post, our dataset is 15 tables of 2M rows each, created with:

./sysbench --test=tests/db/oltp.lua --oltp-tables-count=15 --oltp-table-size=2000000 --mysql-table-engine=ndbcluster --mysql-user=user --mysql-host=host1 prepare

Benchmark against NDB was executed with:

…

SkySQL is looking for a great Support Engineer to join our Team and work the APAC shift. This means you do not need to reside in APAC, but just want to work those hours.

If interested, there is a full description of the position here:

http://www.skysql.com/company/careers/skysql-support-engineer-apac

And as the post says, if you are interested, please send your resume/CV to careers@skysql.com.

Also, if you’d like, please feel free to ping me as well [chris at skysql dot com] and I can try to get your resume looked at with a higher priority (and feel free to ask me any questions too).

Happy Holidays!

MySQL 5.6

Replication

Note 1760
Storing MySQL user name or password information in the master.info repository is not secure and is therefore not recommended. Please see the MySQL Manual for more about this issue and possible alternatives.

With the new 5.6, while doing a change master to, I received the message
Query OK, 0 rows affected, 2 warnings (0.04) sec

A quick show warnings revealed the above note which is a ER_INSECURE_CHANGE_MASTER.

It took some digging, but yes, it's possible to store replication information in a table …

As this topic came up a few times this week for discussion at various places, I thought of composing a post on “Data Scientist vs. Data Analytics Engineer”; even though[...]

16 Table Join Benchmarks were ran at Amazon Web Services.

Results available at www.paralleluniverse-inc.com/benchmarks.shtml .

Percona Live London 2012 was again a great event.
You can find some of the slides on [Plus], enjoy! :

If you would like to add your slides, post a comment with the link.

We are excited to announce that the new version of Jet Profiler for MySQL 3 is finally available.

This release includes the following important improvements:
- SSH Tunneling - connect to remote database servers using SSH tunneling.
- HTML Reports - makes saving and sharing the profiling results easier.
- Japanese translation.
- Improved memory management for large result sets.
- Bug fixes.

We also offer a completely new solution called Jet Profiler Enterprise. In addition to all the features in the professional version, it allows multiple instances so you can record from many databases at once. It also supports command line scheduling for automated recording.

For more details please read …

Learn more about the uncompromising scalability, uptime, and agility of MySQL Cluster by taking the authentic MySQL Cluster training course.

During this three day class, you will learn how to properly configure and manage the cluster nodes to ensure high availability, how to install the different nodes as well as get a better understanding of the internals of the cluster.

Events currently on the schedule for this class include:

As the world's most popular web database, MySQL has quickly become the leading database for the cloud, with most providers offering MySQL-based services.

Access our Resource Kit to discover:

• Why MySQL has become the leading database in the cloud, and how it addresses the critical attributes of cloud-based deployments
• How ISVs rely on MySQL to power their SaaS offerings
• Best practices to deploy the world’s most popular open source database in public and private clouds

You will also find out how you can leverage MySQL together with Hadoop and other technologies to unlock the value of Big Data, either on-premise or in the cloud. …

Two easy ways to prevent SQL Injection in PHP

To many people still execute sql queries using methods which does not prevent SQL Injection, and many tutorials out there give bad example of doing so.

SQL Injection? What? -> SQL Injection explained

There are two easy aproachs to prevent SQL Injection:

1. Using PDO:

       stmt = $pdo->prepare('SELECT * FROM employees WHERE name = :name'); 
   $stmt->execute(array(':name' => $name)); 
   foreach ($stmt as $row) {     
       // do something with $row 
   }

2. Using mysqli:

       $stmt = $dbConnection->prepare('SELECT * FROM employees WHERE name = ?'); 
   $stmt->bind_param('s', $name); 
   $stmt>execute(); 
   $result = …