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 61 to 90 of 593 Next 30 Older Entries

Displaying posts with tag: database (reset)

SkySQL Merges With MariaDB Developers To Create ‘Next Generation Open Source’ Database Company
+5 Vote Up -0Vote Down

SkySQL today announced that it has signed a merger agreement with Monty Program Ab, creators of the fastest growing open source database technology: MariaDB.  This merger reunites key members of the original MySQL AB developer and services teams. Their aim is to develop MariaDB into a truly interoperable, NewSQL open source database in collaboration with its customers, partners and the community. The company also pledges to further evolve its offering for users of the MySQL database.

read more

SkySQL Merges With MariaDB Developers To Create ‘Next Generation Open Source’ Database Company
+0 Vote Up -0Vote Down

SkySQL today announced that it has signed a merger agreement with Monty Program Ab, creators of the fastest growing open source database technology: MariaDB.  This merger reunites key members of the original MySQL AB developer and services teams. Their aim is to develop MariaDB into a truly interoperable, NewSQL open source database in collaboration with its customers, partners and the community. The company also pledges to further evolve its offering for users of the MySQL database.

read more

What’s the data on the 3Ci Data Team?
+0 Vote Up -0Vote Down
3Ci processes over a billion transactions a month. More than 100 million unique U.S. consumers have engaged with a business through our platform. All that activity creates massive amounts of data. The Data Team at 3Ci is responsible for keeping our offerings running at optimal performance and for making sense of our data. They manage MySQL [...]   [Read more...]
SkySQL named 2013 Top 100 Europe winner, more dates added for MySQL & Cloud Database Solutions Day
+0 Vote Up -0Vote Down

We were delighted last week to find out that we’d been named one of the ‘2013 Top 100 Europe’ winning companies by the Red Herring editorial team. Congratulations to all companies involved!

read more

SkySQL named 2013 Top 100 Europe winner, more dates added for MySQL & Cloud Database Solutions Day
+0 Vote Up -0Vote Down

We were delighted last week to find out that we’d been named one of the ‘2013 Top 100 Europe’ winning companies by the Red Herring editorial team. Congratulations to all companies involved!

read more

#DBHangOps 4/10/13 (pre-Percona Conference!)
+0 Vote Up -0Vote Down

Annnnnd here’s the recording:

Hey all!

The Percona Live MySQL Conference and Expo is coming up in 2 weeks, meaning the last of preparations are under way. In the meantime, #DBHangOps is coming your way on Wednesday at 12:00pm PDT (19:00 GMT) with:

  • Talk about Performance Schema from Mark Leith
  • Some discussion on how people use and manage MySQL slow query logs in their environments
  • Filesystems and MySQL — which do you use, why, and how
  • What you’re excited about at Percona Live!

As always, hit up this twitter search or this blog post to grab the google hangout link to join!

See y’all on Wednesday!

MySQL Utilities: The New .frm Reader Utility
Employee +7 Vote Up -0Vote Down
Have you ever wondered what was in those .frm files littered throughout your data directory? Better still, have you encountered a situation where your data is either missing (was deleted) or damaged and all you have is the .frm files but don't know the structure of the table? Well, wonder no more!

The MySQL Utilities Team is pleased to announce the newest utility - the .frm reader (mysqlfrm). This utility is designed to read .frm files and produce a facsimile of the CREATE statement for the table or view.

That's Impossible! How Can That Work?


It works by making a copy of the .frm file(s) and launching a new, read-only instance of your existing server. The server need not be running but you are required to provide an open port for the new instance with the --port option.

The utility will launch the cloned server without






  [Read more...]
Introducing MySQL Utilities release-1.3.0
Employee +5 Vote Up -0Vote Down
The MySQL Utilities Team is pleased to announce a major advancement of MySQL Utilities. It is now available as a separate download!

That's right. If you want to use MySQL Utilities without installing MySQL Workbench, you can do that now.

The Utilities release-1.3.0 has been built for Windows Installer, RPM archive, and .tar/.zip. We have also made downloads for source only if you want to use Utilities to develop your own utilities or install the product in custom location. We plan to add other repositories in the future.

Is that it? Well, not quite. We have also included a new utility - the .frm Reader. See the blog, "New Utility: .frm Reader" for more information.

If you'd like to try out the new download, visit the MySQL Workbench download page:











  [Read more...]
Introducing MySQL Utilities release-1.2.1
Employee +4 Vote Up -0Vote Down
The MySQL Utilities Team is pleased to announce our latest release, version 1.2.1. This release contains many quality improvements and enhancements to the HA and Replication utilities. The following lists some of the most significant improvements.
  • Improved transaction gathering algorithm for failover
    • Skips slaves that are already caught up
    • Ensures all transactions in the relay logs on the slaves are executed first
  • External scripts in mysqlfailover and mysqlrpladmin now receive the old and new master information
  • Improved demote master handling for switchover
  • Improved connection error handling
  • Quoting of tables and database names has been improved
  • Login-path feature now reads port and socket
The utilities team continues to focus on improving usability, making features easier to use,
  [Read more...]
MySQL 5.6: an inside perspective
+2 Vote Up -0Vote Down

MySQL 5.6 through the eyes of a custom storage engine MySQL plugin

MySQL is famous for its pluggable storage engine architecture which allows a DBA or an application developer to choose the right engine for the task. An application uses MySQL API and is isolated from all of the low-level implementation details at the storage level. As an example, the Cloud Storage Engine (ClouSE) enables existing MySQL applications to use cloud storage such as Amazon S3 or Google Cloud Storage to store its data. The application doesn’t need to be changed or even redeployed: with ClouSE, remote cloud storage will look like a better (ultra-scalable, durable, always-on) alternative to the local storage.

As you may already know, ClouSE now supports

  [Read more...]
Speaker Details For MySQL & Cloud Database Solutions Day, hosted by SkySQL & MariaDB, in Santa Clara
+0 Vote Up -0Vote Down

Check out who’s talking, and about what, at our annual event on all things MySQL, MariaDB and Cloud - straight after Percona Live!

As we mentioned earlier this week, we’re gearing up for Percona Live: MySQL Conference and Expo in a few weeks.

But of course, we’re getting particularly excited as we prep for the 2nd annual SkySQL and MariaDB MySQL & Cloud Database Solutions Day, which takes place on the day (Friday, April 26) right after Percona Live: MySQL Conference and Expo.

read more

Speaker Details For MySQL & Cloud Database Solutions Day, hosted by SkySQL & MariaDB, in Santa Clara
+0 Vote Up -0Vote Down

Check out who’s talking, and about what, at our annual event on all things MySQL, MariaDB and Cloud - straight after Percona Live!

As we mentioned earlier this week, we’re gearing up for Percona Live: MySQL Conference and Expo in a few weeks.

But of course, we’re getting particularly excited as we prep for the 2nd annual SkySQL and MariaDB MySQL & Cloud Database Solutions Day, which takes place on the day (Friday, April 26) right after Percona Live: MySQL Conference and Expo.

read more

Gearing up for the Percona Live: MySQL Conference & Expo!
+1 Vote Up -0Vote Down

Join the SkySQL and MariaDB Crews in Santa Clara and Save on Registration

Percona Live: MySQL Conference and Expo 2013 starts in just 3 weeks, and it’s the premiere event for MySQL users, open-source enthusiasts, and the technology movers ‘n shakers that make up the rich and diverse MySQL ecosystem.

read more

Gearing up for the Percona Live: MySQL Conference & Expo!
+0 Vote Up -0Vote Down

Join the SkySQL and MariaDB Crews in Santa Clara and Save on Registration

Percona Live: MySQL Conference and Expo 2013 starts in just 3 weeks, and it’s the premiere event for MySQL users, open-source enthusiasts, and the technology movers ‘n shakers that make up the rich and diverse MySQL ecosystem.

read more

Wide Selection of MySQL DBA Training Events
Employee_Team +1 Vote Up -0Vote Down

MySQL for Database Administrators is the foundation of the authentic MySQL Curriculum. By taking this live 5-day instructor-led course, you find out how MySQL enhancements increase performance, scalability, reliability and manageability of your Web, Cloud and embedded application requirements.

You will learn to:

  • Setup the server and databases
  • Maintain and secure data
  • Configure for performance and high availability
  • Explore real-world problems and discover best practices

You can take this course as a:

  • Live Virtual Event:
  [Read more...]
#DBHangOps 3/27/13!
+0 Vote Up -0Vote Down

Hi everyone!

Here’s a video of this week’s #DBHangOps:

March 27th at 12:00pm PDT (19:00 GMT) is when the next #DBHangOps is gonna go down. Check out the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:


  [Read more...]
#DBHangOps Madness! 3/13/13
+1 Vote Up -0Vote Down

Here’s the recording!

Heyo!

March 13th at 12:00pm PDT (19:00 GMT) is the time to check in and hop online for #DBHangOps this week. Keep an ever watchful eye on the twitter search and hop on the google hangout to contribute some discussion! This week’s topics are:

  • Monitoring
    • What do you consider to be “standard” nagios checks for MySQL
  • Demos of Anemometer and MySQL Enterprise Monitor
  • Daily pain MySQL Bugs and Gotchas (e.g. show table status being cached)
  • MySQL 5.6

See all of ya on the google hangout!

Saving $1,100 Simply by Clicking Faster – Collaborate 13 IOUG Forum Discounts exp. 3/6/2013
+0 Vote Up -0Vote Down
Take 50% Off COLLABORATE 13 Now Through Wednesday But you’ve got to act fast! If you’re not already one of the many joining the IOUG at COLLABORATE 13 – IOUG Forum, sign up today for your chance at attending for … Continue reading →
#DBHangOps 02/27/13
+1 Vote Up -0Vote Down

EDIT: Video from today’s #DBHangOps!

Hey there peeps!

February 27th at 12:00pm PST it is! Check back here for more info and keep a watchful eye on the twitter search (and feel free to join the conversation!). The topics we’re looking to cover this week are:

  • Day-to-day pain points (what takes more time than it should?)
    • rolling restarts and upgrades
    • Performing checksums on your data
      $ /usr/bin/pt-table-checksum \
      --quiet \
      --ignore-databases=mysql,percona,information_schema,per
      formance_schema \
      --lock-wait-time=50 \
      --chunk-size-limit=0 \
      --no-check-plan \
      --no-check-binlog-format \
      --max-lag=1 \
      --replicate percona.checksums \
      h=database.example.com











  [Read more...]
The SkySQL and MariaDB Meetup in Amsterdam - with Monty Widenius, the 'father' of MySQL®
+5 Vote Up -0Vote Down

SkySQL and Monty Program are on the road with our joint Meetup in Amsterdam where Monty Widenius - the origninal creator of MySQL - will unveil his vision of the future of the MySQL database via MariaDB.

Seppo Jaakola from Codership will give a presentation about Galera Cluster for MySQL and MariaDB.

In addition we will have speakers from Booking.com as well as Anders Karlsson from SkySQL who will talk about Big Data.

read more

Meetup SkySQL & MariaDB à Paris en présence de Monty Widenius, créateur de la base de données MySQL®
+2 Vote Up -0Vote Down

Le 27 mars de 14h à 19h à l'Atelier du France, Paris

SkySQL et Monty Program organisent une demie journée de conférences consacrées aux bonnes pratiques et retours d'expériences autour des bases de données MySQL®et MariaDB, l'objectif étant de répondre aux préoccupations actuelles des administrateurs de bases de données.

read more

First steps with MariaDB Global Transaction ID
+8 Vote Up -1Vote Down

My previous writings were mostly teoretical, so I wanted to give a more practical example, showing the actual state of the current code. I also wanted to show how I have tried to make the feature fit well into the existing replication features, without requiring the user to enable lots of options or understand lots of restrictions before being able to use it.

So let us start! We will build the code from lp:~maria-captains/maria/10.0-mdev26, which at the time of writing is at revision knielsen@knielsen-hq.org-20130214134205-403yjqvzva6xk52j.

First, we start a master server on port 3310 and put a bit of data into it:

    server1> use test;

  [Read more...]
The InnoDB Quick Reference Guide is now available
+3 Vote Up -0Vote Down

I’m pleased to announce that my first book, the InnoDB Quick Reference Guide, is now available from Packt Publishing and you can download it by clicking here. It covers the most common topics of InnoDB usage in the enterprise, including: general overview of its use and benefits, detailed explanation of seventeen static variables and seven dynamic variables, load testing methodology, maintenance and monitoring, as well as troubleshooting and useful analytics for the engine. The current version of MySQL ships with InnoDB as the default table engine, so whether you program your MySQL enabled applications with PHP, Python, Perl or otherwise, you’ll likely benefit from this

  [Read more...]
MariaDB, MySQL and Cloud Database resources now available
+3 Vote Up -1Vote Down

Get up-to-date on MariaDB, MySQL, Cloud Databases and SkySQL’s expertise: whitepapers and presentations now available on skysql.com

read more

Serious XFS Performance Regression in Linux Kernel 2.6.32-279
+0 Vote Up -0Vote Down
I'm not the only one to have noticed this, but I spent a sufficient amount of time banging my head against a wall finding this out that I thought it important to make more people aware of this.

While trying to validate new database hardware we were seeing some serious performance issues in production.  Most MySQL benchmarks using sysbench or pt-playback couldn't reproduce it, but a simple sysbench 16 threaded filio test on the mysql partition showed about 1/3 the throughput we would expect.   The fact that much of the hardware was new as well as the OS we were using made tracking down the cause difficult (changing from CentOS 5.5 to Scientific Linux 6.)

Finally some of our ops people working on different systems started noticing similar issues, and they uncovered the XFS issue.  Sure enough -- when took existing hardware,



  [Read more...]
Congratulations on the GA release of MySQL 5.6!
+6 Vote Up -7Vote Down

Tuesday, February 5th was an important day in the MySQL ecosystem due to the release by Oracle of the long-awaited MySQL 5.6 GA. Many MySQL users have been looking forward to this release in order to benefit from the improved performance and scalability. Features such as online operations/schema changes, NoSQL access from memcached to InnoDB, multi threaded-replication and Global Transaction ID significantly improve the competitiveness of MySQL.

read more

#DBHangOps on 1/30/13 \o/
+1 Vote Up -0Vote Down

UPDATE: Here’s the recording, enjoy!

Hello everybody!

#DBHangOps coming at you this week, Wednesday 1/30/12 at 12:00pm PST. Be sure to check out this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.

This week’s topics were:
* bug fixes in recent versions
* Plugins
** authorization plugins (e.g. LDAP)
** audit plugin API — http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html
*** state transitions of records in MySQL with a plugin?
* InnoDB Status variables from twitter — https://github.com/twitter/mysql/wiki/InnoDB-Status-Variables
* Table alters/schema changes
** Twitter patch for non-blocking alter table (throws a different error than









  [Read more...]
MySQL 5.6: What's New in Performance, Scalability, Availability
Employee_Team +8 Vote Up -0Vote Down
With the MySQL 5.6 production-ready GA set for release in the coming days, it’s good to re-cap the key features that make 5.6 the best release of the database ever.  At a glance, MySQL 5.6 is simply a better MySQL with improvements that enhance every functional area of the database kernel, including:
  • Improved Security for worry-free application deployments
  • Better Performance and Scalability
    • Improved InnoDB storage engine for better transactional throughput
    • Improved Optimizer for better query execution times and diagnostics
  • Better Application Availability with Online DDL/Schema changes
  • Better Developer Agility with NoSQL Access with Memcached API to InnoDB
  • Improved Replication for high performance, self-healing distributed deployments
  • Improved

  [Read more...]
#DBHangOps on 01/16/13!
+2 Vote Up -0Vote Down

Update: Recording!

Finally, the end of year madness is over and we’re in a fresh new year. That must mean it’s time to get back into #DBHangops! Tune in on Wednesday, 1/16/13 at 5:00pm PST to get in on the fun and share your experiences.

Check back on this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.

Topics for this weeks hangout include:
* triggers: maintenance, problems, etc.
* Oracle MySQL utilities (similar to Percona toolkit)
** Slideshow of MySQL utilities
* Database caching and cache




  [Read more...]
SkySQL and MariaDB After Work Meetup with Monty Widenius, the "Father of the MySQL® & MariaDB Databases"
+4 Vote Up -2Vote Down

The SkySQL and MariaDB Roadshow comes to Sweden:

Stockholm 7 February 2013, 16:30-19:30, Dramaten Restaurang Pauli

SkySQL and Monty Program are on the road with our joint - free - roadshow in Stockholm where Monty Widenius will unveil his vision of the future of the MySQL database via MariaDB.

In addition, we will have speakers from Codership/Galera, as well as SkySQL experts.

read more

Previous 30 Newer Entries Showing entries 61 to 90 of 593 Next 30 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.