Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 94 10 Older Entries

Displaying posts with tag: mysql replication (reset)

Webinar Replay & Slides: Performance Tuning of HAProxy for Database Load Balancing
+0 Vote Up -0Vote Down
September 11, 2014 By Severalnines

 

Thanks to everyone who attended and participated in this week’s webinar on ‘Performance Tuning of HAProxy for Database Load Balancing’. And special thanks to our guest speaker, Baptiste Assmann of HAProxy Technologies. 

 

If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

 

Watch the replay of this webinar to learn about what HAProxy can tell you about your application and database instances. And understand the difference between short-lived connections and

  [Read more...]
Puppet Module for ClusterControl - Adding Management and Monitoring to your Existing Database Clusters
+0 Vote Up -0Vote Down
September 10, 2014 By Severalnines

If you are automating your infrastructure using Puppet, then this blog is for you. We are glad to announce the availability of a Puppet module for ClusterControl. For those using Chef, we already published Chef cookbooks for Galera Cluster and ClusterControl some time back.  

 

 

ClusterControl on Puppet Forge

 

The ClusterControl module initial release is available on Puppet Forge, installing the

  [Read more...]
Replicating from MySQL to Amazon Redshift
+0 Vote Up -1Vote Down
Continuent is delighted to announce an exciting Continuent Tungsten feature addition for MySQL users: replication in real-time from MySQL into Amazon RedShift.   In this webinar-on-demand we survey Continuent Tungsten capabilities for data warehouse loading, then zero in on practical details of setting up replication from MySQL into RedShift.  We cover: Introduction to real-time movement
Upgrade MySQL to a new version with a fresh installation & use shell scripts and mysqldump to reload your data
+0 Vote Up -0Vote Down

There are several ways to upgrade MySQL (http://mysql.com). In this post, we will use a combination of shell scripts and the mysqldump application to export our MySQL (http://mysql.com) data, and then re-import it back into the upgraded version of MySQL (http://mysql.com).

In this example, we will be doing a minor version upgrade. We will be going from 5.6.17 to 5.6.19. This method may not work if you are upgrading from one major release to another – from 5.1 to 5.5, or 5.5 to 5.6. You will want to check each version and review the new features/functions and also what features/functions have been deprecated. We are also assuming that no one will be using the database during the time it takes

  [Read more...]
Monitoring MySQL flow control in Percona XtraDB Cluster 5.6
+2 Vote Up -0Vote Down

Monitoring flow control in a Galera cluster is very important. If you do not, you will not understand why writes may sometimes be stalled. Percona XtraDB Cluster 5.6 provides 2 status variables for such monitoring: wsrep_flow_control_paused and wsrep_flow_control_paused_ns. Which one should you use?

What is flow control?

Flow control does not exist with regular MySQL replication, but only with Galera replication. It is simply the mechanism nodes are using when they are not able to keep up with the write load: to keep replication synchronous, the node that is starting to lag instructs the other nodes that writes should be paused for some time so it does not get too far behind.

If you are not familiar with this notion, you

  [Read more...]
New webinar-on-demand: Geographically distributed multi-master MySQL clusters
+1 Vote Up -0Vote Down
Global data access can greatly expand the reach of your business. Continuent Tungsten multi-site multi-master (MSMM) solutions enable applications to accept write traffic in multiple locations across on-premises and cloud providers. This includes the following important real-world use cases: Improve performance for globally distributed users registering hardware devices by permitting updates
Harnessing the power of master/slave clusters to operate data-driven businesses on MySQL
+1 Vote Up -0Vote Down
Users seeking high availability, DR and zero downtime maintenance operation for business-critical MySQL applications face confusing choices. Is multi-master or master/slave clustering better?  What about synchronous versus asynchronous replication? Using a plain vanilla, stock MySQL or a modified version of it? Which of these choices are right for data-driven businesses that depend on fast,
New Webinar on July 9th: How To Set Up SQL Load Balancing with HAProxy
+1 Vote Up -0Vote Down
June 17, 2014 By Severalnines

 

We continuously see great interest in MySQL load balancing and HAProxy, so we thought it was about time we organised a live webinar on the topic!

 

As most of your will know, database clusters and load balancing go hand in hand. 

 

Once your data is distributed and replicated across multiple database nodes, a load balancing mechanism helps distribute database requests, and gives applications a single database endpoint to connect to. 

 

Instance failures or

  [Read more...]
Set up & operate Tungsten Replicator - Webinar-on-demand
+0 Vote Up -0Vote Down
Tungsten Replicator is an innovative and reliable open source tool that can solve your most complex MySQL replication problems. In this webinar we will introduce Replicator installation and show you how to use key Replicator features effectively with MySQL.   Replication is a powerful technology that takes knowledge and planning to use effectively. This webinar gives you the background that
Webinar-on-demand: Set up & operate real-time data loading into Hadoop
+1 Vote Up -0Vote Down
Getting data into Hadoop is not difficult, but it is complex if you want to load 'live' or semi-live data into your Hadoop cluster from your Oracle and MySQL databases. There are plenty of solutions available, from manually dumping and loading to the good and bad sides of using a tool like Sqoop. Neither are easy and both prone to the problems of lag between the moment you perform the dump and
Showing entries 1 to 10 of 94 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.