Oracle OpenWorld 2013 is just few weeks away, and of course, we are organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of OpenWorld.
What: Oracle Bloggers Meetup 2013
When: Wed, 25-Sep-2013, 5:30pm
Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 ( …
[Read more]The MySQL Community Team has one and a half new members! Welcome back Morgan Tocker who many of you may remember from MySQL Training. And welcome Jara Jr, Lenka Kasparova’s son, whom mom informs us is ‘really sweet’.
I am speaking today at Djangocon, Dallas PHP on Tuesday the 10th, and then next weekend at Ohio Linuxfest.
Ok, so I’ve been playing around with the idea of setting up MySQL cluster on a couple of Raspberry Pi’s and this is how it has been going.
References
First of all, for anyone else who’s reading this, it’s not a new thing, I know, and I highly recommend reading A.Morgans blog, http://www.clusterdb.com/mysql-cluster/mysql-cluster-running-on-raspberry-pi/ as well as someone else’s blog: http://markswarbrick.wordpress.com/, cheers Mark.
So, to make it all possible, here’s what I bought:
| Product | Model | Quantity |
| Raspberry Pi – Model B … |
Ok, so I've been playing around with the idea of setting up MySQL cluster on a couple of Raspberry Pi's and this is how it has been going.
References First of all, for anyone else who's reading this, it's not a new thing, I know, and I highly recommend reading A.Morgans blog, http://www.clusterdb.com/mysql-cluster/mysql-cluster-running-on-raspberry-pi/ as well as someone else's blog: http://
Note that the webinar replay + transcript of the Questions and Answers is now available from here.
On Thursday 12th September I’ll be co-presenting a free webinar on how MySQL Cluster delivers the key benefits of NoSQL Data Stores without having to give up the features that people rely on from relational databases (consistency, SQL etc.). There will be particular focus on how to use the new node.js JavaScript API which was recently released as part of MySQL Cluster 7.3. As usual the webinar is free but you should …
[Read more]Row-based Replication was introduced in MySQL 5.1. It’s not the default (yet), but I really like it. I wanted to tell you what limitations you may face with statement-based, and why you should join me in making the switch.
Write scalability of certain statements
Statement based binary logging requires additional locking to ensure slave-consistency. To illustrate, here is a naive example:
CREATE TABLE users (
user_id INT NOT NULL primary key,
user_name varchar(60) NOT NULL,
is_deleted TINYINT DEFAULT 0,
UNIQUE KEY(user_name)
);
INSERT INTO users (user_id, user_name, is_deleted) VALUES
(1, 'ted', 0),
(2, 'bill', 0),
(3, 'fred', 0),
(4, 'mike', 1),
(5, 'barry', 0);
session1> START TRANSACTION;
session1> DELETE FROM users WHERE is_deleted = 1; # 1 row matches (user_id 4), deleted.
session2> START TRANSACTION; …Thanks to everyone who attended last week’s webinar, Running MySQL 5.6 on Amazon RDS.” If you weren’t able to attend, the recording and slides are available for viewing/download (or, if you were able to attend and just want to see it again). I’ve also answered the questions I didn’t have a chance to field during the event:
Q: Would you recommend Amazon RDS over manually setting
up MySQL/Percona server on an EC2 instance?
A: This depends on many factors including your data set size,
workload, uptime requirements, what the rest of your stack looks
like, and many other factors.
Q: At Q&A time, can you go more into 5.6 InnoDB full text search vs the Amazon search offering? …
[Read more]
Check out the video!
Hey there everybody!
Coming up this Wednesday, September 4th, 2013 at 12:00pm pacific (19:00 GMT) take part in #DBHangOps to discuss:
If you’re in the Washington, DC area on Sept 12th, be sure to attend Percona University. This is a free 1-day mini-conference to bring developers and system architects up to speed on the latest MySQL products, services and technologies. Some of the topics being covered include Continuent Tungsten; Percona XtraDB Cluster; MySQL Backups in the Real World; MariaDB 10.0; MySQL 5.6 and Percona Server 5.6; Apache Hadoop. I’ll be speaking about using MySQL with Go.
This week we continue our series on the MySQL Utilities. In this week's Ear Candy, we talk about a path problem installing MySQL Utilities on Ubuntu, and At the Movies is a preview of the SkySQL data suite.
Part 1 of MySQL
Utilities
Part 3 of MySQL
Utilities
Part 4 of MySQL
Utilities
Part 5 of MySQL
Utilities
Events
DB Hangops -
every other Wednesay at noon Pacific time
Percona University is coming to Washington, DC on Thursday, September 12th.
…
[Read more]