Users are complaining about slowness in your system, MySQL load is always high… The more your database has access, the more it may get slow or worse: slowness even if it is running with low load. You are starting to get desperate! The consequences of slowness and high load are disastrous: If your site is slow,... Read More
The post MySQL Performance and Tuning Best Practices appeared first on Devops for Dummies.
November 4, 2013 By Severalnines Percona Live London MySQL Conference - 11-12th November, 2013
We’re particularly excited about this year’s Percona Live London MySQL Conference. The line-up of speakers & topics looks excellent and it’s good to see speakers from Oracle, Percona, the MariaDB Foundation (amongst others) scheduled at the same event. It demonstrates not just the diversity of the ever broadening MySQL ecosystem, but also the fact that there really is room for everyone to contribute, participate in and advance MySQL in manifold directions while still retaining a certain amount of uniformity.
And this is how we will be contributing to the event ...
Talk - MySQL Cluster Performance Tuning By Johan Andersson, CTO & Co-Founder, Severalnines
Correct tuning of MySQL NDB Cluster can have dramatic impact on …
[Read more]Installing MySQL Database on Ubuntu or CentOS is a trivial operation as long as they have nice package managers as Aptitute and YUM. Otherwise, in Mac OS X is a hard operation from downloading the correct package, apllying with several steps and it can break the whole install, if you But, with Homebrew, the install... Read More
The post Installing MySQL on Mac OS X easily appeared first on Devops for Dummies.
If you install a MySQL Database Server with the default options, your data are insecure and your server is in risk of invasion and some performance issues will appear shortly. With some best practices, your MySQL database becomes secure and the performance goes well. 1 – Set root password and change its login name As... Read More
The post MySQL Security Best Practices appeared first on Devops for Dummies.
There is a new release of the Connector/Arduino on Launchpad! See
https://launchpad.net/mysql-arduino. The new version supports a
number of refinements and a few new features. These
include:
So What is It?
If you have never heard of Connector/Arduino, it is simply a
library designed to allow the Arduino platform to connect to and
issue queries to a MySQL Database server.
Simply add an Ethernet shield to your Arduino and use the library
to connect your Arduino to a MySQL database server. Yes, no more
web-based hand waving or third party systems! Cool.
New …
When you have a MySQL server in production, backups are necessary to protect your data against any problem that may occur with your server. To make the backup and to restore the data, Exporting to a dump file The operation of export is also called dumping. To carry out the exporting, use the command msyqldump […]
Due to the growing popularity of Connector/Arduino, the moderator
of MySQL Forums has created a forum for us to meet up and discuss
the connector. Yippie!
http://forums.mysql.com/list.php?175
While the forum has been started very recently, I expect it will
grow quickly as people discover the connector for the first time
and experienced users find new and interesting ways to use it. I
hope to moderate the new forum periodically to answer questions
and respond to posts. See you there!
Note: you need an account to write to the forum. Click on
"register" in the upper right hand corner of the forum page to
create an account if you do not already have one.
MySQL is one of the most famous Open Source Relational Database Management System (RDBMS) created by Michael Widenius. Default choice in systems as WordPress and used by top companies as Google and Wikipedia. Due its simplicity and large community, it is largely used by developers and webmasters around the world. MySQL is under dual license: […]
MySQL Connect Conference was a great success and I am really
happy for being
able to attend it this year. Oracle showed interesting
improvements and
exciting features in the upcoming MySQL 5.7 and released a very
early alpha
version of MySQL Fabric which is a framework for managing farms
of MySQL
servers.
You can find the presentations about MySQL Fabric on
SlideShare:
. MySQL Sharding: Tools and Best Practices for
Horizontal Scaling
. MySQL High Availability: Managing Farms of
Distributed Servers
If you haven't watched yet Edward Screven and Tomas Ulin keynote
on “The State
of the Dolphin”, please, click on the following …
Going to MySQL Connect was truly a blast. We got a lot of good
questions and feedback in the sessions and there were a lot of
interest in both MySQL Fabric and the MySQL Applier for
Hadoop.
A big thank you to all that attended the talks, I got a lot of
good questions and comments that will help us build good
solutions.
The talks are available on SlideShare: