… need a Java driver for your database — I’m using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file….10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool…. Moreover, the vCache software is built in to the Virident driver, so there is no additional module to install. FlashCache, on… a separate kernel module in addition to whatever flash memory driver you’ve already had to install, and then further configuration…
Comment: Converting Character Sets
April 9, 2013 By 22 Comments
I get a whole bunch of these when I run the script on windows: DBD::mysql::db quote failed: handle 2 is owned by thread cb0f8 not current thread 4fc00b8 (handles can’t be shared between threads and your driver may need a CLONE method added) at convert_charset.pl line 281, line 1.
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here… the team (Georg, Andrey etc) which will be developing this driver during my visit to Open Source Database Conference in November… load balancing and fall back by itself, similar as JDBC driver does. Client size caching Would be very helpful for simple…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…area for the sake of compatibility with drivers and applications throughout a release lifetime, …MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… new asynchronous call to send a query to MySQL using a new MySQLnd driver for PHP. In this post I’ll only… a query to MySQL, and we do not wait for result but rather get response later. The MySQLnd driver has been available… conclusion, we see that using PHP with MySQLnd drivers we can execute 5 MySQL asynchronous queries in parallel against 5 different nodes…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock prepare [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… in PDF For tests we used tpcc-mysql package, which generates TPCC-like workload on MySQL systems. Server hardware: Dell PowerEdge R815 Storage: Fusion-io ioDrive Duo 640GB MLC. Fusion-io driver version: 2… from your MySQL setup Recently Fusion-io announced new ioDrive2 card with new driver, which promises even better performance for MySQL. I am…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
…. First I think MongoDB is best compared no to MySQL Server but MySQL Cluster, especially in newer versions which implement “sharding”. Same… happens – same with NDB (native API) it is handled on driver level. When you connect to replication set you connect to… server not one of them and if one server fails driver fails over to different master. Things are again tuned to…
