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:
Thanks to everyone who came. Definitely check out the recording
below!
Heyo everybody!
Coming up this Wednesday, October 2nd, 2013 at 12:00pm pacific (19:00 GMT) is another exciting #DBHangOps. Join the google hangout to discuss:
As you saw on the keynote, we are introducing an integrated
framework for managing farms of MySQL servers with support
for both high-availability and sharding. It should be noted that
this is a very early alpha and that it at this point is not ready
for production use.
MySQL Fabric is an integrated system for managing a collection of
MySQL servers and is the framework on which high-availability and
sharding is built. MySQL Fabric is open-source and is intended to
be extensible, easy to use, and support procedure execution even
in the presence of failure, an execution model we call
resilient execution.
To ensure high-availability, it is necessary to have redundancy
in the system. For database systems, the redundancy traditionally
takes the form of having a primary server acting as a master and
using replication to keep secondaries available to take over in
case the primary fails. This means that the "server" …
Applications should be written taking into account that errors
will eventually happen and, in particular, database application
developers usually consider this while writing their
applications.
Although the concepts required to write such applications are
commonly taught in database courses and to some extent are widely
spread, building a reliable and fault-tolerant database
application is still not an easy task and hides some pitfalls
that we intend to highlight in this post with a set of
suggestions or tips.
In what follows, we consider that the execution flow in a
database application is characterized by two distinct phases:
connection and business logic. In the connection phase, the
application connects to a database, sets up the environment and
passes the control to the business logic phases. In this phase,
it gets inputs from a source, which may be an operator, another
application or a component within the same …