Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 33098 10 Older Entries
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...]
OurSQL Episode 200: Information Security and Privacy
+0 Vote Up -0Vote Down
PodcastsSecurity

For our 200th episode, we interview security expert Bruce Schneier. We talk about plenty of topics including airport security and the TSA, PRISM and the NSA, wholesale surveillance, surveillance backwards in time, finding people who have disposable cellphones, about searches and co-travelers, why Facebook does not offer the ability to pay for your account, a bit about Firefox and its propensity to act in the user's interest, and the future of our public information.

innodb_flush_log_at_timeout in 5.6
+0 Vote Up -0Vote Down
A setting that isn't used much but could be used more is innodb_flush_log_at_timeout, which controls how often InnoDB does an fsync from the OS buffer to disk. Here's how it interacts with innodb_flush_log_at_trx_commit.
Deciphering Galera Version Numbers
+0 Vote Up -0Vote Down
Mon, 2014-09-15 11:29guillaumelefranc

It's important to understand which Galera version you are running, for proper compatibility of MariaDB with the Galera replication library, and also to check which featureset you have access to. However, Galera version numbering can be difficult to decipher because of its complex scheme.

Version numbering in Galera consists of three different components:

  • Galera wsrep (write-set replication) Patch for MariaDB or MySQL
  • Galera Replication Shared Library (libgalera_smm.so)
  • Galera wsrep API

The patch component version number appears usually together with the API version number in the server version string of MariaDB. Below is a typical message displayed immediately after logging into MariaDB Galera Cluster with the mariadb client:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your
  [Read more...]
Speaking about libAttachSQL at Percona Live London
+0 Vote Up -0Vote Down
As many of you know I'm actively developing libAttachSQL and am rapidly heading towards the first beta release.  For those who don't, libAttachSQL is a lightweight C connector for MySQL servers with a non-blocking API.  I am developing it as part of my day job for HP's Advanced Technology Group.  It was in-part born out of my frustration when dealing with MySQL and eventlet in Python back when I was working on various Openstack projects.  But there are many reasons why this is a good thing for C/C++ applications as well.

What you may not know is I will be giving a talk about libAttachSQL, the technology behind it and the decisions we made to get here

  [Read more...]
MEB copies binary logs and relay logs to support PITR and cloning of master/slave
Employee_Team +1 Vote Up -0Vote Down

With MySQL Enterprise Backup(MEB) 3.9.0 we had introduced full instance backup feature for cloning the MySQL server. Now with MEB 3.11.0 we have enhanced the feature by copying all the master-slave setup files like MySQL server binary logs(will be referred as 'binlogs'), binary log index files, relay logs of slave, relay log index files, master info of slave, slave info files. As part of full instance backup, copying of binlog files is default behavior MEB-3.11.0 onwards. DBA should be aware of the fact that current full instance backup is bigger than the backups with old MEB's.

As every event on MySQL production database goes as a entry to binlog files in particular format, binlog files could be huge. Backing of huge binlog and/or relaylog files

  [Read more...]
Showing entries 1 to 10 of 33098 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.