Webinar, Wednesday 5/2 @ 10 am PT/1pm ET
Continuent Tungsten has broken new ground to make previously complex or completely unattainable MySQL data management solutions simple and easy to deploy. Continuent Tungsten brings high availability, performance scaling, and simple cluster management to off-the-shelf MySQL. Continuent Tungsten also includes advanced multi-master topologies that
I personally like PCIe based Flash, but from a pricing point our
customers are looking for cheaper alternatives. SATA SSD is an
options. There is many products based on MLC technology, and
Intel 320 I would say is the most popular. I do not particularly
like its write performance – I wrote about it before, that’s why I am looking for
comparable alternatives. Samsung 830 256GB looked like a good
product, that’s why I decided to test it.
For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and recently I switched to use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load, and second, async mode allows to see maximal possible throughput, it does not show …
[Read more]Database backups are typically critical to organizations, and are an important part of an overall disaster recovery strategy.
MySQL Enterprise Backup performs online "Hot", non-blocking backups of your MySQL databases, and interfaces with media management software such as Symantec NetBackup, Oracle Secure Backup and IBM Tivoli Storage Manager to execute backup and restore operations.
Two new white papers are available to help you better understand:
Enjoy the white papers.
After you have setup and properly configured MySQL Cluster
you typically want to load data into it. There are a couple of
ways to load data into MySQL Cluster, e.g, from dumpfiles or from
csv files.
If you expect loading data into MySQL Cluster will be as fast as
on MyISAM then you have the wrong expectations unless you
parallelize your data loading.
Also, MYISAM/INNODB stores the data in local buffers/disk and in
one copy only (asynchronous replication does not count as it is
asynchronous) whereas MySQL Cluster (NDBCLUSTER engine) stores
two copies of the data. Synchronous replication between the two
copies adds ~ 2x overhead and you have network between mysql
servers and data nodes.
So, to load a dump file into MySQL Cluster is bound to be slower
than MYISAM/INNODB. Also loading data files can be error
prone.
Here is …
It seems the Titanic is everywhere, even inside the pyramid of the Luxor hotel. While the Luxor is within the Mandalay Bay complex, it’s about a half mile walk to the conference and a half mile back. We go by the Mandalay Conference Center’s aquarium. We thought it might be interesting but at $18 an admission, we opted to pass on it. It’s amazing to have an aquarium in the desert, but it’s probably not as nice as the Monterey Bay aquarium.
It was interesting to start the day listening to Rich Niemiec on partitioning tables and using Exadata in Oracle. The NoSQL (Not Only SQL) presentations were interesting, as was the upgrading of Oracle 11gR2 in an E-Business Suite environment presentation. Then, I finished the day with what’s new with the Oracle VM Server.
Checking out the exhibit hall I managed to get a signed copy …
[Read more]
XSLT really relies on XPATH.
To learn XSLT you must learn XPATH.
The most common problem with an xslt document is an XPATH
issue.
The most common XPATH issue is a namespace issue.
Try changing your node references to include *: for
namespace.Another common problem is the xslt engine. Free
engines are crippled to the standard.
I don’t think there is a single good-quality MySQL init script for a Unix-like operating system. On Windows, there is the service facility, and I used to write Windows services. Based on that, I believe Windows has a pretty good claim to better reliability for start/stop services with MySQL.
What’s wrong with the init scripts? Well, let me count the reasons! Wait, I’m out of fingers and toes.
I’ll just mention the two annoying ones that I’ve run into most recently. Both are on Debian, though there is nothing especially broken about Debian’s init scripts. The first one comes from parsing my.cnf wrong and not treating pid-file and pid_file identically. The server treats them identically, thus, so should any other program that reads the my.cnf file (there’s this program called my_print_defaults… use it!). The second bug is because Debian uses two configuration files for start/stop services: the init script reads …
[Read more]Inspired by a post from Juice Analytics.
We are a conflicted people. We love our TV and movie violence but worry that it ruins our children’s minds. We want to reduce healthcare costs, but don’t want to restrict the free market.
Conflicts like these leave little room for a satisfactory answer. Basic principles are in conflict and deeply-rooted desires run up against painful consequences. We
In a previous post on DynamoDB, I told you we were
in the process of migrating to DDB and from MongoDB for our
largest datastore. Now, we have moved a bit further on this and
we, including myself, has pretty positive view on DDB, it really
is a viable MongoDB alternative if you can live with the
limitations. That said, there are many limitations, but I would
like to put this differently. I would say this is an opportunity
to simplify and get real good performance from your base level
data, and combine it with other technologies where
appropriate.
I wouldn't think that any serious application that use a database
could live with DynamoDB only, unless the application developers
were prepared to do just about everything database related,
beyond the most simple, themselves. For example, you might need a
secondary index, DDB doesn't provide you …
MySQL Connector/Net 6.3.9, the latest maintenance release of our
6.3 version series, has been released. Connector/Net is our
all-managed .NET driver for MySQL. This release will be the
last release of our 6.3.x series and contains more than 25 fixes
from the 6.3.8 base. Users looking for additional fixes or
features should upgrade to our most recent version. You can
see the list of changes and read more about the connector
at http://dev.mysql.com/doc/refman/5.5/en/connector-net.html
Version 6.3.9 is appropriate for use with versions of MySQL
5.0-5.5.
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/6.3.html#downloads
and mirror sites (note that not all mirror …
