…; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments… When we add additional node to a cluster (e.g. XtraDB Cluster), how does it affect the response …the server. For example, the famous problem with DROP TABLE performance. Does DROP TABLE, running in…
Page: Consulting for MySQL
July 31, 2006 By
… clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL Upgrades, Backup…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… XtraBackup to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following problems: A Real High Availability… setup three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers great performance. What…problem in MySQL is lack of advanced join methods at this point (the work is on a way) – MySQL… In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… all performance problems, with magically means nobody knows how exactly. I would suggest always to question yourself where do you expect these performance… using SAN based active-passive clusters for availability purposes and they look to do the same with MySQL. This works though I…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… far from being only problem. There are fair amount of issues with MyISAM and generally on MySQL level which needs to be… use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not get where quite yet having very particular performance properties…
Post: NDB API examples, the trivia to make ndbapi_scan works!
November 15, 2009 By 4 Comments
… API. Once, a customer asked an example on how to perform a simple scan. Remembering that some examples are within the…/local/mysql-cluster-gpl-7.0.8a/lib/mysql ./ndbapi_scan /usr/local/mysql-cluster-gpl-7.0.8a/mysql.sock 127.0.0.1 MySQL Cluster already… the problem is isn’t it? Let’s remove the recursive “create_table” call. 3. Success $ LD_LIBRARY_PATH=/usr/local/mysql-cluster…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… new IP. What the problem with a new IP? Just change the IP in the cluster config and perform an rolling restart! no? In fact this will not work, since the cluster is already in… the hostname like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname=mgmn1…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… second response requirements). Note you will have to solve this problem even if it is relatively rare case and in most…. MySQL Cluster at this point is a cluster in terms of Storage – only minor aspects such as data filtering can be offloaded and performed… to be performed on the SQL node. May be MySQL Cluster will evolve and data storage nodes will be able to perform all kinds…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly not enough to solve all performance problems… From MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL …
