MySQL
Get flash to fully experience Pearltrees
The main goal of the vitess project is to provide servers and tools to facilitate scaling of MySQL databases for the web. The Project Goals page has more details on this. Vtocc is the first usable product of vitess. It acts as a front-end to MySQL providing an RPC interface that accepts and transmits SQL commands.
vitess - Scaling MySQL databases for the web - Google Project Hosting
3 Biggest MySQL Migration Surprises | Architects Zone
We Recommend These Resources Once a development or operations team gets over the hurdle of open-source, and start to feel comfortable with the way software works outside of the enterprise world, they will likely start to settle in and feel comfortable. Fear not, there are more surprises hiding around the corner. Here are a few of the biggest ones. 1.
Incorrect string value
MySQL Limitations Part 1: Single-Threaded Replication | Architects Zone
We Recommend These Resources I recently mentioned a few of the big “non-starter” limitations Postgres has overcome for specific use cases. I decided to write a series of blog posts on MySQL’s unsolved severe limitations.
Audit Your MySQL Memory Usage » The Planet Blog
We can't seem to find the content you're looking for. It's probably a mistake on our end, so don't feel too discouraged. If you absolutely need to find whatever content you thought you'd find here, leave us a comment on the first SoftLayer Blog entry you can access.
We Recommend These Resources While other Sun projects such as OpenSolaris and OpenOffice.org were driven to make forks (Illumos and LibreOffice respectively) under Oracle's new leadership style, MySQL forks are not in the same position. Oracle seems to be relatively committed to the MySQL community, but this hasn't stopped older forks from moving forward. One fork of MySQL that was started over three years ago is just now reaching beta quality according to the developers.
MySQL Fork "Drizzle" Shows Signs of Life | Web Builder Zone
MySQL is Not ACID Compliant « myNoSQL
This is becoming a “ trend “: That’s because you are basically taking your data and vomiting it on the hard drive without any consideration as to if your data you are writing is sensible or simply dreamed up by magic pixies.
I have very strange exceptions, using JDBC-client, UTF-8 for both parties, and LONGTEXT field: 2007-05-22 21:53:16,849 [eshop.macsales.com ] ERROR org.tokenizer.fetcher.FetcherThread - http://eshop.macsales.com/OSXCenter/XPostFacto/Archive/XPostFacto3.1a3.sitx org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [update web_resource set url_actual=?
error code [1366]; Incorrect string value: '\xF4\x80\x80\xB9Bu...'
Profiling
MySql deadlocks
MySql tmp tables
Replication
The majority of Open Source applications utilizing a database backend are programmed only for the most common and easy to use RDBMS -- MySQL . Unfortunately, MySQL doesn't offer nearly any of the benefits of a serious database management system, and therefore it's often disgarded when selecting corporate database backends. Selecting something else than MySQL means you exclude many of the fine Open Source applications out there from your corporate (or other) infrastructure -- or then not. Some time ago I wrote a patch to enable an Open Source wiki application to be used with PostgreSQL . Converting MySQL-only software to use some other backend is not hard -- it merely takes a bit of digging to find out how MySQL is not compatible with the SQL standard and how the "tweaks" in MySQL are achieved with SQL-conforming database management systems.
Converting MySQL database to Postgresql
