Getting Started Using NDB
Contents |
← Back to MySQL University main page
[edit] Getting Started Using NDB
- Date: 2008-05-08
- Presenter: Stewart Smith
- Scribe: Jon Stephens
- Attendees:
- Ben Wiechman
[edit] Presentation
Intro to NDB Presentation (1.8MB PDF)
[edit] Questions asked during the session
- Does MySQL Cluster perform better for read-intensive or write-intensive applications?
- Its performance is about equal in both scenarios.
- Does MySQL Cluster support row-level locking?
- Yes.
- What are the limiting factors on performance if the cluster nodes are far apart (geographically separated)?
- Cluster performance is highly dependent on connectivity. It should also be noted that there is no encryption or authentication between cluster nodes. For both of these reasons, all nodes in a MySQL Cluster should be on the same local, dedicated network.
- Is it necessary for all for updates to be run on one MySQL server (SQL node), all deletes on another, and so on?
- No, it's fine to mix different types of SQL statements/operations on any and all SQL nodes.
- Can you use MySQL Connectors with MySQL Cluster?
- Yes. MySQL Connectors can access SQL nodes just as they do any other instance of the MySQL server.
- Are rows in NDB tables fixed-width or variable-width?
- Beginning with MySQL 5.1, all rows including VARCHAR are variable.