Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 91 to 120 of 354 Next 30 Older Entries

Displaying posts with tag: MySQL Cluster (reset)

New White Papers from SkySQL on MariaDB, MySQL Cluster, HA & Enterprise Monitor
+2 Vote Up -0Vote Down

Just in time for the holidays, SkySQL has published new white papers to keep you occupied while dealing with holiday travel delays, waiting for your turkey to roast, or hiding from your in-laws! Download them, today:

  • "Should I Migrate to Version 5.3 of the MariaDB Database?" - Written by Mark Riddoch, SkySQL's Senior Software Architect, this white paper looks at those features that have been added in the version 5.3 of the MariaDB™ database and compares them to what is available with version 5.5 of the MySQL® database. This white paper addresses the value that might be gained from migrating from version 5.5 of the MySQL database (or earlier) to version 5.3 of the MariaDB database.
  [Read more...]
MySQL Cluster to MySQL Server ... Part 2
+3 Vote Up -1Vote Down

I previously posted blog about the topic of a MySQL Cluster set up and replication to a MySQL Server. The first blog was just the installation, now lets test the cluster and get replication started. Both are extremely easy. Some people might ask, “Why set up replication from a cluster? It is a HA system why replication?”The ability to move data out of the cluster and allow others to do reporting, data exports, simple backups all can be done easily with it replicated into another MySQL server. Yes a Cluster can do all of those queries, but taking advantage of the replication to keep some users and queries out of your production database is rarely a bad thing.
Testing the Cluster Install. Of course more MySQL Documentation:

  [Read more...]
MySQL Cluster to MySQL Server Part 1
+2 Vote Up -1Vote Down
Recently I was working on a MySQL Cluster that is replicated to a MySQL server. I will create a few blog posts to show how all of this can be done. This is of course not the only way to do this.. Any feedback or other options are welcomed in comments for the community to use.

Part one: the install

First the MySQL Documentation about MySQL Cluster is very good I will make references to it for your convenience.
You can go about this a few different ways but this is a simple RPM install:

Download all the related rpms from http://dev.mysql.com/downloads/cluster/ and install.

MySQL Documentation (http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-install-linux-rpm.html) is here to








  [Read more...]
MySQL HA Solutions – webinar replay
Employee +1 Vote Up -0Vote Down

If you were unable to attend the live webinar (or you want to go back and listen to it again) then it’s now available to view on-line here.

Databases are the center of today’s web and enterprise applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization. Tune into this webcast to learn more.

The session discusses:

  [Read more...]
Enhanced conflict resolution with MySQL Cluster active-active replication
Employee +4 Vote Up -0Vote Down

Detecting conflicts

Part of the latest MySQL Cluster Development Milestone Release (MySQL Cluster 7.2.1 – select the “Development Release” tab at http://dev.mysql.com/downloads/cluster/#downloads) is a couple of enhancements to the conflict detection and resolution mechanism for active-active (multi-master) replication. While MySQL Cluster has had conflict detection for years it has now been made much more complete and a lot easier to

  [Read more...]
MySQL Cluster 7.1.17 available
Employee +4 Vote Up -0Vote Down


The binary version for MySQL Cluster 7.1.17 has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank) (GPL version) or https://support.oracle.com/ (commercial version)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.17 (compared to 7.1.15a) can be found by combining the summaries from the official MySQL Cluster documentation for Cluster – 7.1.16 Change log & 7.1.17 Change log.

MySQl Cluster 7.2 — a single node cluster
Employee +4 Vote Up -0Vote Down

Today we will get MySQL Cluster running on a single node.

A few years ago I created as presentation on running MySQL Cluster 5.1 on a laptop using Virtualbox that has proven to be the most popular download from NorthTexasMySQL.org with over nine hundred downloads.  Now MySQL 7.2 is in development milestone release and I find that I have some catching up to do.

Those of you with access to the Carrier Grade Edition (CGE) of Cluster, check out MySQL Cluster Manager 1.1 and Andrew Morgan’s  blog.  You can set up a cluster with minimal editing of configuration files or perform online software upgrades.

But MySQL Cluster 7.2 from

  [Read more...]
High Performance PHP Session Storage on Scale
Employee +1 Vote Up -0Vote Down

One of the great things about the HTTP protocol, besides status code 418, is that it's stateless. A web server therefore is not required to store any information on the user or allocate resources for a user after the individual request is done. By that a single web server can handle many many many different users easily, and well if it can't anymore one can add a new server, put a simple load balancer in front and scale out. Each of those web servers then handles its requests without the need for communication which leads to linear scaling (assuming network provides enough bandwidth etc.).

Now the Web isn't used for serving static documents only anymore but we have all these fancy web apps. And those applications often have the need for a state. The most trivial information they need is the current user.

  [Read more...]
Come Hear about MySQL Cluster Internals at the DOAG Conference
+0 Vote Up -0Vote Down

If you’re in Nuremberg Germany next week (November 15-17th) and have anything to do with Oracle or their products, then the DOAG (German Oracle User Group) conference is the place to be. I will be representing SkySQL Ab at the conference, giving a talk about the internal architecture of MySQL Cluster. The talk will look at the internals of MySQL Cluster and at the different processes that ensure the High Availability of MySQL Cluster. Beyond that, the talk will also look at how the data is stored on the data nodes, how different types of queries are resolved in the cluster, and how a primary key lookup is executed differs significantly from a tree index search. The talk will also look at the resources involved in resolving the queries.

So if any of the above sounds interesting come and listen to my talk in room Singapur at 13:00 on Tuesday!

Come Hear about MySQL Cluster Internals at the DOAG Conference
+4 Vote Up -0Vote Down
If you’re in Nuremberg Germany next week (November 15-17th) and have anything to do with Oracle or their products, then the DOAG (German Oracle User Group) conference is the place to be. I will be representing SkySQL Ab at the conference, giving a talk about the internal architecture of MySQL Cluster. The talk will look at the internals of MySQL Cluster and at the different processes that ensure the High Availability of MySQL Cluster. Beyond that, the talk will also look at how the data is stored on the data nodes, how different types of queries are resolved in the cluster, and how a primary key lookup is executed differs significantly from a tree index search. The talk will also look at the resources involved in resolving the queries.
So if any of the above sounds interesting come and listen to my talk in room Singapur at 13:00 on Tuesday!
MySQL Cluster, and NoSQL
Employee_Team +0 Vote Up -0Vote Down

Those are the topics we cover in the latest episode of our “Meet The MySQL Experts” podcast.

Mat Keep and Bernd Ocklin talk about new database requirements, and walk us through what's new in the second Development Milestone Release of MySQL Cluster 7.2, including impressive performance improvements, new NoSQL access via memcached, cross data center scalability, and more...

Enjoy the podcast!

MySQL Cluster, and NoSQL
Employee_Team +1 Vote Up -0Vote Down

Those are the topics we cover in the latest episode of our “Meet The MySQL Experts” podcast.

Mat Keep and Bernd Ocklin talk about new database requirements, and walk us through what's new in the second Development Milestone Release of MySQL Cluster 7.2, including impressive performance improvements, new NoSQL access via memcached, cross data center scalability, and more...

Enjoy the podcast!

451 CAOS Links 2011.10.25
+0 Vote Up -0Vote Down

Microsoft: “more than half your Android devices are belong to us”. And more

# Microsoft claimed that more than half of the world’s ODM industry for Android and Chrome devices is now under license to Microsoft’s patent portfolio following its agreement with Compal Electronics.

# Hadapt expanded its board of directors and confirmed its $9.5m series A funding round.

# Appcelerator entered into an

  [Read more...]
Further MySQL Cluster additions to MySQL Enterprise Monitor
Employee +2 Vote Up -0Vote Down

Data Node Restarted alert

About 11 months ago I described the MySQL Cluster functionality that was added to MySQL Enterprise Monitor 2.3; this new post is intended to just bring this up to date – briefly describing the new graph and advisors which have been added since then (up to and including MEM 2.3.7).

Cluster Data Node Has Been Restarted

This new alert flags when a data node has been

  [Read more...]
MySQL Cluster Webinar on Wednesday: What’s New in MySQL Cluster 7.2.1 Development Milestone Release
Employee +3 Vote Up -0Vote Down

There’s a webinar this Wednesday (9 am Pacific; 5 pm UK; 6 pm CET) that explains what’s new in the MySQL Cluster Development Milestone Release – register here for free access (http://www.mysql.com/news-and-events/web-seminars/display-665.html?p=EnNL" target="_blank).

Join this session to learn about the latest enhancements to the MySQL Cluster database, enabling even more of the latest generation of web, telecoms and embedded applications to take advantage of high write scalability,

  [Read more...]
SkySQL & Severalnines Team-up to Help Customers Deploy MySQL® Cluster
+0 Vote Up -0Vote Down

SkySQL today announced that it will begin reselling Severalnines' ClusterControl™ product, which enables customers to set-up a production-ready, MySQL® Cluster configuration. The latest addition to the SkySQL™ Reference Architecture - SkySQL's framework for reducing the cost and complexity of deploying some of the most common MySQL data infrastructure applications - ClusterControl™ provides a virtual DBA assistant that frees the developer from the complexity and typical learning curves associated with database clusters, and provides assistance throughout the database lifecycle.

Kaj Arnö, EVP of products at SkySQL, and Vinay Joosery, CEO of Severalnines, will give an overview of the ClusterControl™ solution in a live webinar, on November 8th at 4PM CET/10AM ET.

  [Read more...]
MySQL Cluster material from Oracle Open World 2011
Employee +3 Vote Up -0Vote Down

For those people that weren’t able to attend the MySQL Cluster demo or sessions at this year’s Oracle Open World (or even for those that did) and would like copies of the material, links are provided here.

  [Read more...]
MySQL Cluster 7.2 (DMR2): NoSQL, Key/Value, Memcached
Employee_Team +0 Vote Up -0Vote Down
0 0 1 977 5569 Homework 46 13 6533 14.0 Normal 0 false false false EN-US JA X-NONE

70x Higher Performance, Cross Data Center Scalability and New NoSQL Interface

Its been an exciting week for all involved with MySQL Cluster, with the announcement of the

  [Read more...]
MySQL Cluster 7.2 (DMR2): NoSQL, Key/Value, Memcached
Employee_Team +1 Vote Up -0Vote Down
0 0 1 977 5569 Homework 46 13 6533 14.0 Normal 0 false false false EN-US JA X-NONE

70x Higher Performance, Cross Data Center Scalability and New NoSQL Interface

Its been an exciting week for all involved with MySQL Cluster, with the announcement of the

  [Read more...]
Synchronously Replicating Databases Across Data Centers – Are you Insane?
Employee_Team +0 Vote Up -0Vote Down
 

Well actually….no. The second Development Milestone Release of MySQL Cluster 7.2 introduces support for what we call “Multi-Site Clustering”. In this post, I’ll provide an overview of this new capability, and considerations you need to make when considering it as a deployment option to scale geographically dispersed database services.

You can read more about MySQL Cluster 7.2.1 in the article posted on the MySQL Developer Zone

MySQL Cluster has long offered Geographic Replication, distributing clusters to remote data centers to reduce the affects of geographic latency by pushing data closer to the user, as well as providing a capability for

  [Read more...]
Synchronously Replicating Databases Across Data Centers – Are you Insane?
Employee_Team +4 Vote Up -0Vote Down
 

Well actually….no. The second Development Milestone Release of MySQL Cluster 7.2 introduces support for what we call “Multi-Site Clustering”. In this post, I’ll provide an overview of this new capability, and considerations you need to make when considering it as a deployment option to scale geographically dispersed database services.

You can read more about MySQL Cluster 7.2.1 in the article posted on the MySQL Developer Zone

MySQL Cluster has long offered Geographic Replication, distributing clusters to remote data centers to reduce the affects of geographic latency by pushing data closer to the user, as well as providing a capability for disaster

  [Read more...]
MySQl Cluster 7.2 at OOW Demo Pod
Employee +4 Vote Up -0Vote Down

Be sure to drop by the MySQL Demo Pod while you are attending Oracle Open World. There you will see a demo of the changes in MySQL Cluster 7.2. My favorite part of this release is that you can access the same data via SQL, LDAP, REST, memcached or via APIs. You get the best of both SQLand NoSQL worlds in one. At the Demo Pod, you can see how to see how Adaptive Query Localization speed up joins. Plus the demo will preview the latest and
greatest 7.2 DMR capabilities, and also demonstrate how MySQL Cluster
remains operational during node failures, upgrades and re-configuration
and how simple it is to create a live cluster using MySQL Cluster Manager. In the past, many cluster users avoid joins and simply used primary key or key/value pairs. But Adaptive Query


  [Read more...]
MySQL Cluster 7.1.15a is available
Employee +4 Vote Up -0Vote Down


The binary version for MySQL Cluster 7.1.15a has now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank) (GPL version) or https://edelivery.oracle.com/ (commercial version)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.15a (compared to 7.1.15) can be found in the official MySQL Cluster documentation for Cluster 7.1.15a Change log.

MySQL Cluster Manager 1.1.2 – creating a Cluster is now trivial
Employee +6 Vote Up -0Vote Down

MySQL Cluster Manager 1.1.2 is now available to download and try from Oracle E-Delivery (select “MySQL Database” as the product pack). Something that’s new and really cool in the new version is that you can download a version of MCM that actually includes the MySQL Cluster software itself and then you can have MCM automatically define, create and start a single-host cluster deployment for you with just the command “mcmd –bootstrap”. This post aims to show that

  [Read more...]
London 18th October: Oracle Technology Network MySQL Developer Day
Employee +5 Vote Up -0Vote Down

I will be presenting on MySQL Cluster and MySQL Replication at the Oracle Technical Network MySQL Developer day in London on Tuesday, 18 October 2011 (8:30 AM – 4:00 PM). It’s free but you need to register here while there are still places (attendance has been extremely high at other locations).

The MySQL Developer Day is a one-stop shop for you to

  [Read more...]
My sessions at Oracle OpenWorld 2011
Employee +6 Vote Up -0Vote Down

Slight adjustment to some of the times + added the MySQL community reception (read  vodka!). Oracle OpenWorld (San Francisco) starts on Sunday 2nd October (including some MySQL community sessions) through Thursday 6th October. MySQL has a lot of sessions this year as well as 3 demo booths.

This year I’m going to be involved in 3 public sessions – if you’re attending, please come along and say hello!

  • Getting the Most Out of MySQL on Windows – 13:15 on Tuesday (Marriott Marquis – Golden Gate C2)
  • Building Highly Available and Scalable Real-Time
  [Read more...]
MySQL Cluster is a brilliant NoSQL database
+0 Vote Up -0Vote Down

MySQL Cluster* is one of the most advanced and scalable databases available today and, despite what its name might suggest, it is also a brilliant NoSQL database**.
Let me discuss this statement!
First, let’s discuss the high level issues that NoSQL databases try to address:-     Scalability. Traditional RDBMS technology was designed four decades ago, and is not appropriate for today’s Big Data requirements. Database systems today need to be able to scale horizontally over multiple machines to handle millions of users. As the CAP theorem states, it is not possible to achieve availability, scalability and consistency in one system. Several NoSQL databases sacrifice consistency for availability and scalability. -     RDBMS has a rigid data model. Once a


  [Read more...]
MySQL Clusters on Amazon EC2 - verified AMIs
+1 Vote Up -0Vote Down
We regularly receive questions from our user community with regards to which AMIs to use when deploying database clusters on Amazon EC2.

As part of our ongoing development work on the Severalnines Configurator and ClusterControl, we have recently done some testing on deploying MySQL Cluster on EC2 using Severalnines on three different AMIs. We thought we should share the results of these tests, hence the reason for this week's blog!

If you would like to test such a deployment yourself, feel free to use the parameters and guidelines below to do so. You can also check out these new videos to see



  [Read more...]
MySQL Cluster Webinar: Best practices in scaling Web databases with Auto-Partitioning and SQL/noSQL Access
+4 Vote Up -0Vote Down


Register yourself here





  [Read more...]
MySQL Clusters in the Cloud with Severalnines on OpenShift
+3 Vote Up -0Vote Down
A blog post on how to deploy a sample JBoss application on OpenShift Flex - using a highly available, scalable backend that leverages MySQL Cluster

The Severalnines team has been busy during the summer months and as result, we have included OpenShift Flex support to our Severalnines Configurator (amongst other things). OpenShift, a Platform-as-a-Service operated by Red Hat, allows developers to develop and manage applications in the cloud. It is now possible to configure a clustered MySQL database for cloud services running on OpenShift. This brings high-availability and scalability at both the application and database layers.

As a guest contributor



  [Read more...]
Previous 30 Newer Entries Showing entries 91 to 120 of 354 Next 30 Older Entries

Planet MySQL © 1995, 2013, 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.