Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #198 is generously published by Sam DeFilippis, who manages Oracle Notes blogs, with latest postings on Oracle GoldenGate.
As always, if you’d like to host your own issue of
Log Buffer, simply reach out to the
Log Buffer coordinator.
Please enjoy Sam’s issue …
If you like to keep your ddl backed up in some source management tool like svn or cvs and want to do it individually for stored procedures, events, triggers, tables and such rather than having a single file you can easily do so using the below. You could even include the –skip-dump-date or –skip-comments and use the below to compare ddl daily checking for alterations thus making sure you are aware of any ddl changes done on the database.
user=backup_user
password=`cat ~/.backup_password`
hostname=127.0.0.1
port=3306
dbname=test_db
path=/home/mysql/ddl
date=`date +%Y%m%d`
mysqldump -u$user -p$password -h$hostname -P$port
--no-create-info --no-data --no-create-db --skip-opt $dbname >
"$path"/"$dbname"_triggers_"$date".sql
mysqldump -u$user -p$password -h$hostname -P$port --routines
--skip-triggers --no-create-info --no-data --no-create-db
--skip-opt $dbname > …
Firstly, if you have not yet seen the Session Schedule for OpenSQLCamp 2010 Germany, take a look -- great work Lenz! I am sad that I will be missing it on Aug 21-22nd.
However, this post is mostly about OpenSQLCamp Boston, which I am planning. I am working on a good hotel room rate -- hotel rooms in the Boston area are pricey, and I'm trying to work out something at $159 per night or lower. I will let you know if that happens, otherwise we will probably be on our own for hotel rooms.
Within a few hours my post Installing Mediawiki on Oracle Enterprise Linux LAMP stack got 5 negative votes.
Wow, I’d be glad if these people could felt so passionately about all the other CRUD on Planet MySQL that has ZERO to do actually do with MySQL.
Using a LAMP product, and providing instructions for operation can’t be a negative voting offense. So it can only be the words “Oracle Enterprise Linux”.
For those negative people out there that care enough to physically mark blogs let me share some facts with you. RedHat Enterprise Linux (RHEL) is the most widely used and support platform for production MySQL environments. CentOS and Oracle Enterprise Linux (OEL) provide via the freedom of Open Source, their own offerings of RHEL with various other features including …
[Read more]A company wiki can be easily configured in under 10 minutes using Mediawiki the open source LAMP software that powers the top 10 website Wikipedia.
A company wiki is an ideal means for a centralized and user contributed documentation system. The following steps show you how to download, configure and get your Mediawiki site operational.
Software Pre-Requisites
[Read more]Even though Data warehouse is picking very rapidly in the last year or so, but few companies who are already made a right mark in the right time could not[...]
The notion "eventual consistency" is bogus to me, in my mind,
either it's consistent or it is not. Full stop. Which is not to
say that consistency is always a requirement, there are many
cases where you can do without it. But do not think that
"eventual consistency" is a kind of "relaxed consistency", rather
it is a lack of consistency.
Look, any kind of distributed system could claim to have
"eventual consistency", in the meaning that at some point, things
will be consistent. Eventual consistency does not mean that we
know when things will be consistent at some known point in time.
Frankly, not even if all the involved servers in a distributed
system claiming "eventual consistency" would stop at the same
time, would the data be consistent. But there is a way o achieve
consistency: If all the application transactions running were
allowed to stop in a controlled manner, and all operations are
then stopped, then data should, I guess, be …
Any time you can get two for the price of one (a “2Fer”), you’re
ahead of the game. By implementing our shared cache as a separate
tier, you get (1) improved performance and (2) storage
flexibility…a 2Fer.
What do I mean by storage flexibility? It means you can use
enterprise storage, cloud storage or PC-based storage. Other
shared-disk cluster databases require high-end enterprise storage
like a NAS or SAN. This requirement was driven by the need
for:
1. High-performance storage
2. Highly available storage
3. Multi-attach, or sharing data from a single volume of LUN
across multiple nodes in the cluster.
Quite simply, you won’t see other shared-disk clustering
databases using cloud storage or PC-based storage. However, the
vast majority of MySQL users rely on PC-based storage, and most
are not willing to pay the big bucks for high-end storage.
ScaleDB’s Cache …
Getting closer to some serious MySQL Cluster NDB API development on Windows, we still need a decent development environment, and as for myself, I like the ability to have a self-contained environment for this, at least contained within one computer, so that I can develop when on the road. So this means I have to use Windows as a Server anyway, right, if I am developing Windows applications? Well, not necessarily, there is always the option of using a VM, such as VirtualBox or something. But I really do prefer to use the native Windows environment for this, which has a few issues.
As I have said before, I do prefer Linux / Unix as a Server platform. But in this case, Windows will only be a development server, which is different. And if you want to use Windows as a production server, well as I have said before, that is fine too, although not my cup of tea,
But running MySQL Cluster on Windows as of version 7.1.4b of MySQL Cluster is …
[Read more]The bug I talked about a little while ago has now also had the fix I wrote committed to the mysql-trunk 5.5.6-m3 repository.
[Read more]