…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult… not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than… the discussion to topics such as monitoring, alerting, backups, caching, reverse proxies, and high availability solutions, all of which we can frequently…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual,…versionblogpercona.commanual proxy_userblogpercona….cache_hitsblogpercona.commanual Ssl_session_cache_missesblogpercona.commanual Ssl_session_cache_modeblogpercona.commanual Ssl_session_cache_overflowsblogpercona.commanual Ssl_session_cache_sizeblogpercona.commanual Ssl_session_cache…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… these things few things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly…. There were a lot of custom technologies created for caching or scalability issues MySQL could not solve well. There are inhouse and… MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL Proxy to…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the… nothing else. The problem is that the passive server’s caches start to get skewed to handle the write workload from… have to be the tools I used — it could be MySQL Proxy or a TCP sniffer or anything else. But if you…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…: Hello, was there any good experiences with MySQL Proxy (RW-splitting)? A: Most solutions with MySQL Proxy I see have stern disclaimers against using… production. Even the official manual page for MySQL Proxy 0.8.2 still says: “MySQL Proxy is currently an Alpha release and should not… you compare / contrast this approach with using a write-through cache? A: The InnoDB buffer pool is effectively a type of…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
….com/supportingmysql/entry/server_defaults_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/refman/5.6/en/server… desirable at high connection rates. max_connections was the best proxy we had for expected high connection rates when dynamically configuring… this at https://blogs.oracle.com/supportingmysql/entry/mysql_server_5_6_default . thread_cache_size is quite low, and dynamic based…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… MySQL driven web site its properties will likely depend on a lot of factors – good web side configuration, which is about caching, proxying… available, secure and fault tolerant. Caching in particular as memcache plays important role here besides MySQL though quite typical you also would…
Comment: Thoughts on MySQL Replication
July 16, 2006 By 18 Comments
James, You’re right. DRBD makes great addition to MySQL replication, however it is not alternative if you’re also … availability. Partitioning on read workload is good way to increase cache efficiency. In Wikipedia case it is not hard as languages… it comming from anonymous users which can be served by caching proxies not even hitting web servers. Language provide very good partitioning…
Comment: Announcing PAM authentication plugin for MySQL (early access release)
December 5, 2011 By 9 Comments
…PAM authentication plug-in (hopefully implementing the proxy users authentication plug-in feature), real … love virtual (indexable) columns, segmented key cache, and other MariaDB goodies, but really…the rocking performance and flexibility of the MySQL platform. [Please no flaming – PostgreSQL rocks…
