On Monday I will deliver with Seppo Jaakola from Codership a tutorial on Percona XtraDB Cluster (Percona Server + Galera).
Already in London and you don’t know how to consume the hotel’s bandwidth ? If you attend this tutorial, you can download the Virtual Box appliance we will use during the session.
Two versions are available:
How to test them:
From Movember to UKOUG, Pythian is stomping the grounds with massive thuds. This Log Buffer #297 collects various great blog posts from across the database world once again. Enjoy the Log Buffer Editions. Oracle: Andre Araujo posts about the union of MoBros, all of them DBAs :) Are you in UK and got penchant for...
Here is the typical “Big” data architecture, that covers most components involved in the data pipeline. More or less, we have the same architecture in production in number of places[...]
I was tired to get manually disk space used for all MySQL databases, I just created a stored procedure to get an overview of the database sizes in our MySQL server.
MySQL don’t have a command that allows us an overall summary of the databases, something like SHOW TABLE STATUS for databases. The “SHOW DATABASES” command lists only the current databases without any other information like how many space are using or how many tables there are, etc.
The procedure that I wrote this based on INFORMATION_SCHEMA database, which contains rich information of all existing databases.
I suggest, in a previous post, place all these procedures in a database called tools, but you can still choose different location.
So when call the procedure will have a global view of information that will be useful for maintenance tasks.
mysql> call tools.sp_overview(); …[Read more]
You may have noticed that I stopped posting the “weekly news”
from the Mozilla DB Team. After going through the Operations Report
Card and applying it to DBAs in OurSQL Podcast numbers
111,
112,
114,
115 and
116, I
started thinking that the updates were really more like metrics,
and it would better serve my own purposes better to do the
updates monthly.
The purposes of doing this type of blog post are:
0) Answering “So what does a DBA do, anyway?”
1) Answering “DBA? At Mozilla? Does Firefox have a database? Why
does Mozilla have databases, and what …
You may have noticed that I stopped posting the “weekly news” from the Mozilla DB Team. After going through the Operations Report Card and applying it to DBAs in OurSQL Podcast numbers 111, 112, 114, 115 and 116, I started thinking that the updates were really more like metrics, and it would better serve my own purposes better to do the updates monthly.
The purposes of doing this type of blog post are:
0) Answering “So what does a DBA do, anyway?”
1) Answering “DBA? At Mozilla? Does Firefox have a database? Why
does Mozilla have databases, and what …
If you’re like me and are a DBA in the UK with a penchant for MySQL or Oracle, you’ll know we have a smörgåsbord of conferences here next week. We’ve been waiting, and like buses two have come at once. We have the UK Oracle User Group Conference 2012, in Birmingham on 3rd – 5th [...]
I was looking around on the MySQL forums when I ran across this post and it got me thinking. First, thank you
to Scott for helping in the community forum. But also about
how some still have issues with MySQL user authentication. So I
thought I would put together a simple quick post about MySQL user
authentication.
The forum post I mentioned above talks about user connection
issues and how a user "is likely the record that is getting
used by MySQL."
Well, lets review a simple example to ensure that we always will
know what user is being authenticated by MySQL.
First we build out a few options for users.
CREATE USER 'foo'@'localhost' IDENTIFIED BY 'some_pass';
CREATE USER '%'@'localhost' IDENTIFIED BY 'some_pass';
…
This week we go over stored routine basics. Ear Candy is linux.die.net, online man pages for Linux, and At the Movies is key things that DBA need to know.
News
Open Source DBA's Holiday Gifts for MySQL DBAs
- check out the CafePress link, many are positively funny.
Events
Oracle is having free Tech Tours for MySQL in Dublin, San Diego, …
This Friday we’ll have two polls instead of one to learn about Operating system we’re using to run MySQL. First Poll is about production use and second is about development. I know many developers would run MySQL on Linux in Production but use Windows or MacOS X for development. Please select operating system which actually runs your MySQL Server not the base operating system. if you’re running Virtualized Linux on your Windows please select Linux as OS used for development. So
Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.
Thank you for Participating!