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 31 to 60 of 70 Next 10 Older Entries

Displaying posts with tag: MySQL Cluster CGE (reset)

MySQL Workbench 5.2 goes GA – partial support for MySQL Cluster
Employee +7 Vote Up -0Vote Down

Configure MySQL Server nodes for MySQL Cluster

The new version of MySQL Workbench (5.2.25) has just gone GA – see the Workbench BLOG for details.

So what’s the relevance to MySQL Cluster? If you have a Cluster that uses MySQL Servers to provide SQL access then you can now use MySQL Workbench to manage those nodes:

  • Start & stop the mysqld processes
  • Configure the per-mysqld configuration data held in my.cnf or my.ini

The reason that I describe the support as ‘partial’ is that these MySQL Servers are treated as independent entities (no concept of them being part

  [Read more...]
Using Syslog with MySQL Cluster
Employee +3 Vote Up -0Vote Down

By default, MySQL Cluster sends log data to a file but you can also send it to the console or to Syslog; this article explains how to send it to Syslog. The example given here is for LINUX.

In this example, I’ll use the “user” syslog facility name and so the first step is to make sure that syslog is configured to route those messages. If this hasn’t already been configured then add the following lines to /etc/rsyslog.conf:

# Log user messages to local files
user.*    /var/log/user

For the changes to take effect, restart the syslog service:

[root@ws1 etc]# service rsyslog restart
Shutting down system logger:                               [  OK  ]
Starting system logger:                                    [  OK  ]

Note that you should make those changes as root.

Still as root,

  [Read more...]
MySQL Cluster presentation at Oracle Open World 2010
Employee +4 Vote Up -0Vote Down

As part of “MySQL Sunday” at this year’s Oracle Open World, Mat Keep and I will be presenting on the latest MySQL Cluster features. We’ll be presenting at 15:30 (Pacific Time) on 19th September (the event starts with a key note at 12:30).

If you’re attending Oracle Open World then please indicate that you’d like to attend the MySQL Sunday when you register. If you aren’t planning to go to Oracle Open World but will be in the San Francisco area then buying a Discover pass (only $50 if you register by 16 July) will get you into the MySQL Sunday sessions. Register

  [Read more...]
Breakfast seminar on what’s new with MySQL – London
Employee +2 Vote Up -0Vote Down

If you’re in London on Thursday 24th June then there’s a great chance to find out what’s new in MySQL.

Join us for an Oracle MySQL Breakfast Seminar to better understand Oracle’s MySQL strategy and what’s new with MySQL!
Agenda:
09:00 a.m.    Welcome Coffee/Tea
09:30 a.m.    Oracle’s MySQL Strategy
10:00 a.m.    What’s New – The MySQL Server & MySQL Cluster
10.45 a.m.    Coffee/Tea Break
11:00 a.m.    What’s New – MySQL Enterprise & MySQL Workbench
11:45 a.m.    Q&A
12:00 noon    End of the Breakfast Seminar

Cost?
None, it’s a free event! But places are









  [Read more...]
Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached
Employee +6 Vote Up -0Vote Down

A new white paper is available from http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php" target="_blank)

MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web.

There are classes of web services however that are highly transactional and update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability.

This whitepaper will discuss the

  [Read more...]
MySQL Cluster Powers Leading Document Management Web Service
Employee +4 Vote Up -1Vote Down

A new customer case-study is available for download from http://www.mysql.com/why-mysql/case-studies/mysql_cs-cluster_docudesk_WebServices.ph (http://www.mysql.com/why-mysql/case-studies/mysql_cs-cluster_docudesk_WebServices.php" target="_blank)p (http://www.mysql.com/why-mysql/case-studies/mysql_cs-cluster_docudesk_WebServices.php" target="_blank)

The DocQ web service eliminates the limitations of sharing physical documents by offering a complete paperless business solution; providing a single place where customers can manage, archive, and send their important documents. DocQ supports secure business transactions and the services to store, edit, collaborate, and publish business documents.

  [Read more...]
Configure MySQL Enterprise Monitor to monitor MySQL Cluster
Employee +6 Vote Up -0Vote Down

MySQL Cluster 7.1 introduced the ndbinfo database which contains views giving real-time access to a whole host of information that helps you monitor and tune your MySQL Cluster deployment. Because this data can be accessed through regular SQL, various systems can be configured to monitor the Cluster. This post gives one example, extending MySQL Enterprise Monitor to keep an eye on the amount of free memory on the data nodes (through a graph) and then raise an alarm when it starts to run low – even generating SNMP traps if that’s what you need.

One of the features of MySQL Enterprise Monitor is that you can define custom data collectors and that those data

  [Read more...]
Presenting Cluster tutorial at MySQL UC (and discount code!)
Employee +4 Vote Up -0Vote Down

Together with Geert and Andrew I’ll be teaching the MySQL Cluster tutrial at this year’s MySQL Cluster User Conference – Santa Clara, on April 12th. If you’re interested in using MySQL Cluster but aren’t sure how to get started (or you’ve used it but would like some tips) then this is a great opportunity. Check out the tutorial description.

If you

  [Read more...]
MySQL Cluster 6.3.31b source released
Employee +2 Vote Up -0Vote Down

The source version for MySQL Cluster 6.3.31b has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.41-ndb-6.3.31b/

This replaces MySQL Cluster 6.3.30 and 6.3.31.

You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

A description of all of the changes (fixes) that have gone into MySQL Cluster 6.3.31b (compared to 6.3.30) can be found in the MySQL Cluster 6.3.31b Change Log

MySQL Cluster 7.0.11b source released
Employee +2 Vote Up -0Vote Down

The source version for MySQL Cluster 7.0.11b has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.41-ndb-7.0.11b/

This replaces MySQL Cluster 7.0.10 and 7.0.11.

You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.11b (compared to 7.0.10) can be found in the MySQL Cluster 7.0.11b Change Log

MySQL Cluster Performance Tuning Best Practices – Webinar replay available
Employee +6 Vote Up -0Vote Down

For anyone that missed the recent webinar on getting the best performance out of MySQL Cluster then the replay is now available from mysql.com (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-480.html" target="_blank).

Benefits of connection pooling

Are you experiencing current performance bottlenecks in your high availability applications ? Are you designing a new mission-critical application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries?

Then this free web presentation is for you!

  [Read more...]
Using NDBINFO – example of monitoring data nodes with MySQL Enterprise Monitor
Employee +6 Vote Up -0Vote Down

You may have read Bernd’s recent post that explained how to try out some new beta functionality for MySQL Cluster and wondered what kind of use you could put the new ndb$info to. ndb$info uses tables/views to give real-time access to a whole host of information that helps you monitor and tune your MySQL Cluster deployment. This article gives one example, extending MySQL Enterprise Monitor to keep an eye on the amount of free memory on the data nodes and then raise an alarm when it starts to run low – even generating SNMP traps if

  [Read more...]
MySQL Cluster 7.0.11 source released
Employee +4 Vote Up -0Vote Down

The source version for MySQL Cluster 7.0.11 has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.41-ndb-7.0.11/

This replaces MySQL Cluster 7.0.10.

You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.11 (compared to 7.0.11) can be found in the MySQL_Cluster_7_0_11_ChangeLog.

Upcoming webinars for Java and JPA access to MySQL Cluster
Employee +4 Vote Up -0Vote Down

ClusterJ Architecture

MySQL have been working on a new way of accessing MySQL Cluster using Java. Designed for Java developers, the MySQL Cluster Connector for Java implements an easy-to-use and high performance native Java interface and OpenJPA plug-in that maps Java classes to tables stored in the high availability, real-time MySQL Cluster database.

There is a series of 2 webinars coming up, as always these are free to attend – you just need to register in advance:

Part 1: Tuesday, February 16, 2010: 10:00 Pacific time

  • an overview of the MySQL Cluster Connector for Java
  • what these technologies bring to
  [Read more...]
MySQL Cluster 7.0.10 source released
Employee +4 Vote Up -0Vote Down

The source version for MySQL Cluster 7.0.10 has now been made available at ftp://ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.39-ndb-7.0.10//

This replaces MySQL Cluster 7.0.9.

You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.10 (compared to 7.0.9) can be found in the MySQL_Cluster_7_0_10_ChangeLog.

New white paper: Guide to Optimizing Performance of the MySQL Cluster Database
Employee +3 Vote Up -0Vote Down

MySQL Cluster Connection Pooling

This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, before exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.

The Guide concludes with recent performance benchmarks conducted with the MySQL Cluster database, an overview of how MySQL Cluster can be integrated with other MySQL storage engines, before summarizing additional resources that will enable you to optimize MySQL Cluster

  [Read more...]
MySQL Cluster fault tolerance – impact of deployment decisions
Employee +7 Vote Up -0Vote Down

Fig 1. Typical management configuration

MySQL Cluster is designed to be a High Availability, Fault Tolerant database where no single failure results in any loss of service.

This is however dependent on how the user chooses to architect the configuration – in terms of which nodes are placed on which physical hosts, and which physical resources each physical host is dependent on (for example if the two blades containing the data nodes making up a particular node group are cooled by the same fan then the failure of that fan could result in the loss of the whole database).

Of course, there’s always the possibility of an entire data center being lost due to earthquake,

  [Read more...]
Free webinar: FreeRADIUS & MySQL Cluster: Scalable and Highly Available AAA Services – EMEA
Employee +0 Vote Up -0Vote Down

As network use grows and services become more dynamic, so existing Authentication, Authorization and Accounting (AAA) environments can struggle to keep pace with demand.

Tune into this webinar where you can hear from the Alan Dekok, one of the founders of the FreeRADIUS project and CEO of Network RADIUS, discuss the concepts and implementation of RADIUS services using the FreeRADIUS server and the MySQL Cluster database to deliver highly available and scalable AAA services.

As always, this webinar is free and you can register here (http://www.mysql.com/news-and-events/web-seminars/display-432.html" target="_blank). I will be manning the Q&A during the webinar.

In this session, you will learn about:

      [Read more...]
    MySQL Cluster 7.0.8a is now released
    Employee +0 Vote Up -0Vote Down

    The GA binaries for MySQL Cluster 7.0.8a (the “a” is used to indicate that this is an increment on the original 7.0.8 source release) have been released – download them from http://dev.mysql.com/downloads/select.php?id=14

    A summary of the changes can be found in the MySQL Cluster 7.0.8a Change Log

    Accessing the same data through LDAP and SQL
    Employee +2 Vote Up -0Vote Down

    OpenLDAP includes a driver that allows it to store and access data held in MySQL Cluster. It uses the NDB-API to access the database and so the performance is extremely good. One of the great things about the solution is that it lets you simultaneously access the same data through both LDAP and SQL (or the NDB-API or any of the MySQL connectors). This article gives an example of how this can be done.

    Prerequisites:

    This article assumes that you’ve already installed MySQL Cluster  – if that isn’t the case then please first refer to “

      [Read more...]
    MySQL Cluster 6.3.27 source released
    Employee +3 Vote Up -1Vote Down

    6.3.27a source release is now available from ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/

    The source version for MySQL Cluster 6.3.27 has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.37-ndb-6.3.27/

    You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

    A description of all of the changes (fixes) that have gone into MySQL

      [Read more...]
    MySQL Cluster 7.0.8 source released
    Employee +3 Vote Up -0Vote Down

    7.0.8aa source release is now available from ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/

    The source version for MySQL Cluster 7.0.8 has now been made available at ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/mysql-5.1.37-ndb-7.0.8/

    You can either wait for the binaries to be released or if you’re in a rush then you can find instructions on building the binaries for yourself in the earlier article: “MySQL Cluster 7.0.7 source released“.

    A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.8

      [Read more...]
    Another free webinar today – FreeRADIUS & MySQL Cluster: Scalable and Highly Available AAA Services
    Employee +1 Vote Up -0Vote Down

    As network use grows and services become more dynamic, so existing Authentication, Authorization and Accounting (AAA) environments can struggle to keep pace with demand.

    Tune into this webinar where you can hear from the Alan Dekok, one of the founders of the FreeRADIUS project and CEO of Network RADIUS, discuss the concepts and implementation of RADIUS services using the FreeRADIUS server and the MySQL Cluster database to deliver highly available and scalable AAA services.

    As always, this webinar is free and you can register here (http://www.mysql.com/news-and-events/web-seminars/display-419.html" target="_blank). I will be manning the Q&A during the webinar.

    In this session, you will learn about:

    • potential AAA limitations as network environments grow
    • advantages of
      [Read more...]
    Free MySQL webinar today – High Availability Architectures for Online Applications
    Employee +0 Vote Up -0Vote Down

    Update: You can now download a recording of the webinar and the slides from http://www.mysql.com/news-and-events/on-demand-webinars/display-od-403.html (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-403.html" target="_blank)

    I’ll be presenting the fourth (and final) session of the MySQL for Online Applications webinar series (http://www.mysql.com/news-and-events/web-seminars/online-apps.html" target="_blank) today (29 September). Today’s High Availability Architectures for Online Applications (http://www.mysql.com/news-and-events/web-seminars/display-403.html) webinar covers:

    • MySQL Replication
    • MySQL Cluster
    • Distributed Replicated Block Device (DRBD)
    • Other high-availability technologies

    Register here

      [Read more...]
    Free Guide released: Scalable Authentication Services with FreeRADIUS and MySQL Cluster
    Employee +1 Vote Up -0Vote Down

    MySQL/Sun have releases a new white paper…

    Do you want to ensure that your Authentication, Authorization and Accounting (AAA) infrastructure will scale to support your business growth? As network use grows and services become more dynamic, limitations can occur which add administrative overhead, inhibit flexible scaling and impact the timely synchronization of data across the AAA environment. To address these challenges, Sun has collaborated with the FreeRADIUS server team, the most widely deployed RADIUS server in the world, to integrate the carrier-grade, real-time MySQL Cluster database with the FreeRADIUS Server. Delivering Scalable Authentication Services: Get the whitepaper now! Attend Webinar Download our free whitepaper “Delivering Scalable and Highly Available Authentication, Authorization and Accounting Services” now to better  [Read more...]
    MySQL Cluster 7.0.7 binaries released
    Employee +0 Vote Up -0Vote Down

    The binaries for MySQL Cluster 7.0.7 have now been released and can be downloaded from http://dev.mysql.com/downloads/cluster/7.0.html

    A description of all of the changes (fixes) that have gone into MySQL Cluster 7.0.7 (compared to 7.0.6) can be found in the MySQL Cluster 7.0.7 Change Log.

    MySQL Cluster 7.0.7 source released
    Employee +2 Vote Up -0Vote Down

    Update: As explained in “MySQL Cluster 7.0.7 binaries released” you can now download the compiled binaries for your particular platform. I am going to leave this entry in place as it will hopefully be useful for future releases but for 7.0.7 you should refer to that other post.

    You’ll need to wait for the pre-built binaries but you can now download the source code and build it for yourself to get started. This article explains where to get it and how to build, install and test the installation.

    In this example, I’ve used Ubuntu.

    The first step is to download the compressed tar ball containing the source code by pointing your browser to

      [Read more...]
    MySQL Cluster: Geographic Replication Deep-Dive
    Employee +2 Vote Up -0Vote Down

    Following requests received during earlier MySQL Cluster webinars, a new (and as always, free) webinar has been scheduled which focuses on MySQL Cluster Replication. The webinar is scheduled for Thursday 10 September and you can register at http://www.mysql.com/news-and-events/web-seminars/display-415.html (http://www.mysql.com/news-and-events/web-seminars/display-415.html)

    I’ll be on-line during the webinar, answering questions.

    Details….

    MySQL Cluster: Geographic Replication Deep-Dive

    Thursday, September 10, 2009

    MySQL Cluster has been deployed into some of the most demanding web, telecoms and enterprise / government workloads, supporting 99.999% availability with real time performance and linear write scalability.

    Tune into this webinar where you can hear from the Director of MySQL Server

      [Read more...]
    Webinar: MySQL Cluster 7.0: What’s New? (AS/ANZ/IN)
    Employee +0 Vote Up -0Vote Down

    Mat Keep and I will be presenting a Webinar on Wednesday, August 12, 2009 describing the new capabilities of MySQL Cluster 7.0. The time is designed to be Asia/Australasia-friendly but of course it’s open to everyone.

    Register for the MySQL Cluster 7 Webinar here (http://www.mysql.com/news-and-events/web-seminars/display-399.html" target="_blank).

    By attending this webinar, you will learn more about the next generation of MySQL Cluster, and how it enables you to deliver 99.999% database availability, with real time performance and linear scalability, while slashing TCO.

    Boasting a range of breakthrough capabilities, MySQL Cluster 7.0 will enable you to stay ahead of your most demanding, mission-critical application requirements. Enhanced scalability delivers higher database performance with fewer nodes to simplify deployment and

      [Read more...]
    MySQL Cluster Data Node restart times
    Employee +0 Vote Up -0Vote Down

    Restarts are required for certain, infrequent maintenance activities. Note that there is no loss of service while a single node restarts.

    When a data node restarts, it first attempts to load the data into memory from the local log files and then it will catch up with any subsequent changes by retrieveing them from the surviving node(s) in its node group.

     Based on this, you would expect the time taken to restart a data node to be influenced by:

  • The amount of data that was stored on the data node before the restart
  • Rate of updates being made to the data during the restart
  • Network performance (assuming the data is being updated during recovery)
  • The times will also be influenced bycertain configuration parameters, performance of the host machine and whether the multi-threaded data node (ndbmtd) is being used.

    To

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 70 Next 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.