Join Continuent, SkySQL and MariaDB for a day of free tutorials and interactive discussions around the MySQL and Maria databases, the Cloud, and High Availability, immediately following Percona Live: MySQL User Conference and Expo 2013.
Robert Hodges (CEO, Continuent) and Edward Archibald (CTO, Continuent) will be talking about "Scalable MySQL Operation in the Cloud with Continuent Tungsten" at
Join us next Friday in Santa Clara for a free day of learning and fun from the SkySQL & MariaDB gang & their partners
We’re proud to announce that Jim Tommaney, CTO of Calpont, has just signed on to speak at the MySQL & Cloud Database Solutions Day, hosted by SkySQL and MariaDB - taking place next Friday, April 26, directly after Percona Live: MySQL Conference & Expo.
Join us next Friday in Santa Clara for a free day of learning and fun from the SkySQL & MariaDB gang & their partners
We’re proud to announce that Jim Tommaney, CTO of Calpont, has just signed on to speak at the MySQL & Cloud Database Solutions Day, hosted by SkySQL and MariaDB - taking place next Friday, April 26, directly after Percona Live: MySQL Conference & Expo.
Date: Tuesday, June 04, 2013
Time: 5:30 PM – 7:00 PM
Oracle Corporation
6031 Connection Drive
Suite 900
Las Colinas, TX 75039
Event is free to the public. But please RSVP so we order enough pizza.
Learn how to set up MySQL replication for simple master/slave relationship, including a live demo. Then we will cover how to scale using replication and advanced strategies. Giveaways include books from Oracle press!
Pizza at 5:30 p.m.
Presentation begins at 6:00 p.m.
Spatial data is being more used and needed at a larger number of applications. This type of data is not always easy to be managed or queried. And sometimes calculations need to be done in the application code instead of doing them at the server. Recently we added a new class to manage spatial data with Connector/Net, so our users can have the option to handle spatial data operations at their application code.
Highlights: Foreign Keys, NoSQL JavaScript Connector,
MySQL 5.6 and Auto-Tuned Clustering
The MySQL team at Oracle are excited to announce the immediate
availability of the second MySQL Cluster 7.3 Development Milestone Release
(DMR)
Some might call MySQL Cluster 7.3 “the foreign keys release” –
and sure enough it is a major engineering achievement to build a
distributed database that enforces referential integrity across a
shared-nothing cluster, while maintaining ACID compliance and
cross-shard JOINs. But MySQL Cluster 7.3 is a lot more as
well.
The design focus has been on enabling developer agility – making
it simpler and faster than ever to enhance new services with a
highly scalable, fault tolerant, real-time database – with
minimum development or operational effort.
The key enhancements …
This tutorial has been authored by Craig Russell and JD Duncan
The MySQL Cluster team are working on a new NoSQL JavaScript connector for MySQL. The objectives are simplicity and high performance for JavaScript users:
- allows end-to-end JavaScript development, from the browser to the server and now to the world's most popular open source database
- native "NoSQL" access to the storage layer without going first through SQL transformations and parsing.
Node.js is a complete web platform built around JavaScript designed to deliver millions of client connections on commodity hardware. With the MySQL NoSQL Connector for JavaScript, Node.js users can easily add data access and persistence to their web, cloud, social and mobile applications.
While the initial …
[Read more]
It’s not uncommon to promote a server from slave to master. One
of the key things to protect your data integrity is to make sure
that the promoted slave is permanently disconnected from its old
master. If not, it may get writes from the old master, which can
cause all kinds of data corruption. MySQL provides the handy
RESET SLAVE command. But as we’ll see, its behavior
has changed along with the MySQL versions and it’s easy to shoot
yourself in the foot if you use it incorrectly. So how do you
safely disconnect a replication slave?
In short
STOP SLAVE,
CHANGE MASTER TO MASTER_HOST='' and then RESET
SLAVE.
STOP SLAVE and then
RESET SLAVE ALL.
master-user,
master-host and master-password
settings in my.cnf, …
Importing a text file containing a list of SQL commands into
MySQL is a straightforward task. All you need to do is simply
feed the file contents through pipe into MySQL command line
client. For example: mysql app_production <
dump.sql.
The reasons for doing such imports can be very different - restoring MySQL backups created with mysqldump, manually replaying binary log events or performing database migrations during software roll-outs.
While the task is simple, the import may not end successfully and when this happens, how to tell what the problem was?
MySQL errors
Whenever database hits an error, MySQL produces an error message that describes the problem and the import process stops immediately. If the message is not clear enough, you can always refer to the reported line number, which is the line number inside the source SQL file. This way you can locate the precise command or query that …
[Read more]Percona is glad to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available from the downloads area or from our software repositories.
New Features: