Found 34 bookmarks
Custom sorting
Racker Hacker » MySQLTuner v0.9.1
Racker Hacker » MySQLTuner v0.9.1
MySQLTuner is a high-performance MySQL tuning script written in perl that will provide you with a snapshot of a MySQL server’s health. Based on the statistics gathered, specific recommendations will be provided that will increase a MySQL server’s efficiency and performance. The script gives you automated MySQL tuning that is on the level of what you would receive from a MySQL DBA.
Racker Hacker » MySQLTuner v0.9.1
Tungsten Replicator
Tungsten Replicator

The Tungsten Replicator implements open source database-neutral master/slave replication. Master/slave replication is a highly flexible technology that can solve a wide variety of problems including the following:

* Availability - Failing over to a slave database if your master database dies
* Performance Scaling - Spreading reads across many copies of data
* Cross-Site Clustering - Maintaining active database replicas across WANs 
* Change Data Capture - Extracting changes to load data warehouses or update other systems
* Zero Downtime Upgrade - Performing upgrades on a slave server which then becomes the master
Tungsten Replicator
freshmeat.net: Project details for dbkiss
freshmeat.net: Project details for dbkiss
dbkiss is a one-file database browser that is easy to upload and use. It supports MySQL and PostgreSQL and features import/export of data, searching of the whole database or single tables, an advanced SQL editor, saving of templates, multi-query execution with pagination, and more.
freshmeat.net: Project details for dbkiss
Maatkit Now Supports Memcached | MySQL Performance Blog
Maatkit Now Supports Memcached | MySQL Performance Blog

Have you ever wondered how optimized your Memcached installation is? There is a common misconception that one doesn't have to think too deeply about Memcached performance, but that is not true. If your setup is inefficient, you could:

* Burn Memory
* Waste Network Round-Trips
* Store Keys That Never Get Retrieved
* Have a Low Cache Hit Ratio (i.e. query MySQL too much)
* Suffer a fate too horrible to contemplate.

Percona does a lot of consulting around Memcached, so we try to take a quantitative, scientific approach to measuring memcached performance, just like everything else we do.

Maatkit Now Supports Memcached | MySQL Performance Blog
DBMonster - The dbMonster home page - About
DBMonster - The dbMonster home page - About
dbMonster is a tool which helps database application developers with tuning the structure of the database, tuning the usage of indexes, and testing the application performance under heavy database load. dbMonster generates as much random test data as you wish and puts it into SQL database. It provides a very pluggable interface and is trivial to use. dbMonster is written in Java.
DBMonster - The dbMonster home page - About
LiquiBase Database Change Management: home
LiquiBase Database Change Management: home
You never develop code without version control, why do you develop your database without it?\nLiquiBase is an open source (LGPL), database-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes are stored in a human readable yet trackable form and checked into source control.
LiquiBase Database Change Management: home
The Apache Cassandra Project
The Apache Cassandra Project

The Apache Cassandra Project develops a highly scalable second-generation distributed database, bringing together Dynamo's fully distributed design and Bigtable's ColumnFamily-based data model.

Cassandra was open sourced by Facebook in 2008, where it was designed by Avinash Lakshman (one of the authors of Dynamo) and Prashant Malik. In a lot of ways you can think of Cassandra as Dynamo 2.0. Cassandra is in production use at Rackspace, Digg, and a number of other companies, but is still under heavy development.

The Apache Cassandra Project
Home - stalkr - GitHub
Home - stalkr - GitHub

Stalkr is a data persistence library. Stalkr enables your PHP web application to interact with database servers in a fully object-oriented pattern. No more messy SQL, no more nasty injection attacks!

This type of library is usually called an object-relational mapper, or ORM for short. However, Stalkr is different from your typical ORM. In addition to the usual “mapping” between PHP objects and SQL rows, Stalkr also boasts a wealth of scalability-friendly features, such as:

Exclusive features (of sorts: see the Yet Another ORM!? wiki page for more information)

Automatic and transparent integration with Memcached (drivers included!) Support for key-value stores, with built-in consistent hashing and redundancy (now with Redis support!) Seamless utilization of multiple clusters of potentially different database software Unique access control mechanism for additional security

Home - stalkr - GitHub
Gemini Mobile Technologies
Gemini Mobile Technologies

Hibari is a distributed, non-relational database management system (distributed non-RDBMS) based on distributed key value store technology, implemented by Gemini Mobile Technologies, it inherits important characteristics of both the distributed non-RDBMS world and of Gemini's HyperScale® Platform.

Hibari has the following characteristics to flexibly support growing volumes of data in cloud computing space. Economic system build-up using commodity hardware Flexible, high scalability High performance and availability by consistent hashing across multiple machines High fault-tolerance by chain replication across multiple machines Safety without a single point of failure (SPOF)

Gemini Mobile Technologies
The Kumofs Project
The Kumofs Project

Kumofs is a simple and fast distributed key-value store. You can use a memcached client library to set, get, CAS or delete values from/into kumofs. Backend storage is Tokyo Cabinet and it will give you great performance. Data is partitioned and replicated over multiple servers. Extreme single node performance; comparable with memcached. Both read and write performance got improved as servers added. Servers can be added without stopping the system. Servers can be added without modifying any configuration files. The system does not stop even if one or two servers crashed. The system does not stop to recover crashed servers. Automatic rebalancing support with a consistency control algorithm. Safe CAS operation support. memcached protocol support. Kumofs is used at Nico Nico douga (Wikipedia), the most popular video sharing service in Japan.

The Kumofs Project
redisql - Project Hosting on Google Code
redisql - Project Hosting on Google Code

Redisql is a lightweight SQL server AND Redisql is built on top of the NOSQL datastore redis, supports redis data-structures and redis commands and supports (de)normalisation of these data structures (lists,sets,hash-tables) to/from SQL tables. Redisql can also easily import/export tables to/from Mysql for Data-warehousing. Redisql is not only a data storage Swiss Army Knife, it is also extremely fast and extremely memory efficient.

Speed is achieved by being an event driven network server that stores ALL data in RAM and achieves disk persistence by using a spare cpu-core to periodically log data changes (i.e. no threads, no locks, no undo-logs, serving data over a network at RAM speed) Storage data structures w/ very low memory overhead and data compression, via algorithms w/ insignificant performance hits, greatly increase the amount of data you can fit in RAM Your hard disk's swap is utilised when your data can no longer fit in RAM. In this mode, performance is not negatively effected, if rarely-used data sits idle in swap. Redisql can use 100% of your RAM for storage and still provide disk persistence. Optimising to the SQL statements most commonly used in OLTP workloads yields a lightweight SQL server designed for low latency at high concurrency (i.e. mindblowing speed).

redisql - Project Hosting on Google Code
How Twitter Uses NoSQL - ReadWriteCloud
How Twitter Uses NoSQL - ReadWriteCloud
Weil is quick to point out that Twitter is heavily dependent on MySQL. However, Twitter does employ NoSQL solutions for many purposes for which MySQL isn't ideal. According to Weil, Twitter users generate 12 terrabytes of data a day - about four petabytes per year. And that amount is multiplying every year. Read on for our notes on Weil's talk.
How Twitter Uses NoSQL - ReadWriteCloud
Holland Backup Project | Backed the #$%& Up!
Holland Backup Project | Backed the #$%& Up!

Holland is an Open Source backup framework originally developed at Rackspace and written in Python. Its goal is to help facilitate backing up databases with greater configurability, consistency, and ease. Holland is capable of backing up other types of data, too. Because of its plugin structure, Holland can be used to backup anything you want by whatever means you want. Notable Features Pluggable FrameworkSupports Multiple Backup SetsDatabase and Table Filtering (Using GLOBs)Auto-Detection of Transactional DBsSafe use of –single-transaction with mysqldumpIn-Line and Pluggable CompressionBackups Suitable for Point-In-Time Recovery / ReplicationMySQL + LVM Snapshot and Logical BackupsPostgreSQL backups using pgdump

Holland Backup Project | Backed the #$%& Up!
Orchestrate
Orchestrate

"Orchestrate unifies multiple databases through one simple REST API. Orchestrate runs as a service and supports queries like full-text search, events, graph, and key/value.

Orchestrate handles security, monitoring, backups, and replication. There are no licenses to buy, no software to download, no hidden costs, and no lock-in."

Orchestrate
mariadb-corporation/MaxScale at release-1.0GA
mariadb-corporation/MaxScale at release-1.0GA

The MariaDB Corporation MaxScale is an intelligent proxy that allows forwarding of database statements to one or more database servers using complex rules, a semantic understanding of the database statements and the roles of the various servers within the backend cluster of databases.

MaxScale is designed to provide load balancing and high availability functionality transparently to the applications. In addition it provides a highly scalable and flexibile architecture, with plugin components to support different protocols and routing decissions.

mariadb-corporation/MaxScale at release-1.0GA