Showing entries 23016 to 23025 of 44118
« 10 Newer Entries | 10 Older Entries »
Want DRBD in RHEL 6? Make yourself heard!

The folks over at Red Hat were kind enough to make public bug 585309, an enhancement request to include DRBD in RHEL 6. If you want DRBD on the last major platform that doesn’t include it yet, feel free to comment and make your voice heard!

A valid login on the Red Hat Bugzilla system is required to comment. Don’t have an account? Create one!


[Read more]
MySQLDump from A to B with pipes

Moving your data and tables around comes in many different flavours. The use of mysqldump is common practice to dump your data and schema out to a file. It is also possible to pipe your mysqldump into a 2nd server. Try the code below (adapting the users and passwords!) in a test environment;
$ mysqldump -u UserA -p p455w0rd --single-transaction --all-databases --host=Server1 | mysql -u UserA -p p455w0rd --host=Server2
As you can see from the command we are taking all the databases in a single transaction into Server2 from Server1. If you're not using transactional tables substitute the --single-transaction for --lock-all-tables to ensure you get a consistent copy.

Remember; You must be able to see the 'other' server over the network and there must be permissions set for remote access from your feeding Server. For large databases this technique may not be suitable because of the performance restrictions surrounding …

[Read more]
MySQL track with free event at Kaleidoscope 2010

The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. The great news this year is that, at popular demand, there will be a MySQL track, organized and manned by the MySQL community.

The even greater news is that, in addition to the general schedule, there are SUNDOWN SESSIONS

Monday, June 28, 5:45 p.m. – 6:45 p.m. (reception immediately following)

Join us on Monday, June 28 for a lively open discussion with Oracle MySQL ACE Directors. In addition to a specific session on MySQL, other Sundown Sessions will address: Middle Tier and Client-Side Development, Database …

[Read more]
InfiniDB performance with AWS - EC2

Recently, we walked through a short list of instructions to get InfiniDB up and running on Amazon Web Services.  Performance falls nicely in line with previous metrics:


Here we see relative performance of an AWS m1.xlarge instance running 4 cores with 15 GB of memory against a Dell 1950 here at Calpont running 4 cores and 16 GB of memory.  The disk infrastruct...

MySQL Query Engine Scalability Issues

Lately in the MySQL community, we only hear about scalability or performance improvements of storage engines, but nothing about query engine itself. For example, one classic example being InnoDB; if[...]

Review: MySQL Admin Cookbook

MySQL Admin Cookbook from Packt Publishing, authored by Daniel Schneller & Udo Schwedt, is a new addition to the MySQL literary genre with 99 great recipes for mastering MySQL configuration and administration. Announcing quick answers to common problems, these 99 recipes cover a broad spectrum of managing MySQL, and are appropriate for new MySQL administrators as well as more experienced administrators. MySQL Admin Cookbook is available in dead tree and PDF formats. The book's website is: https://www.packtpub.com/mysql-admin-cookbook/book with errata found at http://www/packtpub.com/support.


Subjects Covered

  • Replication
  • Indexing Tools
  • Backing Up & Restoring MySQL Data
  • Managing Data
  • Monitoring & …
[Read more]
Review: MySQL Admin Cookbook

MySQL Admin Cookbook from Packt Publishing, authored by Daniel Schneller & Udo Schwedt, is a new addition to the MySQL literary genre with 99 great recipes for mastering MySQL configuration and administration. Announcing quick answers to common problems, these 99 recipes cover a broad spectrum of managing MySQL, and are appropriate for new MySQL administrators as well as more experienced administrators. MySQL Admin Cookbook is available in dead tree and PDF formats. The book's website is: https://www.packtpub.com/mysql-admin-cookbook/book with errata found at http://www/packtpub.com/support.


Subjects Covered

  • Replication
  • Indexing Tools
  • Backing Up & Restoring MySQL Data
  • Managing Data
  • Monitoring & …
[Read more]
Comment on Outgrowing Visual Foxpro by hansem

if I used foxpro database there’re no limit column when I save the records more than 50 column but if I used mysql server to save from foxpro there are limit column and then show warning “command contain unrecognized phrase/keyword” like code below :
SQLEXEC(test,”LOCK TABLE LocalOnLine.vouchers WRITE”)
SQLPREPARE(test,”UPDATE LocalOnLine.vouchers SET division=?v_dv,agent=?v_ag,guide=?v_gd,invoice=?v_iv,month=?v_mt,years=?v_yr,voucher=?v_vc,; bill=?v_vl,cgroup=?v_gr,client=?v_cl,client1=?v_c1,client2=?v_c2,remarks=?v_rk WHERE month=?v_mt and years=?v_yr and voucher=?v_vc and totalrp+totalus>0″)
server=SQLEXEC(test)
SQLEXEC(test,”UNLOCK TABLE”)

IF server<0
MESSAGEBOX('Update voucher '+v_vc+' '+v_vd+' '+ALLTRIM(v_nm)+' failed',16,'Warning')
ENDIF

what wrong with my code above and there are limit column to save from foxpro to mysql server ?

please help me, …

[Read more]
New Maatkit tool to compute index usage

In a couple of recent consulting cases, I needed a tool to analyze how a log of queries accesses indexes and tables in the database, specifically, to find out which indexes are not used. I initially hacked together something similar to Daniel Nichter’s mysqlidxchk, but using the framework provided by Maatkit, which gave me a pretty good start right out of the box. This was useful in the very tight time constraints I was under, but was not a complete solution. Alas, I could not use anything like Percona’s enhancements for finding unused indexes.

So, in response to another consultant’s customer request (and sponsorship — thank you!) I spent more time actually writing a real tool in the Maatkit style, with full tests and all the rest of the usual goodies. The resulting …

[Read more]
The manager-programmer face-off over NoSQL

A lot of conversations with a few different people I respect (no links, sorry) have coalesced some thoughts about these newly popular “non-relational” datastores. I wanted to point out an aspect I’m not sure is very clear in the hot-topic department. This is about what happens when managers learn that their developers or operations team have installed some new technology in their systems without them knowing it.

Lest anyone think that this happens only in a poorly-managed company, I can attest that it happens everywhere, all the time. Remember Marten Mickos’s favorite story about salespeople asking prospects if they used MySQL, the managers saying absolutely not, and the developers contradicting them?

The moment of discovery is unpleasant for the manager, but everything leading up to it was a joy for the programmer. He decided that he’s annoyed with the MySQL database. SQL is hard anyway — it is such a pain to write …

[Read more]
Showing entries 23016 to 23025 of 44118
« 10 Newer Entries | 10 Older Entries »