Feed Aggregator
Pittfalls with Federated Tables
A Federated Table is a table which points to a table in an other MySQL database instance (mostly on an other server). It can be seen as a view to this remote database table. Other RDBMS have similar concepts for example database links.
Read more about the pittfalls with MySQL Federated Tables…
Taxonomy upgrade extras: english, pittfalls, federated tables, federated storage engine,
Categories:
Some more MySQL tools added
We have added some more tools to our MySQL consulting tools collection.
Taxonomy upgrade extras: mysql, tool, consulting, tools, mysql-consulting,
Categories:
Some more benchmarks added
We have added some more database benchmarks to our collection.
More details you can find on our Benchmarking page.
Taxonomy upgrade extras: english, mysql, benchmark, tool,
Categories:
MySQL storage engines
One of the big advantages of MySQL is its concept of pluggable Storage Engines (SE). This means you can choose the most optimal storage engine for your needs. This also has a disadvantage: You have to know what you are doing…
More details you can find here: MySQL pluggable Storage Engines (SE).
Taxonomy upgrade extras: english, mysql, storage engine,
Categories:
Full-Text Search Engines
MySQL has also a Full-Text Search Engine built in. But this Search Engine is not as fast a you probably want to. Thus there are some alternative Full-Text Search Engines which might be working together with MySQL.
- MySQL/MyISAM Full-Text Search
- Sphinx Search
- Lucene
- MnogoSearch
- Solr (based on Lucene)
- Omikron Fact-Finder
- Ioda
- Kneobase (based on Lucene)
- Egothor
- Xapian
More information
Who uses what Full-Text Search Engine
- 2010-10-06: Twitter goes to Lucene
- Wikimedia uses Lucene
Taxonomy upgrade extras: english, full-text, search, engine, sphinx, lucene,
Categories:
Stealthy migrating MySQL tables and MySQL data access interfaces using enlarged updateable VIEW functionality
Applications occasionally require redesign. However, redesigning an application cannot be done in one step because the application is distributed or several versions of applications must be supported. MySQL 5.0 provides the necessary means to stealthy migrate your data. In a short overview let’s look at what we plan to do: Stealthy Migration (PDF 98.7 kByte).
Taxonomy upgrade extras: english, mysql, migration, table, data, access, interface, view,
Categories:
Pages
