Tag: MySQL

Asynchronous Replication from MySQL Cluster

MySQL Cluster is a highly available, distributed, shared-nothing database with very interesting performance characteristics for some workloads. Among other features, it supports automatic sharding and allows us to bypass the SQL layer if we don’t need it, via the NDB…

Read More >

Log Buffer #507: A Carnival of the Vanities for DBAs

This Log Buffer edition covers Oracle, SQL Server and MySQL blog posts with a touch of Cloud.

Read More >

Pythian at the PerconaLive 2017 Open Source Database Conference

With PerconaLive 2017 coming up in a couple of months, go ahead and get excited! The conference is being held in Santa Clara, California from April 24-28, 2017. While you’re there, be sure to add these Pythian sessions to your…

Read More >

Log Buffer #505: A Carnival of the Vanities for DBAs

This Log Buffer Edition searches through various blogs of Oracle, SQL Server and MySQL and picks a few contemporary ones.

Read More >

Log Buffer #504: A Carnival of the Vanities for DBAs

This edition of Log Buffer covers Oracle, Microsoft SQL Server, and MySQL.

Read More >

MySQL may return results in non-deterministic order with ‘order by’

Whenever we want a query’s results sorted, you may think of using the clause “order by.” You are correct: most of the time, MySQL will return the results in expected order with “order by.” Be careful, though. Sometimes MySQL may return…

Read More >

Customizing pt-stalk to Capture the Diagnostics Data You Really Need

Valeriy Kravchuk’s great recent post on using oprofile to profile MySQL mentioned how pt-stalk, the script from Percona Toolkit to capture diagnostics data based on a detected condition, currently does not support the new operf comand, and relies instead on the deprecated and soon…

Read More >

Duplicate Indexes in MySQL

Valerie Parham-Thompson explains why duplicate (redundant) indexes are sometimes helpful.

Read More >

MySQL on AWS: RDS vs EC2

If you are thinking in moving your MySQL databases to AWS, this analysis by Gabriel Ciciliani may help you determine if RDS is the appropriate solution for your data.

Read More >

New MySQL File System Vulnerabilities

Get insight into the recent MySQL file system vulnerabilities.

Read More >
Page 1 of 6612345...10...Last Page »