Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 33103 10 Older Entries
Announcing TokuDB v7.5: Read Free Replication
+0 Vote Up -0Vote Down

Today we released TokuDB® v7.5, the latest version of Tokutek’s storage engine for MySQL and MariaDB.

I’ll be publishing two blogs next week to go into more details about our new “Read Free Replication”, but here are high level descriptions of the most important new features.

Read Free Replication TokuDB replication slaves can now be configured to process the binary logs with virtually no read IO. This is accomplished via two new server parameters: one to allow the skipping of uniqueness checks (for inserts and updates), the other to eliminate read-before-write behavior (for updates and deletes). The two other conditions are that the slave must be in read-only mode and replication must be row based. Hot Backup Now Supports Multiple Directories (Enterprise Edition) The original implementation of our Hot Backup functionality was only  [Read more...]
Lessons from Deploying MySQL GTID at Scale
+0 Vote Up -0Vote Down

by Evan Elias and Santosh Praneeth Banda


Global Transaction ID (GTID) is one of the most compelling new features of MySQL 5.6. It provides major benefits in failover, point-in-time backup recovery, and hierarchical replication, and it's a prerequisite for crash-safe multi-threaded replication. Over the course of the last few months, we enabled GTID on every production MySQL instance at Facebook. In the process, we learned a great deal about deployment and operational use of the feature. We plan to open source many of our server-side fixes via WebScaleSQL, as we believe others in the scale community can



  [Read more...]
Managing big data? Say ‘hello’ to HP Vertica
+0 Vote Up -1Vote Down

Over the past few months, I’ve seen an increase in the following use case while working on performance and schema review engagements:

I need to store exponentially increasing amounts of data and analyze all of it in real-time.

This is also known simply as: “We have big data.” Typically, this data is used for user interaction analysis, ad tracking, or other common click stream applications. However, it can also be seen in threat assessment (ddos mitigation, etc), financial forecasting, and other applications as well. While MySQL (and other OLTP systems) can handle this to a degree, it is by no means a forte. Some of the pain points include:

  • Cost of rapidly
  [Read more...]
Tweaking MySQL Galera Cluster to handle large databases - open_files_limit
+0 Vote Up -0Vote Down
September 18, 2014 By Severalnines

Galera Cluster is a popular choice for achieving high availability using synchronous replication. Though if you are planning to run huge sites with many DB objects (tables), a few tweaks are necessary. 

 

Yes, you might have been successful in loading your 1000s of databases and 1000s of tables, but what happens if you have a node failure and Galera recovery fails?

 

In this blog post we will show you how to determine one common error related to the open_files_limit that MySQL imposes, and also to spot another potential pitfall.

 

Open_files_limit

 

If you are using wsrep_sst_method=xtrabackup

  [Read more...]
Free eBook! Configuring MySQL for Performance
+0 Vote Up -0Vote Down

Are you overwhelmed with the hundreds of MySQL settings? Lost trying to tune the query optimizer and InnoDB buffer pools? Is the configuration process daunting?

We are here to help. Download your free copy of our latest eBook, Configuring MySQL for Performance. In just minutes, you will gain insight into setting configurations for optimal MySQL performance.

It is fast, and it is free. Request your copy here.

Sneek Peak: Continuent Tungsten 3.0
+0 Vote Up -0Vote Down
Get a preview of the next advance in data management technology!  Continuent Tungsten 3.0 brings the power of advanced clustering and replication to offer data management needs for your entire business including MySQL high availability, disaster recovery, multi-master operation, and real-time data warehouse loading. With Continuent Tungsten you can apply the full power not just of MySQL but all
I'm speaking about MaxScale and MariaDB tonight in Chicago
+0 Vote Up -0Vote Down
Wed, 2014-09-17 19:03maxmether

Tonight I will give a presentation on Max Scale (An Advanced Proxy for MySQL) for the Chicago MySQL Meetup

MaxScale is an interesting new proxy for MySQL and MariaDB that provides advanced features for handling multiple MySQL or MariaDB servers. MaxScale allows you to transparently handle clusters of MySQL servers behind the proxy. MaxScale is different from most other proxies as it is content aware and contains a query parser, has a modular plugin architecture, is aware of the state of the underlying servers and much more. In this session we will look at the architecture of MaxScale to find out what makes MaxScale so good. We will look at the basic building blocks of MaxScale and how they work together in a very efficient way. We will also discover the basic modules

  [Read more...]
Syncing MySQL slave table with pt-online-schema-change
+0 Vote Up -0Vote Down

I recently encountered a situation in which after running Percona Toolkit’s pt-table-checksum on a customer system, 95% of the table on the MySQL master was different on the MySQL slave. Although this table was not a critical part of the infrastructure, from time to time, writes to the table from the master would break replication. Additionally, this table has about 6 million rows, and running pt-table-sync would take sometime. Rebuilding the slave from backup of the master would not be an easy option as well since the slave acts as an archive where it has a lot more data than the master.

So how did we solve it? With pt-online-schema-change and a NOOP

  [Read more...]
ClusterControl 1.2.8 Released
+0 Vote Up -0Vote Down
September 17, 2014 By Severalnines

The Severalnines team is pleased to announce the release of ClusterControl 1.2.8. This release contains key new features along with performance improvements and bug fixes. We have outlined some of the key new features below. 

 

Highlights of ClusterControl 1.2.8 include:

  • YUM/APT repositories for ClusterControl
  • Deployment and scaling of single-node MySQL, MariaDB and MongoDB
  • Alerts and incident tracking with PagerDuty 
  • Unified Event Viewer
  [Read more...]
You Won't Believe These 5 Simple Tips to Get the Most from MySQL Central
+0 Vote Up -0Vote Down

The countdown is on, and MySQL Central begins in less than two weeks. We are pumped to be participating and want to make the most of this great experience. Here are five ways we plan to do so:

1) Meet the MySQL development team. They will be leading two sessions on Tuesday evening, both at 6 PM (BOF6883 and BOF5939, respectively). The first is on InnoDB, the MySQL optimizer, and any other MySQL server topic. The other discusses high availability and backup, including MySQL replication, MySQL utilities, MySQL Cluster, MySQL Fabric and MySQL backup. Bring your questions and ideas to the experts!

2) Plan your schedule in advance. Besides the two BOF sessions mentioned above, there are plenty of opportunities to engage with the community, participate in

  [Read more...]
Showing entries 1 to 10 of 33103 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.