June 18, 2013

Page: Consulting for MySQL

architecture which matches your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL

Post: Commodity Hardware, Commodity Software and Commodity People

… post I mentioned not all architectures and solutions work for Commodity People, and people… claim they are in Commodity Software or Hardware business but few would probably mention they … be great MySQL Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster but have …

Post: Return of the Query Cache, win a Percona Live ticket

… are some other query cache improvements in MySQL 5.5 as well, but on big hardware with a write-heavy workload that… Cluster to InnoDB Architecture and Performance Optimization. These detailed presentations will give you the hands-on experience you need to take your MySQL

Post: When would you use SAN with MySQL ?

… using SAN based active-passive clusters for availability purposes and they look to do the same with MySQL. This works though I… always in my HA architectures it is a single “point” which can experience “failure”. Note even if hardware fully redundant the Firmware… really had it) Even if you do not run any “Cluster” having SAN you can always “connect” the storage to another…

Post: Paul McCullagh answers your questions about PBXT

…  However, PBXT’s log-based architecture makes performance characteristics different … the MySQL Backup API which was originally implemented in MySQL 6.0… contributed to this decision: Supporting clustered indexes would have made … maximum performance from the hardware. This work is ongoing. Morgan…

Post: KISS KISS KISS

… do just fine with single “cluster” even on the current hardware for several years. Replication Optimization…with high availability is the more complex architectures and processes you use for high availability… Google guys tells us single MySQL server on a good hardware has MTBF somewhere between 1000…

Comment: Finding your MySQL High-Availability solution – The questions

… the cost of the solution in term of hardware. Usually, people think NDB is very expensive compared… engagements and… I am not cluster certifified. 2.6 It depends on your architecture. Most of the time,…you use SSL between your application servers and your MySQL servers? 2.9 Good point and yes, this…